Six days left for early bird pricing on my SQL Server Performance Tuning Practical Workshop for EVERYONE on April 23, 2019. It is back by popular request.
First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
My SQL Server Performance Tuning Practical Workshop was built for single organizations. On April 23, 2019, I opened it to everyone for the first time, online.
What is Consolidation of Index? – Interview Question of the Week #212
What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.
Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System
Where to find me in early 2019: a free Quest webinar on IO waits, pre-cons at SQLBits and SQL Saturday Stockholm, and a change to my Performance Tuning workshop.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
What is a trusted constraint in SQL Server? Many experts do not know, so instead of a definition I explain it with a simple check constraint example.
Win Apple Watch Series 4 and Solve SQL Server Performance Problems
Every DBA wants to watch something different on their SQL Server. Download Spotlight to monitor your servers and get a chance to win an 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? Here are the steps I use to move a busy LDF or MDF file to a quieter drive.