Just last week, I had to present at SQLBits in Manchester, UK and I used Docker Containers for my SQL Server Presentations. I am an experienced presenter and I usually practice multiple times before I get on the stage to present on any subject. However, a day before the presentation, due to some reason, my docker container did not work and I had to redo my entire container. This is where the problems started for me.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system.
SQL SERVER – How to Invoke SSMS Help From Command Prompt?
This particular question I just received in my recent SQL Server Performance Tuning Practical Workshop. It was a very interesting question and hence I am going to blog about it. The question which I received was – How to Invoke SSMS Help From Command Prompt?
SQL SERVER – Windows Authentication or System Admin Account (SA)
I like to say that I am SQL Server Performance Tuning expert but often during the conversation, I end up discussing security as well. Recently I was asked about my preference for Windows Authentication or System Admin Account (SA) during one of the recent Comprehensive Database Performance Health Check.
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?”
SQL SERVER – Identify Datatype Using SQL_VARIANT_PROPERTY Function
One of my client of Comprehensive Database Performance Health Check sent me the following email about SQL_VARIANT_PROPERTY Function. I really love my job as SQL Server consultant as I get to learn most of the new stuff or discover the hidden knowledge nuggets which I have discovered. Today’s problem is one such problem which I had never come across till I was asked this question by my client.Â