Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
When was Table Accessed Last By User? – Interview Question of the Week #226
Question: When was Table Accessed Last By User?
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.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
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.
SQL SERVER – Stored Procedure sp_datatype_info to Get Supported Data Types
I get to work with various different versions and environment when I am busy with my clients with Comprehensive Database Performance Health Check. While I work with different customers often I forget what data type is supported by which version of SQL Server. Here is a small quick trick, I use all the time when I need to know what are the different data types supported by the version I am working with.