New Pluralsight Course Published

On January 10, 2019, my latest Pluralsight course, SQL Server 2017: Diagnosing Performance Issues with DMVs was published! This makes fifteen courses that I have done for Pluralsight. Here is the official course description: Learn how to easily query SQL Server 2017 for performance information to help identify and fix issues that can affect performance […]

The Importance of Database Compatibility Level in SQL Server

Prior to SQL Server 2014, the database compatibility level of your user databases was not typically an important property that you had to be concerned with, at least from a performance perspective. Unlike the database file level (which gets automatically upgraded when you restore or attach a down-level database to an instance running a newer […]

More CPU Competition Coming for Intel

On January 9, 2019, AMD CEO and President Dr. Lisa Su presented a CES 2019 Keynote where she demonstrated (at 1:25:00 in the video) a 7nm, eight core/sixteen thread, 3rd Generation AMD Ryzen “Matisse” desktop processor running the Cinebench R15 Multithreaded (MT) benchmark vs. a 14nm, eight core/sixteen thread Intel Core i9-9900K “Coffee Lake” desktop […]

SQL Server Diagnostic Information Queries for January 2019

This month, I have just made some more minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works for SQL Server 2008 […]

New Year Technology Maintenance

With the start of a new year, and with many people having some time off work, this seems like a good time to do some maintenance and updates on the computers and related technology items and devices in your home (and the homes of your immediate relatives and friends if possible). While many devices do […]