srgolla

So you are comfortable with SQL Trace events and suddenly you heard that it is on the deprecated list for SQL 2012. Are you wondering if there is an easy way to convert a SQL trace file to an extended event file ? Here is an easy way to convert...

As Always On is a new feature and many DBAs and Infrastructure teams have several questions regrading this solution, I thought of writing a blog post with one line answers for some of the most common FAQs on Always On solution. I will be adding more questions...

Several DBA’s asked me these questions about SQL Server statistics at different customer places. a) Should we disable Auto update stats for the database and run maintenance plans instead? b) What sampling rate does Auto Stats use? Can we control...

This is a basic flowchart explaining SQL Server Scheduling at a very high level. References: Book: Professional SQL Server 2008 Internals and Troubleshooting Book: Microsoft® SQL Server® 2008 Internals Articles on www.sqlskills...

Have you been seeing this error on your SSRS Subscriptions page. Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 8007007e. Mail will not be resent...

In case you are getting cluster validation errors while installing SQL 2008 on Windows Cluster and you see the following message Please follow these directions to troubleshoot the problem: 1) Download Procmon from sysinternals http://technet...

Today, While trying to simulate an SRDF copy scenario to one of my customer. I was trying to copy the system and the user database files to another machine. I was trying to copy all the files from the location " C:\Program files\Microsoft SQL Server...

Hi Everyone, I am Sri Krishna Raghavender Golla. I work for Microsoft as SQL Premier Field Engineer. I will post all my experiences with the SQL Server product and I want to share all my experiences and my learnings to the SQL community. Please...