sqlsathistory

Nr: 763

Back to Main list

SQLSaturday #763 - Sofia 2018

Start Time (24h) Speaker Track Title
10:00:00 Rudi Bruchez Cloud Application Development Deployment From relational to Multimodel : Azure Cosmos DB
10:00:00 Jose Mendes Cloud Application Development Deployment Chatbots for Dummies
10:00:00 Tomasz Libera Cloud Application Development Deployment Azure Data Factory v2
10:00:00 Catalin Gheorghiu Application Database Development “SQL-like” or query languages in Azure IoT
10:00:00 Margarita Naumova Application Database Development Query tuning when indexes cannot help
11:15:00 Marcin Szeliga Analytics and Visualization Image classification with Microsoft Cognitive Toolkit
11:15:00 Boriana Petrova Analytics and Visualization Power BI Tips and Tricks
11:15:00 Ivelin Andreev Advanced Analysis Techniques Data Preparation for Machine Learning
11:15:00 Miroslav Dimitrov Cloud Application Development Deployment Introduction to Azure SQL Data Warehouse for DBAs
11:15:00 Radoslav Gatev Cloud Application Development Deployment Mission: Reactive Cloud - Azure Event Grid
13:00:00 Kaloyan Kosev Enterprise Database Administration Deployment Embrace the future: Running SQL Server in containers
13:00:00 Michal Sadowski Enterprise Database Administration Deployment How to start working in the multiserver environment?
13:00:00 Dennes Torres Enterprise Database Administration Deployment Achieving wonders with Query store
13:00:00 Denis Reznik Enterprise Database Administration Deployment Deadlocks. Everything you ever wanted to ask but were too shy.
13:00:00 Matt Willis Analytics and Visualization The Maths behind Machine Learning
13:00:00 Todor Matev Application Database Development Step by step to weekly or daily releases. Automating database upgrades.
14:15:00 Marcin Szeliga Advanced Analysis Techniques Beyond image classification - object detection with multi-task deep models
14:15:00 Ivan Donev BI Platform Architecture, Development Administration Designing your tabular/PowerBI model for performance and scalability
14:15:00 Murilo Miranda Analytics and Visualization Processing Real-Time Racing Telemetry with Azure Stream Analytics
14:15:00 Vitali Burla Analytics and Visualization Power Query for Better Reporting - 7 scenarios to learn
14:15:00 Emil Lechev BI Platform Architecture, Development Administration IoT and streaming data or how cheating becomes a challenge
15:30:00 Andrey Nikolov Application Database Development The hidden power of Power BI – now with Power BI Embedded
15:30:00 Janusz Rokicki Strategy and Architecture The Road to The Autonomous Databases
15:30:00 André Melancia Advanced Analysis Techniques If a machine can learn, why can't YOU learn Azure Machine Learning?
15:30:00 Marek Matuszewski Cloud Application Development Deployment The power of Microsoft AI Platform combined with Big Data
15:30:00 Valentin Bonev Strategy and Architecture Tenant Data Isolation with Azure SQL DB
16:45:00 Marek Matuszewski Analytics and Visualization 3 Kings in Power BI: ArcGIS Maps, SandDance and Synoptic Panel
16:45:00 Mihail Mateev Cloud Application Development Deployment CosmosDB for IoT Solutions
16:45:00 Sergiy Lunyakin Strategy and Architecture Big Data Analytics Reference Architectures
16:45:00 Rozalina Zaharieva Enterprise Database Administration Deployment SQL Server partitioning - Why, What and How
16:45:00 André Melancia Enterprise Database Administration Deployment Finding The Droids Fast - Indexing For Padawan

SessionID: 74628

From relational to Multimodel : Azure Cosmos DB

Back to calendar

Event Date: 13-10-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Rudi Bruchez

Title: From relational to Multimodel : Azure Cosmos DB

Abstract:

Azure Cosmos DB is Microsoft's globally distributed, multi-model database. This is NoSQL in the cloud. In this session, you'll see how to use it to create columnar tables, JSON documents and graphs, you'll understand what that means, see what's the difference with relational tables, and how it can be useful for you.

SessionID: 80299

Chatbots for Dummies

Back to calendar

Event Date: 13-10-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Jose Mendes

Title: Chatbots for Dummies

Abstract:

The software development landscape is changing. More and more, there is an increased demand for AI and cloud solutions. As a user buying cinema tickets online, I would like to simply ask "I want to buy two cinema tickets for the movie Dunkirk, tomorrow's viewing at 1pm" instead of manually following a pre-defined process.

In this session, we will learn how to build, debug and deploy a chatbot using the Azure Bot Service. We will enrich it using the Microsoft Cognitive suite to achieve human like interactions. Will it pass the Turing test, no, but we can extend the bot service using Machine Learning (LUIS), APIs (Web Apps) and Worflows (Logic Apps).

SessionID: 84560

Azure Data Factory v2

Back to calendar

Event Date: 13-10-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Tomasz Libera

Title: Azure Data Factory v2

Abstract:

Azure Data FDactory is part of Azure. Using this service you can connect to diffrent data sources, transoform data and load to data destination. During this session I will also show how to use new features of ADFv2. How to lift and shift SSIS packages into cloud, how to use triggers to start a pipeline and how to use Data Transformation and Control Flow Activities.

SessionID: 85380

“SQL-like” or query languages in Azure IoT

Back to calendar

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

Speaker: Catalin Gheorghiu

Title: “SQL-like” or query languages in Azure IoT

Abstract:

If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms.

In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero. We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle. So, we will leave no SQL query unturned in Azure IoT Hub, Stream Analytics, Power Bi to name a few.

SessionID: 85818

Query tuning when indexes cannot help

Back to calendar

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

Speaker: Margarita Naumova

Title: Query tuning when indexes cannot help

Abstract:

Creating an index seems to be a silver bullet for optimizing a performance of a query. If this is true, then most of performance problems seems to go away, but they exist. And there are lots of cases when creating yet another index doesn't help. When do indexes help and when do you need to just take a different approach - rewriting the query for removing bad patterns. In this session I will show you how to decide to create an index or not, and which query patterns don't benefit from indexes. You will see some reason of the plan warnings, cardinality errors, and how to avoid them.

SessionID: 82773

Image classification with Microsoft Cognitive Toolkit

Back to calendar

Event Date: 13-10-2018 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Marcin Szeliga

Title: Image classification with Microsoft Cognitive Toolkit

Abstract:

Artificial intelligence is called electricity of the 21st century. 150 years ago the invention of electricity changed our whole world. Today, thanks to AI, we are facing a revolution on a similar scale.

This breakthrough was possible due to use of deep learning models for such tasks as image and film classification, sound recognition and natural language processing. All of these skills that people come naturally are relatively difficult to machines. Only a combination of three factors: a large amount of available training data, blazing fast computers and innovative deep learning algorithms allowed computers to see, hear and understand colloquial language. During this session we will learn the principle of deep learning models for visual recognition, starting from linear models and model hyperparameters, through general neural networks, to convolutional neural networks. All this theory will be augment by examples — we will build and compare different models using Cognitive Toolkit.

SessionID: 85693

Power BI Tips and Tricks

Back to calendar

Event Date: 13-10-2018 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Boriana Petrova

Title: Power BI Tips and Tricks

Abstract:

In this session we will see a couple of tips and tricks like how to use a quick measure to create a Rating on a table, how to add a custom look to Power BI, Apply Sorting, Formatting, Drilldown in an Array and etc.

SessionID: 85706

Data Preparation for Machine Learning

Back to calendar

Event Date: 13-10-2018 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Ivelin Andreev

Title: Data Preparation for Machine Learning

Abstract:

If there is one crucial thing in building ML models, this would be the data preparation. That is the process of transforming raw data to a state where machine learning algorithms could be run to disclose insights and make predictions. Data preparation involves analysis, depends on the nature of the problem and the particular algorithms. As far as there are knowledge and experience involved, there is no such thing as automation, which makes the role of the data scientist the key to success.

ML is trendy and Microsoft already have more than 10 services to support ML. So we will focus on tools like Azure ML Workbench and Python for data preparation, review some common tricks to approach data and experiment in Azure ML Studio.

SessionID: 85817

Introduction to Azure SQL Data Warehouse for DBAs

Back to calendar

Event Date: 13-10-2018 - Session time: 11:15:00 - Track: Cloud Application Development Deployment

Speaker: Miroslav Dimitrov

Title: Introduction to Azure SQL Data Warehouse for DBAs

Abstract:

You are a database administrator working predominantly on SQL Server on-premises databases and just recently started exploring the options available to you in Azure and most probably working already with Azure SQL. This is great but have you explored Azure SQL Data Warehouse offering? Do you know the main differences in this service when compared to Azure SQL and what you can achieve with it? If you do not have the answers of those questions, join me in an Introduction to Azure SQL Data Warehouse session where we will see what the service is made of, compare it with Azure SQL and explore the different methods of loading data.

SessionID: 85918

Mission: Reactive Cloud - Azure Event Grid

Back to calendar

Event Date: 13-10-2018 - Session time: 11:15:00 - Track: Cloud Application Development Deployment

Speaker: Radoslav Gatev

Title: Mission: Reactive Cloud - Azure Event Grid

Abstract:

What is IoT without communication? Modern software development without integration? What if we took a step further and turn messages into events?

Join me in this session to see how we can build a reactive cloud using Azure Event Grid which is a serverless model of the publish/subscriber model, built for the cloud. The service reached general availability earlier this year and it can turn out be more powerful than you suspect.

SessionID: 77270

Embrace the future: Running SQL Server in containers

Back to calendar

Event Date: 13-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kaloyan Kosev

Title: Embrace the future: Running SQL Server in containers

Abstract:

Well, the future is now. Join me in demo heavy session covering SQL server running in containers. Starting from scratch we will go through a complete container implementation.

SessionID: 80842

How to start working in the multiserver environment?

Back to calendar

Event Date: 13-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michal Sadowski

Title: How to start working in the multiserver environment?

Abstract:

For several years you have been working as a database administrator with few Microsoft SQL Server instances and you have moved to a new project where there is a need to consolidate hundreds of instances. How to tackle this problem? On the session, I will show how to discover, check configuration, apply all best practices and introduce best in class maintenance tasks. And all of that using free community-based tools!

SessionID: 84614

Achieving wonders with Query store

Back to calendar

Event Date: 13-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dennes Torres

Title: Achieving wonders with Query store

Abstract:

Query Store, a new feature released with SQL Server 2016, can allow you to achieve wonders on the SQL Server query tunning universe: starting from ensuring that an upgrade will work and up to know exactly when a change on the database created a tunning problem, you will discover in this session how to make incredible tunning magics with query store.

SessionID: 85263

Deadlocks. Everything you ever wanted to ask but were too shy.

Back to calendar

Event Date: 13-10-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Denis Reznik

Title: Deadlocks. Everything you ever wanted to ask but were too shy.

Abstract:

It's not a secret that a deadlock - it's not very good. Definition of deadlock is very simple and quite clear: This is an exceptional situation when two concurrent queries request same resources but in a different order.

Classic deadlock can occur when two concurrent transactions are modifying data from the two tables in a different order. Unfortunately, in real life deadlocks often are more complex and unobvious. One of the rules, which I always keep in mind, sounds: "You can not design a database, in which the occurrence of deadlock is impossible". And we should deal with them. The algorithm is simple:

  1. Catch the deadlock
  2. Find the root cause
  3. Design and implement a solution. In practice, these steps can be tricky and may require different types of analysis.

In this session, we will look at ten various deadlocks scenarios and find the root cause of the deadlocks. Then, you will see how it will be easy to get the solutions for the deadlock issue if we did the second step.

SessionID: 85348

The Maths behind Machine Learning

Back to calendar

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

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 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: 85499

Step by step to weekly or daily releases. Automating database upgrades.

Back to calendar

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

Speaker: Todor Matev

Title: Step by step to weekly or daily releases. Automating database upgrades.

Abstract:

I will present a perspective how you can migrate development process to releases fast and successfully.

How you can easily support and update DB scheme and data by SQL Server Db Project, how it helps to make fast releases. What is the right branch strategy, automating and continuous integration. You can see how SQL server DB Project helps you prepare update script, easy comparison between PRO and Dev Db scheme without direct access to PRO. How each Developer will own Dev Db for 2 – 3 seconds. How you can make fast and safety refactoring of the name of column, table, view, sp and so on. What is the right way to structure DB Project? How we can make an easy code review of DB change by Developers?

Language: Bulgarian

SessionID: 83777

Beyond image classification - object detection with multi-task deep models

Back to calendar

Event Date: 13-10-2018 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Marcin Szeliga

Title: Beyond image classification - object detection with multi-task deep models

Abstract:

Object detection can be challenging to understand, mostly because there is a gap in the literature between image classification and object detection — the former is explained in deluge of easy to understand blog posts and articles, the latter is the subject of research papers, full of scary looking math.

In this session we will take different approach and built state of the art object detection model in easy to understand steps. First, we are going to make sure that everybody understand concepts of convolution networks, the importance of model architecture and loss function. Then we are going to build a model that will classify single object, a model that finds this object on a picture, and a model that combine both and is able to classify and localize the largest object in each image. Finally, we will move to multiple objects detection, discus latest architectures and design appropriate loss function for this task. All this illustrated with examples built using fastai library.

SessionID: 84893

Designing your tabular/PowerBI model for performance and scalability

Back to calendar

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

Speaker: Ivan Donev

Title: Designing your tabular/PowerBI model for performance and scalability

Abstract:

You developed a PowerBI or an Analysis Services Tabular model and you run it on a server with plenty of cores and memory. But your queries does not scale or your users are not happy with the performance! So what can you do? You can fine tune the settings of your AS Tabular (usually does not bring a large benefit), you can scale up (which is costly) or you can apply the techniques I am going to show you in this session. Techniques, that range from optimizing the storage of your model, to how to effectively implement DAX patterns for maximum performance. And all of that, complemented with digging into engine execution plans, DMVs, tracing activity and tabular engine internals.

SessionID: 85495

Processing Real-Time Racing Telemetry with Azure Stream Analytics

Back to calendar

Event Date: 13-10-2018 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Murilo Miranda

Title: Processing Real-Time Racing Telemetry with Azure Stream Analytics

Abstract:

Stream Analytics is the solution from Microsoft for event based data processing on Azure. The objective of this session is to show the value of real-time data insights with a fictional Car Racing Simulator, detailing the steps from the events source, until the analysis of the race telemetry.

SessionID: 85730

Power Query for Better Reporting - 7 scenarios to learn

Back to calendar

Event Date: 13-10-2018 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Vitali Burla

Title: Power Query for Better Reporting - 7 scenarios to learn

Abstract:

The session will focus on 7 data manipulation scenarios, highly likely to occur when working with multiple sources in Power Query - whether in Power BI or Excel. The session will show workarounds and solutions that require some previous knowledge of PowerBI and will use the free desktop version of Power BI.

SessionID: 86119

IoT and streaming data or how cheating becomes a challenge

Back to calendar

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

Speaker: Emil Lechev

Title: IoT and streaming data or how cheating becomes a challenge

Abstract:

SessionID: 83969

The hidden power of Power BI – now with Power BI Embedded

Back to calendar

Event Date: 13-10-2018 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Andrey Nikolov

Title: The hidden power of Power BI – now with Power BI Embedded

Abstract:

Power BI is a very powerful tool. But behind the shiny UI, Power BI REST API gives you even more features to create better solutions! In this session we will explore what you can do using Power BI REST API and what you can’t (at least not yet!). I will demonstrate how your program can authenticate itself (both in interactive and non-interactive way), how it can add new rows to a dataset or refresh it programmatically, how to share one dataset between multiple reports and how you can embed Power BI dashboards, reports, and tiles directly into your application.

SessionID: 85290

The Road to The Autonomous Databases

Back to calendar

Event Date: 13-10-2018 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Janusz Rokicki

Title: The Road to The Autonomous Databases

Abstract:

Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.

SessionID: 85511

If a machine can learn, why can't YOU learn Azure Machine Learning?

Back to calendar

Event Date: 13-10-2018 - Session time: 15:30:00 - Track: Advanced Analysis Techniques

Speaker: André Melancia

Title: If a machine can learn, why can't YOU learn Azure Machine Learning?

Abstract:

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?

AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too... Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.

SessionID: 85983

The power of Microsoft AI Platform combined with Big Data

Back to calendar

Event Date: 13-10-2018 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Marek Matuszewski

Title: The power of Microsoft AI Platform combined with Big Data

Abstract:

The data are the fuel for the rocket and the AI is the engine. During this session we will get know the crucial Cognitive Services from Microsoft based on DEMOS.

We will destroy a car model LIVE on the scene just to showcase the way how the pattern recognition with Microsoft Cognitive Services work. During the session we will build a BOT that will speak with a voice of a volunteer. There are couple surprises which will make the session dynamic, interactive and informative.

SessionID: 86409

Tenant Data Isolation with Azure SQL DB

Back to calendar

Event Date: 13-10-2018 - Session time: 15:30:00 - Track: Strategy and Architecture

Speaker: Valentin Bonev

Title: Tenant Data Isolation with Azure SQL DB

Abstract:

We will share our experience in migrating a solution to a multi-tenant application, where per tenant data isolation is required. The focus would be on automating Azure SQL database provisioning for each customer.

SessionID: 74662

3 Kings in Power BI: ArcGIS Maps, SandDance and Synoptic Panel

Back to calendar

Event Date: 13-10-2018 - Session time: 16:45:00 - Track: Analytics and Visualization

Speaker: Marek Matuszewski

Title: 3 Kings in Power BI: ArcGIS Maps, SandDance and Synoptic Panel

Abstract:

The session covers an overview about the best practices and features of 3 amazing Visuals in Power BI.

  1. ArcGIS Maps - bring your data on a powerful Map with additional custom layers.
  2. SandDance - play with your data as never before. Create new dimensions on the fly and play your insights as an animation.
  3. Synoptic Panel - prepare any image to act as a filter. Got a plane image and want to bind each seat individually to your Dataset? Go ahead and try Synoptic Panel.

The whole session is a pure LIVE DEMO

SessionID: 82000

CosmosDB for IoT Solutions

Back to calendar

Event Date: 13-10-2018 - Session time: 16:45:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

Title: CosmosDB for IoT Solutions

Abstract:

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.

In this presentation, you will learn: • Why CosmosDB is a good option for IoT Database • Challenges with data in IoT Solutions • How to create IoT applications using CosmosDb • Best practices designing IoT applications with CosmosDB • Best practices creating queries. • Tips and Trick using CosmosDB for IoT Solutions

SessionID: 83632

Big Data Analytics Reference Architectures

Back to calendar

Event Date: 13-10-2018 - Session time: 16:45:00 - Track: Strategy and Architecture

Speaker: Sergiy Lunyakin

Title: Big Data Analytics Reference Architectures

Abstract:

Big Data is a hot topic nowadays. But, how to design robust and scalable architecture according to business needs? Could we use Traditional Analytics (BI) approach here? Let's dive together and learn how to use Attribute-Driven Design approach in order to identify key architecture drivers and map it with reference architectures. We also will look at technologies as building blocks for those architectures and some practical use cases for better understanding how it works.

SessionID: 85306

SQL Server partitioning - Why, What and How

Back to calendar

Event Date: 13-10-2018 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Rozalina Zaharieva

Title: SQL Server partitioning - Why, What and How

Abstract:

Partitioning is process which divides very large tables into multiple smaller physical parts. The main of goal of partitioning is to aid in maintenance of large tables and to reduce the overall response time to read and load data. But it doesn’t mean whenever you see a big table you need to partition it. There is more than to take into account and even more to consider when you implement partitioning. Come to this session to get familiar with partition internals and to understand when and how to implement it.

SessionID: 85513

Finding The Droids Fast - Indexing For Padawan

Back to calendar

Event Date: 13-10-2018 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: André Melancia

Title: Finding The Droids Fast - Indexing For Padawan

Abstract:

You don't need to look in an entire planet to find two droids! You just need to find the right kubaz informant.

Indexes are the kubaz informants of database engines. If you never heard of indexes or are afraid to use them, this session is for you! We'll cover indexing basics, introduce all SQL Server 2016 indexing options and look at some typical optimisation scenarios. Session suited for Developers, DBAs and Students (padawan level). Disclaimer: This session might be a trap.