sqlsathistory

Nr: 857

Back to Main list

SQLSaturday #857 - Kyiv 2019

Start Time (24h) Speaker Track Title
10:00:00 Jose Manuel Jurado Diaz Cloud Application Development Deployment Move your database to the Cloud: Understand, Design, Migrate, Man
10:00:00 Edwin M Sarmiento Enterprise Database Administration Deployment The SQL Server DBA’s Guide to Docker Containers
10:00:00 André Melancia Enterprise Database Administration Deployment Hacking SQL Server Is Not Enough
10:00:00 Mihail Mateev BI Platform Architecture, Development Administration Power BI Premium vs Power BI Embedded for Modern BI Solutions
10:00:00 Paul Wehland Enterprise Database Administration Deployment Introduction to Polybase
10:00:00 Vitalii Bondarenko Strategy and Architecture SQL Server 2019 Kubernetes: Cloud Native Development for Enterp
10:00:00 Mykola Pobyivovk Application Database Development Tuning SQL Server for mere mortals (українською)
11:10:00 Senthamil V Cloud Application Development Deployment Blockchain as service - Azure Blockchain Workbench
11:10:00 Erland Sommarskog Application Database Development Working in Batches
11:10:00 Andriy Pogorelov Enterprise Database Administration Deployment SQL Server PowerShell. How to become a true senior DBA (на русском)
11:10:00 Jose Manuel Jurado Diaz Enterprise Database Administration Deployment Attention Contention!!!
11:10:00 Maryna Popova BI Platform Architecture, Development Administration Building BI solution with AWS vs Google Cloud
11:10:00 Anton Boyko Cloud Application Development Deployment The future of serverless computing
11:10:00 Oleksii Vykhristiyk Application Database Development Oracle APEX
13:30:00 Marcin Szeliga Advanced Analysis Techniques How to win Kaggle competition and get familiar with machine learning ?
13:30:00 Satya Jayanty Enterprise Database Administration Deployment DevOPS for DBAs - Where is your magic wand?
13:30:00 Janusz Rokicki Enterprise Database Administration Deployment Anomaly Detection in Predictive Maintenance for Sql Server
13:30:00 Stanislav Lebedenko Cloud Application Development Deployment Securing, maintaining and troubleshooting your Azure SQL in production.
13:30:00 Artur Konstantynov Analytics and Visualization Power BI. Evaluation context in DAX.
14:40:00 Torsten Strauss Enterprise Database Administration Deployment Plan Caching
14:40:00 Kamil Nowinski Application Database Development The databases in SSDT - a work with project and best practices
14:40:00 Sergey Dzyuban Analytics and Visualization Hadoop in AWS - You can already use it without knowing about it
14:40:00 Michal Sadowski Enterprise Database Administration Deployment Hacking SQL Server
14:40:00 Catalin Gheorghiu Cloud Application Development Deployment “SQL-like” or query languages in Azure IoT
16:00:00 Sergii Bielskyi Cloud Application Development Deployment Streaming Big Data in Azure with Kafka and Event Hubs
16:00:00 Andrii Zrobok Application Database Development MS SQLServer 2019 Intelligent Query Processing
16:00:00 Joanna Wolthuis Application Database Development Be a dynamic SQL dynamo!
16:00:00 Taras Kloba Enterprise Database Administration Deployment What is CI/CD for databases or how to automate DB changes

SessionID: 90824

Move your database to the Cloud: Understand, Design, Migrate, Man

Back to calendar

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

Speaker: Jose Manuel Jurado Diaz

Title: Move your database to the Cloud: Understand, Design, Migrate, Man

Abstract:

This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to:

• Understand how Azure SQL Database works • Know the newest and most important features to manage your Azure SQL Database • Design scalable architectures • Design Disaster Recovery plans • Manage security on your Azure SQL Database • Monitor and troubleshoot Azure SQL Database • Face a migration project

SessionID: 93429

The SQL Server DBA’s Guide to Docker Containers

Back to calendar

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

Speaker: Edwin M Sarmiento

Title: The SQL Server DBA’s Guide to Docker Containers

Abstract:

Your role as a SQL Server DBA is evolving and you are now responsible for automating deployment, scaling and management of containerized applications – not just SQL Server databases. You don’t have a clue where and how to start. You are confused about this whole DevOps buzzword being thrown around and you are wasting a lot of time figuring things out on your own. What’s worse, you end up being a stressed, overworked engineer who wished you could focus on the “cool stuff”, but are instead stuck in firefighting mode while juggling the additional workload.

This session is specifically for you. This whole-day workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling and management of containerized applications.

Learning Objectives:

  1. Introduce SQL Server DBAs to the world of Docker Containers
  2. Leverage Docker Containers for deploying SQL Server
  3. Introduce SQL Server DBAs to Container Or

SessionID: 89557

Hacking SQL Server Is Not Enough

Back to calendar

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

Speaker: André Melancia

Title: Hacking SQL Server Is Not Enough

Abstract:

You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks?

This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.

SessionID: 91594

Power BI Premium vs Power BI Embedded for Modern BI Solutions

Back to calendar

Event Date: 18-05-2019 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mihail Mateev

Title: Power BI Premium vs Power BI Embedded for Modern BI Solutions

Abstract:

Power BI Premium introduces a new developer layer for embedding Power BI in custom applications, and a new on-premises deployment option as well. Microsoft Power BI Embedded applications enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. It helps Independent Software Vendors to use Power BI data experiences within their applications.

This talk is abou the best practices designing and implementing in business solutions Power BI Embeded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.

SessionID: 91691

Introduction to Polybase

Back to calendar

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

Speaker: Paul Wehland

Title: Introduction to Polybase

Abstract:

Polybase started as a technology which allows you to query data stored in Hadoop or Azure Blob Storage as if it were just another table within SQL Server. In SQL 'Aris' (2019), Polybase will grow further and add additional connectivity and querying potential.

Come to this Beginner talk to learn how you can get started using Polybase in SQL Server right away, and learn about the 3 core EXTERNAL objects used in Polybase. We will compare and contrast the differences and similarities between Polybase and Linked Servers.

SessionID: 93435

SQL Server 2019 Kubernetes: Cloud Native Development for Enterp

Back to calendar

Event Date: 18-05-2019 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Vitalii Bondarenko

Title: SQL Server 2019 Kubernetes: Cloud Native Development for Enterp

Abstract:

We will start from understanding what is Cloud Native development and why it is actual for Enterprise Digital Transformation Strategy. Will cover different aspects of using Relational Databases on Kubernetes platform and deployments to Public Clouds. Then dive into details of using SQL Server as a containerized application orchestrated by Kubernetes and discuss proc and cons for such solutions. The session contains results of researches, live demos and experience gained from numbers of projects.

SessionID: 93914

Tuning SQL Server for mere mortals (українською)

Back to calendar

Event Date: 18-05-2019 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Mykola Pobyivovk

Title: Tuning SQL Server for mere mortals (українською)

Abstract:

Are you new begining database developer ? Are you .Net developer and often work with database?

I think this session special for you! In this session I would like to show common mistakes, connected with DB development which I saw in my projects and tell audience how we could avoid it . How we can improve performance of SQL Server.

SessionID: 89215

Blockchain as service - Azure Blockchain Workbench

Back to calendar

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

Speaker: Senthamil V

Title: Blockchain as service - Azure Blockchain Workbench

Abstract:

What is Blockchain as Service? This session is more about Blockchain basics and the technical details of the Azure Workbench. With Blockchain Workbench, you can define blockchain applications using configuration and writing smart contract code. You can jumpstart blockchain application development and focus on defining your contract and writing business logic instead of building scaffolding and setting up supporting services.

SessionID: 90473

Working in Batches

Back to calendar

Event Date: 18-05-2019 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Erland Sommarskog

Title: Working in Batches

Abstract:

Early in your career you learnt that loops are bad and that you should use set-based statements. However, there are situations when trying to processing all at once takes you into problems. In this session we will learn what these situations are and how we can address them by splitting up the work in batches. We will learn techniques for batching and pitfalls to watch out for so that we don't introduce new performance issues.

We will also look at batching from a different angle: problems that requires a loop for, say, a single customer, but where we can process all customers abreast for better performance.

SessionID: 90755

SQL Server PowerShell. How to become a true senior DBA (на русском)

Back to calendar

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

Speaker: Andriy Pogorelov

Title: SQL Server PowerShell. How to become a true senior DBA (на русском)

Abstract:

В этом докладе я расскажу об автоматизации административных задач с помощью PowerShell. Затрону некоторые community решения и их имплементацию.

SessionID: 90823

Attention Contention!!!

Back to calendar

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

Speaker: Jose Manuel Jurado Diaz

Title: Attention Contention!!!

Abstract:

In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.

SessionID: 91921

Building BI solution with AWS vs Google Cloud

Back to calendar

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

Speaker: Maryna Popova

Title: Building BI solution with AWS vs Google Cloud

Abstract:

Building a BI solution for a travel platform using AWS ... Or Google Cloud ... Or both .. Or custom services?

Will share the experience of using different infrastructures and the overview of the tools for both

SessionID: 93642

The future of serverless computing

Back to calendar

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

Speaker: Anton Boyko

Title: The future of serverless computing

Abstract:

Are you still planning your servers capacity in CPU and RAM? Do you enjoy answering questions like “what amount of servers we need to buy to serve 10K and 10M users”? Do you enjoy paying for those servers while they are sitting idle?

In my session I will talk about the current state and the future of serverless computing. I will show several demos that show how to start using serverless computing, what are the application scenarios for it, how it can scale, what it will cost, etc.

This session will be useful for developers and architects who are seeking a way to create an app utilizing all your previous skills, but make it scalable, reliable, fast and cost efficient.

SessionID: 93785

Oracle APEX

Back to calendar

Event Date: 18-05-2019 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Oleksii Vykhristiyk

Title: Oracle APEX

Abstract:

This presentation provides a general overview of Oracle APEX.

What is Oracle APEX? Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Are you an existing Oracle Database customer? Then you have everything you need to start building useful, scalable apps now using Oracle APEX. If you know even a little bit of SQL, you can become wonderfully productive and start producing apps that you would have thought required a full-stack developer.

SessionID: 89370

How to win Kaggle competition and get familiar with machine learning ?

Back to calendar

Event Date: 18-05-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Marcin Szeliga

Title: How to win Kaggle competition and get familiar with machine learning ?

Abstract:

Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there?

During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services. Minimum slides and maximum fun guaranteed.

SessionID: 89702

DevOPS for DBAs - Where is your magic wand?

Back to calendar

Event Date: 18-05-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Satya Jayanty

Title: DevOPS for DBAs - Where is your magic wand?

Abstract:

DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.

Take away best practices associated in DEVOPS and DBA world.

SessionID: 91790

Anomaly Detection in Predictive Maintenance for Sql Server

Back to calendar

Event Date: 18-05-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janusz Rokicki

Title: Anomaly Detection in Predictive Maintenance for Sql Server

Abstract:

SessionID: 91907

Securing, maintaining and troubleshooting your Azure SQL in production.

Back to calendar

Event Date: 18-05-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Stanislav Lebedenko

Title: Securing, maintaining and troubleshooting your Azure SQL in production.

Abstract:

Azure SQL usage seems to be easy and straightforward, but there are set of steps to make it truly reliable and properly secured. This talk is about following three important topics.

Are you ready for disaster, are your team take a proper drill? I`m sure you do, but in case you need a few tips and check list - you will obtain it. Usually, proper monitoring(including network impact), profiling and alerts are introduced after the first production issue, so this will be first point.

Security seems to be hot topic these days and there are few steps to secure your Elastic cluster proper way, plain Azure SQL Server firewall might be not enough. Security measures overview with best practices, vNet, user roles isolation, encryption at rest, secret maintenance with KeyVault, Security center and other tips.

Infrastructure as code is essential part of Azure and proper set of the environment crud scripts can really save your day at some point in future, also you can do useful stuff with T-SQL in

SessionID: 93660

Power BI. Evaluation context in DAX.

Back to calendar

Event Date: 18-05-2019 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Artur Konstantynov

Title: Power BI. Evaluation context in DAX.

Abstract:

В докладе Я попытаюсь раскрыть тему контекста в DAX, объяснить сложности и преимущества использования этого языка.

SessionID: 90319

Plan Caching

Back to calendar

Event Date: 18-05-2019 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Torsten Strauss

Title: Plan Caching

Abstract:

With a few exceptions, SQL Server stores the execution plan for a query in the internal plan cache. In most cases, subsequent execution of a similar query will greatly benefit from this mechanism, but not in all cases.

In this session, you will learn why and under what circumstances SQL Server caches execution plans. We will analyze the plan cache to identify performance issues, such as plan pollution, and how to avoid this. You'll see the benefits and drawbacks of parameter sniffing for procedures and functions, and the differences between native compiled and interpreted stored procedures. Furthermore, we will analyse how the settings ‘optimize for adhoc workloads’ and ‘forced parameterization’ influence query execution and the re-use of cached plans.

SessionID: 90968

The databases in SSDT - a work with project and best practices

Back to calendar

Event Date: 18-05-2019 - Session time: 14:40:00 - Track: Application Database Development

Speaker: Kamil Nowinski

Title: The databases in SSDT - a work with project and best practices

Abstract:

A task seems to be easy. Maintenance a project of a database in the code repository, treat as master-version and do deployment evenly and frequently. Simple? Seemingly. The things become more complex as fast as a number of objects in database growing. While instead of one database, we have over a dozen. When databases have got the references to each other. And how about dictionary tables? Where to keep them and how to script? Additional issues are coming whilst we would like to control instance-level objects.

All these topics I will explain in the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.

SessionID: 91404

Hadoop in AWS - You can already use it without knowing about it

Back to calendar

Event Date: 18-05-2019 - Session time: 14:40:00 - Track: Analytics and Visualization

Speaker: Sergey Dzyuban

Title: Hadoop in AWS - You can already use it without knowing about it

Abstract:

This is story about we tried to do some data analysis for S3 logs, and found that AWS Athena allows to do it easy and fast using SQL queries. But for data analysis we need to have more powerful visualization tools - and Amazon Elastic Map Reduce (Hadoop as a Service) in fact are closely integrated with S3, Athena and other AWS services.

Deployed in 2 clicks, Apache Zeppelin can query your data directly from S3 file storage and works with data using SQL or Spark (Scala) if You are brave enough. We used all this stuff only for one reason - delete unused packages from Artifactory, which grows up to 3 Tb and became a little bit expensive to host in Cloud. But the issue was - 'unused' definition was little bit unclear, and some deep analysis need to be made to make a proper decision. Golang application helps us to retrieve data from Artifactory, and Zeppelin and Spark SQL queries allowed to filter and visualize corresponding data.

SessionID: 91430

Hacking SQL Server

Back to calendar

Event Date: 18-05-2019 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Michal Sadowski

Title: Hacking SQL Server

Abstract:

You have been working with SQL Server for several years and you feel quite comfortable with most of the available features. Even you have a checklist for installation/configuration of SQL Server to be compliant with corporate standards. However, somewhere on the back of the head you have a feeling that there is something more that can be done to secure your SQL Server. If you are willing to see how small reconfiguration can lead to compromise of your SQL Server join this session. There will be demos on live system showing how to leverage misconfiguration and how to prevent them from happening in the future. After the session you will have a set of checks that can be implemented on your system.

SessionID: 91922

“SQL-like” or query languages in Azure IoT

Back to calendar

Event Date: 18-05-2019 - Session time: 14:40: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: 89220

Streaming Big Data in Azure with Kafka and Event Hubs

Back to calendar

Event Date: 18-05-2019 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Sergii Bielskyi

Title: Streaming Big Data in Azure with Kafka and Event Hubs

Abstract:

Before having Big data, you must collect the data. During this session, we will see how to stream the data using Kafka and Azure Event hub, how they work together, and when to use Kafka better or Event hub.

SessionID: 89237

MS SQLServer 2019 Intelligent Query Processing

Back to calendar

Event Date: 18-05-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Andrii Zrobok

Title: MS SQLServer 2019 Intelligent Query Processing

Abstract:

The Intelligent query processing feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort.

SessionID: 89256

Be a dynamic SQL dynamo!

Back to calendar

Event Date: 18-05-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Joanna Wolthuis

Title: Be a dynamic SQL dynamo!

Abstract:

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.

SessionID: 91292

What is CI/CD for databases or how to automate DB changes

Back to calendar

Event Date: 18-05-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Taras Kloba

Title: What is CI/CD for databases or how to automate DB changes

Abstract:

In the world of agile software development, the database development process introduces some challenges to the application development process. The delivery of changes at database level tends to be a different and separated process of the application delivery process or even an entirely manual process. This contributes to the perspective that the database is a bottleneck in the agile process.

In this session, I will show how to build a deployment pipeline capable of delivering database and application changes. The pipeline includes the following steps: source control, continuous integration and continuous delivery. I will share methods and strategies that allow bringing together databases and applications in the delivery process reducing the delivery pain. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that this pipeline will allow you not be afraid of making database changes.