Azure Data Platform Resources
A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources...
2016-09-30
848 reads
The Scary DBA
Volunteering With PASS
I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive...
2016-09-29
761 reads
Networking and the PASS Summit
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your...
2016-09-27
405 reads
Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,860 reads
Query Store and Plan Forcing: What Do You Use It For
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...
2016-09-28 (first published: 2016-09-19)
1,251 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,508 reads
Kilt Day! PASS Summit 2016, Thursday
Thursday at the PASS Summit is Kilt Day.
This means you should wear a kilt. Whether you do it in support...
2016-09-07
597 reads
Query Store, Force Plan and “Better” Plans
I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...
2016-09-12 (first published: 2016-09-06)
1,347 reads
Azure SQL Data Warehouse Execution Plans
Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is...
2016-08-29
1,082 reads
PASS Board Update
Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information....
2016-09-07 (first published: 2016-08-25)
1,129 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers