Testing a failover reveals connection, data, job, and recovery gaps before an outage; learn to plan a SQL Server drill and record the result.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors
A friend needed to count Virtual Processors available to SQL Server 2000. Scripts for 2000 with xp_msver, and for 2005 to 2012 with sys.dm_os_sys_info.
SQL Saturday #116: The First SQL Saturday in India
SQL Saturday #116 was the first SQL Saturday in India, and it was a huge success. We filled every seat, hosted two technical tracks with six speakers and ended with a book signing. Here is my recap of the day, with photographs.
SQL Server Questions and Answers: The Movie My Grandma Asked For
SQL Server Questions and Answers began as a book I carried to my grandma for blessings. Grandma’s question about a movie inspired a video course.
Slowly Changing Dimension Quiz: Type 1 or Type 2?
This Slowly Changing Dimension Quiz asks which type to use when a customer moves from Denver to Austin and sales before the move must stay under Denver. The answer is Type 2. A tested script runs Type 1 and Type 2 side by side, checks the move date and shows both reports.
Table Partitioning Quiz: When Does It Make a Query Faster?
This Table Partitioning Quiz asks whether a query for last month runs faster once a sales table is partitioned by month. The answer is only when the filter lets SQL Server skip partitions. A tested script shows the partition count, the reads, and a partition SWITCH.
Query Store Quiz: Where Is Last Week’s Slow Query?
This Query Store Quiz starts with a slow query from last week and a plan cache that restarted empty. The answer is Query Store, which keeps plans and run times inside the database. A tested T-SQL script finds the query, its plan and its duration.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.