Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.

Ruthless Focus - A Different Type of Time Management Philosophy

by Andy Warren

SQLServerCentral.com

Blogs

If you could list all the reasons I work, the number one reason would be to support my family. My definition of support includes spending an appropriate amount of time with family, not just working to support it. I suspect most of you would agree with that as a goal.

SQL Server Version

by Additional Articles

SQLTeam.com

SQL Server

I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.

Guest Editorial: Managing their expectations

by Phil Factor

SQLServerCentral.com

Editorial

In which Phil Factor's attention wanders whilst reading some software product announcements and imagines what would have happened if the current IT Bloggers had been in charge of the White Star Line at the time of RMS Titanic.

Installing Sample 2008 Databases - SQL School Videos

by Brian Knight

JumpStartTV

Video

Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.

CreationName 2005 - Adding components programmatically

by Additional Articles

sqlis.com

Integration Services (SSIS)

If you are building packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post.

DBA Education

by Jeffrey Yao

SQLServerCentral.com

Blogs

I always consider taking seminars and technical conferences as a key component in my DBA education framework

SQL Server CLR function to improve performance of validating email addresses

by Additional Articles

MSSQLTips.com

SQLCLR

I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?

Guest Editorial: And Now; a Recitation

by Phil Factor

SQLServerCentral.com

Editorial

In which Phil Factor responds to the muse and writes a poem in the style of a School Song, in which he tries to give a mention to all the top writers and forum-posters.