Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the negative impact of the Database Engine Tuning Advisor (DTA). I was able to help them achieve this by removing the Hypothetical Indexes they had added using the DTA.
SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account
This was the first experiment with gMSA account in my lab and I faced an interesting issue. In my lab environment, I have a complete domain server and member servers. Once I configured gMSA for SQL Server service and restarted the machine, SQL Service didn’t start automatically even though it was set for an automatic startup as shown below.
SQL SERVER – Error: 18456, State 149 – Login-based Server Access Validation Failed With an Infrastructure Error. Login Lacks Connect Endpoint Permission
Sometimes while reproducing a situation results in another new error and I get an idea for a new blog. In this blog we would talk about an error Login-based server access validation failed with an infrastructure error. Login lacks connect endpoint permission.
SQL SERVER – FIX: 3637 – A Parallel Operation Cannot be Started From a DAC Connection
This was indeed one of an interesting error which I have never seen earlier and it is about DAC Connection.
Here is the complete error message which my client reported.
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
Question: How to Extract Alphanumeric Only From A String?
Early Bird Pricing – SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
There are only 6 days to sign up for the early bird pricing for SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019. The class is very first only class and will not be offered again in the first quarter. Last year when I offered the class, I had received rave reviews for the class, however, we closed the class at the end of last year. However, there has been a lot of requests to offer the class again and I have decided to offer this class on April 23, 2019.
SQL SERVER – Upgrade Error – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You Do Not Have Permission
A few days back, I published the blog on the same error message and one of the blog reader responded and ask how can I generate the script if I don’t have another SQL Server? In this blog, we would learn how to fix error Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.