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.

SQLServerCentral Article

Testing for an Updated Column in a Trigger

The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2003-08-21

18,275 reads

SQLServerCentral Article

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-08-01

15,868 reads

SQLServerCentral Article

The Best of SQLServerCentral.com 2002 - We Did It!

The book is almost here! We've been working on it for months, now you can find out what it's going to look like, who the authors are, and how much it costs. It's been a lot of work but we think it's been worth it. Read the article to see how to save $3 off an already low price.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-07-07

6,091 reads

SQLServerCentral Article

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-25

8,039 reads

Blogs

Lift and shift vs modernizing your data warehouse

By

If you are migrating a data warehouse, there is a question worth asking before...

Power BI Fun With Travels

By

I’m back from a great vacation. I had the chance to visit two new...

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

Read the latest Blogs

Forums

DML Trigger Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Types

PostgreSQL in action with Opensearch

By sabyda

Comments posted to this topic are about the item PostgreSQL in action with Opensearch

Choose the Second One

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choose the Second One

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers