We are happy to announce our three precons for this years SqlSaturday in Denmark
Rob Sewell – Automating the administration of SQL Server using dbatools
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
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 • …
Ben Nissen Jensen & Asgeir Gunnarson – Managing Power BI
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.
We are happy to announce that a new SQLSaturday Denmark is in the planning, the event will take place at Microsoft Denmark at their headquarter on Kanalvej 7 in Lyngby.
There will be a full day precon on Friday 24th of April and the price will as usuall be a bargain. Trust us when we say that the precons this year, will be something extraodinary.
Precons start a 9AM and end around 5PM
So save the dates, 24th and 25th of April 2020 and join us in sharing knowledge.
Team SQLSaturday Denmark