The biggest challenge as any technologies is that while you are getting super specialist at what you do, the world around you move so much ahead that when you look outside your windows you feel that you are expert at the technology which is actually history. This is indeed true in the world of changing trends and technology.
Business Secrets in SQL Server Performance Tuning Practical Workshop for EVERYONE
Lots of people often ask me – What Will Attendee Learn in SQL Server Performance Tuning Practical Workshop for EVERYONE scheduled on April 23rd, 2019? The answer is pretty straight forward – my business secrets.
SQL SERVER – Priority Boost and SSMS 18
Just the other day, I had a very interesting experience while using the latest SQL Server Management Studio 18.0 preview 7 (SSMS 18.0) during one of the Comprehensive Database Performance Health Check. My client said they have realized that SQL Server does not have settings of Priority Boost settings available in SQL Server anymore. Actually, this is not true, let us quickly understand the same.Â
How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216
Question: How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server?
SQL SERVER – Default Worker Threads Per Number of CPUs
During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads.
SQL SERVER – #SQLBits 2019 Videos Are Live
One of my favorite events is #SQLBits and this year it took place in Manchester. I really enjoyed being there as I had an opportunity to present one Preconference (a day-long training day) and 2 breaks out sessions. SQLBits is an amazing conference as it excels in the following area.
SQL SERVER – Unable to Set Cloud Witness. Error: An Existing Connection Was Forcibly Closed by The Remote Host
After finishing my lab and testing, I went to my client and they showed me error while setting up cloud witness. They showed me a different error then earlier. In this blog, we would learn about fixing error Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host while configuring cloud witness.