Based on this question in the Microsoft Forums and the answer from Microsoft in a related Connect feedback item, you can install the Developer edition of SQL Server 2016 or 2017 silently using the Evaluation edition media if you specify the product ID (PID) of 22222-00000-00000-00000-00000. You will either specify this on the command line … Continue reading Silent Installation of SQL Server 2016 or 2017 Developer Edition from Evaluation installation media
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
I was having trouble connecting with the Remote Desktop protocol to a server. The error returned by the Remote Desktop Connection Manager was 7431. Using mstsc.exe the error was more descriptive and indicated a time difference between the client and the server. I verified that the time difference was not the case. Coincidentally, a support … Continue reading Remote Desktop Error 7431 may indicate a DNS problem
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.
Most summers are opportunities to take a break, reflect and recharge. I am thankful for visits from my mother and my mother-in-law. I am pleased to be able to travel regularly. And I am also excited about the many opportunities to present at community events. Here is my speaking schedule for summer 2017. July 15: … Continue reading Summer Speaking Schedule
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