Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
The WINDOW Clause: Name a Window Once and Reuse It
Use the WINDOW clause to reuse partition and order rules, extend named windows with frames, and keep SQL Server calculations consistent.
AutoRecover Settings in SSMS: Protect Your Unsaved Queries
The AutoRecover settings in SSMS decide how often unsaved work is copied to disk and how long the copies are kept. This post shows where to find the two options, what they can and cannot protect, how to test them once, and which habit still matters more than any setting.
Distributed Availability Groups: Linking Two Sites Without One Big Cluster
Understand distributed availability groups, connect two existing groups across sites, inspect health, and plan recovery without one cluster.
SAMPLED vs DETAILED: Running index_physical_stats Safely
A misspelled table name quietly turns into a scan of everything. Here is the guard, and a fair comparison of the three scan modes on one small index.
SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
Is today a weekend or a weekday? A question from the very first SQL Bangalore User Group meeting, answered with the CHOOSE function in SQL Server 2012.
Cursor Options That Matter: LOCAL, FAST_FORWARD and STATIC
Test SQL Server cursor options, including LOCAL FAST_FORWARD and STATIC, on one loop while measuring time and tempdb cost.
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.