T-SQL

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’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 …

This is a brief post containing a script to grant permissions on functions and stored procedures to a database user or role in SQL Server. Every few months I end …

While working on updating the PSBlitz script that retrieves statistics info for a SQL Server database, I’ve decided I should also make it available in a blog post and add …