PowerShell and SQL Server with Drew Furgiuele and Rob Sewell

Description
Level 300 - Advanced

Since Microsoft announced the SqlServer PowerShell module with the July release of SSMS more and more people have been using PowerShell to help them to administer their SQL Servers.
The SQL Server Collaborative organisation have created the free, open source PowerShell modules dbatools lead by Chrissy LeMaire and with over 100 contributors to extend PowerShell support for SQL Server even further, there is also dbachecks enabling configurable SQL Server estate validation using PowerShell as well as many other open source additions.
Join Drew Furgiuele and Rob Sewell to learn how to you can make use of both of these modules to simplify and automate your DBA workload. You will be shown how you can accomplish many routine DBA tasks easily and simply with one line of PowerShell code

• Find ALL of your instances on your estate
• 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
• Gain access to an instance when no-one has a login
• 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
• Use PowerShell to deploy database, agent jobs, SSIS packages and maybe even SSRS reports
• 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
• Use dbachecks to validate your SQL Server estate
• And much much more

Come and join us 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, an accidental DBA or you have DevOps in your job title.
• 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 skillset.

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.

Speakers

Rob is a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). He is a Cloud and Data Center MVP and an officer for the PASS PowerShell VG and has spoken at and volunteered at many events. He is a member of the committee that organises SQL Saturday Exeter, PSDay.uk and also the European PowerShell Conference. He is a proud supporter of the SQL and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.

Rob has a fabulous beard.

Drew is a Senior Database Administrator at IGS in Dublin, Ohio and has been working with the Microsoft Data Platform for over 15 years. When he's not accidentally dropping tables in production, he enjoys helping developers and analysts write faster and more efficient queries, using PowerShell to automate himself, and messing around creating IoT devices, including trying to send SQL Server to the edge of space for the High Altitude SQL Server Project (HASSP).

Drew's presented on topics for Brent Ozar's online conference and training sessions, and he's even a major contributor to the awesome open source PowerShell toolkit for DBAs: dbatools (https://dbatools.io/).

Outside of work, he enjoys blogging, traveling, speaking, CrossFit, and hearing people try to pronounce his last name. He loves his dog more than he loves anything or anyone else, and isn't ashamed of his Spotify playlist.

Additional information
Lunch, snacks and printed workshop material is included. Registration for the free SQLSaturday event on September 1st must be done through the SQLSaturday #746 Oslo website.