Powershell & SQL Server Saturday

German PowerShell Usergroup
German PowerShell Usergroup
Öffentliche Gruppe

Microsoft Deutschland GmbH

Walter-Gropius-Str. 5 · München

Wie du uns findest

Microsoft Office Erdgeschoss / Raum Washington

Bild des Veranstaltungsortes


We are planning an incredible Meetup, that will be out of the ordinary. This Meetup will be on Saturday the 2nd of December and will last the whole day. We will have 7 sessions, held in english - with 7 well known international community speakers. Additionally, we will also have one professional trainer, Robert Spengler, on-site presenting one session in german about how PowerPoint kills Speaker.

Hurry up and register for this great event before someone else grabs your seat.

We have also set up an official website for this event. Find us here: http://PSSaturday.de (http://pssaturday.de/)

See you there,

David & Andre


The Agenda:

All sessions will be in english language, except the marked ones, which are presented in german.

09:00 - 09:15
Registration and Welcome (http://www.pssaturday.de/#this)
David das Neves, Andre Essing & Christian Lehrer

09:15 - 10:15
Continuous Delivery for your Module - Put your PowerShell modules in the gallery with just a commit. (http://www.pssaturday.de/#this)
Rob Sewell, MVP

10:30 - 11:30
PowerShell in Business Intelligence environments: Administration, Development & Deployment (http://www.pssaturday.de/#this)
Sylvio Hellmann

11:30 - 11:50
PowerPoint kills Speaker (http://www.pssaturday.de/#this)(german)
Robert Spengler

11:50 - 12:40
lunch (http://www.pssaturday.de/#this)

12:40- 13:00
PowerShell Automation & Delegation with ScriptRunner (http://www.pssaturday.de/#this)
Achim Wieser

13:00 - 14:00
$Problem -as [Opportunity] (http://www.pssaturday.de/#this)
Mathias Jessen

14:15- 15:15
Chat automation in a modern IT environment (http://www.pssaturday.de/#this)
Jaap Brasser, MVP

15:15 - 16:15
PowerShell for the DBA: Why I love my inner pig-dog (http://www.pssaturday.de/#this)
William Durkin, MVP

16:30 - 17:30
PowerShell - Red vs. Blue – Ready, Steady, Fight! (http://www.pssaturday.de/#this)
Julien Reisdorffer, MSFT & David das Neves, MSFT


The Sessions

$Problem -as [Opportunity]

Mathias Jessen

Becoming a true PowerShell ninja can seem like a daunting task. This is the story of how I turned daily nuisances and technical roadblocks in my professional life in to an endless spiral of learning opportunities, a journey that continues to this day


PowerPoint kills Speaker
Robert Spengler
Ein humorvoller Einblick in die Do´s and Don´ts von Präsentationen mit PowerPoint.

Robert Spengler kommt aus dem Vertrieb und weiß, was eine gute Präsentation ausmacht. Heute ist er Speaker mit ironischem Charme, Autor und Regisseur für starke Auftritte. Spengler provoziert seine Klienten und Zuschauer. Er zeigt Ihnen ganz konkret, wie Sie Ihre Präsenz steigern, Ihr Publikum begeistern und für sich gewinnen.Robert ist seit 2000 Redner, Autor und Regisseur für starke Auftritte. In seinen Vorträgen und Coachings zeigt er Führungskräften und Rednern ganz konkret, wie sie ihre Präsentationskompetenz verbessern und ihre persönliche Präsenz steigern.


PowerShell for the DBA: Why I love my inner pig-dog
William Durkin

DBAs and sysadmins never have time for the fun stuff. We are always restoring a DB for a dev or setting up a new instance for that new BI project. What if I told you that you can make all that time consuming busy-work disappear? In this session we will learn to embrace the power in PowerShell to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work. Along the way we will see that we can benefit from the wide world of PowerShell expertise and avoid re-inventing the wheel, again!

William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for CloudDBA (http://clouddba.io (http://clouddba.io/)). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular SQLGrillen event (http://sqlgrillen.com (http://sqlgrillen.com/)), and is a chapter leader for a German PASS chapter.


Chat automation in a modern IT environment
Jaap Brasser
In this session Jaap will cover a range of topics regarding Chat automation and the possibilities this gives us. We will dive into the concept of ChatOps, what it is, how we can implement it and what the benefits are. After this brief introduction we will dive into real-world examples of setting up and configuring your first chatbot, configuring security and resolving real-world incidents using this chatbot.

Jaap Brasseris a Cloud and Automation Engineer and PowerShell MVP with a big passion for scripting and automation. As an IT professional Jaap is part of several professional communities, he speaks at technical events and writes articles on a variety of subjects on his personal blog and other websites or magazines. As an active member of the PowerShell community he is part of the PowerShell Conference organization, he supports others by providing answers in forums, blogs about PowerShell & automation and he creates and shares PowerShell modules and functions.


Continuous Delivery for your Module - Put your PowerShell modules in the gallery with just a commit.
Rob Sewell

An introduction session to show you how YOU can deploy your PowerShell module to a PowerShell Gallery (public or private) automatically

In this fast paced demo heavy session we will

- Use Plaster to create our module framework
- Use GitHub for Version Control
- Use Pester to develop our module with TDD
- Use VSTS to Build, Test (with Pester) and Release our changes to the PowerShell Gallery

Within 45 minutes you will have the tools that you require to continuously deliver changes safely to your published PowerShell module for the consumption of others all using a module that uses the Microsoft Cognitive Services Faces API to analyse Beards

Rob is a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). He is a Cloud and Datacenter MVP and an officer for the PASS PowerShell VG and has spoken at and volunteered at many events. He is a member of the committee that organises SQL Saturday Exeter, PSDay.uk and also the European PowerShell Conference. He is a proud supporter of the SQL and PowerShell communities. He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter. He has a fabulous beardClose


PowerShell in Business Intelligence environments: Administration, Development & Deployment
Sylvio Hellmann

"PowerShell & Business Intelligence - fit it together?": many will ask themselves. But even in this environment, PowerShell can support and simplify the work of programmers and administrators. This session will give you an overview of the possibilities to use PowerShell and Business Intelligence in development and production environments. Furthermore, I will show you examples, how easy it is to work with PowerShell together with Analysis Services, Reporting Services, Integration Services, and PowerBI to execute actions for administration (installation, configuration, maintenance), deployment (providing solutions in this environment) and development (creating/modify solutions).

"PowerShell & Business Intelligence - passt das zusammen?": werden sich viele Fragen. Aber auch in diesem Umfeld kann PowerShell die Arbeit der Programmierer und Administratoren unterstützen und vereinfachen. Diese Session soll Euch einen Überblick über die Möglichkeiten geben, PowerShell und Business Intelligence in Entwicklungs- und Produktionsumgebungen zu verwenden. Darüber hinaus zeige ich Euch an Beispielen, wie einfach es ist, mit PowerShell in Analysis Services, Reporting Services, Integration Services und PowerBI Aktionen zur Administration (Installation, Konfiguration, Wartung), Deployment (Bereitstellung von Lösungen in diesem Umfeld) und Entwicklung (Lösungen erstellen/ändern) durchzuführen.

Sylvio Hellmann is working as a Principal Consultant and Team Leader of the data group at URANO Informationssysteme GmbH. His main focus is SQL Server, Microsoft Business Intelligence/PowerBI as well as Machine Learning technologies on premise and in the cloud. He supports customers around the world to solve complex challenges in projects and in operational environments. Sylvio has also a deep knowledge of development skills and he loves to work with PowerShell.


PowerShell - Red vs. Blue – Ready, Steady, Fight!
David das Neves & Julien Reisdorffer

Julien & David will show in this very technical but thrilling session commonly used attack techniques using Powershell and possible countermeasures focusing on Win10 to provide very technical insights. Are you even aware of the defensive stack or have you just lost the race? It´s time to figure out.

Julien joined Microsoft´s Cyber Defence, Security and Identity after gathering experience for over 7 years in multiple Security domains and roles. Combined with his extensive knowledge in the offensive security realm, he helps customers to approach Cyber Security in a holistic and effective manner, therefore offering a wide range of expertise from Security Architecture to detecting and responding to attacks.

Davidis a former software developer and works now at Microsoft Germany as Premier Field Engineer with the main specialties of Powershell, Windows 10 and Client Security. He is also focused in client workshops and dev requests. Besides his work he writes his own blog, organizes the Powershell UG Munich and speaks at User Groups and Conferences on PS/Dev topics.


Join us to this great event!