Category: SQL Server 2016

July 2, 2020
How to Install the SQL Server WMI Provider

I wanted to install Ola Hallengren’s SQL Server Maintenance Solution on my lab’s Windows Server Update Services (WSUS). When I tried to install Ola’s script, unfortunately, I received an error…

November 21, 2018
How to Subscribe to SCCM Reports Using Office 365

Service Level Agreements (SLAs) are the driving force behind the need for more reporting with SCCM. Why? In many organizations, SCCM report results are used to validate SLAs. Whether you…

March 21, 2018
Updated – How to Match SSRS Brand Colors with SSRS Site Items

A number of updates have occurred with SQL Server Reporting Services (SSRS) since I first published my original blog post on this topic over a year ago, so I thought…

June 6, 2017
SQL Server Data Tools (SSDT) and RDL Versions

You built your report using SQL Server Data Tools (SSDT) which saves the RDL in the SQL Server 2016 format. That’s great, but now you need the native RDL in…

April 25, 2017
How to Define the Size of a SQL Server Database

In a couple of recent blog posts I talked about two ways to prevent the SQL Server database from running out of disk space because of transaction logs, and what…