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.
SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?
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.
Price Increase Alert – SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
Just a quick note for everyone that if you have not signed up for my SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, so far, the price is going to be increased by USD 100 from March 1st.
SQL SERVER – FIX: Database Diagram Error 15517 – Cannot Execute as the Database Principal Because the Principal ‘dbo’ Does Not Exist
Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, one of the developers reported below error in the database while trying to open a database diagram.
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
Question:Â What is Clean Buffer in DBCC DROPCLEANBUFFERS?