Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals.
SQL Server application developers to want to normalize the query text returned in a Profiler trace. This allows the performance of a query to be more easily tracked and measured. Ken Henderson shares his insightful thoughts through a blog post on query normalization.
Microsoft has released the first CTP of its SQL Server Hosting Toolkit. This toolkit is designed to provide support for companies using a hosted SQL Server.
SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. Unfortunately for those currently using it, SQL Server 2005 has dropped this feature.
Data Dictionary Creator by Jon Galloway allows developers to quickly generate documentation for SQL Server databases.
English Query, a tool that translated queries written in English into SQL queries, has been discontinued.