(daffrey) Have you ever had to deploy a SQL Server database to a customer? If you have, then you will know that it is certainly not as simple as deploying an application that uses an MS Access database.

(J.D. Meier, Srinath Vasireddy, Ashish Babbar, and Alex Mackman) This guide provides end-to-end guidance for managing performance and scalability throughout your application life cycle to reduce risk and lower total cost of ownership. It provides a framework that organizes performance into a handful

In enhancing existing management tools and designing new ones for SQL Server 2005—formerly code-named Yukon—Microsoft’s SQL Server Tools team followed two guiding principles: “no secrets” and integration. Euan Garden, product unit manager for SQL Server Tools for SQL Server 2005, tells SQL Server Ma

(Shiv Kumar) The article here is to identify and track the source for the cause of deadlock. Typically in a system integration solution you wouldn’t encounter deadlock in your testing. This deadlock might creep in production or in live phase as your solution talks to different systems, which is con

As a rule of thumb, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases–such as an identity column, or some other column where the value is increasing–and is unique. In many cases, the primary key is the ideal

(Gregory A. Larsen) How many times have you had problems sending SQL MAIL or SQL Agent Mail from SQL Server because the Exchange server was taken down or not working? Have you ever tried to connect up SQL Mail and/or SQL Agent mail to Exchange through a firewall or across domains, only to find out t

This article can help you to resolve connectivity problems with Microsoft SQL Server 2000. This article contains descriptions of common connectivity problems and the steps that you can take to help resolve your connectivity problems.

(Ken Henderson) SQL Server 2000 clients connect to SQL Server using a stack of APIs, object libraries, and protocols. Ken Henderson walks through each one and explains how they work and interoperate.

(Armen Hakobyan) Workers of the one of our division departments installed an application that used MSDE as a database server. That application was constantly hanging up with no visible reason until we finally found out that the cause of such strange behavior was the too quickly growing transaction l

(John McCormick) If you develop applications and e-commerce Web sites with any version of Dreamweaver MX, MX 2004, or UltraDev 4, they may contain serious to critical vulnerabilities that can allow an attacker to access the back-end database server without discovering a valid user ID and password.