Making Power Shell Useful RealLife Examples of Powershell
- Slides: 10
Making Power. Shell Useful Real-Life Examples of Powershell in Action Rob Sewell http: //sqldbawithabeard. com
Who am I? Email: mrrobsewell@outlook. com Twitter: sqldbawithbeard Rob Sewell http: //sqldbawithabeard. com Profile: Rob Sewell Blog: sqldbawithabeard. com
Why use Power. Shell? s i l l e h S r u e o w y AUTOMATE EVERYTHING o e P c r – u G o s N I e r N Y R L A e N s W O u e d l h t u o t h o s n The Answer? I read a post by @SQLBrit The Best DBAs Automate everything • I automate as much as is feasibly possible mostly through Power. Shell • Backups and restores through Dev/SAT/FAT/UAT/Live environments • Daily Backup Checks, Drive Space Checks, Service Running Checks, File Space Checks, Failed Agent Job Checks, SQL Error Log Checks, DBCC Checks and more Rob Sewell http: //sqldbawithabeard. com
Demo Rob Sewell http: //sqldbawithabeard. com
Please Visit Sponsors & Enter Raffles Rob Sewell http: //sqldbawithabeard. com
Where Can I Find Out More? • • • Windows Power. Shell Reference on MSDN http: //powershell. org/ Hey Scripting Guy Your favourite Search Engine Powershell Magazine Your favourite Social Media Script Center Powershell Slack Channel Pluralsight st Friday #pstweetchat – every 1 Laerte Junior Simple Talk DBA Stack Exchange Power. Shell Gallery http: //sqlps. io/vote http: //sqlps. io/ssms Your Input to Microsoft for SQLPS Your Input to Microsoft for SSMS Rob Sewell http: //sqldbawithabeard. com
Hopefully You have learnt • • You can use Powershell How to create a function CTRL + J How to pass on Knowledge to your team Source Control Script Analyser and Pester Where to go for more help Rob Sewell http: //sqldbawithabeard. com
Questions Rob Sewell http: //sqldbawithabeard. com
Contact Me Email: mrrobsewell@outlook. com Twitter: sqldbawithbeard Rob Sewell http: //sqldbawithabeard. com Profile: Rob Sewell Blog: sqldbawithabeard. com
Coming up Next • Awesome Raffle Prizes • Free Beer and BBQ from 17: 00 Rob Sewell http: //sqldbawithabeard. com