Precons 2024: Fabric, Power BI and SQL DBA

We are happy to announce the pre-con workshops we prepared for our upcoming Data Community Austria Day.

All the workshops take place on Thursday 25th, January 2024 at JUFA Wien City Hotel. This will be in-person workshops only – no hybrid / virtual option will be provided.

Read more and register at our eventbrite page: https://www.eventbrite.at/o/data-community-austria-3211886920

Data Community Austria Day 2024

Habemus Schedule!

The schedule for our upcoming Data Community Day 2024 is finalized. The selection process this year was tough – we had 226 session proposals from 85 unique speakers. After several rounds of discussions we came up with the following schedule: 6 session rooms, 6 timeslots plus lightning talks

Here is the link to schedule on sessionize.com!

Registration is open We are sold out!

You can get your ticket here: https://www.eventbrite.at/e/data-community-austria-day-2024-tickets-718369541637

Precon Workshops on Thursday, 25th January

Right before the main conference, Thursday will be our full day workshop day. We managed to bring well-known speakers to Vienna to talk about

  • Using Microsoft Fabric to become an analytics super hero! (Stijn Wynants, Microsoft)
  • 10 Szenarien, die ein DBA im täglichen Arbeitsumfeld lösen sollte (Uwe Ricken)
  • Power BI – Title coming soon (Paul Turley)

Registration for our paid workshops will open soon.

Data Community Austria June Meetup

It’s time for another Data Community meetup. Joins us next Wednesday, 21.06.2023 at 16:00 for two great sessions on Microsoft SQL Server topics:

  • Microsoft SQL Server Integration Services: Custom Data Flow Components
  • SQL Server Performance Tuning: Memory Grant in Microsoft SQL Server
Microsoft SQL Server Integration Services: Custom Data Flow Components

SQL Server Integration Services provide you with a set of Data Flow components that implement the most common operations in data extraction, transformation, and integration. If your specific situation calls for a solution that is not provided natively, you can also use the Script Component to embed your custom logic in the given SSIS package. However, in order to use such customizations in more than one package, it is recommended to design Custom Components instead.

In this session you will learn how to leverage the functionalities provided in the managed Data Flow Pipeline assemblies to design a custom data flow component that behaves as if it was one of the natively provided ones.

More specifically, you will learn how to implement Regular Expressions in an SSIS data flow to extract additional data from one or more columns in the pipeline and place it back into the pipeline as additional columns.

presented by Matija Lah, Information Technology and Services Consultant, owner @ Mi Lambda

SQL Server performance tuning: Memory Grant in Microsoft SQL Server

When SQL Server executes a query, memory is required to store temporary data while rows are sorted or joined. Therefore, an effective memory management is crucial for performant queries. The memory grant is controlled by the resource semaphore to avoid that a query monopolizes the whole memory for itself and thus all other queries must wait for their memory allocation.

In this session, we will cover the different memory grants and its DOP and server memory dependency, the impact of the resource governor, spilling into tempdb as a result of missing memory, and finally the functionality of the memory grant feedback feature, which was introduced in SQL Server 2019. Thereby, we will also learn how to identify and optimize memory intensive queries to increase overall throughput.

presented by Torsten Strauß, Microsoft MVP, database engineer @ BP

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

Data Community Austria May Meetup

We are super excited to be able to host our upcoming Data Community Meetup again as a face-to-face event in Vienna.

Thanks to our host Machine Learning Reply, we will not only see each other in person, but also have some drinks and food together. If you cannot be there in person, we will provide you with a live stream.

We look forward to bringing you these two great topics:

  • Successful Power BI Rollout in a Multi-Tenant Organization Modern Data Processing
  • Analytics on Azure Databricks – Best Practices
Successful Power BI Rollout in a Multi-Tenant Organization

A large dashboard with hundreds of users or a daily report for a small team? Power BI helps organizations to modernize their reporting by providing a low-code environment in which a business user can structure and visualize the organizational data (citizen development). In this presentation, we will talk about the strategic approach that enables large organizations to scale the provision of Power BI Service while maintaining control of their data. Together, we will walk through the challenges of the roll-out, exploring the flexibility of Power BI and solutions it can provide in hand with Azure capabilities.

Presented by Miriam Obetkova, Senior Consultant @ Machine Learning Reply

Modern Data Processing and Analytics on Azure Databricks – Best Practices

Azure Databricks emerges as a powerful platform for modern data processing and analytics, providing scalable and collaborative capabilities to unlock the potential of big data. We will delve into the world of Azure Databricks, exploring its key features and highlighting how it enables organisations to tackle complex data challenges. The discussion of the core concepts will be supported by small demos for easier understanding, and the presentation of a full end-to-end machine learning solution on Azure Databricks will close the show.

Presented by Döme Lörinczy, Consultant @ Machine Learning Reply

The talks will be in English. Registration is mandatory (see link below).

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

Save the Date: Data Community Austria Day 2024 – 10 years celebration

Open your calendar and mark the following days:

  • Thursday January 25th 2024 – Precon/Workshop Day
  • Friday January, 26th 2024 – Data Community Austria Day

Details about location, call 4 speakers and more will be shared in the coming months!

Photo by Bich Tran on Pexels.com

Data Community Austria Day 2023

Wir sind zurück. Klein aber fein und heuer noch online…

Der Data Community Austria Day 2023 findet heuer am Freitag, 13. Jänner 2023 statt. Wir sind nicht abergläubisch und hoffen, dass auch DU heuer wieder dabei bist.

Mit zwei Tracks, 12 Sessions und ebenso vielen SprecherInnen und Sprechern freuen wir uns auf einen spannenden DataDay!

English version:

We are back – small but beautiful..

The Data Community Austria Day 2023 is back on Friday, 13th January 2023. We are online again but with 2 track and 12 speakers we aim for an interesting data day!

Online Links

We will be there for your right before 9am CET

Room1: Teams Link

Room2: Teams Link

Registration

Register here: https://www.eventbrite.at/e/data-community-austria-day-2023-tickets-505907903157

Schedule

Link to the schedule: https://sessionize.com/view/ft53fcer/GridSmart?format=Embed_Styled_Html&isDark=False&title=Data%20Community%20Austria%20Day%202023

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/