Want to Know What MVPs are Doing: Follow the MVP Blog
DBA Career, MVP | April 30, 2009 | 3:53 pmIf you are a current, or aspiring Microsoft MVP, you can keep up with what other MVPs are doing by reading the MVP Award Program blog. For the most part, the blog focuses on individual MVPs and their contributions to their respective communities.
The Maintenance Plan Wizard Can Lead You Astray
Database Maintenance | April 16, 2009 | 3:57 pmIn theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is that unless you really know what you are doing, you can hurt the performance of your SQL ...read more
Don’t Make Dumb Mistakes by Duplicating Indexes
Database Maintenance, Indexing | April 15, 2009 | 3:59 pmJust today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server Bible; and Itzik Ben-Gan. The script is available ...read more
Online T-SQL Scripts and Copyright
Opinion | April 12, 2009 | 12:40 pmThere are thousands of Transact-SQL scripts available on the Internet. They provide a great way to learn how other people approach and solve the same kind of problems you have and, in many cases, will save you from having to “reinvent the wheel”. When I need a new script, the first thing I always do ...read more
Summary of What PASS Members Want from the 2009 PASS Community Summit
PASS | April 4, 2009 | 4:38 pmPASS recently conducted a survey of its members, asking them what topics they would like to see covered at the 2009 PASS Community Summit. A total of 304 people responded to the survey, and the entire survey can be seen at the PASS Speaker’s Resource Page (you have to log on to the website to ...read more
RSS
Twitter
Linked In