InfoQ Homepage SQL Server 2005 Content on InfoQ
-
SQL Server Best Practices Website
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.
-
Tips on query normalization with SQL Server 2005
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.
-
SQL Server Hosting Toolkit CTP 1 Released
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.
-
Upgrading SQL Server - xp_execresultset
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 - Rapid Database Documentation for SQL Server 2005
Data Dictionary Creator by Jon Galloway allows developers to quickly generate documentation for SQL Server databases.
-
English Query Discontinued in VS 2005
English Query, a tool that translated queries written in English into SQL queries, has been discontinued.