Learning one new thing every day keeps me passionate about my job. Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check and found some non-default values in sp_configure. They asked me – Which settings change in sp_configure needs restart to take effect? Do we need to remember the values?
SQL Authority News – Free Performance Tuning Videos
SQL Server Performance Tuning and Optimization is how I earn my bread at home. Lots of people often ask if I will be happy to teach them my SQL Server Performance tuning tricks and my answer is very simple – of course. I am always willing to help people learn about SQL Server Performance Tuning if they are willing to learn about the subject. I have created some Free Performance Tuning Videos.
How to Track Autogrowth of Any Database? – Interview Question of the Week #205
Question: How to Track Autogrowth of Any Database?
How to Start Database in a Single User Mode? – Interview Question of the Week #202
Question: How to Start Database in a Single User Mode?
SQL SERVER – Configuration Manager Error: The Server Threw an Exception [0x80010105]
In my previous blog, I showed one of the errors caused due to disabled WMI service. In this blog, we would learn how to fix error “The server threw an Exception [0x80010105]” while using SQL Server Configuration Manager.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
One of my clients contacted me to resolve an issue where they were seeing these errors few minutes after restarting SQL Server Service. In this blog, we would learn about how to fix error Timeout occurred while waiting for latch: class FGCB_ADD_REMOVE.
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
While playing with my virtual machine, I encountered an interesting error. In this blog we would learn how to fix error cannot connect to WMI provider [0x80070422] while launching SQL Server Configuration Manager.