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