Users demand not only performance and scalability, but availability of the applications they use. Achieving high availability requires a whole solution, part of which includes the SQL Server 2000 Server failover clustering. This white paper will explain what failover clustering is: how it works, con

Consider the following scenario. You are running Microsoft SQL Server 2000 Analysis Services. You install Microsoft Management Console (MMC) 3.0. In this scenario, you may receive the following warning message: MMC has detected an error in a snap-in. It is recommended that you shut down and resta

(Stephen Swoyer) SQL Server 2005 doesn’t so much constitute an overhaul as a rebirth of Microsoft Corp.’s business intelligence (BI) stack entire. Thanks to five years and more of gestation, many of the BI facilities Microsoft ships with SQL Server 2005 bear only a facile resemblance to their predec

Consider the following scenario. On a Microsoft Windows Server 2003 x64-based computer that is running Microsoft SharePoint Team Services, you try to use the Volume Shadow Copy Service (VSS) administrative command-line tool (Vssadmin.exe) to list subscribed volume shadow copy writers. You may notice

(Greg Robidoux) Another approach to SQL Server backup and restore, aside from using Enterprise Manager as discussed in my previous tip, is to use T-SQL commands. Enterprise Manager can be a quick and easy way to run backups or restores, but T-SQL offers a lot more flexibility. With T-SQL you can scr

(Abey George) In my Previous blog I had explained about SqlServer 2000 Isolation Levels and Locks. SQL Server 2005 gives us a new isolation level, SNAPSHOT, resulting in a total of five isolation levels available for transactions. When the SNAPSHOT isolation level is enabled, each time a row is upda

(Scott Mitchell) A common pattern in web development is providing paged access to data. Rather than displaying the entire contents of a report or database table to an end user, developers often show only a subset of records per web page, with controls for moving from page to page. With ASP.NET 1.x,

(Baya Pavliashvili) Standby servers are a great mechanism for ensuring the high availability of your enterprise applications. In this tip I’ll define standby server and offer options and recommendations for configuring and maintaining such servers. (R)

(Abey George) Before going into SnapShot Isolation in SqlServer 2005, I thought that it will be better if I explain about SqlServer 2000 Isolation Levels and Locks. Even today, some who deal with databases don’t seem to have an adept knowledge of this. There are about 4 transaction isolation levels.

(Muthusamy Anantha Kumar) Let us assume that your production server resides in New York and your Disaster recovery site is 3000 miles away, say San Francisco. Let us also assume that your backup policy in production server is a nightly full backup and transaction log backup every 15 minutes and you