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 »
Category: SQL Server
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 »
SQL Server Presentations
I just uploaded some sample presentations I did. You can find them on the Resources page. Both talks were given at SQL Saturday Sacramento.
Read More »