Join us for a full day, single track of PowerShell presentations.

Our Sessions will cover a wide spectrum of PowerShell, be it testing your code with pester, the security architecture of powershell or database administration. Six full sessions, packed with information to extend your PowerShell skill-set. Closing the event will be a set of lightning presentations, where everybody in the audience is most welcome to bring his or her own presentation (5-10 minutes each).

Sessions

Session: PowerShell ❤ SQL Server

Presented by: Chrissy LeMaire & Rob Sewell

Join PowerShell MVPs Rob Sewell and Chrissy LeMaire to learn how PowerShell can help improve your work/bacon life balance.
We will show you how to perform many SQL Server tasks easily and simply using PowerShell, from instance migrations to automated backup testing and more. Our session is aimed at anyone who works with SQL Server, from junior to senior, who wants to embrace the ease of automation and increase their toolset.

Session: Green is good, Red is bad – Turning your Checklists into Pester Tests

Presented by: Rob Sewell

This session will be relevant to any technicians who use checklists

I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as Operational Validation using Pester.

There are many use cases for this type of solution:

DR testing,
installation,
first line checks,
presentation setups

After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for management.

Imagine this checklist across a few hundred SQL Server Instances with a couple of thousand databases

Every Job in Ola Hallengrens Maintenance Solution
exists,
is enabled,
has a schedule,
has succeeded,
has 2 job steps,
has a generate restore script job step,
the root backup folder is contactable,
for every database the correct folders exist for the full, differential and log backup depending on recovery model in that folder,
each of those backup folders has files in it,
the most recent file in each of those folders is less than the required frequency for those jobs.

I am able to perform those checks in 15 minutes across hundreds of servers and thousands of databases and I think it is cool and useful and everyone should be able to do so and take the functionality to create their own.

Session: Windows 10 Powershell Security - All you need to know

Presented by: David das Neves

More and more customers are concerned about the attack techniques executed through Powershell. But how should a defender configure his Windows 10 Client machines securely to prevent such kind of attacks? Some customers try to just prohibit the usage of Powershell, but is this even an effective approach? The most basic keywords you should know are ExecutionPolicy, Applocker, Device Guard, Constrained Language, AMSI and Powershell Logging. Join this session to receive a complete Powershell Security Stack overview with some deep dive insights to be prepared for the real life and to establish this security approach sequentially with your customer.

Session: Accelerate and empower your scripting with the PSFramework

Presented by: Friedrich Weinmann

When scripting PowerShell - from small on-the-fly scripts up to full modules - we often face similar challenges, have the same repeating decisions to make. Cut corners to save time.

This session introduces the PSFramework and shows you how to:

• Simply introduce logging to your code
• Receive rich debugging information without rich implementation effort
• Handle configurations and settings
• Manage & control your code via GPO / DSC
• Integrate cloud logging services

Session: Hyper-Active Directory - Performant PowerShell with ADDS

Presented by: Mathias R. Jessen

The Active Directory PowerShell module that comes with RSAT is versatile and comprehensive, but has its quirks, among them being execution speed and size limitations. Let's explore opportunities for building faster tools that scale well with 1000s and 1000s of objects, and finally how we can use our existing knowledge of the design concepts in Active Directory to not waste a single CPU cycle when doing complex queries.

Session: TBA

Presented by: TBA

Session: Lightning Presentations

Hosted by: Friedrich Weinmann

Every attendee is free (and very welcome) to sign up for 5-10 minutes on the stage, presenting on anything PowerShell. Any topic of any level is welcome for this, languages German and English are equally fine as presentation languages. To sign up before the actual event, as well as any questions regarding it, feel free to email the Orga Team at saturday@powershell-suttgart.de.

Speakers

Chrissy LeMaire

Chrissy LeMaire is a Windows PowerShell MVP who has worked in IT for nearly 20 years. She currently serves as SQL Server DBA for NATO Special Ops in Belgium, and is pursuing an MS in Systems Engineering at Regis University.
In her spare time, she maintains her two websites, netnerds.net and RealCajunRecipes.com. She also contributes to the Hey, Scripting Guy! Blog and runs the Belgian PowerShell User Group with Luc Dekens.
You can follow her on Twitter at @cl.

Rob Sewell

Rob is a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). He is a Cloud and Data Center Management MVP. He is an officer for the PASS PowerShell Virtual Chapter and has spoken at and volunteered at many events.
He is a member of the committee that organises SQL Saturday Exeter and also 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 beard

http://sqldbawithabeard.com
@sqldbawithbeard
https://uk.linkedin.com/in/robsewellsqldba

David das Neves

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

Mathias R. Jessen

Amateur PowerShell Aficionado (and a huge fan of type inference) with 10 years of IT experience in Development, Ops and Security. Currently attempting to understand humans and how to protect them at Booking.com in Amsterdam.

Friedrich Weinmann

Fred is a general purpose System Administrator / Analyst with a heavy focus on automation using PowerShell, automating the management of a wide spectrum of systems, be it Windows OS, Exchange Server, Active Directory, PKI, VMware or even Licensing audits.
When not on the job he runs the PowerShell UG Stuttgart, contributes to the dbatools project, maintains and extends the PSFramework project, speaks at User Groups and occasionally adds an article to his blog.

FAQ

Why is there no specific location?

The specific location is dependent on the number of sign-ups and will be announced closer to the event. It will be guaranteed to be within easy access range of public transport in Stuttgart.

Great, I'm on the waiting list. Should I just give up on the event?

By no means. Given the number of subscriptions, we will pick a larger location and extend the number of available tickets.

How do I register to hold a lightning presentation?

You can simply walk up to the orga team at the event, describe your topic and sign up. It is also very possible to sneak in early and send an email to saturday@powershell-stuttgart.de with your idea.

I've got more questions, where do I post them?

Any additional questions can be sent to saturday@powershell-stuttgart.de.