When you use SQL Profiler in Microsoft SQL Server 2000 to audit connections to SQL Server 2000 by using the Audit Login event class, login names that contain leading zero characters are be visible in the following contexts: • The SQL Profiler graphical user interface • A trace file that is sav

(Paul Bertucci) Data replication is a powerful feature of SQL Server that can be used in many business situations. Learn how to use data replication as a high availability solution. (pdf)

(Marcin Policht) Continuing our discussion about monitoring execution of SQL Server 2005 Integration Services packages, which we initiated in our previous article by reviewing logging functionality, we will now turn our attention to debugging and its considerably more sophisticated capabilities.

(Jagadish Chaterjee) The previous article mainly concentrated on fetching information available in SQL Server 2000. This article explains how to manage SQL Server 2000 using WMI together with Visual Basic.NET language.

(Adam Machanic) We’ve had seven years to get used to SQL Server’s management tools, Query Analyzer and Enterprise Manager. Although these tools have their flaws, we know our way around them. For many long-time SQL Server DBAs, firing up Query Analyzer is like coming home after a long day. Some might

When you run the DBCC INDEXDEFRAG statement, null mode page locks may accumulate on defragmented pages. These page locks may consume server resources. Then, the transactions that accumulate the locks try to escalate the page locks to table locks. The transactions escalate the page locks to try to re

(Shushmul Maheshwari) As the number of people who are conducting business from outside the corporate workplace increases, the need to access corporate databases using devices such as mobile phones and portable computers also increases.

(Greg Robidoux) To date, most backup and recovery tips talk about best practices for database backups, checklists to follow and troubleshooting backup problems. Usually this is where the discussion stops, and not much is written about what to do with all of these backup files for long-term storage.

To determine the cause of some problems in Microsoft SQL Server, you may have to capture user dump files. However, you may not be able to capture these files in SQL Server 2000 Analysis Services.

(Brian Mains) Recently I had a large amount of data for an in clause in a SQL string. Rather than formatting each item to appropriately meet the SQL parser syntax, I used Microsoft Word instead. Microsoft Word has many functions that can assist a developer or analyst with data queries or data manipu