‘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...]

Build Your Own Microsoft Operations Manager Pack

Operations Manager Management Pack Development Kit I just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit.  Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel.  But I digress... So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007.  It provide the you with all of the info need to design and build a management pack … [Read more...]

Anna Turns 13

I'm a teenager now! Nyah Nyah Nyah! … [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...]

Give A Round of Applause for Microsoft System Center!

I hope you've taken a few minutes to peek in on the nice refresh that's happened on a bunch of the System Center engineering blogs.  Good things are afoot there.  And if you haven't checked in, avail yourself of these great resources: System Center: Service Manager System Center: Operations Manager System Center: Virtual Machine Manager System Center: Orchestrator System Center: Data Protection Manager And, as always, I'm interested in your feedback. Tell me what you think! Enjoy, -Kevin Follow me on Twitter! … [Read more...]

John Oliver Live

Rachel and I finally had a date night and we used it go see one of our favorite Daily Show reporters, John Oliver, at Zanies - our local comedy club:Fantastic show!  So funny and such a different perspective too. … [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...]

The Usual Suspects

Saw this in a pet shop with my buddy Brent Ozar.  It made me laugh, so I thought I'd share it.  ^_^ … [Read more...]

New White Paper: SQL Server Extended Events and Notifications

Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]