‘Backup Completed’ is NOT an Error Message

If you're like me, you like for things to be semantically reliable.  Huh? Said another way, I like for things to mean what they say and say what they mean.  Here are a few examples of I get annoyed by failed sematics - when a footpath is used almost entirely by cyclists, when an escalator is merely stairs, or when a restroom has a huge crowd and long lines.  (No rest to be had in that room). So you can bet that I get a little prickly when the "Error Log" is used to post messages that something completed successfully.  Really?  I came here to this error log looking for, wait for it, ... … [Read more...]

Flexibility When Waiting on Locks

Speaking at a recent SQL Saturday, an attendee in one of my sessions wanted to know how they could more flexibly react to locks on their application than to wait for blocks to occur and then kill the SPID at the head of the blocking chain.  They were also interested in some alternatives to using the  SQL Server syntax like the WITH (NOLOCK) hint, since that might have unintended consequences due to allowing reads on uncommitted data. One alternative I suggested is the SET LOCK_TIMEOUT n statement.  Since most of the attendees hadn't heard of this statement, I figured it'd make a good blog … [Read more...]

How is Microsoft IT using the Cloud?

Steve Balmer very publicly pronounced that Microsoft was “all in” for cloud computing and Windows Azure.  So that means Microsoft is using cloud for its internal IT as well as building products to utilize the cloud.  If you want to learn how Microsoft IT is using Windows Azure to move existing applications to the cloud and creating new applications for the cloud, click here: IT Showcase on Windows Azure.   Let me know what you think.  Accurate and informative? Or marketing fluff? Thanks, -Kevin Follow me on Twitter! … [Read more...]

SQLMag = SQL Server Pro. Goes all-digital!

I was recently chatting with Megan Keller, my long-time editor for the Tool Time column and Executive Editor at SQL Server Pro, DevProConnections, and SharePoint Pro. I've subscribed to SQLMag ever since it was first put to print back in the late 1990's.  (That's a pic of me, on the right, in the shirt given my by SQLMag's first publisher way back in the day).  I have many bookshelves in my office, but SQLMag consumes more than half of the shelf closest to my desk.  It's that good.  Some of my personal favorites and perpetual must-read content are the columns SQL Server Questions Answered … [Read more...]

Starting this week: Dublin, Maidenhead, and London

This might be most most overcommitted four-week period of time ever in my life.  I'm tired just thinking about it! Not only am I traveling internationally and speaking over the next few weeks, I'm also helping on two book projects, learning some new applications from Quest Software, and helping on a small Transact-SQL refactoring project. Swag on hand? I've got a special printing of 500 video training DVDs for this trip: SQL Server Training on DMVs Performance Monitor and Wait Events Plus, I'll have a few posters, stickers, and other goodies.  Come see me!   SQL Saturday … [Read more...]