(Vinod Kumar) Understnading the various locking mechanism is one of the important aspects for developing Online Transaction Processing (OLTP) applications. Now before we get into how the locks are handled, Why Locks on first place? As any databse for that matter has to maintain the concurrency and c

(Kevin Kline and Baya Pavliashvili) Transactions are an inherent part of any application that collects or manipulates data. SQL Server has to ensure the data integrity. This means that no two users should modify the same piece of data at the same time. Nor should they read “dirty” data—modified but

This article discusses various solutions for recovering data from a Microsoft SQL Server database, if a disaster occurs. This article also discusses the advantages and the disadvantages of each solution. Disaster recovery is a process that you can use to help recover information systems and data,

(Ken Henderson) This chapter updates the coverage of SQLXML in my last book, The Guru’s Guide to SQL Server Stored Procedures, XML, and HTML. That book was written before Web Release 1 (the update to SQL Server 2000’s original SQLXML functionality) had shipped. As of this writing, SQLXML 3.0 (which

When you run a Microsoft SQL Server Data Transformation Services (DTS) Package from a Microsoft Visual Basic application, the package may fail without raising any error messages to help you to troubleshoot the failure. This article describes how to troubleshoot DTS packages that you run from Visual

(Buck Woody) Have you ever had someone who treats all technology as equally mysterious ask you to take over a SQL server? He or she assumed you could handle it—after all, you know all about that “computer stuff,” right?

(Vinod Kumar) In many of the sessions and usergroups I’ve been asked by many for the best or rather should I say better practices of coding while using SQL Server 2000. The views listed below are mine and I’am sure any SQL Server Guru might not argue it otherwise. Just thought of adding sections for

(Vinod Kumar) In this article, I will walk you through what trace flags basically are and how you can use some useful trace flags in SQL Server 2000 for administering and monitoring. Trace flags are used to temporarily set specific server characteristics or switch off a particular behavior, You will

(Brian Moran) “First, do no harm” is the essence of the Hippocratic oath, which physicians adhere to when caring for patients. It’s also good advice for DBAs. When you’re trying to fix a problem, a misstep that accidentally brings down a server might also bring down your career. I use SQL Server Pro

(Vinod Kumar) SQL Server 2000 does a good job in optimizing using the present hardware setup. But more often than not it becomes important for DBA’s to analyze how healthy SQL Server is from time to time. No wonder DBAs get paid really good all around the world. In this article I would list some