I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never scheduled it for individuals was the content of the class was customized carefully for a specific organization. However, I believe it is time now when I can announce this class to everyone.
What is Consolidation of Index? – Interview Question of the Week #212
Question: What is Consolidation of Index?
Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System
As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
Question: What is Trusted Constraint in SQL Server?
Win Apple Watch Series 4 and Solve SQL Server Performance Problems
Ask any DBA what would they love to monitor in their SQL Server and I promise you that you will get quite many different answers to this question. Though every DBA would love to see their server always up upon asked what exactly they would like to watch you will see different answers to the popular question. I have previously blogged about it over here: Solve 3 Biggest SQL Server Performance Challenges with Spotlight. Today, you can download Spotlight and Win Apple Watch Series 4.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server?
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
Question: When to Use sort_in_tempdb for Rebuilding Indexes?