Varun Dhawan's Blog
Hands-on with SQL Server
Moving From MSDN To WordPress :: New Blog URL
“For everything you have missed, you have gained something else, and for everything you gain,...
Author: Varun_SQL Date: 05/16/2011
SQL Server 2005 SP4 RTM Release………what it means with RTM or without RTM?
SQL Server 2005 Service Pack 4 (latest SP in SQL 2005) was publically released on...
Author: Varun_SQL Date: 02/18/2011
Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths
It's has been couple of years for me working on SQL Server and I keep coming across various...
Author: Varun_SQL Date: 01/09/2011
SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
You may have seen the announcement of release SQL Server Code-Named “Denali” in recent PASS...
Author: Varun_SQL Date: 12/22/2010
Microsoft Codename Atlanta::How to get in there….
To begin with, lets first get the basics: What is Atlanta? Microsoft Codename Atlanta...
Author: Varun_SQL Date: 11/30/2010
Create a SQL Server Database on a network shared drive
Hello All, Sometime back, I have written blog post on ‘Backing-up SQL Server Database on a...
Author: Varun_SQL Date: 09/02/2010
TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths
Hi Guys In a recent issue with a customer, I came across a strange SQL belief (or say a DBA...
Author: Varun_SQL Date: 08/27/2010
SQL Server 2008 setup Error - Microsoft .NET Framework 3.5 installation has failed. I know i have it installed already!
I recently worked with a customer who ran into an interesting situation. The issue deals with SQL...
Author: Varun_SQL Date: 08/01/2010
Steps to create merged (Slipstream) to Install SQL Server 2008 RTM + Service Pack 1 + Cumulative Update
Starting SQL Server 2008, you can leverage the new “Slipstream” feature. In the below post, I’m...
Author: Varun_SQL Date: 05/26/2010
DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]
Here’s an interesting issue that surfaced recently while troubleshooting a database performance...
Author: Varun_SQL Date: 04/23/2010
SQL Server 2008 RTM Support Ends April 13, 2010. Time for SP1
SQL Server 2008 RTM finally reaches it’s end of support tomorrow i.e. April 13, 2010. Here’s snippet...
Author: Varun_SQL Date: 04/12/2010
End of Support for SQL Server 2005 SP2. Buckle up for SP3
So as the year 2010 settles in, we have approached to an end of support for SQL Server 2005 Service...
Author: Varun_SQL Date: 01/13/2010
SQL Server Management Studio (SSMS) – Unable to detect Tape Drive
Today I was walking a customer through SQL Server database backup on tape and realized that I’m...
Author: Varun_SQL Date: 12/28/2009
Index usage by %Like% operator – Query Tuning
Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning...
Author: Varun_SQL Date: 11/30/2009
BCP command fails with ERROR:"User name not provided…", when both SQL Server 2000 and SQL Server 2005 Tools are installed on machine
This blog post has been moved to my team blog site >>...
Author: Varun_SQL Date: 10/11/2009
Understanding and Troubleshooting ‘Win2003 PF Usage’ on the server running SQL Server 2000
I’ve been recently asked to explain the reason of high PF Usage on Windows 2003 server...
Author: Varun_SQL Date: 09/04/2009
Steps to change the default location of SQL Server /SQL Server Agent - Error log files
Recently came across a customer scenario, wherein the 'ask' was to change the current...
Author: Varun_SQL Date: 08/27/2009
How to: Archive more that six SQL Server Error Logs using SSMS / EM
The following post describes how you can configure your SQL Server to archive more than six Errorlog...
Author: Varun_SQL Date: 07/20/2009
Error “Failed to open a file. Access is denied”, when attempting to open SQL 2005 Profiler Trace
Hello All, Yesterday while doing the regular stuff, I was reported a strange error related to...
Author: Varun_SQL Date: 06/26/2009
Backup and Restore SQL Server Database to a network shared drive
Hello All, You have a situation wherein you want to backup SQL Server database to a network mapped...
Author: Varun_SQL Date: 06/04/2009
SSMS Error “HRESULT: 0x80131040” encountered while opening a Table in Design-View
Hello, April 09, has lot more than expected. During my usual stuff, I was trying to open a table in...
Author: Varun_SQL Date: 04/29/2009
Unable to Drop Data-File – Error: Time-out occurred while waiting for buffer latch type 3
Hello All, This month have been filled with interesting and thought provoking issues. Here's a new...
Author: Varun_SQL Date: 04/24/2009
How To: Improve SQL Server Management Studio Start-up Time
Hi Friends, Here's something interesting about Management Studio 2005 (SSMS) When you launch SQL...
Author: Varun_SQL Date: 04/16/2009
How to: Copy “Column Header” in SQL 2008 SSMS, SQL 2005 SSMS and SQL 2000 Enterprise Manager
SQL Server Management Studio 2008 SQL Server Management Studio 2008 (SSMS) has never failed to...
Author: Varun_SQL Date: 04/10/2009
How to: Verify path for SQL Server Error Log Files
Hello Friends, March has been a busy month, and it is not over yet. Taking some time off to blog; as...
Author: Varun_SQL Date: 03/21/2009
Lock Pages in Memory in SQL Server 64-Bit
Hello All, Well after a long time of no writing, I finally found an interesting topic and also some...
Author: Varun_SQL Date: 02/25/2009
Benefits of Backup Compression - Faster BACKUP / RECOVERY
This is in continuation to my blog that I posted on 23rd Dec, 2008 on “SQL Server 2008 Backup...
Author: Varun_SQL Date: 01/17/2009
How to identify weather a Database Backup Set was compressed using WITH COMPRESSION
This is in continuation with my first blog “SQL Server 2008 Backup Compression”. I received this...
Author: Varun_SQL Date: 12/26/2008
SQL Server 2008 Backup Compression
I’m still in process to make myself familiar with latest SQL Server release i.e. SQL Server 2008. To...
Author: Varun_SQL Date: 12/23/2008
My First Blog – Welcome All
Hello World ! Welcome to my first blog post. With this blog post, I intend to help online community...
Author: Varun_SQL Date: 12/22/2008