Application and Database migrations can be a cause for concern. How many times have you heard, "If it isn't broke don't fix it". Come see how you can give confidence to key stake holders on testing the process.
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
You will get the tools to automate generation of test cases for columns, measures and values from your Power BI reports and set these up to be run automatically.
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>>