I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn't become huge. My main concern with that is that the errorlog contains valuable information. When I do a health check on a SQL Server machine, I want a few months worth of errorlog information available. I typically use my own scripts for this, ...

How often do you do this? Look over each message (type) in the errorlog file and determine whether this is something you want to act on. Sure, some (but not all) of you have some monitoring solution in place, but are you 100% confident that it really will notify for all messages that you might find interesting? That there isn't even one little ...

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 read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing what I'm reading at least once per week, partly so that I don't firehose too many ...

Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...

Lucy, You Got Some 'Splainin to Do!' Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia ...

I did a lot of writing in 2010. Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active. So here are a few more posts from my blog, put on-line during the months of November and December 2010, that I didn't get posted here on SQLBlog.com: 1. It's Time to ...

Everybody enjoys a little free training now and then. I've got mountains of free training in the works. Some of it is in-person and local while some are in webcast format. Please join me as you're able! Tomorrow - Wednesday! Wed, Feb 10, 2010 12 pm (noon) MST - PASS DBA Virtual Chapter; Top 10 Administration Mistakes on SQL ...

It’s common to be called to find out why an app cannot connect to one of your database servers. So you start by checking the server, and it’s working just fine. Then, you check the client machine and its database connectivity to the server, and that is also no problem. But still, the app continues to fail on trying to connect to the server. ...

I just posted a new entry on my SQLMag Tool Time blog that you might like to check out. I'm a big fan of Bill Graziano's ClearTrace tool, but perhaps you'll like the new tool from DBSophic, called TraceAnalyzer, even better?  Compare the two and let me know here. Cheers, -Kevin  Twitter @kekline  More content at ...