SQL Server 2017 – Interleaved Execution
I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...
2017-11-20 (first published: 2017-11-09)
862 reads
Figuring out Time-Out Prone queries
Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...
2017-11-20 (first published: 2017-11-09)
690 reads
IF RDBMS = SQL Server, NoSQL = ???
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
479 reads
The Future of the SQLSaturday Tools
Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools...
2017-11-23 (first published: 2017-11-08)
2,095 reads
SQL Puzzle 4: The Beale Papers
I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...
2017-11-24 (first published: 2017-11-08)
1,507 reads
Notes on the 2017 PASS Summit
Just a few notes:
Weather on Wed was great, ok on Thurs, cold on Fri. Have had worse years!Felt like I...
2017-11-08
440 reads
Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
348 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
382 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how to setup one, how to configure a user and...
2017-11-08
22 reads
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)
In this week’s episode, I’m not answering a reader’s question. Instead, I’m talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions...
2017-11-08
17 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