(Subramanyam Krishna Murthy) The GO command plays a very important role in Microsoft SQL Server. It signals the end of a batch of SQL statements and executes them as a whole. Seems simple enough. But using GO can be disastrous if you don’t understand its usage in a certain scenario.

(Marcin Policht) Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution. While SQL Server 2005 offers a number of different w

(Sanjay Gulati) Today I was trying to access the web page and getting following error Error Message:Login failed for user ”. The user is not associated with a trusted SQL Server connection.

(Greg Robidoux) Archiving database backups is probably relatively low on most DBA to-do lists. Unfortunately, it’s one of those things that has to be done. (R)

(John Papa) SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification

(Jayaram Krishnaswamy) If you want to transfer data between SQL 2000 and SQL 2005, this article explains how. Thanks to the SQL Server Import Export Wizard, it might even be easier than you think.

Microsoft SQL Server 2005 uses the Microsoft Windows Address Windowing Extensions (AWE) API to support very large amounts of physical memory. SQL Server 2005 can access up to 64 gigabytes (GB) of memory on Microsoft Windows 2000 Server and Microsoft Windows Server 2003.

(Neil Boyle) One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted

(Tim Chapman) As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we’re expected to answer any number of questions, via appropriate documentation, about who

(Kevin Beaver) If you’re performing a penetration test or higher-level security audit of your SQL Server systems, there’s one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentica