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

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.

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.

Brandon Moak felt as if a freight train had hit hi...

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...

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...

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....

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...

In the previous post, I added the tasks to on-prem...

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:...

In the last post, we have discussed the DTU purcha...

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...

"We're going to be the most forward-leaning compan...

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...

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...

So you’ve decided to use Azure for your existing...

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...

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.

I’m presenting a full-day training at PASS Summi...

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...

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...

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...

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...

Hi all, I get asked this question a lot. So I deci...

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...

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...

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...

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...

In this article, we share an idea to reduce the fr...

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...

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...

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...

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.

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.

A/B Testing Let’s look at a pretty simple query ...

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...

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...

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...

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...

Have you ever wanted a single date picker in your ...

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...

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 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...

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...

Power BI tooltips can add a lot of context to a vi...

Have you ever wanted a single date picker in your ...

There are a number of options for monitoring Power...

I replaced my desktop recently and installed new s...

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 is a fantastic coding aid, but it does ...

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+....

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...

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...

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...

Ben Buchanan has written "A National Security Research Agenda for Cybersecurity and Artificial Intelligence." It's really good -- well worth reading....

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...

An interesting question came to my attention the o...

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...

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....

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...

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...

[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...