SQL Saturday Rochester 2020 Recap
Another SQL Saturday Rochester is in the books - our eighth over the past nine years. Unlike past years, I actually am going to recap the event! Ray Kim...
2020-03-03
17 reads
Let’s Call It What It Is: Complexity Debt
Technical debt get deprioritized too often because business sees the word, “technical.” It doesn’t matter what the true meaning is. And it’s a big problem. It really needs proper...
2020-03-09 (first published: 2020-03-02)
601 reads
SQL Database MI benefits
As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an...
2020-03-10 (first published: 2020-03-02)
902 reads
Altering an indexed view in SQL Server drops all indexes
I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views. This is covered in the product documentation, but it’s not something I...
2020-03-02
83 reads
SQLSaturday Baton Rouge 2020 Business Intelligence edition this Saturday!
The first of a double whammy of SQLSaturday Baton Rouge events over the next 5 months, SQLSatBatonRougeBI is this Saturday, March 7! The organizers of this event, from the...
2020-03-02
10 reads
Setting 2020 Learning Goals
I deliberately didn’t set any goals at the start of 2020 since I was taking six weeks off for a sabbatical. That’s done, and it’s time to look forward....
2020-03-06 (first published: 2020-03-02)
484 reads
Query Store, Plan Forcing, and DROP/CREATE
I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...
2020-03-09 (first published: 2020-03-02)
420 reads
SQL Homework – March 2020 – Database Configurations.
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this ... Continue reading
2020-03-05 (first published: 2020-03-02)
471 reads
SQL Server Agent for Azure SQL DB?
I always wanted a way to schedule commands within Azure SQL Database. Personally, for me, the go to standard is the functionality of SQL Server Agent. Obviously, this is...
2020-03-02
45 reads
Undercover Tools: February Updates and Change Log
Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...
2020-03-02
27 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers