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
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
I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.
How do you deal with errors opening a SQL Server table in Datasheet view in an Access Data Project when you have bad Extended Properties values?
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
With the release of SQL Server 2016, SQL Server Management Studio (SSMS) is now a stand-alone tool. It requires no licensing and can be downloaded without as much as registering. Because it is a separate download, it requires a separate installation. The computer labs I manage have SQL Server installed, including Management Studio. Prior to … Continue reading Performing a Silent Install of SQL Server Management Studio (2016)