SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows...
2016-04-19
215 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older,...
2016-04-19
25 reads
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
555 reads
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
224 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
961 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
497 reads
Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-03-02 (first published: 2016-02-23)
2,366 reads
Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
185 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,934 reads
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
478 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers