Monthly Archives: February 2009

Best of the SQL Server Blogs

Kevin Kline, who is a fellow SQL MVP and former President of PASS has posted a list list of blogs written by SQL MVPs.  The PASS web site also has an updated directory of SQL Server blogs. Subscribing to these … Continue reading

Posted in SQL Server 2008 | Leave a comment

Another Microsoft Certification

I took and passed the Microsoft 70-432 Exam yesterday, which gives me the MCTS: SQL Server 2008, Implementation and Maintenance certification. This is one of three MCTS certifications for SQL Server 2008. The other two are for database development and … Continue reading

Posted in SQL Server 2008 | 1 Comment

Very Cute New Microsoft Commercial

Microsoft has a new TV commercial that features a very cute 4 1/2 year old girl named Kylie. She is shown uploading a picture of her fish Dorothy from a digital camera to a Windows PC. Then she uses Windows … Continue reading

Posted in Microsoft | Leave a comment

Rocky Mountain Tech Tri-Fecta On February 21, 2009

A group of Colorado area Users Groups is putting on a FREE, all-day event on Saturday, February 21, 2009 at Metro State College in downtown Denver. It is called the Rocky Mountain Tech Tri-Fecta, and it starts at 8:00AM. There … Continue reading

Posted in Microsoft Training | 2 Comments

Minimizing Downtime With SQL Server 2008 Database Mirroring

SQLCAT.com has a new blog post up that I co-authored with Kevin Cox from the SQLCAT Team. The full content of the post is available here.  Kevin Cox has been a very valuable and helpful resource from Microsoft since the … Continue reading

Posted in SQL Server 2008 | 1 Comment

How to Drop A User Database in SQL Server 2008

I have had a few questions recently from some of my students at University College about how to drop a database with T-SQL. Depending on whether or not there are any open connections to the database, this can be a … Continue reading

Posted in SQL Server 2008 | Leave a comment

Beware of CONVERT_IMPLICIT in a SQL Execution Plan

I was troubleshooting a stored procedure for a developer today, and I discovered that part of the query was doing an index scan against a fairly large table. Initially this did not make sense, since we had a non-clustered index … Continue reading

Posted in SQL Server 2008 | 2 Comments

Top 10 SQL Server 2008 Features for the Database Administrator (DBA)

Microsoft’s Mike Weiner has a new Top 10 List up on SQLCAT.com that outlines and explains the ten most valuable new features in SQL Server 20008 for the database administrator. These include Activity Monitor, SQL Server Audit, Backup Compression, Central … Continue reading

Posted in SQL Server 2008 | Leave a comment