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.

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,721 reads

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,777 reads

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

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

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.

4.75 (4)

2012-12-14 (first published: )

10,530 reads

Blogs

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Accessibility in font choice

By

Choosing the right typeface for your presentation (or for that matter anything you create...

Read the latest Blogs

Forums

Azure data studio editor tabs

By jmetape

Hi--Does anyone one know what the "M" and "1, M" indicate in the editor...

Script to find session running SQL text and kill session

By caz100

Hi Looking for a  SQL script I can run as an agent job that...

Import Multiple Packages to SSIS server

By sagarSQLDBA

Comments posted to this topic are about the item Import Multiple Packages to SSIS...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers