Category Archives: SQL Server

SQL Server – Configure Backup on Availability Replicas

For a recent project, I needed to create a backup maintenance task for databases in a SQL Server Always On Availability group. In three separate AO environments. Now there are several options available: Use custom backup jobs Use Ola Hallengren’s … Continue reading

Posted in High Availability, SCCM, SQL Server | Leave a comment

Failed to create Availability Group Listener

In implementing a SQL Server Always On availability group; I know I’ve run into this issue in the past, so figured I’d document the solution. The Windows Server Failover cluster was properly created. The SQL Server Always On Availability Group … Continue reading

Posted in Always ON, High Availability, SQL Server | Leave a comment

Enhancing WSUS database cleanup performance SQL script

There have been many reports of slow and sluggish clean up and removal of expired updates. An old WSUS database can include 1000’s of updates that need to be removed. Turns out that adding two non-clustered indexes on SUSDB can … Continue reading

Posted in SCCM, SQL Server, Uncategorized, WSUS | 17 Comments

Backup SQL Server to an Azure Storage Account

One of the benefits of backing up SQL Server to Azure, is an immediate “off site” storage solution. Another, is that Azure storage account can be geo-replicated for additional backup copies. There are a few ways to make this work, … Continue reading

Posted in Azure, Azure SQL Server, SCCM, SQL Server | Leave a comment

How to apply a SQL Server update for ConfigMgr

This example is used to illustrate applying the latest SQL Cumulative Update to SQL 2016, this CM Site server happens to be running current branch 1710. This same process would be used to update SQL Server with a service pack … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2016 | Leave a comment

TSQL2sday #94–SQL Server and PowerShell

T-SQL Tuesday (#tsql2sday), I’ve been absent for a few, figured it was time to jump back in! SQL and PowerShell, what a great combination. First, let me thank the sponsor, you can find his site from the following link. One … Continue reading

Posted in PowerShell, SQL Server | Leave a comment

Installing Power BI Report Server

Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft released the Power BI Premium service tier, … Continue reading

Posted in Power BI Report Server, PowerBI, SQL, SQL Server | Leave a comment