2025-09-19
1,707 reads
2025-09-19
1,707 reads
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
97 reads
Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL […]
2025-09-17
127 reads
Are the AI tools developers use making them enjoy their jobs more or less? Steve has a few thoughts.
2025-09-15
1,152 reads
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
570 reads
2025-09-15
1,569 reads
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
506 reads
Older technology can introduce security issues, along with performance ones. Keeping your systems somewhat up to date is important for security.
2025-09-12
73 reads
I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers...
2025-09-10 (first published: 2025-08-20)
676 reads
Passwords are essential and also a problem in many organizations. Guidance has changed over the years and Steve has a few thoughts on what's recommended today.
2025-09-10
134 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