How to become PowerDBA - PowerShell for the SQL Server Administrator
Details
```
Are you a database administrator who spends most of his time fixing unexpected incidents? Would you like to have more time to be able to focus on your environment so as to reduce unplanned tasks?
In this session, you will learn the following PowerShell modules:
-
dbatools - is an open-source, community-maintained tool that serves as "SQL Server Management studio on the command line".
-
Pester - this module allows you to create your own tests to make sure your PowerShell code is always running.
-
dbachecks - you already know Pester, so now it's time for his so-called a wrapper that will allow you to verify and monitor your environment.
-
ImportExcel - this free PowerShell module will allow you to create and manage Excel spreadsheets without the need to install Microsoft Office.
There will be a lot of demos and the PowerPoint slides have been kept to an absolute minimum. The aim of the presentation is for the participants to learn about useful tools and the reasons why they can use them in their work.
Mikey BronowskiHusband | Dad | DBA | MCT | Data Platform MVPWhat do I do? I select, I select stars!
Data enthusiast with a mathematics background. Working with SQL Server for over 15 years. Works as a database engineer (Microsoft SQL Server) responsible for environments upgrades and migrations. Microsoft Certified Trainer with a couple of certificates. Blogger at (bronowski.it). Since 2021 Microsoft Data Platform MVP.
Not long ago Poland Data Community member, now proud UK Data Platform active member.
When not working or teaching, learns new things or attends various data/technical conferences and meetups.
Italian Calcio fan and traveller.
```