Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.
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
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?
PowerShell loves Power BI. In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Join me for this session as I demo how disaster recovery can be greatly simplified using PowerShell.
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.
Learn how you can validate your SQL Server estate with ease using dbachecks
Automate SSRS management using Microsoft's PowerShell module
Provision dev databases quickly and easily using containers and clones
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function
Combining Always ON Availability Groups and Powershell will make your life easier
Row Level Security based on related tables
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.
We will take a look into my favourite Powershell scripts
<<123>>