The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Use SQL Server and ASP.NET to build a powerful Web-based membership application, and see how to use ADO.NET's SqlCommand object. Then, open Microsoft's performance-tuning toolbox, which uses waits and queues information to diagnose problems.
By Michael Otey
The DBCC command has powerful documented functions and a lot of undocumented capabilities that you might not know about. Here are seven undocumented DBCC commands that can give you a peek at what’s going on inside your SQL Server system.
Oracle's Oracle 10g grid computing technology has its advantages--and one big disadvantage. And so far, SQL Server's clustering capabilities remain competitive.
By Itzik Ben-Gan
Sometimes, the table order you specify doesn't affect the order in which SQL Server processes joins or the query result. But here are two techniques you can use to control the order while keeping your code simple.
By Tom Davidson
Microsoft's SQL Server Customer Advisory Team uses a repeatable methodology involving waits and queues to diagnose and solve customer performance problems. In this article, the team opens its toolbox and shares its effective techniques.
By Michelle A. Poolet
Few medical research organizations have funds to purchase and maintain elaborate database systems for tracking diseases, so many researchers must devise their own tracking systems. For these people, an effective database design is literally a lifesaver.
By Rick Dobson
SQL Server and the .NET framework make a powerful pair for developing enterprise applications. If you're not familiar with .NET's languages and capabilities, this article's sample Web application can quickly bring you up to speed.
Diagnosing network problems is an important part of any performance-tuning process. This sidebar describes how to use the NETWORKIO wait type to determine whether network problems are affecting your system's performance.
Executing SQL commands from your applications is easy when you understand ADO.NET's SqlCommand object.
By Eric Brown
One of the most exciting new technologies in SQL Server Yukon provides a programmatic access layer that lets database administrators and developers work directly with database objects in any Microsoft .NET language.
By Dawn Cyr
Check out the latest SQL Server-related new and improved products.
By Russ Whitney
Discover the solution to the previous MDX puzzle.
By Brian Moran
With sp_detach_db, you can quickly detach the database from the server, then reattach it by using sp_attach_db, specifying a new location for the physical log file.
Information about the correct values to use in an Object Type filter within SQL Server Profiler is poorly documented, but here's the full list of values for Profiler filters and some advice on using them.
Challenge yourself with this month's puzzle.
By Kalen Delaney
The ALTER TABLE command can make many changes at once and still gives better performance than dropping and recreating a table. Find out how it all works.
By Tim Ramey
If you’ve ever tried to connect users to Analysis Services over HTTP, you know you can’t use the default security protocol. Fortunately, Analysis Services lets you choose from three security options.
By
In response to Michael Otey's December 2003 editorial, "The Threat from Below," one reader agrees that Microsoft is leaving small business behind and another reader suggests that small businesses use MSDE.
advertisement