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
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.
<<12>>