Ryan Adams explains a critical SQL Server error about network binding order and shows how to fix it in this Notes from the Field episode.
SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111
Earlier you saw query statistics only after a query finished. In Notes from the Field #111, Mike Lawell shows Live Query Statistics in SQL Server 2016 and more.
SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109
Bill Anton explains how to tell if your app suffers from unknown SSAS performance issues, and why Analysis Services need not be a black box. Notes from the Field #109.
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.
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.
SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
Tim Mitchell shows a handy but overlooked feature: project versions in the SSIS catalog, which keep earlier deployments you can browse in SSMS.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.