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 |

Tsql

  • January 23, 2019: Why You Shouldn't Use SELECT * In Production Systems (EVER!)
  • January 18, 2019: Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
  • January 07, 2019: Profiler Is Dead, Long Live Extended Events
  • January 03, 2019: SQL Server Removing Duplicates
  • December 06, 2018: SQL Server Find Unused Data Files
  • November 29, 2018: SQL Server Guide To NULL Handling
  • May 21, 2018: SQL Server Debugging With RAISERROR Instead Of Print
  • May 20, 2018: SQL Server Error Handling In Depth
  • May 14, 2018: SQL Server Building On Calculations With APPLY
  • May 01, 2018: SQL Server Advanced Aggregations Part 3 GROUPING/GROUPING_ID
  • April 30, 2018: SQL Server Removing Outliers With Standard Deviation
  • April 28, 2018: SQL Server Advanced Aggregations Part 2 ROLLUP and CUBE
  • April 26, 2018: SQL Server Advanced Aggregations Part 1 Grouping Sets
  • July 06, 2017: Upgrade Your SQL Server CASE Statements With IIF and CHOOSE
  • July 05, 2017: SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE
  • June 20, 2017: SQL Server 2017 Concatenation With STRING_AGG
  • June 12, 2017: SQL Server 2017 Graph Data Features In Action
  • June 06, 2017: SQL Server 2016 What's New With TSQL
  • May 23, 2017: SQL Server Window Functions in Action
  • May 08, 2017: Using The SQL Server Merge Statement
  • May 07, 2017: SQL Server Dynamic Pivot
  • May 06, 2017: Using JSON In SQL Server 2016
  • May 04, 2017: SQL Server Pivot and Unpivot Explained

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