dbatools-PowerShell and SQL Server Working Together

2019

TL; DR

The dbatools module now has over 400 commands you can work with. How do you know where to start and which ones you can use in your day-to-day work?

Session Details

The dbatools module now has over 300 commands and anyone who wants to start is overloaded with amount of functionality in this module.
There are not enough hours in the day to get everything done as a DBA. We need to automate our repetitive tasks to free up time for the important and more fun tasks.
In this session I'll show you a set of commands which will help you start automating your tasks.

3 things you'll get out of this session

Sander Stad's previous sessions

Streamlining Power BI with PowerShell

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.

Saying no is OK

In the high-demand IT field, professionals often struggle with overcommitment and work-life balance. This presentation, "Saying No is OK," offers practical insights and strategies for IT professionals to assertively manage their workload and protect their well-being. Learn the art of saying no, how to prioritize, and maintain professionalism while achieving a healthier work-life balance. Join us for a transformative session that will empower you to succeed while setting necessary boundaries.

Unveiling the magic of CI/CD for SQL Server using GitHub Actions

In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.

Github and Azure DevOps Duet - SQLBits edition

A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.

Battle tested project planning with Azure Devops boards

Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?

Start to See With tSQLt

Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt

Solving the dev DB problem with Docker and dbaclone

Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.