How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...

How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-
1) Open SQL Server Installation Center > Go to...

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...

Wishing You a Very Happy Holi

Steps for Windows Cluster Installation on Windows Server 2008

Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008.
Step 1: Validate Cluster Configuration
a)...

ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...

System Configuration Check – Without Starting SQL Server Installation

Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it...

Cumulative Update – 8 for SQL Server 2012 Service Pack 1 Is Now Available !

The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all...

Cumulative Update – 15 for SQL Server 2008 Service Pack 3 Is Now Available !

The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...