Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
564 reads
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
564 reads
I find it extremely easy to sometimes lose sight of the important stuff. The day-to-day grind can seriously get in the way. I think this is a big part of how we find ourselves having so many silly intra-organizational turf wars. The developers don’t like how the DBAs do things. The DBAs are frustrated with […]
2017-10-30
74 reads
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
322 reads
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,871 reads
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
518 reads
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
483 reads
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...
2017-09-21 (first published: 2017-09-18)
1,968 reads
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
430 reads
Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...
2017-09-14 (first published: 2017-09-06)
2,305 reads
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
346 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