A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
Offloading Backups to a Secondary Replica: Notes from the Field #108
Offloading backups to a secondary replica takes work off the primary server. In Notes from the Field #108, Eduardo Castro explains backup priority and read-only routing for AlwaysOn availability groups.
SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS
SQL Server 2016 adds two new string functions, COMPRESS – DECOMPRESS. Here is how they work, with examples, and the error you get on older versions.
Readable Secondary in Standard Edition: Transactional Replication Setup
A secondary server sitting idle as a backup feels like a waste. In Notes from the Field #107, Kenneth Urena shows how to build a readable secondary in Standard Edition with transactional replication.





