Browse the archive
It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Bert Wagner (blog | vlog| twitter). The topic: Code You Would Hate To Live Without It’s been a little bit since the last T-SQL …
Continue readingThese files are way neater than the ones on my laptop. SQL Server is great at a lot of things. I spend a lot of time blogging about all the cool things that SQL Server does. But (you knew there was a “but”, didn’t you) SQL Server isn’t great at everything. …
Continue readingConfessions of a carbaholic: When I start thinking about `ROLLBACK`, I start thinking about rolls. Have you ever forgot to commit a transaction? Maybe you’ve even left for lunch and caused a problem while you were gone. Uncommitted transactions can cause all …
Continue readingWhen blocking becomes excessive, it can cause problems. Are your blocks excessive? Identifying blocking is one of the most basic things that a DBA should be monitoring for. I previously wrote about how to identify blocking in SQL Server and find the leading …
Continue readingWho's at the front of the line blocking all the traffic? During the course of normal processing in a database, blocking happens. Blocking is “by design” because your database is on ACID. In an OLTP database, most of your transactions are short in duration, so …
Continue readingWhat'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 readingWho 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 readingWhen 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
