Category: SQL Server Database

December 12, 2017
Getting Started with Power BI Desktop and SCCM

In this blog post I will show you how to connect Power BI Desktop to your System Center Configuration Manager (SCCM) SQL Server database. During the connection process I will…

October 11, 2017
Does SQL Server Database Compatibility Level Matter?

Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over…

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

By Garth Jones 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…

April 19, 2017
Never Leave Your SQL Server Database in Full Recovery Model without a Backup

By Garth Jones When your SQL Server database is left to “auto-grow” without a maximum limit, you will run out of hard drive space. Believe me, I learned the hard…