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
456 reads
Blog Posts
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,997 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
261 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
296 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
165 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
16 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
231 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
16 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
235 reads
PASS Summit 2018 – Day 1 Keynote Announcements
Good morning from Seattle, at the Summit for the Professional Association of SQL Server. I’m lucky enough to be sitting at the blogger table this morning, watching the keynote...
2018-11-07
8 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers