Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani
Balmukund Lakhani of Microsoft India GTSC writes a guest post with a fun title and a useful trick: how to hide yourself from SQL Server, in his own words.
SQL Server – Using SSMS Command Line Parameters
My friend Vinod Kumar shows how SSMS Command Line parameters can save you a few clicks every time you open Management Studio and connect to a server.
Sharding by Customer: Routing Queries to the Right Database
Plan sharding by customer with a shard map, parameterized routing and synonyms, and account for reports, keys and customer moves.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2
Is every redundant index safe to drop? In part 2 of this interesting case of redundant indexes, Jon shows Mike a demo where a redundant index should stay.
Finding Duplicate Customers With T-SQL
Find duplicate customers with T-SQL by normalizing names, reviewing fuzzy matches, and merging records only after ownership is settled.
Running a Command in Every Database Without sp_MSforeachdb
Run a checked command in every database with a FAST_FORWARD cursor, AG role filter, QUOTENAME, and per-database error log.
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.