Converting a SQL Trace to an Extended Event session

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 a SQL Trace into an Extended…

0

SQL Server 2012: Always On FAQs

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 as we go. I have collected this information…

11

SQL Server Statistics: Explained

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 it? c)       Should we update statistics after rebuilding indexes during maintenance plans?   Here is…

8

SQL Server Scheduling Flowchart

  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.com

0

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.

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.   This generally occurs when you have missing DLL files which are required to send an email. So how…

0

SQL 2008 Cluster Install Errors :KB953748

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.microsoft.com/en-us/sysinternals/bb896645 2) Setup filters in Procmon to include processname as “setup100.exe”  3) Now,Go to the installation screen and Click on…

1

Unable to open the MSSQL install folders – Transfer Ownership Issue

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\MSSQL10_50.MSSQLSERVER\MSSQL\Data” it is a  SQL 2008 R2 standalone instance on a Windows 2008 R2…

0

My first blog entry

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 provide me some feedback if there is anything that needs to be improved on my blog…

2