sqlsathistory

Nr: 711

Back to Main list

SQLSaturday #711 - Plovdiv 2018

Start Time (24h) Speaker Track Title
10:00:00 Sergiy Lunyakin BI Information Delivery Get data insights faster with Data Wrangling
10:00:00 Mihail Mateev Strategy and Architecture Choosing the Right Database for Microservices Solutions
10:00:00 Pavel Malek Application Database Development Score a (row) goal and beat a query optimizer
10:00:00 André Melancia Analytics and Visualization If a machine can learn, why can't YOU learn Azure Machine Learning?
11:10:00 Boriana Petrova BI Platform Architecture, Development Administration Real solution using PowerBI
11:10:00 Andrey Nikolov Application Database Development The hidden power of Power BI or what we can do using Power BI REST API
11:10:00 Janusz Rokicki Cloud Application Development Deployment The Road to Autonomous Databases
11:10:00 Catalin Gheorghiu Cloud Application Development Deployment “SQL-like” or query languages in Azure IoT
12:50:00 Ust Oldfield BI Platform Architecture, Development Administration Tabular Automation With TMSL and PowerShell
12:50:00 Margarita Naumova Application Database Development Query tuning when indexes cannot help
12:50:00 Sergey Prokofiev Cloud Application Development Deployment Moving eLearning system to the cloud
14:00:00 Matt Willis Analytics and Visualization The Maths behind Machine Learning
14:00:00 Arnie Rowland Application Database Development RC, SI, and RCSI -It's So Confusing. Which Should You Use?
14:00:00 Cédric Charlier Analytics and Visualization Building a data connector for Power BI
15:10:00 Jose Mendes Cloud Application Development Deployment Chatbots for Dummies
15:10:00 Ivan Donev Application Database Development SQL Server statistics - quick and dirty deep dive
15:10:00 Todor Matev Application Database Development How do SQL DB projects support DB scheme and help you make weekly or daily releases?
16:20:00 Jose Manuel Jurado Diaz Cloud Application Development Deployment Back to the future - Migrating our SQL Server OnPremise Database to Azure
16:20:00 Radoslav Gatev Cloud Application Development Deployment Bringing DevOps to your database
16:20:00 Rozalina Zaharieva Enterprise Database Administration Deployment SQL Server on Linux –  from 0 to 100 in 1 hour!
17:30:00 David Postlethwaite Application Database Development Taming the Beast – How a SQL DBA can keep Kerberos under control
17:30:00 Ventsy Popov Application Database Development Service Fabric Reliable Collection - Lessons Learned
17:30:00 Ivan Pavlov Other Deep Learning with Keras, Microsoft R Open, and VS – A Practical Introduction

SessionID: 73695

Get data insights faster with Data Wrangling

Back to calendar

Event Date: 02-06-2018 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Sergiy Lunyakin

Title: Get data insights faster with Data Wrangling

Abstract:

SessionID: 73859

Choosing the Right Database for Microservices Solutions

Back to calendar

Event Date: 02-06-2018 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Mihail Mateev

Title: Choosing the Right Database for Microservices Solutions

Abstract:

The past years have seen the explosive growth of large-scale distributed systems. This trend has changed the database world that is arguably without precedent in the history of the software industry. The result is a ompetitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about making the right choices?

In this talk we will discuss how we can go about choosing the right database models for your application. We will also look at how the choice of data models can help determine which technologies to include in your data tier.

SessionID: 77687

Score a (row) goal and beat a query optimizer

Back to calendar

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

Speaker: Pavel Malek

Title: Score a (row) goal and beat a query optimizer

Abstract:

Query optimizer is a magical piece of architecture inside SQL Server which instructs the engine how your query is going to be executed. It performs a great job …unless it doesn’t.

In this session we will have a deep look on cases where the query optimizer fails and explain why is it happening. Expect to see a real code written by real developers which will be tuned just in front of you to perform several times faster. If you want to (or possibly need to) take control of execution plan, this session is right for you!

SessionID: 80233

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

Back to calendar

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

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

Real solution using PowerBI

Back to calendar

Event Date: 02-06-2018 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Boriana Petrova

Title: Real solution using PowerBI

Abstract:

The session present 3 real project that using Power BI.

First one is for Pharmaceutics industry, the second one is for HR department and the last is for information and technology services company.

SessionID: 73896

The hidden power of Power BI or what we can do using Power BI REST API

Back to calendar

Event Date: 02-06-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Andrey Nikolov

Title: The hidden power of Power BI or what we can do using Power BI REST API

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 make one simple report from scratch and then 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, and how to share one dataset between multiple reports. By the end of this session we will get a complete reporting solution, with a monthly cost as a decent pizza! :)

SessionID: 77592

The Road to Autonomous Databases

Back to calendar

Event Date: 02-06-2018 - Session time: 11:10:00 - Track: Cloud Application Development Deployment

Speaker: Janusz Rokicki

Title: The Road to Autonomous Databases

Abstract:

The latest version of Sql Server takes advantage of data science more than ever and that trend is going to continue. Three pillars of change are Adaptive Query Processing, Database Automatic Tuning and Intelligent Query Diagnostics. This session will give high level overview of these features and then will focus on performance monitoring intelligence available in Azure Sql DB/DW and standalone version of Sql Server. That covers Query Store and smart tools built on top of it like Automatic Tuning, Automatic Index Management and more.

SessionID: 80229

“SQL-like” or query languages in Azure IoT

Back to calendar

Event Date: 02-06-2018 - Session time: 11:10:00 - Track: Cloud Application Development Deployment

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

Tabular Automation With TMSL and PowerShell

Back to calendar

Event Date: 02-06-2018 - Session time: 12:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ust Oldfield

Title: Tabular Automation With TMSL and PowerShell

Abstract:

This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.

SessionID: 80040

Query tuning when indexes cannot help

Back to calendar

Event Date: 02-06-2018 - Session time: 12:50: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: 82108

Moving eLearning system to the cloud

Back to calendar

Event Date: 02-06-2018 - Session time: 12:50:00 - Track: Cloud Application Development Deployment

Speaker: Sergey Prokofiev

Title: Moving eLearning system to the cloud

Abstract:

In this session I will talk about practical experience of moving a legacy eLearning system to the cloud with significant internal refactoring to get benefits of usage cloud technologies. Also I will trace differences between system design, implementation and major issues/changes in a 3 years of maintenance. Some technical details:

SessionID: 75833

The Maths behind Machine Learning

Back to calendar

Event Date: 02-06-2018 - Session time: 14: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: 78883

RC, SI, and RCSI -It's So Confusing. Which Should You Use?

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Arnie Rowland

Title: RC, SI, and RCSI -It's So Confusing. Which Should You Use?

Abstract:

I'm just going to say it straight out. I'm pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it 'pessimistic', or 'optimistic', or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel 'dirty' as you attempt to 'repeatedly' read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of 'Dirty', 'Repeatable' and 'Phantom' reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.

SessionID: 80238

Building a data connector for Power BI

Back to calendar

Event Date: 02-06-2018 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Cédric Charlier

Title: Building a data connector for Power BI

Abstract:

Do you want to access data from a REST API with Power BI? Willing to know more about data connectors and the Power Query M language? Welcome on board! This session will show you, with a real use-case, what’s a data connector and how to build it. Starting with the definition of a function, going through authorization and finally packaging the whole is a nice journey that we’ll follow during the next 60 minutes.

SessionID: 71569

Chatbots for Dummies

Back to calendar

Event Date: 02-06-2018 - Session time: 15:10: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: 74279

SQL Server statistics - quick and dirty deep dive

Back to calendar

Event Date: 02-06-2018 - Session time: 15:10:00 - Track: Application Database Development

Speaker: Ivan Donev

Title: SQL Server statistics - quick and dirty deep dive

Abstract:

No, this is not going to be a Data Science talk. We will talk on a topic as old as the world itself - SQL Server statistics. Why the engine needs them, how the engine uses them, why should we care and most importantly, how to make our queries run faster by creating the right statistics.

SessionID: 82080

How do SQL DB projects support DB scheme and help you make weekly or daily releases?

Back to calendar

Event Date: 02-06-2018 - Session time: 15:10:00 - Track: Application Database Development

Speaker: Todor Matev

Title: How do SQL DB projects support DB scheme and help you make weekly or daily releases?

Abstract:

I will present a perspective how you can easily support and update DB scheme by SQL Server Db Project, how it helps to make fast and quick releases. What is the right branch strategy, automatization 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: 71688

Back to the future - Migrating our SQL Server OnPremise Database to Azure

Back to calendar

Event Date: 02-06-2018 - Session time: 16:20:00 - Track: Cloud Application Development Deployment

Speaker: Jose Manuel Jurado Diaz

Title: Back to the future - Migrating our SQL Server OnPremise Database to Azure

Abstract:

We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.

This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?

SessionID: 74243

Bringing DevOps to your database

Back to calendar

Event Date: 02-06-2018 - Session time: 16:20:00 - Track: Cloud Application Development Deployment

Speaker: Radoslav Gatev

Title: Bringing DevOps to your database

Abstract:

Application code deployment is an easy thing as long as it is stateless. But what about the databases which are intrinsically stateful?

Have you ever deployed a new release of your database schema manually? How sure were you that you followed 100% of the steps from you deployment list. Do you feel nervous when the time for a new release comes by? I will show you how to introduce the DevOps principles to your databases in order to be much effective in your business and significantly reduce the lead time. The technologies we are going to have in our tool belts are SQL Server Database Tools, Azure Resource Manager and Release Management in VSTS(Visual Studio Team Services). For the advanced scenarios, we will take a look at Build Deployment Contributors.

SessionID: 80199

SQL Server on Linux –  from 0 to 100 in 1 hour!

Back to calendar

Event Date: 02-06-2018 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Rozalina Zaharieva

Title: SQL Server on Linux –  from 0 to 100 in 1 hour!

Abstract:

As you might know, SQL Server runs directly on Linux! Therefore, it was time for me to cross the bridge and install my first SQL Server on Linux so that I could play with on it. In the session we will start with simple things like installation but will quickly get yet deeper with DBA tasks.

SessionID: 73120

Taming the Beast – How a SQL DBA can keep Kerberos under control

Back to calendar

Event Date: 02-06-2018 - Session time: 17:30:00 - Track: Application Database Development

Speaker: David Postlethwaite

Title: Taming the Beast – How a SQL DBA can keep Kerberos under control

Abstract:

The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators.

What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works

SessionID: 82239

Service Fabric Reliable Collection - Lessons Learned

Back to calendar

Event Date: 02-06-2018 - Session time: 17:30:00 - Track: Application Database Development

Speaker: Ventsy Popov

Title: Service Fabric Reliable Collection - Lessons Learned

Abstract:

In this session we will take a practical look at a real-world solution where we apply microservices architecture. We will talk about the challenges we faced during the development and maintenance of an example solutions and will discuss how to solve them.

SessionID: 82513

Deep Learning with Keras, Microsoft R Open, and VS – A Practical Introduction

Back to calendar

Event Date: 02-06-2018 - Session time: 17:30:00 - Track: Other

Speaker: Ivan Pavlov

Title: Deep Learning with Keras, Microsoft R Open, and VS – A Practical Introduction

Abstract:

A practical introduction - Deep Learning with Keras, Microsoft R Open, and VS