New & Notable
SQL Server and .NET development News
May 18, 2010
Q&A: Author and Microsoft C# MVP highlights new enhancements and common challenges with Visual Studi
While Microsoft fixed many issues to Visual Studio in version 2010, updates are "evolutionary not revolutionary," says author Alex Mackey. In VS 2010/.NET 4.0, Microsoft updated a number of APIs and has made parallelization much easier. On the down ...
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.
February 06, 2008
Database Restyle can create and synchronize database structures for .NET Framework 2.0 applications. Among the database schema it supports is LINQ to SQL.
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.
Evaluate SQL Server and .NET development Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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. Continue Reading
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