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
|
Partitioning
May 10, 2018:
SQL Server Partition Swapping
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