New & Notable
SQL Server and .NET development News
March 03, 2009
The January 2009 release is giving developers a better idea of how Oslo's tools and languages will look, but its relationship to Windows and the .NET framework is still up in the air.
December 17, 2007
TulaSoft's SQL Examiner Suite 2008 offers two synchronization products for database developers and managers. One targets schema; the other, data sets.
July 05, 2007
SQL Populator 1.0, from Software Development Innovations, lets developers turn the content of SQL Server database tables into valid SQL script.
June 08, 2005
While announcing when SQL Server 2005 and Visual Studio 2005 will ship, Microsoft senior vice president Paul Flessner also outlined plans for tools, previews and editions of the company's database management platform.
Problem Solve SQL Server and .NET development Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
When you're dealing with really large data sets (think in terabytes of data) it's especially important to save time wherever you can. Partitioning, and the resulting partition elimination, can save hours of query time in these huge databases. Continue Reading
Dan Sullivan shows how to use Common Table Expressions to query hierarchical data in SQL Server 2005. Hierarchical queries combine recursive SELECT commands to provide the functionality to query self-referencing data. Continue Reading
Dan Sullivan shows how to use SQL Server 2005's new Common Table Expressions to write recursive functions. Starting with a C# implementation he then goes on to demonstrate how to build the same recursion in a T-SQL function. Continue Reading