(Leo Peysakhovich) As usually, most of my articles started with a specific task for my company. I am not looking for the article but the articles are finding me. Ones upon a time (starts like all those magic stories) I placed a question to myself – “How many columns in the corporate database are not

When you try to bring a SQL Server cluster resource online for a virtual instance of Microsoft SQL Server 2000, you may notice the following behavior: • The SQL Server cluster resource goes to a ‘failed’ state and does not come online. • You receive a combination of the following error messa

(Terry Voss) I thought I had it made, using my own HTML reporting methods for Web appliactions and Crystal Reports foe Windows applications, but a new tool is now of interest. With MS SQL Server Reporting Services I now have one solution for reports for Web and Windows forms applications.

(Darren Green) The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services

(Dale Elizabeth Corey) Log P.I. is an application designed to read native SQL Server transactions logs without creating performance hits. Log P.I. provides solutions for auditing, recovery, and performance. Log P.I. consists of a Client component and a Server component. It is designed to be installe

(Muthusamy Anantha Kumar) In the Database administration world, it is often necessary to run a query on the production box and then run the same query on the QA or UAT box and compare the results. In this article, I would like to introduce a method that takes advantage of an MS-DOS batch file and SQ

(Wei-Meng Lee) Microsoft has finally added reporting capabilities to SQL Server 2000. With the rollout of SQL Server 2000 Reporting Services, you can now generate reports from your database without the need to use third-party reporting tools. In this article, I will walk you through the basics o

(Ravi Okade) SQL Server 2005 implements a new feature called Snapshot Isolation or Row Versioning. If implemented on a suitable database, it has the potential to eliminate data contention in your database. It will reduce deadlocks, lock contentions and session waits if appropriately implemented.

(Joe Chang) Modern server systems are capable of supporting phenomenally high I/O bandwidths, possibly over 2GB/sec, even in dual processor systems. While there are few applications that can actually use such high I/O bandwidths, the database backup is one such function. However, a native SQL Se

(Michelle A. Poolet) Traditional database design techniques such as the Systems Design Life Cycle (SDLC), also known as the Yourdon Waterfall method, and Information Engineering (IE) were created to make design a manageable process, complete with tools, milestones, and reviews. A design-testing