DPS 2020 Training Class – PowerShell & SQL Server – by Rob Sewell

Pre-Con Title

PowerShell And SQL Server With DBATools

Track(s)

Data Administration

Tags

#PowerShell #dbatools #sqlserver

Level

Basic

Trainer/Speaker

Rob Sewell

Abstract

The SQL Server Collaborative organisation have created the free, open source PowerShell module dbatools lead by Chrissy LeMaire and with over 100 contributors to extend PowerShell support for SQL Server even further

Join Cloud and Data Center MVP and dbatools evangelist Rob Sewell to learn how to you can make use of both of these modules to simplify and automate your DBA needs.

You will be shown how you can accomplish many routine DBA tasks easily and simply with one line of PowerShell code

• Migrate an entire instance with one line of code – databases, users, jobs, schedules, credentials ,proxies, operators (The list goes on, it’s pretty much everything)
• Restore an entire instance from a backup directory
• Test your restores every day
• Simply and easily find a stored procedure, trigger, view in a database even if you don’t know which instance it is on
• Show who changed my database and what they did
• Display the last time a successful DBCC CHECKDB was run for all databases across my estate
• Make us of sp_whoisActive and Glenn Berry’s diagnostic queries straight from PowerShell
• Write Pester Tests to validate your SQL Server environment
• And much much more

Come and join me for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.

Who Are You?

You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server or an accidental DBA.

You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.

You have spent 1 day or 20 years working with SQL Server.

You know that you work in a field where automation is king and want to understand more of what is available.

You are interested in learning and improving your automation skill set.

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with the demos you should have access to a machine with PowerShell v 5 or above with a SQL Server 2012 or above instance.

Modules/Topics

• What is dbatools?
• Finding Commands
• Using Commands
• Migrate an entire instance with one line of code – databases, users, jobs, schedules, credentials ,proxies, operators (The list goes on, it’s pretty much everything)
• Restore an entire instance from a backup directory
• Test your restores every day
• Simply and easily find a stored procedure, trigger, view in a database even if you don’t know which instance it is on
• Show who changed my database and what they did
• Display the last time a successful DBCC CHECKDB was run for all databases across my estate
• Make us of sp_whoisActive and Glenn Berry’s diagnostic queries straight from PowerShell
• Write Pester Tests to validate your SQL Server environment

Attendee Pre-requisite (if any)

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with the demos you should have access to a machine with PowerShell v 5 or above with a SQL Server 2012 or above instance.

Is this class being recorded?

Yes, this class will be recorded. Recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now