Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

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 […]

5 (1)

2020-04-27

1,743 reads

SQLServerCentral Article

Worst Practices - Objects Not Owned by DBO

Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!

4.86 (7)

2019-08-01 (first published: )

38,095 reads

SQLServerCentral Article

Error Logging Gone Wild

Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you!

3.67 (6)

2016-10-11

1,784 reads

Technical Article

Time to Rebrand

I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.

2015-04-01

6,297 reads

Technical Article

Mo-SQL

If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.

2013-04-01

3,528 reads

Blogs

RMOUG Training Days in Denver

By

Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Read the latest Blogs

Forums

What are the alternatives of S3 Object Lambda?

By kwalampur

Hi all! AWS has a good example of how to manipulate the requested objects...

SQL Script plug-in

By dmarino324

Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...

Modify RDS page missing the Storage Autoscaling option

By jecobdruv

Hi folks, I have a single Postgres instance on RDS that in the past...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers