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
- Odd Behavior With LOB/Overflow Data
- SQL Server, What's In My Buffer Cache?
- SQL Server, What Waits Happened In The Last X Seconds
- 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