How To

Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.

This blog post will show you how to find and affect the default Extended event file target’s path.

Entering cheats in Lego Video games is incredibly time-consuming. So I’ve used the power of SQL to save a few keystrokes and optimize my cheating experience.

I’m reminding myself how to set up secure CrossDB access. This blog post includes a nifty diagram and follow-along example.

Aaron Bertrand has thrown a gauntlet on Twitter. Instead of commenting on how you do stuff differently, blog about it yourself. Well, challenge accepted!

If you ever had a problem mapping the binary hash from DMVs to the numeric one in Extended Events - this is the blog post for you.