Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.
Regaining sysadmin Access When Nobody Can Log In
Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.
Sharding: When One Server Is Not Enough
Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
SQL SERVER – Creating Database with Different Collation on Server
A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.
SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
Three questions I get all the time: where to get AdventureWorks, restoring a 64-bit backup on a 32-bit server, and restoring a 2012 database to 2008 or 2005.
SQL SERVER – What is Hekaton? – Simple Words Explanation
What is Hekaton? In simple words, it is the in-memory feature announced at PASS Summit 2012 that keeps busy tables in memory to make applications much faster.
Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding
Test disabling nonclustered indexes before a large load, rebuilding them afterward, and measuring total time and log use.