Data Community Austria December Meetup Special

Itzik Ben-Gan is coming to town and joins us for a Data Community meetup in December. Get your free tickets in time, we are meeting in-person in Vienna this time!

Beware of Nondeterministic T-SQL code

Nondeterministic calculations are calculations that, when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.

Presented by Itzik Ben-Gan, Data Platform MVP, Co-Founder & T-SQL Trainer @ Lucient

Kostenfreie Anmeldung zum Live Webcast und zum Onsite meetup in Wien: https://www.eventbrite.at/e/473476098757/

Also, if you’re a Database Professional, don’t miss Itzik Ben-Gan’s awesome Advanced T-SQL Querying, Programming and Tuning for SQL Server training in Vienna (12.12.2022 – 16.12.2022).
Get your tickets at Lucient – Central Europe | Advanced T-SQL Querying, Programming and Tuning for SQL Server.

Data Community Austria November Meetup

Für unser kommendes Data Community Austria Meetup am 16. November 2022 haben wir wieder zwei superspannende Sessions vorbereitet und freuen uns auf zahlreiche Teilnahme von Datenbank Cracks und Power BI Enthusiasten:

  • This Is Fine – Firefighting for the DBA
  • Infusing AI with Power BI

This Is Fine – Firefighting for the DBA

Whether you’ve been a DBA for a week, a year, or a decade, you’ve likely had that day where it felt like you were fighting multiple fires at the same time. That often makes you feel like you have no idea what you’re doing – but you do. I’ve been both an on-call DBA and a consultant in my career so I’ve seen how to handle firestorms like this correctly – and how to set fire to everything by handling them wrong. Join me for an hour where I share some technical tips, some horror stories, and some success stories. Hopefully you will walk away with some tips to improve your incident response while improving your sanity during the storm as well!

presented by Matt Gordon, MVP, Director of Data and Infrastructure @ Rev.io

Infusing AI with Power BI

Wie bringe ich Power BI Berichte auf das nächste Level? Mithilfe der in Power BI integrierten künstlichen Intelligenz lassen sich Berichte einfach aufwerten und bieten so den Berichtskonsumenten eine Vielzahl zusätzlicher wertvoller Informationen und Einblicke in die Daten. Q&A, Quick Insights, Key Influencer Visual, Chart Insights, Forecasting und AI Insights sind nur einige Beispiele der vielen Möglichkeiten mit denen Power BI Berichte ohne viel Aufwand mit neuen Einblicken und Erkenntnissen aus den Daten erweitert werden können.

In einer „demo-lastigen“ Session zeige ich, wie man die unterschiedlichen KI-Funktionalitäten in Power BI nutzen und sinnvoll einsetzen kann.

presented by Martin Pöckl, Cloud Solution Architect Data & AI @ Microsoft

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/465862335787/

Data Community Austria Meeting Oktober

For our upcoming community meeting on October 19th, we have prepared two exciting „deep dive“ sessions with great speakers:

  • Defeat Page Latches in Microsoft SQL Server
  • Lessons learned from optimizing enterprise data models in Power BI

Defeat Page Latches in Microsoft SQL Server

Concurrent inserts into a clustered table with an ever-increasing key become a bottleneck since Microsoft SQL Server must protect the corresponding pages with a page latch. There are several techniques like, hash partitioning, reserve bits, in-memory OLTP and the feature introduced in 2019 CTP 3.1 called OPTIMIZE_FOR_SEQUENTIAL_KEY. We will compare these features to understand their performance improvements and the effort required to modify your existing application.

presented by Torsten Strauss (MVP, MCSE, MCT), Senior Platform Engineer @ BP Europe

Lessons learned from optimizing enterprise data models

You know that DirectQuery performance sucks – but, what should you do when DirectQuery is the ONLY available option?

You know that high cardinality increases data model size – but, what should you do when your users want to analyze numbers on a granularity level higher than day? How to reduce the data model size, while at the same time satisfying business requirements?

You know that by leveraging composite models, you can gain significant performance improvements – but why do you still have DirectQuery queries even when you target the data from the aggregated table in Import mode?

In this session, I’ll share tips, tricks and workarounds learned and implemented in real-life scenarios on enterprise data models.

As you may assume, this session is not for rookies – I’ll assume that you already have at least intermediate Power BI/Tabular model knowledge.

presented by Nikola Ilic, Data Mozart, Microsoft Data Platform MVP | data-mozart.com

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/440455342787/

Data Community Austria Meeting September

In unserem nächsten Data Community Austria Meeting am Mittwoch, den 21. September 2022 ab 16:00 Uhr haben wir wieder 2 spannende Sessions vorbereitet:

  • Azure Data Factory ♡ Bicep
  • Building your lakehouse on Synapse

Azure Data Factory ♡ Bicep

Azure Data Factory Bicep Azure Data Factory (ADF) is a mighty tool when it comes to creating data loading workflows and orchestrations. However, creating ADF loading logic takes a lot of clicking and even though it is thoroughly integrated with Git, the code representation of ADF resources is hardly ever used. Bicep is a mighty tool when it comes to creating Azure Resources from Code and its capabilities go beyond just creating infrastructure resources. What if both came together and we were able to create ADF Linked Services, Datasets and Pipelines from a Bicep template? It would be a match made in heaven. But why wait for dreams to come true?

In this session we will introduce you to the basic concepts of ADF and Bicep and then show you how you can create ADF from Code by writing Bicep files and deploy them to your Azure subscription with one click.

presented by Benjamin Kettner, MVP and CTO @ ML!PA Consulting & Alpa Buddhabhatti, MCT and Consultant @ Cluster Reply UK

Building your lakehouse on Synapse

No, not that kind of lakehouse… The data lakehouse architecture launched launched by Databricks a few years ago has become a viable solution for modern data platforms, increasingly so with the string of new features released from Databricks lately. But the data lakehouse concept can also be fully implemented using Azure Synapse.

So join me in this session to understand what the data lakehouse is, and how to make one using Databricks and Synapse!

presented by Johan Ludvig Brattås, MVP, Principal solution architect @ Capgemini

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/420142586787/

Data Community Day 2022 Vienna – 28. Jänner 2022

Wir sind zurück – in Deutsch, in klein, aber oho 🙂

Freut euch mit uns auf den Data Saturday Vienna 2022 #21 -> http://datasaturdays.com/2022-01-28-datasaturday0021/

Anmeldung unter: https://www.eventbrite.at/e/data-saturday-21-vienna-2022-tickets-237372747277

Der Schedule

Die Sessions werden auf Deutsch vorgetragen.
Änderungen im Zeitablauf können noch vorkommen!

Data Community Austria Meeting November

In unserem nächsten Data Community Austria Meeting am Mittwoch, den 17. Oktober 2021 ab 16:00 Uhr haben wir wieder 2 spannende Sessions vorbereitet:

  • SQL Server on Kubernetes (Ben Weissman)
  • Power Automate und Power BI (Ynte Jan Kuindersma)

SQL Server on Kubernetes

You may have heard of Kubernetes – in my opinion the future platform for any kind of modern data platform deployment. But maybe you also heard how complicated it is and that you have to be a Linux Pro to use it?

Well, how about me showing you, how to deploy SQL Server 2019 to a new Kubernetes cluster running in Azure (Azure Kubernetes Services) and all you need is a Windows Workstation and an Azure Subscription.

presented by Ben Weissman

(Power) Automate Power BI

Wenn man Daten via Power Automate aus Power BI exportieren möchte, dann gibt es einige Möglichkeiten: Paginated reports exportieren, den Power Automate Button in Power BI benutzen und seit kurzen auch ein WebAPI Call.Ich zeige kurz die ersten 2 und fokussiere mich dann auf die dritte.

Gezeigt wird:

  • Wie man in Azure AD eine App registriert und so ein service pricipal kreiert.
  • Wie man die Berechtigungen setzt in AD und Power BI workspace damit die App auch Rechte hat die daten zu lesen.
  • Wie man ein Token bekommt womit man sich dann beim Webapi identifiziert.
  • Wie man ein DAX query aus ein Power BI Bericht heraus holt und in Power Automate einfügt.
  • Wie man die Daten in eine Sharepoint Liste speichert.
  • Und dann die Daten in Power App einbindet.

presented by Ynte Jan Kuindersma, Director @ BIRD Automation

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/data-community-austria-meeting-november-registrierung-209719024247

Data Community Austria Meeting Oktober

In unserem nächstes Data Community Austria Meeting am Mittwoch, den 20. Oktober 2021 ab 16:30 Uhr führt uns Microsoft MVP Dejan Sarka in die Tiefen von Advanced Analytics ein:

  • Association Rules Step by Step – Market basket analysis with T-SQL, R, Python, Azure ML and SSAS

Association Rules Step by Step

You will learn how to recognize good products, products which raise the sales of other products, and toxic products, products which are usually sold alone or are the last product in the basket, thus finishing the shopping. Measures like support, confidence and lift, are explained in details. Sequential basket analysis is covered as well. Demos are developed step by step in T-SQL, in order to show how the calculations are made. Then you will see demos also in other languages and on other platforms.

presented by Dejan Sarka, MCT and Data Platform MVP, Independent Consultant @Dejan Sarka s.p.

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/data-community-austria-meeting-oktober-registrierung-191945302567

Data Community Austria Meeting September

In unserem nächstes Data Community Austria Meeting am Mittwoch, den 15. September 2021 ab 16 Uhr präsentieren die Microsoft MVPs Torsten Strauss und Kathrin Borchert die folgenden Themen:

  • SQL Performance Tuning with Optimistic Concurrency
  • Live-Kommentierung in Power BI

SQL Performance Tuning with Optimistic Concurrency

The default transaction isolation level of SQL Server is set to read committed, which eliminates certain read phenomena, but can also affect concurrency and overall read performance.

SQL Server also offers two optimistic transaction isolation levels where a transaction does not acquire a lock when reading data, which reduces the probability of blocks and therefore leads to significantly better reading performance in a busy database.

In this session you will learn how to increase the reading performance in a database simply by changing the transaction isolation level to snapshot isolation. You will also understand how SQL Server implements this function internally and what disadvantages like for example page splits and ghost records and it has.

presented by Torsten Strauss, Data Platform MVP, Senior DB Engineer @ inside-sqlserver

Live-Kommentierung in Power BI mit Power Apps und Power Automate

In meiner Session möchte ich gerne demonstrieren wie man sehr einfach Live-Kommentierungen in einem Power BI Bericht implementieren kann, mit Hilfe von Power Apps und einer Azure SQL DB.

Die meisten Kommentierungen die in Power BI mit Power App erstellt werden, basieren aus meiner Erfahrung nach, auf einer statischen Excel Tabellen oder SharePoint Listen. Es gibt aber auch eine sehr elegante Lösung über Azure SQL DB, um Kommentare in Echtzeit in einen Power BI Bericht zu erzeugen. Diese können auch anschließend mit Hilfe von dem neuen Power Automate Visual als Mail versendet werden oder auch direkt im PDF-Format in ein frei wählbares Ablagesystem gelegt werden, z.B. für Auditzwecke. Also lasst euch überraschen wie vielseitig die Power Platform ist.

presented by Kathrin Borchert, Data Platform MVP, Senior BI consultant @ drjve GmbH

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/data-community-austria-meeting-september-registrierung-170167901775

Data Community Austria Meeting August

Nach einer kurzen Sommerpause starten wir in unser nächstes Data Community Austria Meeting. Am Mittwoch, den 18. August 2021 ab 16 Uhr gibt es, sommerlich passend, zwei heiße Power BI Themen präsentiert von zwei Top Vortragenden:

Calculation Groups – Your universal tool?

Calculation groups have been celebrated as an important step to close gaps between Analysis Services Tabular and the good old Multidimensional. And probably nobody will contradict this statement.

But… Does this mean calculation groups are a good choice in every situation? Do they solve all your potential issues? Or do you need to be aware of downsides or limitations and make a well-founded choice?

This question is especially interesting for Power BI developers, as you are not only in the need to create the models, but you also need to be aware of visualization requirements that might lead to very specific issues.

Let’s have a look at some scenarios and evaluate the aptitude of Calculation groups as a solution approach …

presented by Gabi Münster, Data Platform MVP, BI Consultant @ oh22data AG

Keeping Up With Your Power BI Tenant Administration

For many organisations, Power BI is becoming absolute key in their Information Delivery stream. As an important cog in the chain, it’s the responsibility for that organisation to keep the cog well oiled.

Power BI Tenant Admins need to make sure they’re on top of their game, to keep all parties involved on their good side. During this talk, we’ll go through some of the key activities to optimise this process, based on my war stories as a consultant.

Security, Auditing, Monitoring and Alerting are the cornerstone of this process, which doesn’t have to be hard. Walking out, you’ll have some practical tips to take home with you.

presented by Benni De Jagere, Data Platform MVP, Enterprise Data Architect @ Realdolmen

Kostenfreie Anmeldung zum Live Webcast: https://www.eventbrite.de/e/data-community-austria-meeting-august-registrierung-166920871821

Data Community Austria Meeting Juni

Im Rahmen unserer Data Community Austria Meetings präsentieren Experten in Live Webcasts aktuelle technologische Themen und Lösungen in der Praxis rund um Azure Data Services, Power BI und SQL Server Technologie.

Im kommenden Webcast am Mittwoch, 16. Juni 2021 ab 16 Uhr haben wir die folgenden zwei Themen vorbereitet:

Einführung in Process Mining mit Power BI

Dieser Vortrag gibt einen Einblick in die Process Mining Technologie und die ausführliche Analyse von Prozessdaten mit Microsoft Power BI.

Was ist Process Mining und wie sieht es aus? Wie kann ich Process Mining in Power BI betreiben und welchen Nutzen habe ich davon? Welche Datenvoraussetzungen gibt es? Ein Fallbeispiel für die Prozessanalyse mit Process Mining und eine Einführung in das kostenlose PAFnow Process Mining Visual runden den Vortrag ab. In einer anschließenden Q&A-Session beantworten Marc und Philipp alle offen gebliebene Fragen.

presented by Marc Ottenthal und Philipp Kapelle, Data Analysten bei der Process Analytics Factory (PAF)

Introduction to the Microsoft Dataverse

Microsoft Dataverse is a cloud-based, low-code data service and app platform, which allows you to leverage the security and connectivity of Microsoft services. Dataverse connects easily to all aspects of Microsoft Power Platform so that you can fully control, automate, and strengthen your business. With standard tables and columns, as well as the ability to easily define relationships between your data, Dataverse was built for powerful, scalable solutions. In this session Microsoft Data Platform MVP will give you an introduction in the Data Layer behind the Power Platform.

Kostenfreie Anmeldung zum Live Webcast: Data Community Austria Meeting JUNI Registrierung, Mi, 16.06.2021 um 16:00 Uhr | Eventbrite