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

Dependency Walker

Dependency Walker has been around for a while as part of Visual Studio. Have you tried it? Got the latest version? Andy does a very quick run through of what the product does, why you might need it, where to get the latest version, and why the new version is better than the old one (isn't it always?).

You rated this post out of 5. Change rating

2003-05-30

7,879 reads

SQLServerCentral Article

Is Steve Jones Really Steve Jones?

Alien imposter? No, not that complicated. Andy saw an actor on TV that according to some looks JUST like our own Steve Jones. Steve is a good sport about such things and provided several photo's so you could judge for yourself. Of course, there is a little more to the story - read the article to see!

You rated this post out of 5. Change rating

2003-05-26

3,799 reads

SQLServerCentral Article

Standards Are a Good Thing

This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent.

You rated this post out of 5. Change rating

2003-04-09

6,172 reads

SQLServerCentral Article

We Studied, We Passed, Was It Worth It?

Several months ago Andy posted a 'Review of Developing Windows Based Applications for VB.Net and C#.Net' and mentioned that his company was requiring all developers to achieve the MCAD within 12 months. Read this to find out how the first exam went, how they studied, what they achieved, and their plans for taking the rest of the exams.

You rated this post out of 5. Change rating

2003-03-21

7,747 reads

SQLServerCentral Article

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!

You rated this post out of 5. Change rating

2003-02-14

8,415 reads

SQLServerCentral Article

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.

(1)

You rated this post out of 5. Change rating

2003-01-31

10,518 reads

SQLServerCentral Article

Worst Practice - Bad Comments

This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.

(2)

You rated this post out of 5. Change rating

2003-01-23

11,086 reads

Blogs

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

By

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

Which Object Definitions Are Available?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Object Definitions Are Available?

What's Your Theme Music?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's Your Theme Music?

T-SQL in SQL Server 2025: The PRODUCT Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Which Object Definitions Are Available?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)

See possible answers