Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
624 reads
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
624 reads
I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number...
2017-04-03
425 reads
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
644 reads
I made a mistake the other day. For some reason I got it into my head that I was flying...
2017-03-28
448 reads
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
2,973 reads
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I...
2017-03-20 (first published: 2017-03-07)
1,837 reads
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,755 reads
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...
2017-03-09 (first published: 2017-02-28)
1,951 reads
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...
2017-03-06 (first published: 2017-02-27)
2,145 reads
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to...
2017-03-03 (first published: 2017-02-24)
3,365 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers