Rob Sewell


Powershell And SQL Server With DBATools

Trainer(s): Rob Sewell
Provider: DPS 2020 (Data Platform Summit)
Duration: 7 Hours 00 Mins
Subtitles: No
Price: USD 99.5

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.

Modules:

  1. What is dbatools?
  2. Finding Commands
  3. Using Commands
  4. 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)
  5. Restore an entire instance from a backup directory
  6. 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

Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.