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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Context Switching Has a Cost: Batch Your Interruptions
Context switching costs more than the seconds it takes to change windows. This post compares attention with SQL Server commits: pay the fixed fee once per batch, not once per ping. It gives concrete ways to batch messages, tickets and reviews, and ends with a short checklist.
Why datetime Turns .999 Milliseconds Into the Next Day
See why 999 milliseconds rounds into tomorrow with datetime, compare datetime2 precision, and use an exclusive next-day report boundary.
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.