Events

We organize various events on the topic of the Microsoft data platform. Book your place on time and join us.

Upcoming events

/* Torsten Strauss - Batch mode Adaptive Join in Microsoft SQL Server */

October 13, 2021. - Online
What?
The batch mode adaptive join feature introduced in Microsoft SQL Server 2017 enables the choice of a hash join or nested loops join method to be deferred until after the first input has been scanned, by using a single cached plan. In this session you will learn about the requirements, advantages, and disadvantages of using the adaptive join. I will especially focus on the runtime improvements using adaptive joins but also show workloads that lead to a significant performance degradation. We will also see when SQL Server cannot use apaptive joins and what effect adaptive query joins have on the hardware resources like memory allocation and disk IOs.
More information / registration - Meetup

/* Markus Ehrenmüller-Jensen - Do You Speak English? Localized Reports with Power BI */

November 10, 2021. - Online
What?
Even when we live in a global world your end-users might expect to get their reports in their own local language. This talk is guiding you through the available options and necessary steps to give the report user control over the language:
• Content of textual columns
• Headlines
• Currency
• Model (names of tables, columns and measures)
• Power BI Desktop and Power BI service
You will learn to extend Power BI’s data model to allow for multi-language support of column content and headlines (and how you can automate the translation of the texts with Azure Cognitive Services). I will show you how you can implement currency conversion and how to translate the model’s meta data. Finally, we look at how to change the language in Power BI Desktop in in Power service.
More information / registration - Meetup

/* Luis Beltran - Cosmos DB + Azure Functions: A serverless database processing */

December 8, 2021. - Online
What?
With the native integration between Cosmos DB and Azure Functions, you can create database triggers, input bindings, and output bindings directly from your account.
Using Azure Functions and Cosmos DB, you can create and deploy event-driven serverless apps with low-latency access to rich data for a global user base.
In this session, we'll explore what it takes to setup a serverless environment capable of performing CRUD operations on a Cosmos DB account, as well as some recommendations and use cases.
More information / registration - Meetup

Past events

/* Data Saturday Croatia 2021 */

September 11, 2021. - In person
What?
Data Saturday Croatia is a free one-day event for professionals who use the Microsoft data platform. This community event offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more.
Where? - The plan is for the event to be in person at the Hotel International, Miramarska 24, 10000 Zagreb, Croatia. We hope for the best! If this is not possible, the event will switch to virtual / hybrid.
More information / registration - datasaturdays.com

/* SQL Server for Developers by Miloš Radivojević */

September 10, 2021. - In person
What?
Clearly, it’s impossible to cover everything a developer needs to know about SQL Server in one one-day workshop, but this one certainly covers the most important ones.
Where? - Course will take place on September 10th 2021 at Hotel International, Miramarska 24, 10000 Zagreb, Croatia.
More information / registration - 3NF Events

/* Improve Your Database Tuning Skills by Uwe Ricken */

September 10, 2021. - In person
What?
This one-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Where? - Course will take place on September 10th 2021 at Hotel International, Miramarska 24, 10000 Zagreb, Croatia.
More information / registration - 3NF Events

/* Advanced Data Visualization in Power BI by Markus Ehrenmueller */

September 10, 2021. - In person
What?
This workshop will give you hands-on experience on what Power BI Desktop (even in the free version!) has to offer for interactive reports and dashboards.
Where? - Course will take place on September 10th 2021 at Hotel International, Miramarska 24, 10000 Zagreb, Croatia.
More information / registration - 3NF Events

/* Dejan Sarka - Power BI and Columnstore Building Blocks */

September 1, 2021. - Online
What?
When you start a journey into the Power BI world, you get quickly confused. There are so many products and services available, it is hard to distinguish between them and select the appropriate building blocks for your needs. This presentation introduces and systematically explains the Power BI elements, thus helping you organizing the Power BI environment in your project or company. The presentation shows where you can get the columnar storage, from Power Pivot in Excel and two versions of Power BI Desktop to Analysis Services, SQL Server, and Azure Synapse Analytics. For extracting, transforming and loading the data you use Power Query, which can again be found in Excel, Power BI Desktop, Analysis Services, and Power Bi Dataflows. You publish the reports in the cloud using the Power BI Service or locally to the Power BI Report Server. You can also build paginated reports with two versions of Report Builder, for local and cloud publishing. Even if you are already experienced with Power BI, this session can help you sorting out the parts.
More information / registration - Meetup

/* Andrea Martorana Tusa - Advanced analytics with Power BI */

September 1, 2021. - Online
What?
Power BI makes advanced analytics handy for business users, allowing stakeholders to extract knowledge and insights from data, to solve business problems and make decisions.
This session will introduce to the advanced analytics features of Power BI, showcasing some real word areas of application: forecasting, predictive analytics, machine learning algorithms, customer sentiment analysis.
For every case it will also be covered the integration with all the complementary tools needed for building a working solution: Azure ML, Cognitive Services, R, quick insights, decomposition tree,Key influencer visuals …
Discover how easy is using advanced analytics in Power BI to effectively address the business challenges and uncover new insights.
More information / registration - Meetup

/* Erland Sommarskog - Dynamic Search Conditions */

June 9, 2021. - Online
What?
A common requirement in database applications is that users want a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintainable and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitations.
More information / registration - Meetup

/* Deepthi Goguri - Method behind the magic of Indexes in SQL Server */

May 12, 2021. - Online
What?
Do you want to learn how to view Indexes behind the scenes? Are you interested in learning how indexes quickly retrieve the data? In this session, we are going to see the Index internals, index maintenance and how indexes are used to get back the results. By the end of this session, you will know how to view index internals, B-tree structures, how this data is useful for effective index usage and get the best performance for your queries.
More information / registration - Meetup

/* Alexander Arvidsson - SQL Server hates you(?) - what the DBAs never told the developers */

April 14, 2021. - Online
What?
Have you had performance tank despite the code working fine in another environment? Maybe heard that some SQL is bad but not why? If so, this is the session for you!
This session will start with a walkthrough of some of the basic settings in SQL Server and how they affect you as a developer. It follows with key tips on what settings to change, why some code will wreak havoc on your performance and how isolation levels matter (and why NOLOCK can be an exceptionally bad idea!) The session is led by a 20-year DBA veteran who decided to try to help developers understand performance issues by seeing things from his perspective.
If you want to explore how default settings kill your performance, investigate why harmless SQL might not be quite so harmless and gain insight into how isolation levels affect function and performance, then this session will provide you with the tools to think outside the box and incorporate database engine knowledge into your developer prowess!
More information / registration - Meetup

/* Taiob Ali - Think like the Cardinality Estimator */

March 10, 2021. - Online
What?
SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code and in turn, influence the type of physical operations during query execution. Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? If your query has only one predicate, the query optimizer will use the histogram to estimate how many rows will be qualified. What happens when you have multiple predicates, range predicates, variable values that are “NOT KNOWN” to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using an amount that is outside of the histogram range?
In this session, I will show you how cardinality estimator estimates in all of these scenarios. You will walk out of this session with a clear understanding of how the CE generates its numbers and ready to tackle those nasty, hard to solve query plans.
More information / registration - Meetup

/* Angela Henry - Profiling Your Data */

February 11, 2021. - Online
What?
Have you ever started a warehouse or ETL project and realized that the data wasn’t as “clean” as you were told? If only you had profiled your data before you started then you wouldn’t have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.
Level: Intermediate
Target Audience: DBAs, Developers & Analysts
More information / registration - Meetup