The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Build a smooth-running performance-engineering process by using these design, monitoring, and maintenance techniques. Then you'll be able to anticipate certain behaviors and characteristics and determine how they will affect performance.
By Rick Dobson
ASP.NET 2.0 lets you use Visual Studio login controls with a SQL Server membership provider to dramatically simplify Web-site membership management.
By Kimberly L. Tripp
In a database performance-engineering process, applying the right design techniques will ensure smooth-running operations. Here’s a laundry list of essential technical items you need to include in your process.
By Blake Eno
By Michael K. Campbell
Check out DBMoto 5.0 if you're looking for a replication solution that's highly scalable and had been designed to help you move and copy data between heterogeneous database platforms.
By Brian Larson
The ReportViewer control is a powerful tool for integrating reports into Windows and Web form applications. You can make it even more powerful if you're willing to write a few lines of Visual Basic .NET or Visual C# code.
By Michelle A. Poolet
Are you unsure how to use supertypes and subtypes to your advantage? Learn why they are used and how to implement them correctly.
By Kalen Delaney
Row-level versioning can stress your tempdb database—but you can mitigate the increased demand by monitoring tempdb usage using SQL Server 2005 tools.
By Itzik Ben-Gan
How many hands did my wife shake at a party of eight? The answer lies in pure logic.
By Michael Otey
Despite media rumors, Intel's Itanium is still alive and well. Find out how its high-end power will save it from demise.
By Kevin Kline
A free Microsoft change-management and trending tool helps you head off potential performance problems and get the most out of your multi–SQL Server environment.
T-SQL randomization isn't particularly straightforward. But some improvements in SQL Server 2005—the use of TOP with input expressions, the APPLY operator, and the TABLESAMPLE option—pave the way toward more accurate randomization.
Using Microsoft's virtual labs, you can get hands-on experience with SQL Server 2005—but which of the 17 SQL Server 2005 virtual labs should you try first? Here's a quick preview of 5 of the most useful.
advertisement