Monthly Archives: April 2016

Talk: Comparing Azure SQL Database and SQL Server

I spoke tonight at the New England SQL Server Group to a large audience of feisty SQL experts. Thanks for all the tough questions. And thanks to George for backing me up on questions I couldn’t answer.


The Microsoft Azure cloud platform offers a service called Azure SQL Database. How does this compare to SQL Server, the venerable boxed product so many DBAs have come to know and love? In this talk from long-time Azure MVP Bill Wilder, we will look at similarities and differences. We will also briefly talk about complementary data storage sources that may also interest DBAs. At the end of the talk, you will understand the big picture of database options in the cloud, how Azure SQL Database is positioned and stacks up relative to SQL, and leave with an appreciation of key scenarios where it might make sense to use one over the other.

One thing I didn’t get to work was the PowerShell cleanup at the end. I ran it later and here is the code (the last line is the one I botched during the demo):

Add-AzureRmAccount # then log in interactively, including with 2FA 🙂
Select-AzureRmSubscription -SubscriptionName MyAzureSubsriptionNameHere
Get-AzureRmSubscription # optional
Find-AzureRmResource -ResourceGroupNameContains sqltest # optional
Remove-AzureRmResourceGroup -Name sqltest -Force

For those interested, here is the deck:


Talk: Boston Code Camp 25 – 17 Specific #Azure Security Tips and Tricks

At Boston Code Camp 25 (yes, this was the 25th Boston Code Camp!) I presented 17 Specific Azure Security Tips and Tricks. The talk was pretty rapid-fire, with a lot of information. For folks interested in following-up, the deck (included below) includes lots of links to more information.

Also, for those interesting in more information, please check out Boston Azure ( and @bostonazure), the world’s oldest Azure-focused user group – right here in Boston. We have an all-day bootcamp coming up April 16, among other coming Azure-related action.

My Cloud Architecture Patterns book is available:


The powerpoint deck: 17 Specific Azure Security Tips and Tricks – Boston Code Camp 25 – 02-Apr-2016 – Bill Wilder


(photo via Frank Wu (@FrankWWu))