Database in Source Control
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...
2014-01-15
1,193 reads
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...
2014-01-15
1,193 reads
For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...
2014-01-15 (first published: 2014-01-08)
2,042 reads
A whole new year. Cool.
I was at SQL Saturday DC, #233, at the beginning of December. I sat through several...
2014-01-03
744 reads
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
13,570 reads
The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...
2013-12-23 (first published: 2013-12-20)
920 reads
Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...
2013-12-19
2,842 reads
I love that I get to travel around and learn from my #sqlfamily. We’re still filling in the majority of...
2013-12-18
671 reads
Some of the new functionality of 2014 is straight forward, non-controversial and easily welcomed by the community. Think, updateable column...
2013-12-17
2,347 reads
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,719 reads
This will be my fifth speaker of the month post. Do a search to see the others.
I try to find...
2013-12-06
619 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