Microsoft Data Platform User Group Norway

Welcome to Microsoft Data Platform User Group Norway!

PASSChapterLogo.jpgMicrosoft Data Platform User Group Norway (MDPUG Norway, formerly SQL Server User Group Norway) is for for everyone interested in or working with Microsoft Data Platform technologies including SQL Server, SQL Server Reporting Services & Analysis Services, Information Management (SQL Server Integration Services, Azure Data Factory (ADF) & Data Sync), Power BI, Analytics Platform System, Cortana Analytics Suite, Azure Data Lake, Azure DocumentDB, Azure HDInsight and Hadoop, Spark, & Storm on Azure, Azure Machine Learning, Azure Search, Azure SQL Data Warehouse, Azure SQL Database and Azure Stream Analytics. Our goals are to share knowledge, present new technologies, network and have fun. We welcome everyone from database administrators and developers to business intelligence professionals and students.

Membership is free, join us today!

We are always looking for speakers. Have you worked on an interesting project? Discovered a cool feature? Built an automated framework? Performance tuned the heck out of an application? Scripted all your daily tasks? Join us and share your experiences! We are looking for both Norwegian and English presentations of all levels.

Our meetings are managed via our Meetup group. You can also find Microsoft Data Platform User Group Norway on LinkedIn and you can join us on Twitter by following @MDPUGNorway and using the hashtag #MDPUGNorway.

Next Meeting

Thursday,

December

12

December Meetup with Petar Trbos and Vasko Bashoski

On December 12th, we will be hosting the final meetup of 2019. Join us in Microsoft Norway's offices for networking, food, and two great sessions!

Petar Trbos will kick off the evening with his session about SQL Server Execution Plans, before Vasko will teach us how to optimize databases for consumption in Power BI.

Food and mingling will start around 17:00, Petar will start his presentation around 17:20, and Vasko will start his presentation around 18:30.

See you there! :)

Featured Presentation:

SQL Server Execution Plans

Petar Trbos

A SQL Server Execution Plan determines how efficient a SQL query will be. Execution plans provide us the behavior of a query and indicates whether indexes are used or not when the query runs. An execution plan provides information about tasks executed like tables, indexes, joins, parallelism, and more. It can also provide recommended instructions for improving query performance. In order to fine tune queries in your SQL server environment sometimes we need to examine plan cache. This session is going to show you how plans are created and cached, how to analyze plan cache by finding those with warnings, most expensive, using specific objects, etc.. Also, I am going to show you tools like Query Store and Extended Events, processes and some most frequent queries I use. Also , if time permits, I am going to talk about common reasons for bad plans and how we are trying to avoid these issues, including with intelligent query processing changes in SQL 2019

About Petar:
None

Optimizations for database to be consumed by Power BI direct querying vs. OData streaming

Vasko Bashoski

Overview of the differences in execution plans for queries originating from analytical BI tool [Power BI direct querying] and paginated streaming data [OData queries]. Targeting the scenarios with clustered rowstore or clustered columnstore indexation, partitioning, loading data, overview of memory buffers. This session will show you the decision points in creating objects organization for the scenarios.

About Vasko:
None

Sponsors:

Webstep
Glasspaper
dbWatch
Avanade

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids