Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
287 reads
Blog Posts
Cannot Use the Special Principal – Back to Basics
Cannot use the special principal 'dbo'. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for...
2018-11-07
418 reads
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,989 reads
Exporting configuration data from SQL Sentry
SQL Sentry is a pretty cool monitoring system but there's a downside to having so many knobs to turn:
it's next...
2018-11-07
241 reads
How do I ask for SQL Server help on Twitter?
For those of us who have been on twitter for a long time, we are familiar with the #sqlhelp hashtag....
2018-11-07
289 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server...
2018-11-07
157 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server and Microsoft Data Professionals to gather to connect, share...
2018-11-07
8 reads
Missing those we’ve lost
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...
2018-11-07
222 reads
No Speaker? No Problem! Host a non-traditional User Group meeting
Was honored to speak to fellow User Group leaders at the PASS Summit User Group leader meeting on Tuesday. Here's detail and links to some of the things I...
2018-11-07
6 reads
PASS Summit 2018 – Day 1 – 11/7/2018
I am proud and fortunate to be sitting beside stars of the community at the blogging table this year. I...
2018-11-07
234 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