This is a buy one get one to my recorded class SQL Server Performance Tuning Practical Workshop for EVERYONE. Very unique offer for everyone!
When was Table Accessed Last By User? – Interview Question of the Week #226
Question: When was Table Accessed Last By User?
SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode
The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we will discuss an error about REBUILDDATABASE.
SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name
In this blog we would learn how to fix Msg 4353 – Conflicting file relocations have been specified for the file. We solve this error very quickly.
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.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.