Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.
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.