Sessions & Content

Tags
Content Type
Search
Conference
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
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
Build your own Monitoring Environment with Powershell
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
Challenge Me! Capturing SQL Server Data with PowerShell
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.
Introduction to Powershell cmdlets for DBAs
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 Developer Side of SQL Server Monitoring and Diagnostics
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#.
How to write professional Powershell scripts
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.
Microsofts big data strategy : Enhancements & Scenarios
Firstly we will show off Microsoft's enhancements to the Hadoop open source stack with HDInsight showing you how easy it is to get started with Hadoop. Secondly we'll explore an interesting big data use case
ETL shootout-SSIS vs Powershell
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
Maintain SQL Server System and Performance with PowerShell
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
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
Enter the Dragon: SQL 2012 on Server Core
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
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.
<<12>>