Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting
June 9, 2015
Tag: #SQLYog
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL
June 3, 2015
Northwestern Management: “We haven’t had any other issues with performance, which translates into revenue”
Northwestern Management
June 3, 2015
The Interview Trick Question
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want
May 21, 2015
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out
May 13, 2015
Fight The Weeds
Spring time means tuning up the lawn mower, digging out the pruning shears, and testing the sprinklers (at least in
May 7, 2015
Automating DBCC DBTABLE – Obtaining the Disk Sector Size
It’s a best practice to have the disk sector size (also known as the allocation unit size or block size)
April 28, 2015
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform
April 22, 2015
Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was
April 7, 2015
What is a DBA Worth?
The value of a DBA can vary depending on numerous factors. Something that should be easy to answer is: what
March 31, 2015