The Build Book of News (DBW 2020-05-23)

 Database Weekly for May 23, 2020 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News Hand-picked content to sharpen your professional edge Editorial  The Build Book of News Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted to see were early in the morning or late at night, but I am sure most of these will be available on demand later, so I can watch them if I wish. One of the things Microsoft has done is produce a Build Book of News, a 55 page PDF book of all their announcements and changes. You can download it from [Paul Andrew's blog]( or you can look at the announcements online at [Microsoft News](. I randomly watched Build on and off this past week, having some of the sessions in the background while doing other things. There certainly were some interesting sections, though not a lot of data platform focus, but I found a few items that you might like. We're all remote now, or the majority of us are, and I can see that remote tools are important. I know there has been some remote code work in Visual Studio in the past, but I didn't think many people would use it. Now in watching some of the remote code demos, I think these tools might be interesting, especially when a few people are trying to debug a crisis situation. Being able to see the code on my own machine, and seeing what others might change or think is a better (or worse) solution could be very helpful. The mobile GitHub tools for review are getting better, and that's good. Since it's likely more of us might be in different locations, on different schedules, the ability to approve a PR could prove really helpful. [Codespaces]( are especially interesting. Maybe not so much for databases, but maybe. I wonder if we could easily get data provisioning in here. Azure CosmosDB is still something I want to play with, though I've been hesitant to set up a db because of cost. [Serverless CosmosDB]( might get me to try something. I have no real excuse since they're [an emulator]( so maybe not. I wonder how many of you might try CosmosDB out. There are also announcements about PostgreSQL and MySQL on as PaaS services [getting feature parity]( with SQL Server in many ways. Lots of [Synapse changes]( which might be of interest to those of you with larger warehouses and looking to take advantage of the cloud offering. Quite a few AI changes as well, with [Bots]( [speech]( [ML]( and more. I especially liked [the keynote on AI]( which I think was interesting. It provides some vision of what could be possible. Tons of developer sessions, and I'd suggest that you [browse or search the sessions]( to see what interests you. There aren't a ton on demand as I write this, but likely more will appear this coming week. I hope the [Cloud Skills Challenge]( will also remain up there, as I'd like to spend some time experimenting with services. If you haven't worked with the Azure services, I might give that a try and get a feel for what's possible. Build is always interesting, and I'm not sure if I love this virtual format, but I'm glad the event was still available and once again I'm impressed with all the work Microsoft is doing to help developers build solutions. Steve Jones - SSC Editor [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [Get advice on using Git from Redgate’s experts]( On Tuesday 26 May, Redgate is opening up their Ask The Experts webinar to all for the first time. Join Microsoft MVPs Grant Fritchey, Kathi Kellenberger, and Steve Jones as they answer your questions on all things Git, as voted by members of the Microsoft Data Platform community. [Automate Oracle database deployments with Redgate Change Automation]( We’re excited to introduce a brand-new capability of the Deployment Suite for Oracle: Redgate Change Automation is a command line tool with built-in safety checks that lets you safely automate your Oracle database deployment. With four commands that help you build, test, prepare, and perform Oracle database releases, Redgate Change Automation can be used as part of a CI/CD pipeline.  The 2020 State of Database Monitoring report is now available, free, to download. With insights including the impact of third-party monitoring tools on time to detection and time to recovery, the biggest issues facing monitoring this year, and an update on cloud adoption rates across the industry. Get your copy here. AI/Machine Learning/Cognitive Services [Self-driving cars are being trained in virtual worlds while the real one is in chaos]( Brandon Moak felt as if a freight train had hit hi... [Microsoft builds a supercomputer for OpenAI for training massive AI models]( Microsoft is building a supercomputer for and with OpenAI and is using it to train massive distributed AI models, which it is counting on to improve the AI capabilities... Administration [Can I Offload DBCC CHECKDB To Another Server?]( You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m... [Key Insights from the 2020 State of SQL Server Monitoring Report]( This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded.... [Detecting Query Weirdness In Query Store]( Let’s Have Fun I got asked recently if there’s a way to find parallel queries that are potentially skewed. One thing that you’ll see quite often is that duration and cpu... Azure DevOps [Adding a new task in TFS/Azure DevOps using Excel]( In the previous post, I added the tasks to on-prem... Azure SQL Database [Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.]( The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using ... Continue reading The post Connecting to Azure SQL Database:... [Stairway to Microsoft Azure SQL Database Part 3 : Purchase Models DTU vs vCore continue]( In the last post, we have discussed the DTU purcha... Azure Synapse (SQL Data Warehouse and Data Lake) [Build announcements: Azure Synapse Analytics in public preview and more]( A few data platform announcements yesterday at Microsoft Build that I wanted to blog about. The biggest one is Azure Synapse Analytics is now available in public preview! You... The... Career Growth and Certifications [Facebook workers get remote work option—but it could come with a pay cut]( "We're going to be the most forward-leaning compan... [Blogging and writing for the tech professional]( I’m Kathi Kellenberger. I’m the editor of Simple Talk, a DevOps Advocate, and a Microsoft Data Platform MVP. Probably the most important thing to know about me is that... Computing in the Cloud (Azure, Google, AWS) [Cloud Adoption in 2020]( We wanted to discover what our readers were doing with cloud, microservices, and other critical infrastructure and operations technologies. So we constructed a survey and ran it earlier this... [Which Azure Data Platform service should I choose?]( So you’ve decided to use Azure for your existing... [New Features in Cloud Shell in the Azure Portal]( One of the things that was really painful in the early days of Azure, especially for those of us who are consultants with many customers, was the process of... Conferences, Classes, Events, and Webinars [The latest Database DevOps techniques in AWS]( The time has come to bring your database into version control and DevOps automation, whether on-prem or in the cloud. Join our experts from Redgate and Octopus Deploy to see how Runbooks, cloning, and automation enable this. Date and time: Wednesday June 3, 10-11am CDT / 4-5pm BST. Can't join us live? register to receive the recording. [SQL on the Edge: Full-Day Training at PASS Summit 2020]( I’m presenting a full-day training at PASS Summi... [I’m Speaking at #SQLSatBrisbane]( I’ve always wanted to go to Australia, in fact we have a trip planned for Martin’s 60th birthday in a couple of years. But with all that’s happened in... The... DMO/SMO/Powershell [Day 17 – dbatools Restore-DbaDatabase and Azure – 31 days of dbatools backup and restores]( Restoring with Azure with dbatools All our talk about restores so far has been talking about restoring to on premises SQL Server instances, from on premises filestores. How well... Data Privacy, Compliance, and GDPR [The Evolution of Data Governance]( Click to learn more about author Olivia Hinkle. This is the second part of a series on Data Governance, see part one here. Today’s forward-thinking businesses place enormous emphasis... Data Visualisation [Building End-to-End Diagnostics: Visualization with Exporters]( Posts in this series: An Intro Trace Context Diagnostic Events OpenTelemetry Integration Activity and Span Correlation Visualization with Exporters Source Code In the last post, we looked at surfacing our diagnostics events from the Activity and DiagnosticSource... ETL/SSIS/Azure Data Factory/Biml [When Should I Use Multiple Azure Data Factory’s?]( Hi all, I get asked this question a lot. So I deci... [ADF.procfwk v1.6 – Error Details for Failed Activities Captured]( Code Project Overview This open source code project delivers a simple metadata driven processing framework for Azure Data Factory (ADF). The framework is made possible by coupling ADF with... HA/DR/Always On/Clustering [Refresh databases that belongs to Availability Group using dbatools]( Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed... The... Hardware [Intel’s Latest 10th-Gen vPro CPUs Get Mandatory Hardware Shield]( Intel releases 27 10th generation CPUs for desktop and mobile with Hardware Shield to improve remote worker security. The post Intel’s Latest 10th-Gen vPro CPUs Get Mandatory Hardware Shield appeared... [AMD to Support Zen 3 and Ryzen 4000 CPUs on B450 and X470 Motherboards]( In a surprising twist, AMD has today announced that it intends to enable Ryzen 4000 and Zen 3 support on its older B450 and X470 Motherboards. This is going... MDX/DAX [A proposal for visual calculations in DAX]( In this article, we share an idea to reduce the fr... Microsoft News [Microsoft Book of News – Build 2020]( Hi friends, its conference time again and Microsoft have kindly provided another Book of News. This time its for Build 2020 and it contains details of all the announcements... [Microsoft announces first vertical cloud offering: Microsoft Cloud for Healthcare]( At Build 2020, Microsoft is taking the wraps off the first of its planned industry-specific clouds, the Microsoft Cloud for Healthcare, which is due to start rolling out in... [Windows PowerToys FancyZones is the essential window manager for Windows 10]( Last year Microsoft rebooted PowerToys and it's open source and on GitHub. It's a few months later and PowerToys is getting even better. You can download and install it... [Five questions for Microsoft EVP of Cloud and AI Scott Guthrie]( What's Microsoft's head of Cloud and AI been up to lately? What is he most excited about at Build 2020 and beyond? I asked and ScottGu (sort of) answered. Oracle [Free Ebook: How to Handle a Licensing Audit]( While the E-book has Oracle-centric language, the ideas behind making sure your audit is painless can be applied to SQL Server as well. Performance Tuning SQL Server [SQL Server 2019: Index Choice and Batch Mode On Rowstore]( A/B Testing Let’s look at a pretty simple query ... [Untrusted Foreign Keys Still Check New Data]( Blitzing This comes up enough that I figured I’d write it down with a quick example. Foreign keys, which are next to useless in SQL Server, can become untrusted for... [RID Lookup]( Introduction The RID Lookup operator offers the same logical functionality within the execution plan as the Key Lookup operator. But where Key Lookup is used for tables that have... [Row counts and arrow width, read or returned]( In my last two posts, I presented use cases for the Actual Number of Rows and Estimated Number of Rows properties, and showcased one shortcoming. Was that the only... [Can We Get Row Counts After Execution?]( The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I... The... PowerPivot/PowerQuery/PowerBI [Build a DATE PICKER in Power BI Desktop]( Have you ever wanted a single date picker in your ... [Power BI Databricks Spark connection error]( When querying data from Azure Databricks (spark) into Power BI you may encounter an error: “ODBC:ERROR [HY000] [Microsoft][Hardy] (100) The host and port specified for the connection do not... [How to Improve Power BI Performance - Part I]( If you take your car to the mechanic, throw your keys on the counter, tell them your car is performing poorly and walk out, odds are the problem won't... [Power BI Measures in slicer]( Power BI measures are mainly used to show and visualize data, that can be measured. But from time to time, end-users will want to have measures to be easily... [Standard DAX separators in Power BI Desktop]( Starting from the May 2020 version of Power BI Desktop, regardless of the Windows locale settings DAX always uses standard separators by default. This change does not affect most... [EVERYTHING you wanted to know about Power BI tooltips]( Power BI tooltips can add a lot of context to a vi... [Build a DATE PICKER in Power BI Desktop]( Have you ever wanted a single date picker in your ... [Monitoring Power BI]( There are a number of options for monitoring Power... Product Reviews and Articles [SQL Source Control Link Errors on a New Machine]( I replaced my desktop recently and installed new s... [The Database Development Stage]( Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them. The post The Database Development Stage appeared first on Redgate... [SQL Prompt Fixes Missing Begin End in Procs]( SQL Prompt is a fantastic coding aid, but it does ... Python [Parsing HTML and Applying Unsupervised Machine Learning. Part 2: Applied Clustering Using Python]( Are you interested in guest posting? Publish at DataScience+ via your RStudio editor. Category Advanced Modeling Tags Data Visualisation Machine Learning Python This is the second part of a three-part article recently published in DataScience+.... SQL Server Security and Auditing [An insidious form of SQL injection]( As longtime readers know, I am also a software developer (we can’t call them engineers in Canada for legal reasons). I took over a complex codebase last year in... The... SQL Server on Linux [SQL Server 2019 Linux On Azure]( It was just a matter of time until I started combining my cloud experience with “different” flavours of SQL Server. I haven’t used Linux since my university days (Oracle... The... Security News and Issues [Ramsey Malware]( A new malware, called Ramsey, can jump air gaps: ESET said they've been able to track down three different versions of the Ramsay malware, one compiled in September 2019... [AI and Cybersecurity]( Ben Buchanan has written "A National Security Research Agenda for Cybersecurity and Artificial Intelligence." It's really good -- well worth reading.... Software Development [Tackle Big-O Notation in .NET Core]( Every computer science student must learn about Big-O Notation, a way to conceptualize algorithm complexity that directly relates to performance of the algorithm. In this article, Camilo Reyes demonstrates... T-SQL [Negative (-) is an operator and will affect the order of operations.]( An interesting question came to my attention the o... The Lighter Side [It’s time to taste a byte of Redgate]( At Redgate, we launched the Community Circle back in April as a place our customers and the Data Platform community could visit to find free resources, tips and content... [How I Use Streamlabs OBS for Streaming and Training Classes]( I’ve written a lot about the hardware & gear I use for streaming, and now let’s talk about the software side. There are a few thousand words in here.... [Here’s how we could mine the moon for rocket fuel]( The moon is a treasure trove of valuable resources. Gold, platinum, and many rare earth metals await extraction to be used in next-generation electronics. Non-radioactive helium-3 could one day... Tools for Development [Connecting to SSAS–#SQLNewBlogger]( Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post, I installed SSAS on... The... Virtualization and Containers/Kubernetes [Create Virtual Machine in Hyper-V and Step by Step Windows Server 2016 Installation]( [MSSQLFUN & Decote ITeS becomes a family of 1400 individuals across the globe. Please join us on Facebook & YouTube.] Today, We will go through “How to create a... The...  [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -