By Andrew Georgopulos – In this 10-Minute Solution, I discuss the controls and settings that go into transaction management and describe how to debug deadlocks by integrating resources in a manner that balances concurrency and integrity.

By Randy Dyess – Learn the basics of how to create and manage SQL Server stored procedures.

As we learn more about SQL Server and Transact-SQL it is easy to become overwhelmed with the amount of information out there. I can recall hundreds of times when I have said, “I know there is a (stored proc, DBCC command, SQL statement, ect) out there that does that, I just can’t remember its name.”

This article provides the required code for a DTS ActiveX Script task, that overwrites the DTS package error files, and prevents them from growing huge!

From SQLTeam – This Reader Challenge #3 solution is quite a bit different from the first solution I posted. And it’s chock full of “sqlicious” goodness. And a suprise at the end!

By Barbara Darrow – Precise Software Solutions this week added a performance management tool for SQL Server 2000 to its roster. Available now, the Precise/Indepth software uses technology developed by the company with Microsoft to glean better metrics about database performance.

Learn from Microsoft experts how to code scalable, secure, high-performance server and datacenter applications for Windows 2000 and Windows .NET Servers.

How do I create stored procedures for performing a log shipping role change without having to create a Data Transformation Services (DTS) package to copy the logins from the primary server to the secondary server?

By Liesbeth Evers – Network managers can save their companies millions by forcing users to delete old data, but only if they rid themselves of the “whipping boy” role. Four out of five company data records serve no business purpose because they contain orphaned, duplicated or stale data.

By Barbara Darrow – NetIQ’s new SQL Management Suite 1.1, which is now being shipped, comes with two of its four component applications upgraded. The revised DiagnosticManager gives database administrators (DBAs) new reports and views and promises to help them better manage databases and tabl