SQL Server Best Practices Website

by Jonathan Allen Follow 491 Followers on  Dec 04, 2006 7

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

by James Vastbinder Follow 0 Followers on  Nov 20, 2006

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

by Jonathan Allen Follow 491 Followers on  Oct 30, 2006

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

by Jonathan Allen Follow 491 Followers on  Oct 21, 2006

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

by Jonathan Allen Follow 491 Followers on  Oct 11, 2006

Data Dictionary Creator by Jon Galloway allows developers to quickly generate documentation for SQL Server databases.


English Query Discontinued in VS 2005

by Jonathan Allen Follow 491 Followers on  Oct 10, 2006 1

English Query, a tool that translated queries written in English into SQL queries, has been discontinued.

Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you