By Rich Rollman, 07/25/2001
In this column, Rich looks at follow-up questions about some of the subjects covered in previous columns such as transforming a recordset into an XML document, querying a column ...
By Richard Waymire, 07/25/2001
Richard Waymire answers readers’ questions about estimating replication time, changing database names during a restore, and more.
By Brian Moran, 07/25/2001
Brian Moran answers readers’ questions about tracing events on a selected SQL Server machine, retrieving specified rows within a result set, and more.
By Michael Otey, 07/25/2001
Here are seven cool tools in the Microsoft SQL Server 2000 Resource Kit.
By Itzik Ben-Gan, 07/25/2001
Sometimes, the use of an auxiliary table can help you provide shorter, more efficient code than a solution that doesn’t use an auxiliary table.
By Ken Spencer, 07/25/2001
Here's the description of the meanings of security terms in a component context.
By Chip Andrews, 07/25/2001
Keep your SQL Server--based applications secure by being aware of what code is getting back to the server at every tier.
By Russ Whitney, 07/25/2001
This column, which continues last month’s discussion of analysis applications, shows you how to build an application that monitors disk usage.
By Kalen Delaney, 07/25/2001
Try these tips and tricks to keep your indexes working their best.
By Russ Whitney, 07/25/2001
Test your MDX skill with the August MDX puzzle, which deals with parent-child dimensions.
By Christopher R. Shaw, 07/25/2001
Use SQL Mail to simplify SQL Server 2000 administration and troubleshooting.
By Michelle A. Poolet, 07/25/2001
The rarely used cross join is an option when you need to create a large number of tables.
By Larry Barnes, 07/25/2001
DTS 2000’s new Dynamic Properties and Execute SQL tasks help programmers zip through package development and testing.
By Russ Whitney, 07/25/2001
Here's the answer to the July MDX puzzle.
By Chip Andrews, 07/25/2001
Excellent sources of SQL Server security information.
By Michael Otey, 07/25/2001
Is SQL Server 2000 a true .NET Server? Michael Otey says the relational database management system falls short of meeting all the .NET Server requirements. But the next SQL Server ...
By Jeffrey Bane, 07/25/2001
Ever find yourself stuck with an assignment to code against poorly designed tables? Learn some tricks that will help you get the data you need from these abnormal tables.
By Ken Spencer, 07/25/2001
Safeguard your Web applications by using COM+ components to provide vital authentication and authorization services.