SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16

I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...

Visualizing Hash Match Join Internals And Understanding Their Implications

This post is part 3 in a series about physical join operators (be sure to check out part 1 – nested...

Watch: Can This Team Succeed at DevOps? Panel discussion

I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about...

Why is the query hash so useful?

An example of how I use the query hash
I wrote a blog on what the query hash is, right here....

A Monumental Migration to SQL Server 2016 - Part 2

In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...

A shell for working with Kubernetes

I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...

Back to the future

It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...

BIOS and OS Power Settings to enhance SQL Server Performance

Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.One of my Code Project article on SQL Trigger has been selected as entry in this contest. I...

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.

One of my Code Project article on SQL Trigger has...