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

Review of Data Compare v.151

In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!

You rated this post out of 5. Change rating

2001-10-31

8,783 reads

SQLServerCentral Article

Reattaching Databases - Some Code AND a Contest!

Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!

You rated this post out of 5. Change rating

2001-09-04

6,460 reads

SQLServerCentral Article

Try the SQL Parser Object to Colorize your SQL!

The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.

5 (1)

You rated this post out of 5. Change rating

2001-08-31

7,817 reads

SQLServerCentral Article

Some Comments about our Discussion Area

Sometimes as hard as you look you just can't find the answer or idea you're looking for - that's when a good discussion forum comes in handy! Read this article for some tips and tricks on using our discussion forums successfully. Then when you have time, browse our current discussions and see if they work.

You rated this post out of 5. Change rating

2001-08-07

2,291 reads

Blogs

Should I Learn PostgreSQL

By

I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...

A New Word: Hickering

By

hickering – n.  the habit of falling hard for whatever pretty new acquaintance happens...

Minimize Downtime with SQL MI Disaster Recovery

By

I speak to many people who use cloud technologies, especially database tech and how...

Read the latest Blogs

Forums

test new topic

By philip.scott

posting a new topic

New article

By Steve Jones - SSC Editor

Comments posted to this topic are about the item New article

Monitoring Azure Blob Storage

By arindamxs

Comments posted to this topic are about the item Monitoring Azure Blob Storage

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers