Sessions & Content

Tags
Content Type
Search
Conference
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!
Slack for the DBA
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module
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.
Automate Your ETL with SSIS and PowerShell
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 and the Data Warehouse
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
The Posh DBA: Troubleshooting SQL Server with PowerShell
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
Extended Events and the new Profiler in SQL Server 2012
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
Gather SQL Server Performance Data with PowerShell
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Hey PowerShell Eventing, can you notify me ?
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?
Introduction to Powershell
Back (hopefully) by popular demand I'll be sharing the secrets to getting started with Powershell in a SQL Server Environment.
Automating Admin Tasks with Powershell
Powershell is a powerful scripting engine that can be used to automate admin tasks making more efficient use of your time. This session will introduce Powershell and how it can be used within a SQL Server environment.
Powershell - old tricks for a new dog?
We all have tried and tested methods of doing things, but may be this new dog will help you do those old tricks?
Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework
Wouldn't you rather spend your day learning all the funky new features in SQL Server 2008 than running all your daily checks over your instances? SQL Server 2008 introduced Policy Based Management which allows a fine-grained level of configuration and control of the instance's properties. The Enterprise Policy Management Framework takes this and extends it out to allow you to manage SQL 2000 and 2005 instances through policies as well.
<<1>>