gavdraper gavdraper gavdraper
Gavin Draper's SQL Server Blog and Related Ramblings
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.
Tags
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 | backup-and-restore | cloud | azure | hadr |

Transactions

  • May 19, 2018: SQL Server Triggers and Transactions
  • April 25, 2018: SQL Server Nested Transactions Probably Don't Work How You Think

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

  • SQL Server Script To Check Your Backup RPO Status
  • How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
  • Backing Up and Restoring Your On-Premise Databases To and From the Cloud
  • How to Encrypt and Restore Your SQL Server Database Backups
  • Why You Shouldn't Use SELECT * In Production Systems (EVER!)
  • Leveling Up Your TSQL
  • Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
  • Dodging Deadlocks With Indexes
  • Introducing ChaosLoad
  • Waiter Waiter There's an Index in my Index
  • Gavin Draper's SQL Server Blog and Related Ramblings
  • gavdraper
  • gavdraper
  • gavdraper

Father, Developer, DBA, Extreme Sports Enthusiast