sqlsathistory

Nr: 406

Back to Main list

SQLSaturday #406 - Kharkiv 2015

Start Time (24h) Speaker Track Title
00:00:00 Denis Reznik Database development Hidden gems of SQL Server 2014
10:30:00 Eugene Polonichko BIPrograming Tabular SSAS - очень быстрая аналитика
10:30:00 Vitalii Bondarenko BIPrograming HDInsight: Big Data solutions on Microsoft Azure
10:30:00 Andrey Langovoy Database development Case study on real test data generation for web application
10:30:00 Olena Smoliak Database development T-SQL Cookbook: TipsTricks
11:45:00 Denis Reznik Database development SQL vs. NoSQL. It's always a hard choice.
11:45:00 Yan Roginevich BIPrograming Introduction to Datazen: it's all about Zen
11:45:00 Mihail Mateev BIPrograming Think Connected – Modern IoT Solutions with Microsoft Azure
11:45:00 Sergiy Lunyakin BIPrograming Создание аналитических приложений с использованием PowerQuery
13:00:00 Oleg Alekseev Database administration SQL 2014. InMemory OLTP
13:00:00 Andrii Zrobok Database development “Magic numbers”, local variable and performance
13:00:00 Valentyn Yeliseyev BIPrograming SQL Server 2016 and new possibilities to unlock insights of any data
13:00:00 Vitaliy Popovych Database development Key-Range Locking — Все тайное становится явным
14:30:00 Kevin Boles Database development Unit Testing SQL Server
14:30:00 Taras Bobrovytskyi Database development Introduction to columnstore
14:30:00 Mariya Shirokopetleva Database development Database Normalization - back to basics
14:30:00 Yevhen Nedashkivskyi Database administration SQL Server Security Best Practices
15:45:00 Kevin Boles Database development Common TSQL Mistakes
15:45:00 Vitalii Bondarenko BIPrograming Dive into HDInsight: common Big Data analysis scenarios on Microsoft Azure
15:45:00 Konstantin Proskurdin Database development Database version control
15:45:00 Alesya Zhuk Database development Использование динамического sql в MS SQL Server

SessionID: 13107

Hidden gems of SQL Server 2014

Back to calendar

Event Date: 19-09-2015 - Session time: 00:00:00 - Track: Database development

Speaker: Denis Reznik

Title: Hidden gems of SQL Server 2014

Abstract:

SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.

SessionID: 37761

Tabular SSAS - очень быстрая аналитика

Back to calendar

Event Date: 19-09-2015 - Session time: 10:30:00 - Track: BIPrograming

Speaker: Eugene Polonichko

Title: Tabular SSAS - очень быстрая аналитика

Abstract:

На докладе посмотрим на Tabular модель. Как строить решение на основе данной модели, зачем она вообще нужна, как настраивать ее, как оптимизировать. Что такое DAX и как на нем писать запросы.

SessionID: 38614

HDInsight: Big Data solutions on Microsoft Azure

Back to calendar

Event Date: 19-09-2015 - Session time: 10:30:00 - Track: BIPrograming

Speaker: Vitalii Bondarenko

Title: HDInsight: Big Data solutions on Microsoft Azure

Abstract:

Microsoft Azure HDInsight is a big data solution based on the open-source Apache Hadoop framework, and is an integral part of the Microsoft Business Intelligence (BI) and Analytics product range. We will explore the use of HDInsight in a range of use cases and scenarios such as a data warehouse, for ETL processes, and integration into existing BI systems. We will review the concepts of big data, planning and designing big data solutions, and implementing these solutions.

SessionID: 39093

Case study on real test data generation for web application

Back to calendar

Event Date: 19-09-2015 - Session time: 10:30:00 - Track: Database development

Speaker: Andrey Langovoy

Title: Case study on real test data generation for web application

Abstract:

While developing a web application, you need to make sure you are testing it under conditions that closely simulate production environment. Without meaningful test data in test environment, it is quite impossible to predict the way the application will behave after the release. During this session, we will talk about how to generate real test data to be used in the test environment.

SessionID: 40511

T-SQL Cookbook: TipsTricks

Back to calendar

Event Date: 19-09-2015 - Session time: 10:30:00 - Track: Database development

Speaker: Olena Smoliak

Title: T-SQL Cookbook: TipsTricks

Abstract:

In this session you will learn about unusual uses of the coalesce() function, different methods to pivot table, how to store hierarchies and many-many other interesting things that can be done with T-SQL!

SessionID: 13106

SQL vs. NoSQL. It's always a hard choice.

Back to calendar

Event Date: 19-09-2015 - Session time: 11:45:00 - Track: Database development

Speaker: Denis Reznik

Title: SQL vs. NoSQL. It's always a hard choice.

Abstract:

This will be an interesting and sometimes fun session with a small demo. This session will answer some of your questions and force you to think about new questions. It will not be very technical, so it's ok for choose another more technical session from the schedule :) But if will decide to come, I can assure you, that you will not be disspointed.

SessionID: 39123

Introduction to Datazen: it's all about Zen

Back to calendar

Event Date: 19-09-2015 - Session time: 11:45:00 - Track: BIPrograming

Speaker: Yan Roginevich

Title: Introduction to Datazen: it's all about Zen

Abstract:

Launched about three years ago and acquired by Microsoft this spring Datazen is a business intelligence and data visualization service, available on Windows, Windows Phone, iOS, Android and the web.

During the session we will go through the product basics and of course do some demos.

SessionID: 39755

Think Connected – Modern IoT Solutions with Microsoft Azure

Back to calendar

Event Date: 19-09-2015 - Session time: 11:45:00 - Track: BIPrograming

Speaker: Mihail Mateev

Title: Think Connected – Modern IoT Solutions with Microsoft Azure

Abstract:

The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the best set of services, required for the Internet of Things solutions, including a wide set of storages, websites, cloud services, Azure Service Bus / Event Hubs, Mobile Services, AD authentication and many data platform and BI related products like Azure SQL Database, DocumentDB, Azure Storage, Azure Stream Analytics, Machine Learning, Power BI and more..

This talk is about the main business cases and main architectural challenges, related to the actual and new IoT systems and particularly predictive services, based on Microsoft Azure.

SessionID: 39860

Создание аналитических приложений с использованием PowerQuery

Back to calendar

Event Date: 19-09-2015 - Session time: 11:45:00 - Track: BIPrograming

Speaker: Sergiy Lunyakin

Title: Создание аналитических приложений с использованием PowerQuery

Abstract:

PowerQuery - это пользовательский инструмент обработки, комбинирования и очистки данных для дальнейшего их анализа прямо из Excel, самого популярно инструмента для анализа данных. Хотя все его возможности и проявляются совместно с подпиской PowerBI, но он вполне применим и для локального использования. Например для создания аналитических приложений в Excel ) Простой, удобный интерфейс и вся мощь встроенного языка M позволяет создавать вполне функциональные и полезные приложения, а главное Вам не понадобится ничего кроме Excel.

В докладе мы рассмотрим как использовать PowerQuery и Excel чтобы:

SessionID: 39155

SQL 2014. InMemory OLTP

Back to calendar

Event Date: 19-09-2015 - Session time: 13:00:00 - Track: Database administration

Speaker: Oleg Alekseev

Title: SQL 2014. InMemory OLTP

Abstract:

• Implementing InMemory OLTP

• In-Memory OLTP Performance • In-Memory OLTP Migration • In-Memory OLTP Interoperability

SessionID: 39474

“Magic numbers”, local variable and performance

Back to calendar

Event Date: 19-09-2015 - Session time: 13:00:00 - Track: Database development

Speaker: Andrii Zrobok

Title: “Magic numbers”, local variable and performance

Abstract:

About dependency between query syntax (adhoc query, query with local variables, stored procedures, local variable ) and query execution plan; deep dive into OPTION (RECOMPILE)

SessionID: 40542

SQL Server 2016 and new possibilities to unlock insights of any data

Back to calendar

Event Date: 19-09-2015 - Session time: 13:00:00 - Track: BIPrograming

Speaker: Valentyn Yeliseyev

Title: SQL Server 2016 and new possibilities to unlock insights of any data

Abstract:

What's new in SQL Server 2016 and what new directions in data analysis and data processing are now at the top of Microsoft's strategy.

SessionID: 40547

Key-Range Locking — Все тайное становится явным

Back to calendar

Event Date: 19-09-2015 - Session time: 13:00:00 - Track: Database development

Speaker: Vitaliy Popovych

Title: Key-Range Locking — Все тайное становится явным

Abstract:

Доклад будет посвящен блокировкам диапазона ключей (Key-Range Locking). Вначале будет рассказано о базовых механизмах, после чего, мы поговорим о некоторых аспектах которые не описаны в MSDN. Дополнительно рассмотрим неявное использование блокировок диапазона ключей в уровне изоляции READ COMMITTED.

SessionID: 38526

Unit Testing SQL Server

Back to calendar

Event Date: 19-09-2015 - Session time: 14:30:00 - Track: Database development

Speaker: Kevin Boles

Title: Unit Testing SQL Server

Abstract:

In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

SessionID: 40512

Introduction to columnstore

Back to calendar

Event Date: 19-09-2015 - Session time: 14:30:00 - Track: Database development

Speaker: Taras Bobrovytskyi

Title: Introduction to columnstore

Abstract:

Get deeply familiar with columnstore indexes.

This session includes the columnstore technology overview with a deeper look inside the physical structure of columnstore indexes and will cover the practical aspects of utilizing columnstore indexes in different versions of SQL Server. Additionaly includes the features that are expected in upcoming version of SQL Server: introduction to operational analytics - overview of new data indexing approach introduced in SQLServer 2016; columnstore for memory-optimized data - some notes on how the the columnstore behaves in-memory; columnstore enchancements for data warehousing At the end it covers the introduction to Vertipaq encoding

SessionID: 40535

Database Normalization - back to basics

Back to calendar

Event Date: 19-09-2015 - Session time: 14:30:00 - Track: Database development

Speaker: Mariya Shirokopetleva

Title: Database Normalization - back to basics

Abstract:

During the session we will talk about how to avoid modification anomalies and improve the performance of your DBMS.

SessionID: 40573

SQL Server Security Best Practices

Back to calendar

Event Date: 19-09-2015 - Session time: 14:30:00 - Track: Database administration

Speaker: Yevhen Nedashkivskyi

Title: SQL Server Security Best Practices

Abstract:

Зачастую даже при жёстких требованиях заказчика многими интеграторами и разработчиками вопрос безопасности баз данных игнорируется в угоду упрощения разработки и развёртывания. Бывают и обратные ситуации, когда в довольно глубоко продуманной и защищённой системе начинают появляться пробелы в безопасности вследствие расширения инфраструктуры и дальнейшей эволюции продукта.

Во время данной сессии мы ознакомимся и обсудим основные практики по обеспечению безопасности SQL Server, попытаемся разобраться, чем действительно можно пожертвовать, а от чего отказываться не стоит ни в коме случае.

Доклад будет интересен разработчикам, администраторам, специалистам по безопасности, а также руководителям, которых волнует вопрос сохранности данных и безопасности доступа к ним.

SessionID: 38524

Common TSQL Mistakes

Back to calendar

Event Date: 19-09-2015 - Session time: 15:45:00 - Track: Database development

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!

SessionID: 38615

Dive into HDInsight: common Big Data analysis scenarios on Microsoft Azure

Back to calendar

Event Date: 19-09-2015 - Session time: 15:45:00 - Track: BIPrograming

Speaker: Vitalii Bondarenko

Title: Dive into HDInsight: common Big Data analysis scenarios on Microsoft Azure

Abstract:

Microsoft Azure HDInsight is a big data solution based on the open-source Apache Hadoop framework, and is an integral part of the Microsoft Business Intelligence (BI) and Analytics product range. We will review the various methods of programming with HDInsight, including how to use the HDInsight cmdlets in Windows PowerShell to work with the HDInsight cluster, how to use the HDInsight Software Development Kit (SDK) to develop applications, how to use Hive, Pig, Excel Power Query, Sqoop to work with data. We will explore common Big Data analysis scenarios and their implementations with Azure HDInsight.

SessionID: 39587

Database version control

Back to calendar

Event Date: 19-09-2015 - Session time: 15:45:00 - Track: Database development

Speaker: Konstantin Proskurdin

Title: Database version control

Abstract:

The session will describe the typical schemes of the developers work with database and methods how to maintain the database up to date with the history of changes. There will be a demonstration of some methods.

SessionID: 40167

Использование динамического sql в MS SQL Server

Back to calendar

Event Date: 19-09-2015 - Session time: 15:45:00 - Track: Database development

Speaker: Alesya Zhuk

Title: Использование динамического sql в MS SQL Server

Abstract:

В докладе я расскажу что такое динамический sql, какие способы его построения, рассмотрены примеры использования "exec" и "sp_executesql".

This site is open source. Improve this page.