Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

Presenting at ONETUG on July 10, 2014

by Andy Warren

SQLAndy

I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...

2014-05-20

412 reads

Running Out of Foreign Keys-Question of the Day

by Andy Warren

SQLAndy

Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...

2014-05-20

342 reads

Running Out Of Foreign Keys

by Andy Warren

SQLServerCentral

Foreign Keys (FK)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2014-05-20

1,792 reads

Discuss

Password Cracking–Part 2

by Andy Warren

SQLAndy

Two days felt like a long time, so we found a cloud server with 16 cores we could use. We...

2014-05-19

604 reads

Building The SQLSaturday Orlando Marketing Plan–Part 8

by Andy Warren

SQLAndy

One of things I wish PASS provided was at least one template for an event flyer, something that is basically...

2014-05-18

504 reads

BASIC

by Andy Warren

SQLAndy

It might or might not surprise you that I learned to code in Basic. I suppose my first real attempt...

2014-05-16

696 reads

Statistics Parser

by Andy Warren

SQLAndy

A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set...

2014-05-16

1,069 reads

Password Cracking–Part 1

by Andy Warren

SQLAndy

I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...

2014-05-15

1,014 reads

Peace Officers Memorial Day and Half Staff

by Andy Warren

SQLAndy

Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...

2014-05-15

312 reads

Building the SQLSaturday Orlando Marketing Plan-Part 7

by Andy Warren

SQLAndy

Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...

2014-05-14

533 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

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

March 2026 SQL Server Security Updates

By Brian Kelley

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By Meagan Longoria

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

Multiple Deployment Processes

By Steve Jones - SSC Editor

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

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

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