I like to keep my Windows Event Logs clean. To me, the event log should be a place to go to find errors. In fact, the only time I look at the event log is when I’m seeing errors with the system. So when programs write informational messages to the event log, I try to […]
I am now officially a published author! Well, I suppose if you count blog posts, I already was, but today, my first ever non-blog article has been published! I even got paid for it and everything! You can check it out at SQL Server Central here. There is also a discussion thread about it on […]
I love Database Mail. The new mail system that was introduced in SQL Server 2005 is head and shoulders above the old SQL Mail functionality of SQL 2000. Setting up email alerts for failed jobs and error conditions is now a breeze. Unfortunately, I still have a couple SQL Server 2000 machines in use that […]
I’d like to say a few words today about consistency. Whether you are responsible for maintaining two SQL Servers or dozens, your job will be a lot easier if you can make things as consistent as possible across all your servers. It can be difficult, especially when your servers are running different versions of SQL […]
A commenter recently reminded me that, although I had mentioned that I attempted to do a migration from SQL 2000 to 2008 a while back, failed, and had to go back to the old version, I never really explained what happened. So now I will! We had a SQL Server cluster running SQL 2000. One […]