sqlsathistory

Nr: 878

Back to Main list

SQLSaturday #878 - Sofia 2019

Start Time (24h) Speaker Track Title
09:30:00 Peter Larsson Application Database Development The Date Conspiracy
09:30:00 Ivan Donev BI Platform Architecture, Development Administration Performance troubleshooting in the Analysis Services Tabular and PowerBI world
09:30:00 Boriana Petrova BI Platform Architecture, Development Administration Time intelligence function in DAX
09:30:00 Kevin Chant Enterprise Database Administration Deployment Database Adventure
11:15:00 Andrey Nikolov Application Database Development Embedding Power BI in your application
11:15:00 Catalin Gheorghiu BI Platform Architecture, Development Administration ML on the Edge
11:15:00 Margarita Naumova Enterprise Database Administration Deployment Practical Adaptive Query Processing in SQL Server 2019
11:15:00 Rozalina Zaharieva Enterprise Database Administration Deployment SQL Server Big Data Cluster
13:00:00 Dennes Torres Application Database Development SQL Graph Databases: Beyond Relational
13:00:00 Francesco Sbrescia Advanced Analysis Techniques The intelligent Firing Range (Building Server-less python applications)
13:00:00 Lazaros Viastikopoulos Analytics and Visualization Successful Enterprise Roll-out of Power BI
13:00:00 Diana Tisheva BI Information Delivery A star is born - a.k.a. Power BI data modeling
14:15:00 Matt Willis BI Platform Architecture, Development Administration The Maths Behind Machine Learning
14:15:00 Jose Mendes BI Platform Architecture, Development Administration Learn how to build a real-time analytics solution
14:15:00 Ivelin Andreev Advanced Analysis Techniques ML in PowerBI for Business and Pros
14:15:00 Reinhard Flügel Application Database Development Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics
15:30:00 Mike Byrd Application Database Development Climbing the SQL Server Index B-Tree
15:30:00 Ruslan Zolotukhin Advanced Analysis Techniques Hidden force of the PowerQuery. Powerful ETL AI integration
15:30:00 Boris Simandoff Application Database Development An evolution of the database: Scalable and Distributed SQL
15:30:00 Emanuil Tolev Analytics and Visualization Make sense of real-time data using Elasticsearch
16:45:00 Denis Reznik Application Database Development Hidden gems of SQL Server 2017
16:45:00 Vitali Burla BI Information Delivery Practical Power BI
16:45:00 Mihail Mateev Advanced Analysis Techniques Connecting IoT data with artificial intelligence at scale
16:45:00 Miroslav Lessev Enterprise Database Administration Deployment Elasticsearch with Azure
18:00:00 André Melancia Analytics and Visualization BI Powers - The A.I. Who Tagged Me
18:00:00 Gethyn Ellis Enterprise Database Administration Deployment Driven by the 9s - I need a highly available Microsoft Data Platform – what features should I use?
18:00:00 Jason Bonello Cloud Application Development Deployment Microsoft PowerApps: Creating apps with less time effort
18:00:00 Daniel Joskovski Advanced Analysis Techniques Use forecasting in your application with ML. NET

SessionID: 90152

The Date Conspiracy

Back to calendar

Event Date: 12-10-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Peter Larsson

Title: The Date Conspiracy

Abstract:

Do you really understand dating?

In this session you will learn a new way to look at dates and how to handle them gracefully. After this session you will master new smooth tricks about dates.

SessionID: 90161

Performance troubleshooting in the Analysis Services Tabular and PowerBI world

Back to calendar

Event Date: 12-10-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ivan Donev

Title: Performance troubleshooting in the Analysis Services Tabular and PowerBI world

Abstract:

Have you ever wondered what sits behind the powerful tabular engine (the same, used in PowerBI)? How it achieves that blazing performance over billion and even trillion records? What are the compression algorithms? Or have you ever wondered what happens in the background when you visualize your reports? Well, I have, and I've gathered number of topics I want to share with you - from the engine internals, through tracing expensive queries (including PowerBI Gateway) and querying metadata, to optimizing your model for the best performance, model size and scalability.

SessionID: 90354

Time intelligence function in DAX

Back to calendar

Event Date: 12-10-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Boriana Petrova

Title: Time intelligence function in DAX

Abstract:

This session provide data using time periods and explain some tips and tricks with custom periods, build and compare calculations over those periods.

SessionID: 92136

Database Adventure

Back to calendar

Event Date: 12-10-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Chant

Title: Database Adventure

Abstract:

Aimed mostly at administration and based on real life scenarios, in this audience interactive session we will go through some scenarios you might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.

SessionID: 90151

Embedding Power BI in your application

Back to calendar

Event Date: 12-10-2019 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Andrey Nikolov

Title: Embedding Power BI in your application

Abstract:

Power BI is great tool and reports we made are always beautiful and catchy, right? But sometimes forcing users to open their browser to go to Power BI Service web site isn't so nice. In this session we will explore the various ways to embed Power BI reports, dashboards and tiles. We will learn what is needed to do this, what it will costs us and what architecture decisions must be taken to build an embedded solution.

SessionID: 96854

ML on the Edge

Back to calendar

Event Date: 12-10-2019 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Catalin Gheorghiu

Title: ML on the Edge

Abstract:

Or options in running TensorFlow on Pi or similar class devices. My idea was (a bit born from need), to run TensorFlow on Pi class device. And this presentation is born from my adventures, showing pro and cons of each approach. From running directly on Pi to Azure IoT Edge on to Intel Neural Stick, and the list most probably is in “works” you will see the challenges and results of implementing TensorFlow using these technologies. Remark: Kinder chocolates have nothing to do with ML but will be present.

SessionID: 96922

Practical Adaptive Query Processing in SQL Server 2019

Back to calendar

Event Date: 12-10-2019 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Margarita Naumova

Title: Practical Adaptive Query Processing in SQL Server 2019

Abstract:

We are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance. Join me in this demo rich session to find what’s in 2019 Adaptive QP for you and how it affects your queries and your workload. You will find answers of questions like is there a reason to migrate my database to SQL Server 2017 or 2019, what it will bring for my workload.

SessionID: 96923

SQL Server Big Data Cluster

Back to calendar

Event Date: 12-10-2019 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rozalina Zaharieva

Title: SQL Server Big Data Cluster

Abstract:

Another new SQL Server version, another great new feature. SQL Server big data cluster (BDC) is here. In fact, it is not just a feature, it is a whole platform. BDC combines multiple technologies, deployed as containers, orchestrated by Kubernetes. Its sole purpose is to offer a unified platform that allows us to easily combine and analyze our high-value relational data with high-volume big data.

During this session we will go over the architecture of the platform and we will see it in action.

SessionID: 90158

SQL Graph Databases: Beyond Relational

Back to calendar

Event Date: 12-10-2019 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Dennes Torres

Title: SQL Graph Databases: Beyond Relational

Abstract:

Since SQL Server 2017 the Graph Database feature was released, enabling us to mix the relational model with a Graph model. Some existing flaws in this release are being fixed in SQL Server 2019, bringing graph objects closer to SQL Serve reality.

In this session, you will discover how Graph Databases in SQL Server works and what's new for them in SQL Server 2019

SessionID: 95585

The intelligent Firing Range (Building Server-less python applications)

Back to calendar

Event Date: 12-10-2019 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Francesco Sbrescia

Title: The intelligent Firing Range (Building Server-less python applications)

Abstract:

How to build an automatic score calculator for a nerf gun firing range using various Microsoft technologies.

In this session we will explore how to implement an end to end solution to detect nerf darts fired at a target, the challenges involved and how to overcome them.
The technologies involved will range from Power Apps for user interaction and orchestration, Azure SQL DB for information storage, Azure Storage for file storage, Azure functions to ensure automation and provide a server-less environment for the python script and, last but not least, PowerBI to display the results. At the end of the session you'll have an understanding of how to set up these different technologies to work together seamlessly.

SessionID: 95984

Successful Enterprise Roll-out of Power BI

Back to calendar

Event Date: 12-10-2019 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Lazaros Viastikopoulos

Title: Successful Enterprise Roll-out of Power BI

Abstract:

Many enterprise organisations bought into the self-service gold rush and rolled Power BI out to their users and let them loose. They now find themselves with a mass of uncontrolled workspaces, hundreds of duplicated reports and the kind of conflicting KPI definitions that started the whole warehousing movement in the first place.

A self service environment for most organisations, is a big cultural and business shift, this session looks to address how Power BI should be deployed and managed in an Enterprise scenario, along with how to manage business change and what we can do with Power BI to ensure a smooth transition into a the new world of self-service reporting.

SessionID: 99034

A star is born - a.k.a. Power BI data modeling

Back to calendar

Event Date: 12-10-2019 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Diana Tisheva

Title: A star is born - a.k.a. Power BI data modeling

Abstract:

Power BI is broadly marketed as a self-service BI tool which could be easily mastered even by a non-technical user. Often the focus of the development is not on the data model but on the reports and the respective measures needed for the analytical solution. However, if the data model, even a simple one, does not follow some fundamental design rules, the potential analyses are seriously hampered. In this session we will see the most important design concepts for a good BI data model.

SessionID: 95872

The Maths Behind Machine Learning

Back to calendar

Event Date: 12-10-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Matt Willis

Title: The Maths Behind Machine Learning

Abstract:

The new world of Machine Learning can sound quite overwhelming! Do I need a PhD in Machine Learning to get involved? The answer, thankfully, is no. But what you do need, which is often neglected, is a solid understanding of the theory behind the models.

This session will look to do just that, looking at some of the most popular algorithms used today, we will explore the maths involved, to help us understand our problems and get the best results possible. We will be also diving into practical examples, using Databricks to consume a dataset and to visualise results, with R Python scripts to execute the Machine Learning models.

If you would like an introduction to the world of Machine Learning and to acquire a solid grounding that will help you develop the skill, then this is the session for you.

SessionID: 96119

Learn how to build a real-time analytics solution

Back to calendar

Event Date: 12-10-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jose Mendes

Title: Learn how to build a real-time analytics solution

Abstract:

Real time is fundamental for the life of an organization and to the decision making process, therefore, building a real-time analytical model becomes a business need.

In this session we will learn which processes are required to build a real-time analytical model and how to achieve our goal by either using the Lambda or Databricks Delta architecture.

At the end of the session, you will have learned how to ingest, store, prepare and serve the data with Apache Kafka for HDInsight, Azure Data Lake Store Gen 2, Azure Databricks, SQL Data Warehouse and Power BI.

SessionID: 96333

ML in PowerBI for Business and Pros

Back to calendar

Event Date: 12-10-2019 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Ivelin Andreev

Title: ML in PowerBI for Business and Pros

Abstract:

Machine Learning is approaching a peak of inflated expectations, although we see AI daily and in all contexts. Media pressure is high, governments are overly optimistic, plenty of ventures are putting money in nonviable ideas or some brilliant engineers fail to reach business users. ​

But Microsoft bring all of this under the same roof and unleash the power of AI by integrating Power BI ecosystem with Azure ML and Cognitive services. The result is as simple and effective as great technology at end-user's hand.​ This session is not about learning how to do AI but how to make AI usable and add value. Integrating ML models and sophisticated cognitive services in reports, understanding concealed relations and bringing automated ML empowers any business user to exploit AI for better decisions, regardless of his technical skills.

SessionID: 96824

Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics

Back to calendar

Event Date: 12-10-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Reinhard Flügel

Title: Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics

Abstract:

This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.

SessionID: 90587

Climbing the SQL Server Index B-Tree

Back to calendar

Event Date: 12-10-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree

Abstract:

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially

when it comes to indexes. Some of the things you have probably heard are:  keep clustered index width small  unique indexes perform better  keep non-clustered index width small  compressed indexes have fewer logical reads  add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.

SessionID: 96899

Hidden force of the PowerQuery. Powerful ETL AI integration

Back to calendar

Event Date: 12-10-2019 - Session time: 15:30:00 - Track: Advanced Analysis Techniques

Speaker: Ruslan Zolotukhin

Title: Hidden force of the PowerQuery. Powerful ETL AI integration

Abstract:

PowerQuery is widespread tool with own language in Microsoft BI stack. Namely Power BI reports, Excel, SSAS Tabular, SSIS, Microsoft Flow, Power BI dataflows. ETL of this tool is powerful but you are not limited by it, because you can expand it in different ways. I will show you several examples, which may be unexpected for you, including AI integration.

SessionID: 99125

An evolution of the database: Scalable and Distributed SQL

Back to calendar

Event Date: 12-10-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Boris Simandoff

Title: An evolution of the database: Scalable and Distributed SQL

Abstract:

CockroachDB delivers resilient, consistent, distributed SQL at your scale. It is a new SQL database, designed for the cloud and horizontal scalability. We will have a look at some of the key features of the database and how easy is to deploy, use and scale.

SessionID: 99167

Make sense of real-time data using Elasticsearch

Back to calendar

Event Date: 12-10-2019 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Emanuil Tolev

Title: Make sense of real-time data using Elasticsearch

Abstract:

Elasticsearch is a data store built for addressing various data challenges using the foundations of speed, scale and relevance. It provides advanced querying, search and real-time analytics capabilities. Throughout this talk, we will introduce Elasticsearch and the Elastic Stack, demonstrate different use cases of using it as a main data store, or alongside with your current databases, using the polyglot persistence architectural approach. We'll have a look at a few real-time use cases, build some architectural castles in the sky and show a short introductory demo of how to get started with Apache Kafka and the Elastic Stack for your own real-time data applications.

SessionID: 90500

Hidden gems of SQL Server 2017

Back to calendar

Event Date: 12-10-2019 - Session time: 16:45:00 - Track: Application Database Development

Speaker: Denis Reznik

Title: Hidden gems of SQL Server 2017

Abstract:

SQL Server 2017 is full of new features and improvements. The main "Killer" feature of SQL Server 2017 is SQL Server on Linux, but there are some more big and interesting features: Adaptive Query Processing, Graph Processing, Automatic Tuning and many others which you are aware of. And in this session we will not talk about them. We will not do that just because there are a lot of cool features in SQL Server 2017, which are more hidden from our sight and have not get enough attention.

In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!

SessionID: 96051

Practical Power BI

Back to calendar

Event Date: 12-10-2019 - Session time: 16:45:00 - Track: BI Information Delivery

Speaker: Vitali Burla

Title: Practical Power BI

Abstract:

The "Practical Power BI" session will show you three, particularly practical uses of Power BI for various fields in life. You will learn how Power BI can help you save money time, how it can help you organize your work better and finally, what job opportunities are available. This session is suitable for both beginners and intermediate users of Power BI.

SessionID: 96390

Connecting IoT data with artificial intelligence at scale

Back to calendar

Event Date: 12-10-2019 - Session time: 16:45:00 - Track: Advanced Analysis Techniques

Speaker: Mihail Mateev

Title: Connecting IoT data with artificial intelligence at scale

Abstract:

This talk is about intersection of IoT and artificial intelligence.

IoT solutions to generate more data than traditional systems and users can analyse. Nowadays, AI enabled software solutions that optimize equipment and process performance for large industrial customers. These solutions use large volumes of real-time, batch data from equipment and processes in real time, and apply AI/ML algorithms to predict failures and anomalies as well as optimize performance. The concept is explained in the context of Azure IoT and Azure AI platforms.

SessionID: 99126

Elasticsearch with Azure

Back to calendar

Event Date: 12-10-2019 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Miroslav Lessev

Title: Elasticsearch with Azure

Abstract:

Elasticsearch Service on Elastic Cloud now supports deployments on Microsoft Azure. This session will demonstrate how users on Azure can now deploy fully hosted Elasticsearch and Kibana from the creators of the software all with the click of a button. The Elasticsearch Service on Elastic Cloud is the official hosted Elasticsearch and Kibana service, created and supported by Elastic. It offers features — like Elastic APM, SIEM, Maps, Canvas, machine learning and more — and tech support expertise you simply won’t find anywhere else. Users can wield Elasticsearch and Kibana with confidence, knowing they always have the latest release and security patches and can upgrade their deployments with a single click and zero downtime.

Users can start with a free 14-day trial by only email registration.

SessionID: 93798

BI Powers - The A.I. Who Tagged Me

Back to calendar

Event Date: 12-10-2019 - Session time: 18:00:00 - Track: Analytics and Visualization

Speaker: André Melancia

Title: BI Powers - The A.I. Who Tagged Me

Abstract:

So everyone knows how to make some nice graphs in Power BI from Excel or SQL Server... But what about getting "intelligent" results from unusual data sources?

Disclaimer: A.I. will eventually take over the world. Unlike Doctor Evil, it won't ask for a ransom.

SessionID: 94110

Driven by the 9s - I need a highly available Microsoft Data Platform – what features should I use?

Back to calendar

Event Date: 12-10-2019 - Session time: 18:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Gethyn Ellis

Title: Driven by the 9s - I need a highly available Microsoft Data Platform – what features should I use?

Abstract:

Microsoft’s data platform and SQL Server comes with a plethora of High Availability features. Some of these features can work hand-in glove with each other to allow you to configure your SQL Servers to be both Highly-Available and recoverable in the event of the worst happening.

If you are driven by the '9s', have strict SLAs and up time is key to you and your business, then combining SQL Server’s high availability features is something you should consider.

In this session we will look at how we can combine SQL Server Availability Groups and SQL Server Failover cluster instances to keep our servers both highly available and maintain a secondary disaster recovery.

SessionID: 96806

Microsoft PowerApps: Creating apps with less time effort

Back to calendar

Event Date: 12-10-2019 - Session time: 18:00:00 - Track: Cloud Application Development Deployment

Speaker: Jason Bonello

Title: Microsoft PowerApps: Creating apps with less time effort

Abstract:

In this session we will show how to use PowerApps to build YOUR next customized business application! As part of Microsoft’s Power Platform, this cloud-based suite can allow the design and development of your application in minutes – without requiring extensive coding background and with no need to worry about where to host the application! Apart from easy integration with other Microsoft technologies, it also allows integrations with third-party services with minor setup required, through out-of-the-box connectors!

During this session we will go through some examples of how an application can be built from scratch, using connections to other data-sources and highlighting some important tips to keep in mind during development – learnt through our real-life projects!

It might also be worth keeping in mind one thing: PowerApps could also be part of your modern data warehouse architecture! So, if you’re thinking “applications are not for me”, then think twice!

SessionID: 99123

Use forecasting in your application with ML. NET

Back to calendar

Event Date: 12-10-2019 - Session time: 18:00:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Joskovski

Title: Use forecasting in your application with ML. NET

Abstract:

ML.NET lets you re-use all the knowledge, skills, code, and libraries you already have as a .NET developer so ML.NET gives you the ability to add machine learning to .NET applications, in either online or offline scenarios. With this capability, you can make automatic predictions using the data available to your application. This presentation explains the basics of machine learning in ML.NET.