Top 5 SQL Server Challenges Automated with PowerShell


There are many ways to automate activities within SQL Server, but one of the best methods is PowerShell. PowerShell offers unique scalability and programmatic control for Windows OS. (And some members of the SQL Server community write and share free cmdlets frequently at https://dbatools.io.)

Join Kevin Kline, dbatools.io leader Chrissy LeMaire, and major dbatools.io contributors Sander Stad, Rob Sewell, and Kirill Kravtsov as they share PowerShell cmdlets that address some of the biggest and most difficult SQL Server challenges, including

  • Automated SQL Server migrations
  • Preventative maintenance checks on a daily, weekly, and monthly basis
  • Provisioning security for SQL Server databases, including data masking
  • Continuous Integration/Continuous Deployment (CI/CD) of code to SQL Server databases
  • Logging errors and messages while automating with PowerShell

Once you become familiar with these scripts, you can use them to control and automate SQL Server estates ranging from 1 to 1,000 instances.


Interested in additional SentryOne webinars?  Check our webinar library.

Register Now

Already Registered?   Sign-in To Attend
Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at sentryone.com/blog/author/kevin-kline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Chrissy LeMaire

Chrissy LeMaire

PowerShell and SQL Server MVP, dbatools.io

Chrissy is a PowerShell and SQL Server MVP and creator of the popular PowerShell module, dbatools. She also serves as the SQL Server DBA for GDIT at NATO Special Ops HQ in Belgium. Chrissy recently finished her MS in Systems Engineering and looks forward to exploring more of Europe in her newly found free time.

Rob Sewell

Rob Sewell

Director/Founder, Sewells Consulting Limited

Rob was once a Production SQL Server DBA but now is generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and also the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter (@sqldbawithbeard) and his blog sqldbawithabeard.com. 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 or flying a drone in the winter.

He has a fabulous beard!

Sander Stad

Sander Stad

DBA, Waypoint Analytical

Sander is a SQL Server DBA and a Cloud and Datacenter Management MVP.He has been working with SQL Server since version 2000 and has worked in a variety of industries like agriculture, finance, and healthcare. He is a big fan of PowerShell and automation and will try to automate every process possible.

Kirill Kravtsov

Kirill Kravtsov

Database Administrator, xMatters, inc

Kirill has been a SQL Server DBA for the past 10+ years. He is passionate about automation and PowerShell and adept at the DevOps mentality and workflow. Major contributor of two SQL Server-related projects: dbatools and dbops. Outside of work, he enjoys traveling, heavy metal music, scuba diving, taekwondo, and video games together with his wife Svitlana.

Companies with the highest demands for database performance choose SentryOne