7th Anniversary
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
14 reads
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
14 reads
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
325 reads
Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading
2019-08-13
224 reads
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
658 reads
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
715 reads
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
866 reads
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
57 reads
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
172 reads
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading
2019-07-24
36 reads
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
299 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