Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – What Resource Wait Are We Seeing?
A reader saw many PAGELATCH waits on 2:1:3 and 2:1:1 in Activity Monitor. I explain how to tell which resource wait you are seeing and what these pages are.
Linked Server to PostgreSQL: Set It Up From SQL Server 2025
A linked server to PostgreSQL lets SQL Server read PostgreSQL tables through an ODBC driver. This post tests the PostgreSQL side on PostgreSQL 18.6, runs the SQL Server steps up to the missing driver, and shows the real error messages.
SQL SERVER – New features in SQL Server 2016 Setup Wizard
Microsoft listened to feedback, and the SQL Server 2016 Setup Wizard shows it. Here are the new options I noticed, such as Perform Volume Maintenance Task.
Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?
How are @@DATEFIRST and SET DATEFIRST related? One sets the first day of the week for your session, the other reads it back, and language matters too.
SQL SERVER – Inserting into ColumnSet with SPARSE Columns
A friend had a table with 1000s of SPARSE columns and asked about inserting into ColumnSet directly. Yes, you can. Here is how it works.
SQL SERVER – InMemory Table Creation Error Message: Msg 41337
My cousin tried InMemory tables on SQL Server 2016 and hit Msg 41337 while creating one. Here is what the error means and how to get past it.
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.

