SQL Server

In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files. This is meant to help get an …

In this post I cover my solution to Brent Ozar’s recent query exercise, where we needed to optimize a query so that it’s able to find long values faster. Introduction …

In this post I cover what the ASYNC_NETWORK_IO wait type is, when it occurs, and how applications cause ASYNC_NETWORK_IO waits in SQL Server. Lately I’ve had to troubleshoot a few …

This post contains a script that I’ve written and used a few times when I’ve needed to search for a string in an entire SQL Server database. You can find …

In this post I cover my favorite SSMS tips and tricks that I’ve picked up along the years, and on which I rely on a daily basis in my workflow. …

In this post I cover two ways to export/import multiple SQL Server tables to/from CSV in one go with the help of a little PowerShell magic and tools like dbatools …

In this post I’m going over one method that I like to use for testing SQL Server storage read speeds. While there are a few ways to do this, a …

In this post I cover a way to import and query HTML table data in SQL Server using only T-SQL and no external tools. Why? For science! But I also …

In this post I demo one of SQL Server’s lesser-known features, startup stored procedures, and use it to automate sp_BlitzWho for capturing ongoing session activity as soon as the instance …

In this post I cover SQL Server client aliases, what they are and when they’re useful, as well as how to configure, update, and use them. I’ll be demoing ways …