File this in the category of error messages that don't really mean what you think. When configuring a failover group using Azure SQL DB, you need to provide a "name" for the failover group. However, the name really becomes the FQDN of the failover group, but that's not directly obvious. The implication of that is … Continue reading Azure SQL DB: The specified failover group name is already in use
Category: Azure SQL Database
As announced before, I will be speaking once again at the annual Atlanta SQL Saturday. The Atlanta MDF is a great group and they put on an excellent event each year. Note: this year, the venue has changed for the first time in as long as I can recall. Be sure to check the location: … Continue reading Speaking at SQL Saturday #652 Atlanta 2017
During my talk "Azure SQL DB: 12 Things to Know ," I briefly discuss the importance of monitoring and updating the IP addresses allowed to connect to your Azure SQL DB. Efficiently managing those firewall rules means you want to script them. In this post, I will provide a few ideas of how you can manage the database server rules using PowerShell scripts.
SSMS 17 was released today. This is a quick first look at some of the additions and changes that immediately stand out to me.