The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
By William Vaughn
The latest release of Microsoft’s data-access tool, ADO.NET 2.0, has a slew of new features designed to solve specific developer problems. Get an overview of what the new release can do to solve your development dilemmas.
In Visual Studio 2005, Microsoft has hidden some commonly used features. Here's how to get back the features you're used to.
By Michael Otey
One function that SQL Server lacks is the ability to compare and reconcile versions of a database. See how Red Gate Software’s SQL Compare fills this important gap and decide if it meets your organization's needs.
T-SQL debugging in earlier versions of Visual Studio required creative workarounds. In Visual Studio 2005, the problems are fixed--and new features make debugging easier.
By Brian Moran
Find out whether a multiprocessor server with relatively slow processors is faster than a single-processor notebook computer with a faster processor.
By Dawn Cyr
A reader highlights his favorite product: Log Explorer
Check out new and improved SQL Server–related products.
This utility helps you determine how many physical processors are installed on your server.
By
Microsoft's Patrick Conlan comes up with a hatful of tricks to performance-tune a simple query that won't perform.
Readers write in about August's "Logical Puzzle"-- plus some updates on our Readers' Choice issue.
By Kalen Delaney
A new capability, row-level versioning, helps SQL Server 2005 prevent some of the old locking and blocking conflicts.
By Itzik Ben-Gan
Learn the solution to September's puzzle, The Missing Buck, and see whether you can determine the states of the alternating lamps in October's puzzle.
Find out whether a side-by-side installation of SQL Server 2005 and SQL Server 2000 is feasible.
Knowing what 2005 offers puts you in the driver’s seat, so grab the latest Community Technology Preview (CTP) and get up to speed on SQL Server 2005.
Although there are downsides to using dynamic execution, it can provide better performance than static code when you need to support dynamic filters.
By Robert H. Brune
Take a trip through history and learn why SQL Server's first date is so late.
All BI technologies fundamentally deal with time history and involve logic based on time. BiTemporal database designs enhance these technologies by providing a framework for temporal data.
COM-based ASP and its successor ASP.NET 1.x are the most popular Web-development frameworks for SQL Server. ASP.NET 2.0 has several new features that make it an even more productive, powerful Web-development platform.
By Matt Nunn
New BI tools in SQL Server 2005 let end users report and learn from data and give developers the ability to embed data mining in applications.
Here's how to find out more about BiTemporal technology.
Get a solution to a potential resource-allocation contention problem.
By Hari Ramachandran
Use these handy tools to stress-test your SQL Server applications before putting them into production and to tune database and query performance.
advertisement