One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time.
First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never scheduled it for individuals was the content of the class was customized carefully for a specific organization. However, I believe it is time now when I can announce this class to everyone.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
What is Consolidation of Index? – Interview Question of the Week #212
Question: What is Consolidation of Index?
SQL SERVER – Enabling Older Legacy Cardinality Estimation
Yesterday, I had a very interesting situation, one of our Comprehensive Database Performance Health Check client immediately called me on Skype with his entire server going continuously stopping due to a very toxic poison wait type of Resource Semaphore. Though, we had a good idea how to fix the wait type the real issue was the server was not staying up long enough to put us a patch in the system. It was extremely frustrating for us and finally, we were able to deploy the patch Enabling Older Legacy Cardinality Estimation.
SQL SERVER – Find Out Current Language of the Session
After reading my post SQL SERVER – Puzzle – Playing with DateTime with Customer Data, one of my blog readers asked me “How to find out the current language setting of the session?”
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
I am not sure what changes I made in one of my Virtual Machine, but I was running into an issue. In this blog, we would discuss how to fix error “The ‘SqlStudio Profile Package’ package did not load correctly” while launching Visual Studio.