Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 Part 3
Index on Col1, Col2 and index on Col1, Col2, Col3 Part 3: Jon and Mike ask if it is always best practice to drop redundant indexes. Here is a special case.
Maintaining SharePoint Content Databases: What the DBA Still Owns
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.