Sessions & Content

Tags
Search
Conference
Application and Database Migrations-A Pester Journey
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.
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
The quick journey from Power BI to automated tests
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.
dbatools-PowerShell and SQL Server Working Together
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?
Power BI and PowerShell-A Match Made in Heaven
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!
PowerShell Medley
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Simplifying Disaster Recovery using dbatools
Join me for this session as I demo how disaster recovery can be greatly simplified using PowerShell.
Slack for the DBA
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
Smart Alerts in SQL DB using Automation and Logic Apps
Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.
Validate Your SQL Server Estate with Ease Using dbachecks
Learn how you can validate your SQL Server estate with ease using dbachecks
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module
Containers and Clones: giant databases on tiny HDDs
Provision dev databases quickly and easily using containers and clones
Creating complex labs from start to finish with Lability
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
DevOps, CI and the Data Warehouse
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
Introduction to Pester-TDD for PowerShell
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
Managing Always On Availability Groups with Powershell
Combining Always ON Availability Groups and Powershell will make your life easier
Row Level Security-A real world example
Row Level Security based on related tables
Simplifying XEvents Management with dbatools
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Tabular Automation With TMSL and PowerShell
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.
Powershell community scripts for DBAs
We will take a look into my favourite Powershell scripts
<<123>>