5 Things to Know About Indexes for SQL Server
One of the first questions I got while interviewing for a potential position as a DBA was “If there is...
2014-06-25 (first published: 2014-06-19)
6,669 reads
One of the first questions I got while interviewing for a potential position as a DBA was “If there is...
2014-06-25 (first published: 2014-06-19)
6,669 reads
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
457 reads
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not...
2014-05-05
820 reads
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There...
2014-04-23
754 reads
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick...
2014-04-11
651 reads
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,355 reads
Database Normalization
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th...
2014-03-17 (first published: 2014-03-09)
6,575 reads
Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and...
2014-01-28
1,123 reads
Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in...
2014-01-15
622 reads
Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the...
2014-01-08
755 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