Software Developer/Dev DBA. Often hyper, often talking rubbish. Pick and choose what to take away from this blog.... Want to get in touch? My social network profiles are listed above. temporal-tables | tsql | pivot | json | data-warehouse | indexing | statistics | performance-tuning | window-functions | security | graph-data | maintenance | transaction-log | profiling | transactions | isolation-levels | partitioning | snapshots | tips-and-tricks | central-management-server | policy-based-management | triggers | error-handling | in-memory-oltp | etl |

Top Posts

• Isolation Levels Explained
• Indexed Views Explained
• SQL Server 2016 What's New With TSQL
• SQL Server Service Broker Explained
• Parameter Sniffing In Depth
• Clustered & NonClustered Indexes Explained
• Minimally Logged Inserts (Assume Nothing!)
• These Are Not The Indexes You're Looking For
• SQL Server Guide To NULL Handling
• Indexing In Memory OLTP Tables

Recent Posts

• Dodging Deadlocks With Indexes
• Introducing ChaosLoad
• Waiter Waiter There's an Index in my Index
• Profiler Is Dead, Long Live Extended Events
• SQL Server Removing Duplicates

• SQL Server Adventures In Reducing IO
• SQL Server Find Unused Data Files
• Indexing In Memory OLTP Tables
• Turbo Charged Staging\Caching Tables With In Memory OLTP
• SQL Server Guide To NULL Handling