Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Resource Bottlenecks in SQL Server: A Wait Stats Script That Groups Them
Resource bottlenecks hide in the wait statistics, under a pile of idle waits and totals since startup. This post builds a script that removes the idle waits, measures an interval and groups the rest by resource. It also explains how to read each group and the signal wait.
SQL SERVER – Case of Different Default Collation on Two Servers
My client saw a different default collation on two servers installed with SQL Server 2012. Here is what decides the default collation during setup.
SQL SERVER – Puzzle – Playing with Datetime with Customer Data
Playing with Datetime became a puzzle when one conversion worked for a customer but failed for me. The input was unchanged.
SQL SERVER – Edition Downgrade with Supported Migration Checks
To Downgrade SQL Server editions, I plan a supported migration or reinstall. I test the application on the destination edition first.
SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist
A developer found a columnstore index cannot be created on a large history table in SQL Server 2014. The surprise cause: computed columns in the table.
Duplicate Entry for Key PRIMARY in wp_options: Fix With REPAIR TABLE
A duplicate entry for key PRIMARY on INSERT INTO wp_options made my blog slow and stopped scheduled posts. After four hours of trial and error, REPAIR TABLE wp_options fixed the corrupted table. Here is the log line, the command and a script that repairs every table.
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.
Who We Are
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.
Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.
Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

