sqlsathistory

Nr: 956

Back to Main list

SQLSaturday #956 - Belgium 2020

Start Time (24h) Speaker Track Title
09:45:00 Benni De Jagere Analytics Troubleshooting Power BI Report Performance
09:45:00 Andriy Pogorelov Administration SQL Server Transaction Log: internals
09:45:00 Kamil Nowinski Developer The databases in SSDT - a work with project and best practices
11:00:00 Chris Taylor Administration Database CI/CD with Containers and Azure DevOps
11:00:00 Philipp Lenz Developer Introduction into Power BI Embedded
11:00:00 Cédric Charlier Analytics Azure databricks: brick by brick for the data engineer
13:00:00 Marcelo Fernandes Administration Effectively Troubleshooting Latency and Failover of Always On Availability Group
13:00:00 Joanna Wolthuis Developer Be a dynamic SQL dynamo!
14:15:00 Nico Jacobs Analytics Azure Data Factory, your data pipeline in the cloud
14:15:00 Tiago Balabuch Developer Intelligent Query Processing in SQL databases
14:15:00 Martin Croft Administration Azure Data Studio – The 30-day challenge
15:30:00 Paul Andrew Developer An Architects Guide to Delivering Data Insights on the Microsoft Azure Data Platform
15:30:00 Gethyn Ellis Administration Pay less, get more, a guide to SQL Server Licensing
15:30:00 Nicky van Vroenhoven Analytics Tips Tricks of a Power BI Implementation at a Financial Institute

SessionID: 100444

Troubleshooting Power BI Report Performance

Back to calendar

Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Analytics

Speaker: Benni De Jagere

Title: Troubleshooting Power BI Report Performance

Abstract:

So you've built a Power BI report with all the shinies? Good!

After some usage, users have reacted that it's a bit sluggish in usage, and they're not keen on using it anymore.

Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.

With the myriad of root causes that are out there, an elimination approach might suit us very well. Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.

Be it DAX-measures, modelling issues, or an overload of visuals. Every report can be tuned to handle like a dream, and you can do it too!

SessionID: 101038

SQL Server Transaction Log: internals

Back to calendar

Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Administration

Speaker: Andriy Pogorelov

Title: SQL Server Transaction Log: internals

Abstract:

We will touch in depth a one of the most important component of a databases - transaction log. What is it used for? What processes is it involved.

Topics to discuss: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, Best Practices.

SessionID: 101350

The databases in SSDT - a work with project and best practices

Back to calendar

Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Developer

Speaker: Kamil Nowinski

Title: The databases in SSDT - a work with project and best practices

Abstract:

A task seems to be easy. Maintenance a project of a database in the code repository, treat as master-version and do deployment evenly and frequently. Simple? Seemingly. The things become more complex as fast as a number of objects in database growing. While instead of one database, we have over a dozen. When databases have got the references to each other. And how about dictionary tables? Where to keep them and how to script? Additional issues are coming whilst we would like to control instance-level objects.

All these topics I will explain in the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.

SessionID: 100450

Database CI/CD with Containers and Azure DevOps

Back to calendar

Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Administration

Speaker: Chris Taylor

Title: Database CI/CD with Containers and Azure DevOps

Abstract:

In this demo heavy session we will show how Containers along with Azure DevOps can work for your CI/CD pipeline.

You will leave this session with the knowledge and ability to start creating your own bespoke SQL Server on Linux development / testing environments with automated image builds and releasing to Azure Kubernetes Service (AKS) along with some of the issues / pitfalls of doing so.

Pre-Requisite: To get the most out of this session a basic understanding of what Docker/Containers are, is recommended.

SessionID: 100494

Introduction into Power BI Embedded

Back to calendar

Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Developer

Speaker: Philipp Lenz

Title: Introduction into Power BI Embedded

Abstract:

The session gives an overview about Microsoft Power BI Reporting Platform and how this amazing technology can be a game changer at the information delivery to the customer. The session explains what Power BI Embedded is, how to embed reports into ISV application works. Also, the session clarifies the licensing aspect and gives information about the maintenance of this architecture. After the session, the attendees will be able to create her first Power BI Embedded Application

SessionID: 100565

Azure databricks: brick by brick for the data engineer

Back to calendar

Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Analytics

Speaker: Cédric Charlier

Title: Azure databricks: brick by brick for the data engineer

Abstract:

Still developing your ETL with SSIS but you're willing to take a look to the new Azure databricks platform? This session is the first step to start developing with Azure Databricks! We'll start by the use-cases or if you prefer "when is it smarter to switch your good old SSIS for the new tools". Then we'll take a look to a data preparation and a data move with Databricks and we can automate its execution. Finally, we'll go for a few tips with the tooling.

SessionID: 100503

Effectively Troubleshooting Latency and Failover of Always On Availability Group

Back to calendar

Event Date: 07-03-2020 - Session time: 13:00:00 - Track: Administration

Speaker: Marcelo Fernandes

Title: Effectively Troubleshooting Latency and Failover of Always On Availability Group

Abstract:

In this session, we will cover: The internals of SQL Server Always On, Identifying and detecting latency and failover issues with Always On, Artifacts and data pointers available to troubleshoot latency and failover issues, Tips and Tricks to troubleshoot Always On availability groups, New enhancements which make troubleshooting Latency and Failover issues easier

SessionID: 100627

Be a dynamic SQL dynamo!

Back to calendar

Event Date: 07-03-2020 - Session time: 13:00:00 - Track: Developer

Speaker: Joanna Wolthuis

Title: Be a dynamic SQL dynamo!

Abstract:

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.

SessionID: 100456

Azure Data Factory, your data pipeline in the cloud

Back to calendar

Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Analytics

Speaker: Nico Jacobs

Title: Azure Data Factory, your data pipeline in the cloud

Abstract:

Before data can be analyzed it must first be converted and copied into a format and a location where the analysis is the easiest. ETL tools (Extract, Transform, Load) make this possible. But if the data is needed in the cloud, it’s best to run the ETL in the cloud as well.

Azure Data Factory is a cloud-based ETL tool, allowing data to be copied from on-premises as well as cloud based locations. Transformations can be hand-coded, but recently Microsoft added data flows to the product, which allow you to do data transformations without the need to write custom code. In this session you will see the product in action and learn how to get started building your own flows.

SessionID: 100605

Intelligent Query Processing in SQL databases

Back to calendar

Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Developer

Speaker: Tiago Balabuch

Title: Intelligent Query Processing in SQL databases

Abstract:

What if I say you can accelerate database performance automatically without any applications.

Come to this session and figure out how Intelligent Query Processing (IQP) works and adapts to any type of workload with no application changes required.

SessionID: 100827

Azure Data Studio – The 30-day challenge

Back to calendar

Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Administration

Speaker: Martin Croft

Title: Azure Data Studio – The 30-day challenge

Abstract:

Heard of dry January? Well, this the DBA equivalent.

What is it? Why would I want to use this over Management Studio? Can I use it instead of Management Studio? Martin will answer these questions – and more – and share with you what happened when as a DBA/Database professional he tried to exclusively use this instead of SSMS. A month’s work of expertise to be shared in 60 minutes, detailing all the caveats and clever tricks needed to avoid pulling his hair out on a daily basis.

SessionID: 100819

An Architects Guide to Delivering Data Insights on the Microsoft Azure Data Platform

Back to calendar

Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Developer

Speaker: Paul Andrew

Title: An Architects Guide to Delivering Data Insights on the Microsoft Azure Data Platform

Abstract:

The resources on offer in Azure are constantly changing, which means as data professionals we need to constantly change too. Updating knowledge and learning new skills. No longer can we rely on products matured over a decade to deliver all our solution requirements. Today, data platform architectures designed in Azure with best intentions and known good practices can go out of date within months. That said, is there now a set of core components we can utilise in the Microsoft cloud to ingest and deliver insights from our data? When does ETL become ELT? When is IaaS better than PaaS? Do we need to consider scaling up or scaling out? And should we start making cost the primary factor for choosing certain technologies? In this session we'll explore the answers to all these questions and more from an architects viewpoint. Based on real world experience lets think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete solution.

SessionID: 101020

Pay less, get more, a guide to SQL Server Licensing

Back to calendar

Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Administration

Speaker: Gethyn Ellis

Title: Pay less, get more, a guide to SQL Server Licensing

Abstract:

In this session, we will talk about how you can save money by right-licensing SQL Server. Some people consider SQL Server licensing as the “elephant in the room” while others refer to it as “something that no one wants to own, but know they need to sort out.”

SQL Server licensing is a complex beast. It is not always transparent and straight forward to understand what licensing you need. In this session, we will look at how you best license your SQL Servers to get the best return on investment. We will discuss •What SQL Server editions you need to license •SQL Server and software assurance – why you might need both •How can you buy your licenses? o On-premises o Cloud •Licensing models o Core-based o Server+CAL •How to license SQL Server in a virtual environment •Licensing scenarios o High availability o Application mobility o Non-production o SQL Server on containers

SessionID: 101150

Tips Tricks of a Power BI Implementation at a Financial Institute

Back to calendar

Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Analytics

Speaker: Nicky van Vroenhoven

Title: Tips Tricks of a Power BI Implementation at a Financial Institute

Abstract:

Back to September 2016: Power BI is new, shiny and hot. It is the tool of the moment, so people cannot wait to get their hands on it.

Fast forward 6 months, there is more traction within the business, training is given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems. Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users. We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. Throughout this session we take you along on our Power BI journey, with tips, tricks, do's and don'ts during the implementation of Power BI (Premium).