SQL Server and .NET development
New & Notable
Download: The Developer's Guide to IoT
The IoT world may be exciting, but there are serious technical challenges that need to be addressed, especially by developers. In this handbook, learn how to meet the security, analytics, and testing requirements for IoT applications.
SQL Server and .NET development News
-
March 03, 2009
03
Mar'09
Microsoft releases new CTP of Oslo SDK
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
17
Dec'07
SQL Examiner Suite synchronizes data schema, sets
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
05
Jul'07
Turn SQL data into script with SQL Populator
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
08
Jun'05
SQL Server's reporting tool goes across the board
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.
-
Managing large databases with SQL Server partitioning
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
-
The CTE, the hierarchical query and SQL Server 2005
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
-
SQL Server 2005 recursive functions and the CTE
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