DBA Fired by the PowerShell Wiz

Abstract:

DBA work usually means you touch many different severs, and you do many mundane tasks. Your main tool for performing work is SSMS. You know all the keyboard shortcuts, which drilldown dialog box has which parameter, and you've got a long list of t-sql script templates to pull out the information you need.

But all of that takes time. There is still a lot of mouse clicking in SSMS. Many times you need to copy data out to further massage it to create a report.

Take a look at some of the great things you can do with PowerShell as a scripting language to let you access settings and make changes. You can make custom changes to your investigative queries much faster with a scripting language than t-sql. PowerShell's object-oriented nature allows for compact code. Learning to use PowerShell to manage SQL Server can save you large amount of time.

This will go over the PowerShell module SqlServer (the replacement of SqlPs) and the benefits of a scripting language.

This will not use DbaTools.io, since that amazing tool deserves its own presentation.

Installing the module SqlServer will not be include. There are many tutorials on how to do this, and there are also a wide range of possible strange issues that are annoying to cover when they don't pertain to you.

Also, the DBA's intelligence is still needed. PowerShell can get you data much faster, but you still need to understand what it means and what settings to change. So a PowerShell wiz probably won't take over a DBA's job, but a DBA with PowerShell knowledge is preferred when hiring for a DBA position.

Speakers:

  • Mike Burek

    7 Recordings

    Mike is the leader of the Austin SQL User Group

Recorded At:

Recorded on:

Jul 20, 2021

More Info:

https://www.meetup.com/Austin-SQL-Server-User-Group/events/llgfgsycckbbc/

Tags: