Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Query Performing Slow When Issued Against A Partitioned Table
Recently, when I was working with one of our customer, I came across an interesting issue....
Date: 09/03/2014
“AddNode” operation while setting up SQL 2005 Cluster fails with an error: “Error String : The setup has encountered an unexpected error while Preparing Installation Wizard. The error is: Fatal error during installation. Error Number : 29528”
Recently, I was working on one of the customers on an issue. The resolution is simple but I...
Date: 07/10/2014
Why is it important to close the keys after retrieving the data from an encrypted table, using Cell level encryption?
When we use cell level encryption, we usually create a symmetric key, do the encryption and close...
Date: 03/29/2014
How to store the SQLBPA recommendations in a SQL database to make more use out of the recommendations data
Lot of us use SQL Best Practices Analyzer (BPA) to detect any potential errors, warnings,...
Date: 03/17/2014
Restore Database from a UNC path – Why SSMS doesn’t show network drives/paths in the restore wizard
Lot of times we get into a situation where we need to restore databases from backup files (.BAK)...
Date: 03/11/2014
SQL 2012 cluster installation fails with disk resource can’t be moved error
When I was working with one of the customers on SQL server 2012 failover cluster installation, we...
Date: 03/11/2014