The PowerShell Virtual Chapter is geared towards those wanting to learn more about PowerShell and to share best practices.
. - Thursday, April 9, 2015

View Recordings of Previous Sessions on Our YouTube Channel

 read more ...
Next Meeting

Thu, May 14 2015 12:00 Eastern Daylight Time

Simplifying SQL Server Migrations with PowerShell


Simplifying SQL Server Migrations with PowerShell

Imagine migrating SQL Server databases, logins, jobs, operators, and other SQL Server components with just a single command; this is what PowerShell can do for you. In this session, I'll discuss the reasons DBA's migrate SQL Server instances, some of the tools and techniques that are used, and the objects that are most commonly migrated, along with considerations that must be made for each. Then, I'll perform a few migrations using PowerShell scripts available within my sqlmigration repository on github ( Code specifics and current limitations will also be discussed.

I have worked in IT for nearly 20 years, and currently serve as the SQL Server DBA for NATO Special Ops in Belgium. I'm also an avid scripter, and have used PowerShell since I was first introduced to Monad in 2005 at the Microsoft PDC in Los Angeles. I'm currently pursuing an MS in Systems Engineering at Regis University. In my spare time, I explore Trappist breweries in Belgium with my wife and maintain with my mom and best friend.