SQL Server Magazine January 2004
[Focus]
Executing SQL commands from your applications is easy when you understand ADO.NET's SqlCommand object.
By Michael Otey
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.
By Rick Dobson
[Features]
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 Tom Davidson
[SQL Server Savvy]
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.
By Brian Moran
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.
By Brian Moran
[Editorial]
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 Michael Otey
[Inside SQL Server]
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 Kalen Delaney
[Mastering Analysis]
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 Russ Whitney , et al.
[Solutions by Design]
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 Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
[Letters]
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.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
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.
By Michael Otey
[Preparing for SQL Server 2005]
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 Eric Brown
|
