Memory Grants part 6: Memory used in aggregate functions (Min/Max/etc)
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
679 reads
Blog Posts
Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize...
2019-01-25
336 reads
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a...
2019-01-25
160 reads
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a goal of mine to speak at SQLBits for...
2019-01-25
3 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,198 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and...
2019-01-25
225 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
10 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don't have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
2 reads
The Execution plan comparison feature (in SSMS)
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
992 reads
Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
304 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers