How do you manage 1000 SQL Servers without clicking through each one? Here is the script I use to change service account for all instances with WMI and SMO.
SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes
SQL Server 2016 lets you create additional nonclustered indexes on tables with clustered ColumnStore indexes. Here is how it works.
SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early
Preparing a point in time restore demo, I got Msg 4335: the specified STOPAT time is too early. Here is what the error means and how to get past it.
Circular Foreign Keys: Inserting Rows That Point at Each Other
Two tables point at each other, and every insert fails. Here is the nullable column that gives you a way in.
SQL SERVER 2016 – InMemory OLTP support for Foreign Key
SQL Server 2016 adds InMemory OLTP support for Foreign Key constraints, a big missing piece in SQL Server 2014. Here is how I tested it on CTP3.2.
Giving Every Developer a Dedicated Development Database
Set up a dedicated development database from approved schema scripts and clean seed data, with repeatable rebuilds and drift checks.
Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects
A favorite interview script: how to retrieve user defined object details from sys.objects in SQL Server, with the query to run.