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
80 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
Why can’t I remove this extra transaction log file?
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-02-29
12 reads
Why can’t I remove this extra transaction log file?
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-03-05 (first published: 2020-02-29)
422 reads
Blogs
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Forums
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...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
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