Microsoft SQL Server 2019 has surpassed the end of mainstream support on Feb 28, 2025. It’s the end of an era and a new beginning for your SQL Server instances.
Feature Image Attribution (img/license)
Read More »
Category: SQL Server
T-SQL Tuesday #182 – Integrity and Database Corruption
The topic for this month’s T-SQL Tuesday #182 hosted by Rob Farley (Blog) is integrity. Read on to see my thoughts on integrity in the world of databases – in particular database corruption.
Read More »
T-SQL Tuesday #177 – Managing Database Code
The topic for this month’s T-SQL Tuesday #177 hosted by Mala Mahadevan (Blog) is regarding how we manage our database repository. Read on to see my journey of using different repositories and source control for my code.
Read More » T-SQL Tuesday #174 – My Favorite Job Interview Question
The topic for this month’s T-SQL Tuesday #174 hosted by Kevin Feasel (Blog) is regarding our favorite job interview question. Read on to see my thoughts on job interview questions from both sides of the table…
Read More »
Maintaining Healthy SQL Server Hygiene: The Importance of Patching SQL Server
Last November marked the 20 year anniversary of Microsoft’s Patch Tuesday. Like brushing your teeth or taking showers, keeping your SQL Server patched is good hygiene and a best practice. Let’s explore why in this post.
Read More » T-SQL Tuesday #171 – Describe the Most Recent Issue You Closed
The topic for this month’s T-SQL Tuesday #171 hosted by the great and powerful Brent Ozar (Blog) is about our most recent closed issue.
Read More » T-SQL Tuesday #167 – Encryption and Data Protection
The topic for this month’s T-SQL Tuesday #167 hosted by Matthew McGiffen (Blog / Twitter) is about encryption and data protection in SQL Server.
Read More »
Working with the SQL Server STRING_AGG Function
Often when generating dynamic sql we must add some separator values in the string(s) we build. A function delivered way back in 2017 called STRING_AGG is a simple way to do this. Let’s look at some examples.
Read More »
How to Monitor Windows Event Log for Reboots
When was my server last rebooted? Who shutdown my machine? Read on to see how easy it is to find out using the Windows Server Event Logs.
Read More »
How to Load SQL Server Error Log into Table for Analysis
A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.
Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.
Read More »