TSQL Tuesday #104: dbo.Check_FileSize
It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner's call to blog about code I would hate to live without
Continue readingBrowse the archive
DBA Database
Parsing file names from paths using T-SQL
As a DBA, there seems to be a constant trickle of automation where I need to parse a file name out of a full path. So let's parse this stuff in T-SQL, even though other languages might be better for this.
Continue reading
Finding active transactions
Find active SQL Server transactions and avoid leaving uncommitted work that can block other users.
Continue reading
Alerting on SQL Server Blocking
A practical approach to monitoring SQL Server blocking and alerting when it becomes disruptive.
Continue reading
Finding the Leader Blocker
Learn how to identify the head blocker in SQL Server and trace a blocking chain to its source.
Continue readingxp_sqlagent_enum_jobs alternative
What's xp_sqlagent_enum_jobs? If you landed on this post, I'm guessing you know the answer to this, so I'll be quick. `xp_sqlagent_enum_jobs` is an undocumented (and thus, unsupported) extended procedure that gives information on whether a job is currently …
Continue reading
Planning for an outage: Phone numbers
Who ya gonna call? If there's somethin' strange in your neighborhood Who ya gonna call? If it's something weird and it won't look good Who ya gonna call? This summer, they've been taping the new Ghostbusters movie in Boston. It's pretty cool to see the …
Continue reading
Formatting HTML emails in SQL
When I am writing monitoring/alerting stored procedures for my SQL Servers, its important to have those alerts be well-formatted. I like to minimize the amount of time I spend sorting through emails & alerts, and part of that is making sure that I can …
Continue reading