Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.
SQL SERVER – Detecting Database Isolation Level MEMORY_OPTIMIZED_ ELEVATE_TO_SNAPSHOT
Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip
My most of the Comprehensive Database Performance Health Check consulting engagement I do are online and I enjoy working on them when I am at home office and I have multiple monitors. However, I often travel to the customer’s location when my client wants me to mix SQL Server Performance Tuning Practical Workshop with Health Check. This is when I doing a presentation on my laptop and I need every single real estate on my small laptop screen. Let see a neat trick, I use to Maximizing Query Execution Plans On Screen.
SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression
Comprehensive Database Performance Health Check Client sent me an SOS message for help . The entire issue was about Page and Row level compression.
SQL SERVER – Difference Between Login Vs User – Security Concepts
In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.
Docker – Running SQL Server Image Without Running Pull Command
I have been using Docker for a while to run the latest CTP of SQL Server 2019 and it has been so far amazing ride to use the product. Every time when new CTP is released, I learn something new with Docker. This time I learn that I can just run SQL Server Image without running pull command. Let us discuss it in this blog post.Â
SQL SERVER – Download and Install SQL Server Sample Databases (Updated Post for 2019)
My primary task is to do consultation for SQL Server Performance Tuning. I always use Microsoft provided sample databases for my demonstrations.