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!

(2)

You rated this post out of 5. Change rating

2002-07-18

11,426 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.

(1)

You rated this post out of 5. Change rating

2002-06-25

12,671 reads

Blogs

T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?

By

My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...

Monday Monitor Tips: The MCP Server

By

I have been experimenting with MCP servers in a few ways, and pressing on...

Programmatic Tool Calling with the Claude SDK

By

Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...

Read the latest Blogs

Forums

Test topic for spam filtering

By philip.scott

A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather

Removing production permissions when restoring database to non-prod

By webrunner

Hello experts, An application team has asked us to modify a SQL Agent job....

Advanced T-SQL: Replacing Slow Cursors with Window Functions

By sabyda

Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...

Visit the forum

Question of the Day

The Service Name

What does @@servicename return?

See possible answers