SQLAndy

Blog Post

Unusual BBQ

Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...

2010-12-17

594 reads

Blog Post

Email Pruning

Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...

2010-12-15

873 reads

Blog Post

IT Education Part 2

For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...

2010-12-10

697 reads

Blogs

“We love to debate minutiae”

By

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

By

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

By

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

By water490

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

By a.koopman

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

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