(Jeremy Kadlec) Long-term, highly performing systems serve as a tremendous asset to an organization, but do not happen by mistake. They are initially a result of comprehensive design and development (from both the hardware and software perspectives) to meet high throughput requirements validated by

In a logical expression, the comparison of the Data Transformation Services (DTS) Connection Object password will always return false and an empty string will be returned when attempting to display the password. This only occurs after installing Service Pack 2 for SQL Server 7.0.

(G Vijayakumar) When I was using SQL Server, I was not using the “order by” clause properly. I always say myself that when I want the data in a particular order, I should use order by clause in select statement otherwise leave to the SQL Server. I presumed MS-SQL Server will return the data in i

(Craig Utley) Data-warehousing projects are prone to failure. How prone is subject to debate. Various studies show wildly different percentages of failure. For example, according to the Data Warehousing Information Center article “The Case Against Data Warehousing” (http://www.dwinfocenter.org/again

When it comes to clustering, there aren’t a lot of books to choose from, especially on Windows 2003 clustering. So if you are new to clustering, and are considering clustering either Windows 2000 or Windows 2003 (both topics are included), then you will want to consider this book.

(Brian Moran) I know I can view a job’s status from Enterprise Manager, but I need to view the status from a program or SQL query. How can I create an SQL batch to programmatically test whether SQL Server Agent is running a job? (R,$)

(Marcin Policht) We have described, so far, authorization based on a predefined fixed server (determining a set of SQL server-wide privileges) and database (applying to database objects and activities) roles. We have also discussed application roles, which makes the level of permissions independent

The network redirector, the Rdr.sys file, caches data locally for files that it accesses on a Microsoft networking server. When SQL Server generates the snapshot, SQL Server tries to write the snapshot files to the UNC share or to the drive location. If network redirector caching is enabled, SQL Ser

(Chris Kempster) This article provides a short overview of attaching and de-attaching databases. The article does not mention any GUI functionality (on purpose of course) as the GUI is simplistic and self-explanatory. This, and other articles I write will focus on the “command line” (namely Quer

You installed a virtual instance of Microsoft SQL Server 2000 by using a custom installation, but you did not install some of the SQL Server components, such as Replication Support. You cannot then add those SQL Server components to your virtual instance of SQL Server by running SQL Server Setup aga