Training Class:- POWERSHELL AND SQL SERVER WITH DBATOOLS WITH ROB SEWELL
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.