---
title: "Slides / Videos"
url: "https://dbatools.io/slides-videos/"
last_updated: "2016-05-30"
---

# Slides / Videos

## Presentation Materials

#### Slide Deck (Filled With Comments) From "Simplifying SQL Server Migrations Using PowerShell"

- [Slides](https://github.com/psconfeu/2016/raw/master/Chrissy%20LeMaire/SimplifyingSqlMigrations/psconfeu_lemaire_simplifying_redistrib.pptx)
- [Demo code](https://github.com/psconfeu/2016/raw/master/Chrissy%20LeMaire/SimplifyingSqlMigrations/code.zip)

## Videos

### Migrate an Entire Instance

In this video (sound coming later), I migrate a fully stocked instance to a rather empty one. Migration includes databases, logins, SQL Server agent, agent categories, alerts, audits, audit specifications, backup devices, central management servers, credentials, custom errors, database assemblies, database mail, data collector sets, endpoints, extended events, jobs, linked servers, operators, policy managements, proxy accounts, resource governor, server triggers, shared schedules, sp_configure and user objects in system databases.

<iframe src="https://www.youtube.com/embed/PciYdDEBiDM" frameborder="0" allowfullscreen></iframe>

### Copy-SqlDatabase With GridView

This is one of my favorite demos. Migrate two databases by selecting them visually using PowerShell's GridView.

<iframe src="https://www.youtube.com/embed/N3vf5bfzNZg" frameborder="0" allowfullscreen></iframe>

### Create Login With a Ton of Properties, Migrate

Migrate a login with SID, password, server/database roles, server/database permission sets & securables, default database and login attributes. Updates job ownership. Works on SQL Server 2000 and above.

<iframe src="https://www.youtube.com/embed/OswRoJP8s-Q" frameborder="0" allowfullscreen></iframe>

### Reset-SqlAdmin

Another favorite demo. Ever inherited a SQL Server but not admin credentials? If you have Windows administrator access, you can add a Windows or SQL Login user as sysadmin.

<iframe src="https://www.youtube.com/embed/glCfKQTvCFM" frameborder="0" allowfullscreen></iframe>