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
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
This seems simple enough... but I had to try a few methods to get it right. Note: the solution here is the one I settled on because it's the first one that worked for me. There probably are better solutions available. Feel free to comment if you have any. I settled on using Notepad++, my … Continue reading Removing the first n lines from all text files in a folder
SSMS 17 was released today. This is a quick first look at some of the additions and changes that immediately stand out to me.
Just sometimes, my wife needs some IT help. The latest occurrence is when she had scanned a number of documents to a TIFF file but really needed every page to be a single PDF file. We're talking a few dozen files with a few hundred pages each - a manual approach was not going to … Continue reading Using ImageMagick to simultaneously split and convert a TIFF into multiple PDFs