XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
226 reads
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
226 reads
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...
2013-03-20
117 reads
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
108 reads
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
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...
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