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

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!

(1)

You rated this post out of 5. Change rating

2006-06-23 (first published: )

24,247 reads

SQLServerCentral Article

Brooke Philpott of sqlSentry

The guys that build software rarely get exposure of credit. Maybe that's why so many of them turn to open source where they get more well known. After a meeting at TechEd 2005, Andy Warren had the chance to get some interesting interview questions answered by Brooke Philpott, one of the 2 core developers of sqlSentry. And not a marketing guy.

You rated this post out of 5. Change rating

2006-01-19

5,786 reads

SQLServerCentral Article

Digging Into Access Performance

Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.

(2)

You rated this post out of 5. Change rating

2006-01-02

8,181 reads

Blogs

How I Troubleshoot a Slow SQL Server Live

By

No two SQL Server environments are alike. A fix that resolves a performance issue...

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...

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