SQL Server Magazine May 2003
[Focus]
In the aftermath of the Slammer worm, Microsoft Vice President of SQL Server Gordon Mangione explores why customers aren’t applying patches, shares how Microsoft plans to solve these problems, and looks to the future of security for SQL Server.
By Brian Moran
[Features]
If you’re diving into ADO.NET, you might be wondering how you can use connection pooling to improve your applications’ performance. Here are some basic connection-pooling concepts you’ll need to know when you’re ready to get your feet wet.
By William Vaughn
[SQL Server Savvy]
Find out what your options are when determining the port number a SQL Server instance is using.
By Brian Moran
Both ISQL and xp_sqlmaint are particular about whether parameters are enclosed in single and double quotes. Find out if using the -i switch is a suitable option for you.
By Brian Moran
Have you noticed entries in the sysindexes table for indexes that you didn't create? Read on to find out what these entries are for.
By Brian Moran
[Editorial]
One aspect of database performance that's rarely considered is the OS itself, which ultimately handles all I/O requests.
By Michael Otey
[SQL Seven]
ADO.NET isn’t just a fancy new wrapper for the COM-based version of ADO. Here are seven tips to help you write better ADO.NET applications.
By Michael Otey
[Inside SQL Server]
With just a few counters and a little experience, you can monitor and manage your SQL Server memory.
By Kalen Delaney
[Solutions by Design]
“A rose by any other name would smell as sweet,” but when you change a database object’s name, you can create confusion and poor performance. Here are some tips for choosing and using a good naming convention.
By Michelle A. Poolet
[T-SQL Black Belt]
A histogram is a simple means of gathering statistics for analysis. But what's the best way of generating histograms?
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft's SQL Server development team takes a close look at a query that works from the inside out to return information from tables that are related only indirectly.
By Microsoft's SQL Server Development Team
When you delete rows, pages, or extents, SQL Server can mark those objects as "ghosts" and clean them up later. Here's how one DBA unearthed these ghostly objects while investigating a mysterious error code.
By Microsoft's SQL Server Development Team
How can I keep SQL Server 7.0 from truncating varchar data?
By Microsoft's SQL Server Development Team
[Exploring XML]
You’ve stored open content from your XML document in your database. Now you need to merge the content with relational data in an XML query result. Read on to see how you can use FOR XML Explicit queries and XML Views to return the open content.
By Rich Rollman
[Letters]
Readers ask why so many SQL Servers were connected to the Internet--where they were vulnerable to Slammer, whether linked servers work for Oracle running on Solaris, and comment on choosing a .NET language.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
