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.

Blog Post

Thoughts on the PASS Virtual Summit

Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...

2020-07-31 (first published: )

219 reads

SQLServerCentral Article

A Pattern Based Approach to Masking Errors

A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]

(1)

You rated this post out of 5. Change rating

2020-04-27

1,763 reads

Blog Post

Covid Thoughts, So Far

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write them down to at least be able to look back at them once the storm...

2020-04-04

148 reads

Blog Post

SQLOrlando Update

We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...

2020-03-16

6 reads

Blogs

Rolling Back a Broken Release

By

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Presenting with Visual Studio Code

By

A while back I wrote a quick post on setting up key mappings in...

Read the latest Blogs

Forums

Lots of FKs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

By Cláudio Tereso

Comments posted to this topic are about the item Real-time On-prem SQL Server Data...

Can You Let Go of Determinism

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Let Go of...

Visit the forum

Question of the Day

Lots of FKs

In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?

See possible answers