Glenn’s Tech Insights For February 21, 2019

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers interesting new hardware and software developments that are generally relevant for SQL Server). PCIe 5.0 Nears Release On January 17, 2019, the PCI-SIG ratified […]

Creating SQL Server Agent Job Schedules for Ola Hallengren’s Maintenance Solution

Data Platform MVP Ola Hallengren has created and maintained his free SQL Server Maintenance Solution script for over eleven years now. This script creates some objects in your master system database (by default), and it also creates and enables twelve SQL Server Agent jobs which are used to do things like database backups, index maintenance, […]

Avoiding SQL Server Upgrade Performance Issues

As SQL Server 2008 and SQL Server 2008 R2 rapidly approach the end of Extended support from Microsoft on July 9, 2019, and with SQL Server 2014 also falling out of Mainstream support on July 9, 2019 (joining SQL Server 2012, which fell out of Mainstream support on July 11, 2017) ), I am seeing […]

SQL Server Diagnostic Information Queries for February 2019

This month, I have just made some 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 through […]