SQL Server 2005 introduced dynamic management views (DMV) and functions (DMF) , a mechanism to allow you to look at the internal workings of SQL Server using TSQL. They allow you an easy method for monitoring what SQL Server is doing and how it is performing.
Read More...
The SQL Server team has moved away from the current priority-driven hotfix release model to a scheduled delivery model, called Incremental Servicing Model , designed to ensure that high quality fixes are delivered within an acceptable amount of time and
Read More...
SQL Server 2005 Best Practices Analyzer (July 2007) has been released and is available for public download at http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en SQL Server Best Practices Analyzer
Read More...
