Check your Windows OS for Spectre and Meltdown vulnerability with PowerShell

Microsoft has released a PowerShell module to check your device and operating system for the Spectre and Meltdown vulnerabilities. This PowerShell module is easy to install from an elevated PowerShell window: You may need to approve the installation of the NuGet provider if you haven't previously installed modules from NuGet. You will likely also get … Continue reading Check your Windows OS for Spectre and Meltdown vulnerability with PowerShell

Complete automated configuration of SQL Server 2017 Reporting Services

In my post two days ago on silently installing SQL Server 2017 Reporting Services (SSRS 2017), I just provided the most basic information on configuration. In fact, after installing SSRS 2017, it will be completely unconfigured. Configuration can be done using the Reporting Service Configuration Manager GUI. In my case, the configuration needs to be … Continue reading Complete automated configuration of SQL Server 2017 Reporting Services

Silent Installation and Configuration for SQL Server 2017 Reporting Services

With the release of SQL Server 2017, Reporting Services is now a separate installation. The installer can be downloaded from the Microsoft Download Center and installed in either a free edition (Evaluation, Express, or Developer) or a paid edition with a product key. It can also be installed silently, and in this blog post, I … Continue reading Silent Installation and Configuration for SQL Server 2017 Reporting Services

Silent, Offline Installation for SSDT 15.5 for Visual Studio 2017

The 15.5 release of SQL Server Data Tools for Visual Studio 2017 is the first release to support SSRS, SSAS, and SSIS in VS 2017. The command line below shows how to install all SSDT components in the only installation of VS 2017 on a machine: To work offline, you'll need to create a layout … Continue reading Silent, Offline Installation for SSDT 15.5 for Visual Studio 2017

Silent Installation of SQL Server 2016 or 2017 Developer Edition from Evaluation installation media

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

Azure SQL DB: The specified failover group name is already in use

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