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.

Script to Attach Multiple MDF

Copies mdf files located in a directory on a client and attaches them to the connected server. This is the winning solution to the contest that was presented in an article posted at http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp. That article shows how to do the same thing using DMO. Wynn Muse is the author of this stored procedure.

2001-09-23

2,804 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Minimal Downtime Storage Migration of Large Databases

By Dinesh Karunarathna

Comments posted to this topic are about the item Minimal Downtime Storage Migration of...

Some questions regarding Service Broker

By kramaswamy

Hi all, I have a third-party database/application that I'm attempting to augment with functionality...

Multiple listener for same AG

By Syed_SQLDBA

I am trying to educate myself and understand what are some of the advantages...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers