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

Using the Copy Database Wizard

In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!

4.5 (2)

You rated this post out of 5. Change rating

2002-07-18

11,297 reads

SQLServerCentral Article

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.

2 (1)

You rated this post out of 5. Change rating

2002-06-25

12,651 reads

Blogs

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Capturing errors and auditing in Azure SQL DB

By

Logging is a necessity in the database world, well, the entire tech world. You...

Read the latest Blogs

Forums

The Mindset of a Database Administrator: A Love Letter to Risk Aversion

By dbakevlar

Comments posted to this topic are about the item The Mindset of a Database...

Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You

By Chandan Shukla

Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...

how to move all SP from one db to another db?

By water490

Hi everyone I have two db - one is test and other is archive. ...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers