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

I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having.
If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the ...

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress...
Anyway, I pointed out a couple ...

Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter),
I decided I'd spend a few minutes looking back on both the year 2009.
(From a personal standpoint, the 00's were my most difficult decade
yet. Major problems of every stripe beset me on all sides and with
alarming frequency throughout ...