Nr: 1010
SQLSaturday #1010 – Slovenia – Virtual 2020
SessionID: 107349
From XL to S - Reduce your Power BI model size by 90%!
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: YELLOW
Speaker: Nikola Ilic
Title: From XL to S - Reduce your Power BI model size by 90%!
Abstract:
In this session, we will dig deep to discover what is “under the hood” of Power BI, how your data is being stored, compressed, queried, and finally, brought back to your report. After the session, you will get a better understanding of the hard work happening in the background and appreciate the importance of creating an optimal data model in order to get maximum performance from the Power BI engine.
Finally, you will see a real use-case demo showing how the Power BI data model was reduced by 90%!
SessionID: 108088
Common Data Model - Our new buddy for Data Governance
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: RED
Speaker: Oliver Engels
Title: Common Data Model - Our new buddy for Data Governance
Abstract:
SessionID: 108224
SQL Server Intelligent Query Processing
Event Date: 12-12-2020 - Session time: 09:00:00 - Track: BLUE
Speaker: Dean Savović
Title: SQL Server Intelligent Query Processing
Abstract:
I will talk about new intelligent query processing features in SQL Server 2019. The features that will be described are adaptive joins, interleaved execution, memory grant feedback, table variable deferred execution, batch mode on rowstore, T-SQL scalar UDF inlining and approximate count distinct. The presentation will end with extensive demo.
SessionID: 107068
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: BLUE
Speaker: Gilberto Zampatti
Abstract:
Some new object and configuration option of our databases can enhance the
efficiency of our monitoring and tuning. This session will show some new
object (DMO) introduced in the new platform and a couple of new options
that can change our approach to the monitoring, maintenance and tuning activity.
SessionID: 107079
When Things go Wrong - Error Handling in SQL Server
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: RED
Speaker: Erland Sommarskog
Title: When Things go Wrong - Error Handling in SQL Server
Abstract:
The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling "fancy", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
SessionID: 108467
Connect your data artifacts with Azure Synapse Analytics
Event Date: 12-12-2020 - Session time: 10:15:00 - Track: YELLOW
Speaker: Wolfgang Strasser
Title: Connect your data artifacts with Azure Synapse Analytics
Abstract:
Join this session, if you want to hear about the building blocks of Azure Synapse Analytics, how Data Engineers and Data Scientists and even BI developer can work together in a single service and see how easy it is to start with Synapse Analytics!
SessionID: 107066
Working with parameters in Power Query
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: YELLOW
Speaker: Boriana Petrova
Title: Working with parameters in Power Query
Abstract:
This session will show how to create and use parameters in Power Query. From basic to advanced techniques - from static to dynamic parameters and functions.
SessionID: 107207
Baking Extended Events recipes without breaking a sweat
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: BLUE
Speaker: Gianluca Sartori
Title: Baking Extended Events recipes without breaking a sweat
Abstract:
OK, you got the message: Extended Events is the way to monitor SQL Server from now on. However, you feel overwhelmed by XML shredding and the simplest of tasks seems impossible.
Fear not: in this demo intensive session I will show you how to tackle the most challenging tasks without writing a single line of code. I will use the open-source tool XESmartTarget to audit logins, find unused objects, capture and notify deadlocks and much more.
Stop doing things the hard way! Join me and learn how XESmartTarget can do all the heavy lifting for you.
SessionID: 108416
2 Fast 2 Furious - designing for speed, concurrency, and correctness
Event Date: 12-12-2020 - Session time: 11:30:00 - Track: RED
Speaker: Mark Broadbent
Title: 2 Fast 2 Furious - designing for speed, concurrency, and correctness
Abstract:
In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.
We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
SessionID: 107182
"DAX" the way to do it
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: YELLOW
Speaker: Pedro Reis
Title: "DAX" the way to do it
Abstract:
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI. In this session, I'll show you it's true power and how knowing it can even make you completely rethink your data models.
No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core.
I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
SessionID: 107598
Azure Key Vault, Azure Dev Ops and Data Factory how do these Azur
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: BLUE
Speaker: Erwin De Kreuk
Title: Azure Key Vault, Azure Dev Ops and Data Factory how do these Azur
Abstract:
Can we store our Connectionstrings or BlobStorageKeys or other Secretvalues somewhere else then in Azure Data Factory(ADF)? Yes you can! You can store these valuable secrets in Azure Key Vault(AKV).
But how can we achieve this in ADF? And finally how do we deploy our DataFactories in Azure Dev Ops to Test, Acceptance and Production environments with these Secrets ? Can this be setup dynamically?
During this session I will give answers on all of these questions. You will learn how to setup your Azure Key Vault, connect these secrets in ADF and finally deploy these secrets dynamically in Azure Dev Ops. As you can see a lot to talk about during this session.
SessionID: 108090
Azure Synapse Analytics - Early Lessons learned
Event Date: 12-12-2020 - Session time: 13:00:00 - Track: RED
Speaker: Gabi Münster
Title: Azure Synapse Analytics - Early Lessons learned
Abstract:
We were in the lucky situation to actively accompany several customers on their POCs and early developments of Data Warehouse projects using Azure Synapse Analytics. Based on those experiences we will take you with us on a journey from the first steps into this new offer to use cases and scenarios from existing projects. Let's explore the current set of features, childhood diseases left behind and potential for improvement.
SessionID: 107077
The Evolution of SQL Server as a Service - Azure SQL Database Managed Instance
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: RED
Speaker: Javier Villegas
Title: The Evolution of SQL Server as a Service - Azure SQL Database Managed Instance
Abstract:
In this session we will cover SQL Server running as a managed service (Paas) and will get to know it so that we can consider it as a possibility for our developments
SessionID: 108182
Designing impactful visualisations for your data
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: YELLOW
Speaker: Benni De Jagere
Title: Designing impactful visualisations for your data
Abstract:
As Data is key, visualising said data is even more important. We want our message to be understood with ease, and merely with a couple of glances. Hence making sure the receiving party can do so with ease will be vital to our success.
During this session, we'll go through some steps on how to maximise the potential of data visualisations. Starting at choosing the right types of visualisations, and which colour palettes are good matches for your message, we'll also make sure that our designs are as inclusive as we can possibly make them. Wrapping up with a few common use cases, you’ll definitely pick up a few new things to take home with you.
Walking out of this session, you can expect to have a decent understanding on a few common design principles for your data visualisations and reports.
SessionID: 108354
Change your skills - from an onpremise DBA to a cloud DBA
Event Date: 12-12-2020 - Session time: 14:15:00 - Track: BLUE
Speaker: Björn Peters
Title: Change your skills - from an onpremise DBA to a cloud DBA
Abstract:
In this session, everything will be around changing your daily business from an on-premise environment to a cloud world... new challenges, new tasks, and new options... in order not to struggle too often, you need to create new knowledge and learn a lot of new stuff, so I want to show several ways to update your skills and what you really need to become cloud database admin.
SessionID: 107061
Why Partitioning can boost your data management
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: RED
Speaker: Uwe Ricken
Title: Why Partitioning can boost your data management
Abstract:
Partitioning is a great feature of SQL Server and since SQL 2016 you can use it in Standard Edition, too. See in this session the benefits of partitioning for ETL, maintenance and backup / restore.
The main area of application for partitioning is the optimization of load paths for complex DWH solutions and maintenance of large databases (statistics, indexes, backup, restore).After a brief introduction to partitioning, this session will focus on the key benefits of the above topics
SessionID: 107171
Poor man's SQL Server job monitoring with R
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: BLUE
Speaker: Thomas Hütter
Title: Poor man's SQL Server job monitoring with R
Abstract:
Of course SQL Server (Management or Azure Data Studio) offers you a list view of the agent job history. But wouldn't it be nice to have a graphical overview of job durations and how they develop?
This session is for DBAs and R newbies alike: In one hour we'll develop a dashboard-like overview of your agent jobs' and their durations with the R language.
We'll work our way from finding the right system tables to use, generating one graph per job with the help of R, to adding that little trend line to every one of them. After creating it in RStudio, we'll eventually adapt our script to run in SSMS/ADS just as fine. Once finished, no additional tools are needed, no additional €€ spent.
SessionID: 108197
The Hitchhiker's Guide to navigating Power BI
Event Date: 12-12-2020 - Session time: 15:30:00 - Track: YELLOW
Speaker: Just Blindbaek
Title: The Hitchhiker's Guide to navigating Power BI
Abstract:
Are you also sometimes lost in space? What is up and what is down, when it comes to navigation in Power BI. How much is controlled and what can you adjust yourself?
This session will cover all the options we have to change and setup navigation on three different levels. (1) Inside Reports, (2) between Reports in an App and finally (3) the Power BI Web Portal to help users finding the Apps and Reports. You will be amazed how much actually can be done, to give your users a better experience.
We will cover topics like, Power BI Service navigation, Linking from an Intranet, Setting up Dashboards, The new App navigation, Drillthrough, Buttons, Bookmarks and much more.
SessionID: 107118
Debugging without debugger: investigating SQL Server’s internal structures
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: BLUE
Speaker: Hugo Kornelis
Title: Debugging without debugger: investigating SQL Server’s internal structures
Abstract:
Have you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don’t blame you. It’s a bit like wanting to know who watered the rubber tree that produced the rubber your tires are made off before you get in the car to drive to work. You really don’t need it.
But you might still WANT to know. I did. And I figured it out.
Without ever touching the debugger (I’m a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators.
If you are willing to commit to a fast-paced and deep internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.
SessionID: 107928
Data Modeling Solutions for Challenging BI Data Modeling Problems
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: RED
Speaker: Paul Turley
Title: Data Modeling Solutions for Challenging BI Data Modeling Problems
Abstract:
Sorry to break the news but the world is not flat and neither is business data. Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In this session, we will enumerate common challenges and demonstrate modeling techniques to resolve them. Session topics: implementing star and snowflake schema essentials, role-playing tables, many-to-many and bi-directional filters, working without relationships, disconnected lookup tables and calculation groups. We will also discuss the composite models and the future of BI data modeling.
SessionID: 108243
Automating the testing of your BI solutions with NBi
Event Date: 12-12-2020 - Session time: 16:45:00 - Track: YELLOW
Speaker: Cédric Charlier
Title: Automating the testing of your BI solutions with NBi
Abstract:
If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources.