Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
NORECOMPUTE : Can lead to SQL server performance degradation!!
ANALYSIS:- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat...
Author: Harsh Chawla Date: 01/10/2012
Procedure Cache-Part II
Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing...
Author: Harsh Chawla Date: 12/12/2011
Procedure cache - Part I
Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing...
Author: Harsh Chawla Date: 12/12/2011
Troubleshooting Kerberos Delegation Using DelegConfig
Gain an expertise in solving the "Kerberos Delegation" issues using one of the useful...
Author: Harsh Chawla Date: 12/12/2011
What's execution log in Reporting services?
Check out our video blog to gain in depth knowledge about importance of "Execution Log" in reporting...
Author: Harsh Chawla Date: 12/07/2011
Transparent Data Encryption (TDE)
Leverage our video blog to empower your knowledge on TDE. Highlights of this video blog :- 1....
Author: Harsh Chawla Date: 11/17/2011
Demystifying SQL server memory concepts video
Leverage our video blog to empower your knowledge on "SQL Memory".This video will help you to gain...
Author: Harsh Chawla Date: 11/16/2011
SQL server service pack installation may fail if your instance name is a Windows reserved word
Okay, so I woke up one morning and decided that this was a good day to patch my SQL Server 2008 R2...
Author: Harsh Chawla Date: 11/02/2011
Multiserver administration
In this video presentation you will learn in depth about Multiserver administration For better...
Author: Harsh Chawla Date: 10/31/2011
SQL Server could not create a subscription for Subscriber 'ServernameInstanceName'.The value for the @sync_method parameter is not valid
Recently we worked on a support case where creation of a Subscription was failing with the following...
Author: Balmukund Date: 10/13/2011
DDL Triggers
Hello Everyone, In this presentation, you will learn about what are DDL triggers and how they could...
Author: Harsh Chawla Date: 10/10/2011
The mystery of incorrect filegroup size
Recently, there was a question that why the SQL Server DMVs were reflecting incorrect information...
Author: Harsh Chawla Date: 09/26/2011
Creating stoplist on database of compatibility 80/90 in SQL server 2008
Introduction: In this blog we will see how to add a stopword in a stoplist and also look at one of...
Author: Harsh Chawla Date: 08/31/2011
Another reason of Index logical fragmentation!
Problem Description: Indexes gets fragmented soon after rebuilding index Detailed description You...
Author: Harsh Chawla Date: 08/30/2011
Implementing SSL encryption for SQL Server in a DNS forwarding environment
Let’s say you have an environment which implements DNS forwarding. In such a setup, the client uses...
Author: Harsh Chawla Date: 08/08/2011
SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers
Recently, I worked on a case with one of my clients wherein SQL Server was encountering several...
Author: Harsh Chawla Date: 08/08/2011
Moving data from the mdf file to the ndf file(s)
SCENARIO: 1)You have an MDF file from a database which has grown up to a size that has almost...
Author: Harsh Chawla Date: 08/02/2011
How to Convert UTC Time to Local Time in SQL
There currently isn’t a way in T-SQL to convert UTC Time to Local time; however this seems to...
Author: Harsh Chawla Date: 07/29/2011
What's Performance Dashboard and how it can help in troublehsooting SQL issues.
In this presentation you learn about: 1. How to install performance dashboard 2. How to use...
Author: Harsh Chawla Date: 07/07/2011
What are SQL server audits - a new feature in SQL server 2008
In this presentation, you will learn about the complete description of the SQL audits , their...
Author: Harsh Chawla Date: 07/06/2011
What are plan guides and how it could help in managing performance of the queries
In this presentation, you will learn about what are the plan guides and how they could help the DBAs...
Author: Harsh Chawla Date: 06/17/2011
Managing SQL resources using resource governer
In this presentation, you will learn about how you could manage SQL resources using resource...
Author: Harsh Chawla Date: 06/16/2011
Whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup
In this video we will see whats the backup compression in SQL server 2008 and how it can help to...
Author: Harsh Chawla Date: 06/15/2011
Problems may occur when you try to install SQL Server 2008 R2 Shared Features if the %TEMP% folder is Encrypted.
Symptoms: You might see a couple of components from the “shared features” failing with the error...
Author: Balmukund Date: 06/06/2011
What are Virtual log files - VLF in SQL server - video
In this presentation you will learn : 1. Very basics of transaction logs internal structure i.e....
Author: Harsh Chawla Date: 06/01/2011
Implicit conversions and their implications on the SQL query execution
In this presentation , you will learn about what are implicit conversions. What can be their...
Author: Harsh Chawla Date: 06/01/2011
INF : Restore Database UI fails with error: "Length cannot be less than zero. Parameter name: length"
Recently we came across a situation where one of the customer was trying to restore a Database...
Author: Balmukund Date: 05/31/2011
INF : How does Logical Record Feature Works in Merge Replication
By default, merge replication processes data changes on a row-by-row basis. In many circumstances...
Author: Balmukund Date: 05/31/2011
INF: SQL Server Extended Stored Procedures & behaviour change starting with Windows 2008
Many of you SQL folks out there have extended stored procedures installed and being used in your SQL...
Author: Balmukund Date: 05/24/2011
INF: Hey, my SQL Server Service is not starting – what do I do?
This is one of those challenging situations when customers call us at times. I can understand the...
Author: Balmukund Date: 05/11/2011
Errors Raised with Severity/Level 16 May Cause Transactions into Doomed State
Consider a scenario wherein you are doing some operation which is generating an error with...
Author: Balmukund Date: 05/11/2011
Presentation Material for Webcast on Performance Dashboard
On 4th May 2011 (Day 3), Amit Banerjee presented webcast on “Understanding Performance Bottlenecks...
Author: Balmukund Date: 05/10/2011
Presentation Material for Webcast on SQL Server Full Text Search
On 3rd May 2011 (Day 2), Sudarshan presented webcast on “Optimizing and Tuning Full Text Search for...
Author: Balmukund Date: 05/04/2011
Presentation Material for Webcast on SQL Server Resource Governor
On 2nd May 2011 (Day 1), I presented webcast on “Managing and Optimizing Resources for SQL Server”....
Author: Balmukund Date: 05/04/2011
Service broker concepts and troubleshooting
In this presentation you will learn about what's service broker and it's basic troubleshooting...
Author: Harsh Chawla Date: 05/03/2011
How to configure and monitor log shipping in sql server
In this presentation, you will learn about how to configure and monitor logshipping. Presented by:...
Author: Harsh Chawla Date: 05/03/2011
SQLDIAG: There are no instances of version 10 on this computer
But really SQLDIAG I do, and I am not lying!! I have helped multiple users of SQLDIAG (not SQL...
Author: Balmukund Date: 04/05/2011
INF: How to retrieve data from a large XML string
We encountered an interesting issue some time back. We already had XML data inserted into a SQL...
Author: Balmukund Date: 03/18/2011
SQL server 2008:Declarative Management Framework-DMF
In this presentation you will learn about working of Declarative Management Framework with demo....
Author: Harsh Chawla Date: 02/25/2011
SQL server 2008: Change Data Capture
In this video we are going to present a brief demo of how CDC works and it's functionality....
Author: Harsh Chawla Date: 02/25/2011
SQL server 2008: Extended events
In this video, you will learn about how to extended events are configured and how they work:...
Author: Harsh Chawla Date: 02/25/2011
SQL server 2008 clustering using Hyper-V-Video
In this video you will learn about how to configure SQL 2008 Cluster using hyper-v on windows 2008....
Author: Harsh Chawla Date: 02/25/2011
PRB: SQL Backups to a UNC path fail with OS Error 1 (Incorrect Function)
Symptoms When you try to take a SQL Server database backup to a UNC path (\server\folder), you get...
Author: Balmukund Date: 02/17/2011
SQL Nexus and RML Utilities: A primer on the issues that I have dealt with last year
I have answered multiple queries last year regarding the tools SQL Nexus and RML Utilities via MSDN...
Author: Balmukund Date: 02/07/2011
Unable to read trace definition file Microsoft SQL Server TraceDefinition n.n1.n2.xml
Symptoms When you open SQL Server profiler, and try to start a new trace (or when try to open...
Author: Nikesh Mhatre Date: 01/14/2011
Case Study: Troubleshooting a Slow Log Shipping Restore job
Scenario Consider a scenario where you have a Log shipping setup with a STANDY secondary database...
Author: Balmukund Date: 01/07/2011
Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths
It's has been couple of years for me working on SQL Server and I keep coming across various SQL...
Author: Balmukund Date: 01/07/2011
Microsoft SQL Server 2005 Service Pack 4 Released!
The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download,...
Author: Balmukund Date: 12/17/2010
SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
As you might be aware that SQL Server Code-Named “Denali” has introduced a new feature called Always...
Author: Balmukund Date: 12/17/2010