I am preparing some posts about managing aspects of Azure services with PowerShell. Before you can do that, you'll need to authenticate to Azure. In this "prereq" blog post, I'll briefly walk through the process of authenticating to your Azure subscription from PowerShell. This blog post will only use the "newer" Azure Resource Manager (AzureRm) … Continue reading Logging on to Azure with PowerShell
SSMS 17 was released today. This is a quick first look at some of the additions and changes that immediately stand out to me.
I don't post about my speaking engagements frequently enough. I realize I should do better and why not start today? I will be speaking at SQL Saturday Birmingham 2017 tomorrow, March 18. I have a single session titled "12 things to know about Azure SQL DB." I got started with Azure SQL DB about two … Continue reading Speaking at SQL Saturday Birmingham 2017
When connecting to an Azure SQL DB endpoint (somename.database.windows.net), your IP must be listed in that endpoint's (server's) firewall: If you're connecting to your Azure SQL DB from SQL Server Management Studio 2016 and your IP address is not in the list, SSMS will offer to add it: You'll need to sign in with a … Continue reading Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401