SQLSaturday 963


PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Sep 26 2020 at Microsoft Danmark, Kanalvej 7, Kongens Lyngby, Capital Region, 2800 Kongens Lyngby, Denmark

Register Now

Billedresultat for covid-19

Due to the circumstances around the COVID-19/Corona virus, the event team has decided to postpone the event for later this year.
The date is not yet settled with PASS, but we will update you as soon as we get confirmation.
This information will shortly be sent to all parties involved with the event, that be sponsors, attendees, volunteers and speakers

Stay safe! 


Note to attendees!
Lunch Fee will this year be mandatory. It's DKK 75,-
If you didn't pay the lunch fee during sign-up, you will be required to do so in order to gain admitance to the event.

We will accept MobilePay: 0607MD (for reference, please add registered e-mail as note to payment)

PreCons announced

Go to http://www.sqlsaturday.dk to book your seat

We are happy to announce our three precons for this years SqlSaturday in Denmark

Rob Sewell –  Automating the administration of SQL Server using dbatools

Image result for rob sewell

Join Rob Sewell,a dbatools contributors and co-author of ‘dbatools in a Month of Lunches’ for a day of SQL Server and dbatools.
dbatools is an open-source cross-platform PowerShell toolkit for SQL Server DBAs.
With over 150 contributors from the SQL and PowerShell communities, dbatools is designed and written by the people who use it in their everyday work. Spend a day with Rob and learn

Automation – When you are responsible for a number of SQL Instances automating tasks is vital.

Consistency – When a script run it will do the same thing every time. It won’t forget to copy the WHERE clause into the query!

Expertise – Gaining more knowledge, developing skills and being able to improve your productivity will have a positive bearing on your career There will be many practical examples of how dbatools can help to save time in DBA administration duties –

Creating Availability Groups – Syncing Agent Jobs and Logins between replicas – Finding SQL Instances on your estate –

Working with Central Management Server
– Disaster Recovery
– Backup Testing
– Simple instance migrations
– Complex instance migrations
– Tracking Activity
– Working with other community tools with dbatools
– Encompassing dbatools in DevOps
– Using dbachecks

Even better, you will be able to ask questions, meet other people and learn together and make connections that will be of benefit in the future as you take this knowledge and use it in your day to day work.

Learning to use dbatools will also teach you how to use PowerShell and PowerShell interacts with many technologies so you will also be gaining knowledge that you will be able to make use of when you are faced with interacting with other technologies. This day-long session will be of benefit to any level of DBA looking after estates with one or more instances who have a little knowledge of PowerShell.

Uwe Ricken – Index Analysis and Performance Improvement

Image result for dbberater" It is not always the wrong configuration of a Microsoft SQL Server which causes bad running applications.
Quite often you’ll find design problems in the database, bad indexes or a mix of all together. This demo based workshop shows daily indexing problems and solutions with SQL Server prior to 2017 and new improvements in 2017/2019.

Equipped with the basics of row based indexes we walk through different detailed examples and build solutions for common problems based on wrong indexing and/or database design. Fasten seat belts for the following topics which will be handled in 10 lab scenarios in detail: • HEAP / Clustered Index / non clustered Index – basics of indexing • What key is an ideal candidate for a clustered index? Analysis of workloads is an essential part for a good determination • Importance of statistics for efficient queries • Index Improvements in SQL 2017/2019 • sargable vs nonsargable queries • good and bad parallelism scenarios • importance of correct data types • …

Bent Nissen Froning & Asgeir Gunnarson – Managing Power BI

Bent (Nissen Pedersen) Nissen FroningImage result for asgeir mvp"

In this training session we will cover everything you need to know as a Power BI administrator or Power BI responsible. We will use theory and practice to learn concepts and apply them.


We will provision a Power BI environment, we will look at the main settings and figure out which of them are important and how the should be set according to best practices. We will then setup Power BI premium and look through the administration options when it comes to dedicated capacity. We will investigate the role of the Enterprise Gateway, set it up, configure it and talk about how to administer it. We will look at Power BI governance and see how you can set governance strategy, create processes and roles and lastly but not least how you can monitor your Power BI environment.

Make sure to secure your seat.


Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids