sqlsathistory

Nr: 577

Back to Main list

SQLSaturday #577 - Dnipro 2016

Start Time (24h) Speaker Track Title
10:00:00 Denis Reznik Application Database Development Hidden gems of SQL Server 2016
10:00:00 Sergey Syrovatchenko Professional Development Статистика ожиданий или как найти место "где болит"
10:00:00 Oleg Alekseev Enterprise Database Administration Deployment How to bring a new life for Oracle 9I in MS SQL Server environment.
11:10:00 Eugene Polonichko BI Platform Architecture, Development Administration Power BI Embedded. Why do you need embed bi into your application?
11:10:00 Sergiy Lunyakin BI Platform Architecture, Development Administration Azure SQL Data Warehouse: What, Where, How
11:10:00 Dmitri Korotkevitch Application Database Development Все, что вы хотели узнать об объектах БД, но всегда боялись спросить
12:20:00 Konstantin Proskurdin Application Database Development PostgreSQL as a Document Storage for .NET applications
12:20:00 Vitalii Bondarenko Advanced Analysis Techniques HDInsight: Spark. Advanced in-memory BigData Analytics with Microsoft Azure
12:20:00 André Melancia Enterprise Database Administration Deployment NSA Secrets - Hacking SQL Server
14:30:00 Taras Bobrovytskyi Application Database Development Inside Transaction Logging
14:30:00 Andrii Zrobok Application Database Development @Table vs #Table: шаблони використання, спільні характеристики, міфи
14:30:00 Dmitri Korotkevitch Application Database Development Как убить SQL Server за 60 минут
15:35:00 Anton Boyko Cloud Application Development Deployment Azure Search - full-text search in a cloud
15:35:00 Andriy Pogorelov Information Delivery SQL Server: Delivery and synchronizing of the data
15:35:00 Sergiy Lunyakin BI Platform Architecture, Development Administration Cloud BI with Azure Analysis Services
16:45:00 Rostislav Nikitin Application Database Development Data-tier Application (DAC) overview
16:45:00 Yevhen Nedashkivskyi Enterprise Database Administration Deployment Переход в облако: Microsoft Azure и базы данных (ru)
16:45:00 Viktoriia Mala Application Database Development Always Encrypted at rest and in motion

SessionID: 53796

Hidden gems of SQL Server 2016

Back to calendar

Event Date: 26-11-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Denis Reznik

Title: Hidden gems of SQL Server 2016

Abstract:

SQL Server 2016 is full of new features and improvements. Some of them are "Killer" features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight.

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

Статистика ожиданий или как найти место "где болит"

Back to calendar

Event Date: 26-11-2016 - Session time: 10:00:00 - Track: Professional Development

Speaker: Sergey Syrovatchenko

Title: Статистика ожиданий или как найти место "где болит"

Abstract:

Каждый раз, когда возникали проблемы с производительностью сервера, куда вы решали в первую очередь смотреть? В профайлер? Perfmon? В рамках доклада мы поговорим про sys.dm_os_wait_stats содержащее статистику ожиданий SQL Server. С помощью информации из этого DMV можно быстро определить потенциальные узкие места в производительности нашей системы.

SessionID: 54632

How to bring a new life for Oracle 9I in MS SQL Server environment.

Back to calendar

Event Date: 26-11-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Oleg Alekseev

Title: How to bring a new life for Oracle 9I in MS SQL Server environment.

Abstract:

Non-optimized and obsolete Oracle 9I environment

Oracle Publishing very rear MS SQL Replication technology Main issues and limitations Performance measurements:

SessionID: 53790

Power BI Embedded. Why do you need embed bi into your application?

Back to calendar

Event Date: 26-11-2016 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Eugene Polonichko

Title: Power BI Embedded. Why do you need embed bi into your application?

Abstract:

What do you know about PowerBI SDK? Do you want to embed bi into your application? Do you want to know about it? Let's come to my session and I'll talk about Power BI Embedded. Power BI Embedded.

Power BI Embedded is an Azure service that enables ISVs and app developers to surface Power BI data experiences within their applications. As a developer, you've built applications, and those applications have their own users and distinct set of features. Those apps may also happen to have some built-in data elements like charts and reports that can now be powered by Microsoft Power BI Embedded.

SessionID: 54376

Azure SQL Data Warehouse: What, Where, How

Back to calendar

Event Date: 26-11-2016 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sergiy Lunyakin

Title: Azure SQL Data Warehouse: What, Where, How

Abstract:

Have you heard about Azure SQL DWH? Do you want to move your current DWH into the Cloud? Can I use Azure SQL DWH like my regular DWH on-premise?

In this session I'm going to answer on these questions. Also, I will prodive information where is better to use Azure SQL DWH and what is more important, how to use it.

SessionID: 56251

Все, что вы хотели узнать об объектах БД, но всегда боялись спросить

Back to calendar

Event Date: 26-11-2016 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Dmitri Korotkevitch

Title: Все, что вы хотели узнать об объектах БД, но всегда боялись спросить

Abstract:

Представления, триггеры, ограничения, функции, CLR, XML – этот список можно продолжать бесконечно. В данном докладе, мы обсудим внутреннюю реализацию различных объектов БД, поговорим об их ограничениях, а также об оптимальных методах использования. Доклад ориентирован на аудиторию, предпочитающую код слайдам PowerPoint.

SessionID: 53893

PostgreSQL as a Document Storage for .NET applications

Back to calendar

Event Date: 26-11-2016 - Session time: 12:20:00 - Track: Application Database Development

Speaker: Konstantin Proskurdin

Title: PostgreSQL as a Document Storage for .NET applications

Abstract:

In a relational database system we must define a schema before adding data to a database but sometimes we need to store and (that is more important) query semi-structured data. And of course it would be great if we could use the same interface to access both structured and semi-structured data. The session will describe how to solve it via building IQueryable document storage for .NET applications using PostgreSQL and jsonb.

SessionID: 54103

HDInsight: Spark. Advanced in-memory BigData Analytics with Microsoft Azure

Back to calendar

Event Date: 26-11-2016 - Session time: 12:20:00 - Track: Advanced Analysis Techniques

Speaker: Vitalii Bondarenko

Title: HDInsight: Spark. Advanced in-memory BigData Analytics with Microsoft Azure

Abstract:

Apache Spark is an open-source parallel processing framework that supports in-memory processing to boost the performance of big-data analytic applications. We will cover approaches of processing Big Data on Spark cluster for real-time analytic, machine learning and iterative BI and also discuss the pros and cons of using Spark in Azure cloud.

SessionID: 55069

NSA Secrets - Hacking SQL Server

Back to calendar

Event Date: 26-11-2016 - Session time: 12:20:00 - Track: Enterprise Database Administration Deployment

Speaker: André Melancia

Title: NSA Secrets - Hacking SQL Server

Abstract:

How easy is it to hack a SQL Server?

In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.

SessionID: 53775

Inside Transaction Logging

Back to calendar

Event Date: 26-11-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Taras Bobrovytskyi

Title: Inside Transaction Logging

Abstract:

This session covers the main principles and internals of transaction logging mechanism and focuses on different factors, which influence the process of transaction logging. It also contains several general recommendations for Developers, Application Support engineers and DBA's on dealing with different transaction log issues and, possibly, avoiding them.

SessionID: 53825

@Table vs #Table: шаблони використання, спільні характеристики, міфи

Back to calendar

Event Date: 26-11-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Andrii Zrobok

Title: @Table vs #Table: шаблони використання, спільні характеристики, міфи

Abstract:

MS SQL Server надає дві можливості для зберігання тимчасових наборів даних: тимчасові табиці та табличні змінні. Вважається, що табличні треба використовувати для маленьких об'ємів даних (бо вони живуть в оперативній пам'яті), а тимчасові таблиці - для великих. Подивимося, чи дійсно це так; чи можна за такими характеристиками порівнювати ці об'єкти.

SessionID: 56244

Как убить SQL Server за 60 минут

Back to calendar

Event Date: 26-11-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Dmitri Korotkevitch

Title: Как убить SQL Server за 60 минут

Abstract:

Простота и гибкость SQL Server существенно облегчают использование продукта в качестве сервера БД. Несмотря на то, что эта простота зачастую приводит к неэффективным решениям и коду, современные сервера способны скрыть проблемы с производительностью, что преуменьшает роль разработчиков и администраторов БД в производственном процессе.

В этом докладе Дмитрий продемонстрирует несколько простых методов дизайна БД и написания T-SQL кода, которые помогут Вам ухудшить производительность систем работающих с SQL Server и, в результате, сделают Вашу жизнь более интересной и улучшат job security.

SessionID: 53999

Azure Search - full-text search in a cloud

Back to calendar

Event Date: 26-11-2016 - Session time: 15:35:00 - Track: Cloud Application Development Deployment

Speaker: Anton Boyko

Title: Azure Search - full-text search in a cloud

Abstract:

SessionID: 54940

SQL Server: Delivery and synchronizing of the data

Back to calendar

Event Date: 26-11-2016 - Session time: 15:35:00 - Track: Information Delivery

Speaker: Andriy Pogorelov

Title: SQL Server: Delivery and synchronizing of the data

Abstract:

In this session we are going to discuss different methods of the data delivery.

Why do we need them? In which cases should we use them?
We will concern following technologies and definitions (cloud of tags): HA/DR, AlwayOn HAG, Replication, CDC, Log Shipping, Mirroring, Heterogeneous synchronization partners and, probably, something else :-) In the demonstration we'll consider the one interesting example of using the Replication.

SessionID: 56577

Cloud BI with Azure Analysis Services

Back to calendar

Event Date: 26-11-2016 - Session time: 15:35:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sergiy Lunyakin

Title: Cloud BI with Azure Analysis Services

Abstract:

Azure Analysis Services (Azure AS) was released in Public Preview and it gives us possibilities to create full-managed Cloud BI solution without using on-premise servers or VMs, installing and configuring any software. Now, we have full set of PAAS and SAAS services like Azure SQL DWH, Azure AS and Power BI for creating our BI solutions. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.

SessionID: 53844

Data-tier Application (DAC) overview

Back to calendar

Event Date: 26-11-2016 - Session time: 16:45:00 - Track: Application Database Development

Speaker: Rostislav Nikitin

Title: Data-tier Application (DAC) overview

Abstract:

1. Unversioned database development problem description

  1. DAC solution
  2. DAC overview
  3. Real experience
  4. QA

SessionID: 55123

Переход в облако: Microsoft Azure и базы данных (ru)

Back to calendar

Event Date: 26-11-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Yevhen Nedashkivskyi

Title: Переход в облако: Microsoft Azure и базы данных (ru)

Abstract:

В данной сессии будет рассказано о том, какие плюсы и минусы ожидают организацию в случае принятия решения о переносе СУБД из локального датацентра в облако от Microsoft. Мы поговорим о практике использования виртуальных машин (IaaS), сервисов (PaaS), а также о имеющихся альтернативах (гибридные решения). Основной темой будут реляционные базы данных, однако также будут затронуты и другие облачные технологии хранения и обработки данных как от компании Microsoft так и от её конкурентов.

Аудитория: ИТ руководители, разработчики и администраторы, которые ещё не работали с Microsoft Azure и которые хотят понять какие выгоды можно получить от миграции баз данных в облако и какие подводные камни их ожидают. Доклад не будет интересен людям, которые уже активно работают с вышеперечисленными технологиями.

SessionID: 56593

Always Encrypted at rest and in motion

Back to calendar

Event Date: 26-11-2016 - Session time: 16:45:00 - Track: Application Database Development

Speaker: Viktoriia Mala

Title: Always Encrypted at rest and in motion

Abstract:

Does your application work with the sensitive data?

Always Encrypted is one of the newest SQL Server 2016 features, that provides a new way to encrypt columns. Data is protected at rest and in motion. You can encrypt your sensitive data on the client, send across the network and store encrypted data in the database. The database administrator can't read your data without special key. Always Encrypted provides a separation between those who own the data and those who manage the data.