SQL Server Magazine October 2005
[Focus]
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.
By William Vaughn
[Features]
Use these handy tools to stress-test your SQL Server applications before putting them into production and to tune database and query performance.
By Hari Ramachandran
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.
By Robert H. Brune
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.
By Michael Otey
[SQL Server Savvy]
Find out whether a multiprocessor server with relatively slow processors is faster than a single-processor notebook computer with a faster processor.
By Brian Moran
Get a solution to a potential resource-allocation contention problem.
By Brian Moran
This utility helps you determine how many physical processors are installed on your server.
By Brian Moran
Find out whether a side-by-side installation of SQL Server 2005 and SQL Server 2000 is feasible.
By Brian Moran
[Editorial]
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.
By Michael Otey
[Inside SQL Server]
A new capability, row-level versioning, helps SQL Server 2005 prevent some of the old locking and blocking conflicts.
By Kalen Delaney
[T-SQL Black Belt]
Although there are downsides to using dynamic execution, it can provide better performance than static code when you need to support dynamic filters.
By Itzik Ben-Gan
[Letters]
Readers write in about August's "Logical Puzzle"-- plus some updates on our Readers' Choice issue.
By Readers
[New Products]
Check out new and improved SQL Server–related products.
By Dawn Cyr
[SELECT TOP(X)]
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 Michael Otey
[Preparing for SQL Server 2005]
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.
By Matt Nunn
[Ask Microsoft]
Microsoft's Patrick Conlan comes up with a hatful of tricks to performance-tune a simple query that won't perform.
By Microsoft's SQL Server Development Team
[Hands On]
A reader highlights his favorite product: Log Explorer
By Dawn Cyr
|
