I’m Speaking at Data Platform Discovery Day!

I'm always honored to be chosen to present at events, but I'm especially happy to be speaking at the first ever Data Platform Discovery Day! Data Platform Discovery Day is "A free one-day virtual conference introducing you to the Microsoft Data Platform", and it's new this year. It's actually 2 days, consisting of 10 sessions, each 50 minutes long. There's a U.S. edition taking place on April 29, and a European edition on April 30. Anyone can attend or speak at either edition, the only real difference is time zone convenience. My Session I'll be presenting a classic session entitled…
Read More
Understanding Azure SQL Deployment Options: The Difference Between SQL VM and SQL Database

Understanding Azure SQL Deployment Options: The Difference Between SQL VM and SQL Database

When migrating databases to the cloud, requirements can differ between organizations and often between applications as well. One deployment option does not fit all. With Azure, you have two choices: SQL virtual machines or a fully managed SQL database service. Understanding the differences between the two is the first step to choosing the right deployment option for your workload. If you would like to learn more, download Microsoft's e-book "Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators." SQL Server on Azure Virtual Machines SQL Server on Azure virtual machines allows you to benefit from a full…
Read More
New: Azure Cosmos DB Free Tier!

New: Azure Cosmos DB Free Tier!

For those wanting to experiment with Azure Cosmos DB for free, a great option has long been the Azure Cosmos DB 30 Day Trial, which is awesome because you can keep renewing it in perpetuity. But now there's something even better - an entire free tier! That's right! Microsoft has just announced Azure Cosmos DB Free Tier. You get 400 RU/second and 5GB of storage for free. Forever. No need to renew every 30 days! So if you have been using Azure Cosmos Emulator locally, or have tried a cloud deployment with the 30 Day Trial and are now looking…
Read More
The Luhn Algorithm

The Luhn Algorithm

Checksums can be very helpful for validating that data is intact and free from simple mistakes. They are extremely fast to calculate, and computing power has made them all but trivial over the past few decades. Because of this, checksums often hide in plain sight. One of these is the Luhn Checksum, which is produced by the Luhn Algorithm. The Luhn Algorithm was invented by Hans Peter Luhn, a scientist at IBM. It's patent was granted in 1960, but has since expired and it is now in the public domain. The best place where you can find its handiwork? Your…
Read More
Updating the PowerShell Kernel in Azure Data Studio

Updating the PowerShell Kernel in Azure Data Studio

In my previous post, I discussed an issue I encountered where comments caused strange issues in a PowerShell notebook in Azure Data Studio. I opened an issue in GitHub about this, and got some very prompt feedback from a member of the team. It turns out I did not have the latest version of the PowerShell Kernel running on my machine. The latest version is currently 0.1.3, and I had 0.1.2. Upgrading appears to have solved this issue for me - yay! This solution also raises the issue that there is no notification from Azure Data Studio that a PowerShell…
Read More