SQLSaturday #577 - Dnipro 2016
Event Date: 11/26/2016 00:00:00
Event Location:
- Parle, ТЦ «Новый металлург», 3 этаж
- ул. Троицкая, 21 Г
- Dnipro, Dnipropetrovs’ka Oblast’, Ukraine
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Переход в облако: Microsoft Azure и базы данных (ru)
Abstract: В данной сессии будет рассказано о том, какие плюсы и минусы ожидают организацию в случае принятия решения о переносе СУБД из локального датацентра в облако от Microsoft. Мы поговорим о практике использования виртуальных машин (IaaS), сервисов (PaaS), а также о имеющихся альтернативах (гибридные решения). Основной темой будут реляционные базы данных, однако также будут затронуты и другие облачные технологии хранения и обработки данных как от компании Microsoft так и от её конкурентов. Аудитория: ИТ руководители, разработчики и администраторы, которые ещё не работали с Microsoft Azure и которые хотят понять какие выгоды можно получить от миграции баз данных в облако и какие подводные камни их ожидают. Доклад не будет интересен людям, которые уже активно работают с вышеперечисленными технологиями.
Speaker(s):
- Yevhen Nedashkivskyi
Track and Room: Enterprise Database Administration Deployment - Room A
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.
Speaker(s):
- André Melancia
Track and Room: Enterprise Database Administration Deployment - Room B
Title: Как убить SQL Server за 60 минут
Abstract: Простота и гибкость SQL Server существенно облегчают использование продукта в качестве сервера БД. Несмотря на то, что эта простота зачастую приводит к неэффективным решениям и коду, современные сервера способны скрыть проблемы с производительностью, что преуменьшает роль разработчиков и администраторов БД в производственном процессе.
В этом докладе Дмитрий продемонстрирует несколько простых методов дизайна БД и написания T-SQL кода, которые помогут Вам ухудшить производительность систем работающих с SQL Server и, в результате, сделают Вашу жизнь более интересной и улучшат job security.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Application Database Development - Room A
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.
Speaker(s):
- Vitalii Bondarenko
Track and Room: Advanced Analysis Techniques - Room A
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!
Speaker(s):
- Denis Reznik
Track and Room: Application Database Development - Room A
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.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - Room B
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.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - Room B
Title: Все, что вы хотели узнать об объектах БД, но всегда боялись спросить
Abstract: Представления, триггеры, ограничения, функции, CLR, XML – этот список можно продолжать бесконечно. В данном докладе, мы обсудим внутреннюю реализацию различных объектов БД, поговорим об их ограничениях, а также об оптимальных методах использования. Доклад ориентирован на аудиторию, предпочитающую код слайдам PowerPoint.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Application Database Development - Room A
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.
Speaker(s):
- Konstantin Proskurdin
Track and Room: Application Database Development - Room C
Title: @Table vs #Table: шаблони використання, спільні характеристики, міфи
Abstract: MS SQL Server надає дві можливості для зберігання тимчасових наборів даних: тимчасові табиці та табличні змінні. Вважається, що табличні треба використовувати для маленьких об’ємів даних (бо вони живуть в оперативній пам’яті), а тимчасові таблиці - для великих. Подивимося, чи дійсно це так; чи можна за такими характеристиками порівнювати ці об’єкти.
Speaker(s):
- Andrii Zrobok
Track and Room: Application Database Development - Room C
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.
Speaker(s):
- Taras Bobrovytskyi
Track and Room: Application Database Development - Room B
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:
- performance counters
- output sorting
- page splits
- Virtual log files
- Bulk logging
- Tab lock
- Indexes
- Trace flag 610 Constraints not for replication Dirty data and SQL Server limitations Replication optimization
Speaker(s):
- Oleg Alekseev
Track and Room: Enterprise Database Administration Deployment - Room C
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.
Speaker(s):
- Eugene Polonichko
Track and Room: BI Platform Architecture, Development Administration - Room C
Title: Azure Search - full-text search in a cloud
Abstract: During this session we will talk about Azure Search - full-text search engine provided to us via SaaS model. The main advantage of this service is not only that is fully managed by Microsoft, scalable, reliable and all other cloud related stuff. It is more about numerous data sources you can use to populate your search indexes. Also, because you use HTTP to work with Azure Search, you can easily use it not only within your desktop or web applications, but also you can easily consume it in your mobile applications, IoT solutions, etc.
Speaker(s):
- Anton Boyko
Track and Room: Cloud Application Development Deployment - Room A
Title: Статистика ожиданий или как найти место “где болит”
Abstract: Каждый раз, когда возникали проблемы с производительностью сервера, куда вы решали в первую очередь смотреть? В профайлер? Perfmon? В рамках доклада мы поговорим про sys.dm_os_wait_stats содержащее статистику ожиданий SQL Server. С помощью информации из этого DMV можно быстро определить потенциальные узкие места в производительности нашей системы.
Speaker(s):
- Sergey Syrovatchenko
Track and Room: Professional Development - Room B
Title: Data-tier Application (DAC) overview
Abstract:
- Unversioned database development problem description
- DAC solution
- DAC overview
- Real experience
- QA
Speaker(s):
- Rostislav Nikitin
Track and Room: Application Database Development - Room C
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.
Speaker(s):
- Andriy Pogorelov
Track and Room: Information Delivery - Room C
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.
Speaker(s):
- Viktoriia Mala
Track and Room: Application Database Development - Room B
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Andriy Pogorelov
LinkedIn: Andriy Pogorelov
I have been dealing with database administration and development for more than 16 years. Started from SQL Server 2000
- Active member of Data Platform community
- Organizer of SQLSaturday Kharkiv
- Speaker at various Data Platform related events
- I possess Microsoft certificates: MCDBA, MCITP, MCSA.
Rostislav Nikitin
LinkedIn: Rostislav Nikitin
Full stack developer from the 2002 year.
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Denis Reznik
Twitter: - https://twitter.com/DenisReznik
LinkedIn: Denis Reznik
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
Vitalii Bondarenko
I’ve been designing data-centric systems for last 20 years and have gained huge experience in developing BI, AI and Big Data solutions. For the last 5 years I’ve mostly been focused on enterprise platform designing and implementing different innovative approaches for Fast Data Processing. At the moment I’m responsible for building Processional Services in Cloud Solutions for Enterprise Customers.
Konstantin Proskurdin
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
Anton Boyko
Twitter: - https://twitter.com/BoykoAnt
LinkedIn: Anton Boyko
Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.
Sergey Syrovatchenko
DBA
Yevhen Nedashkivskyi
LinkedIn: Yevhen Nedashkivskyi
Yevhen Nedashkivskyi is a professional DBA and a database developer with more than 10 years of experience. MSCP, MSCA, MSCE, MVP.
Andrii Zrobok
LinkedIn: Andrii Zrobok
25+ years of experience in database development: development data-centric applications from scratch, support of legacy databases/applications, data migration tasks, performance tuning, consulting, database trainer. I have experience with wide range of databases such as FoxPro for DOS (Fox Software), MS SQL Server (started from version 6.5) , Oracle, Sybase ASE, MySQL, PostgreSQL. Co-Leader of PASS Local Chapter in Lviv. Speaker at PASS SQLSaturday conferences (since 2013); PASS Lviv/Vinnitsa/Virtual SQL Server User Group, EPAM IT Week (2015-2017), AIBig Data Day 2019.
Viktoriia Mala
MongoDB and SQL Server.
Dmitri Korotkevitch
Twitter: - aboutsqlserver
LinkedIn: Dmitri Korotkevitch
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.
Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Eugene Polonichko
Twitter: - https://twitter.com/EvgenPolonichko
LinkedIn: Eugene Polonichko
Contact: https://msolapblog.wordpress.com/
Leader of PASS Local Chapter in Donetsk (Ukraine). I work as DWH/BI architect. Responsible for designing and developing Data Warehouse and BI solutions with using Microsoft BI Stack products.
Oleg Alekseev
12 years of experience with MS SQL Server. Used to work for Banks, International IT-companies, Microsoft. The main specializations - SQL core, DBA.
Taras Bobrovytskyi
LinkedIn: Taras Bobrovytskyi
Started working with SQL Server in 2007 as consultant, eventually becoming a MIcrosoft Certified Trainer. Participated in consulting projects in Ukraine, Belarus, Georgia, Kazakhstan Since 2012 working as a database developer/data architect at DieboldNixdorf SSI team
Dmitri Korotkevitch
Twitter: - aboutsqlserver
LinkedIn: Dmitri Korotkevitch
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.
Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Sponsors
The following is a list of sponsors that helped fund the event: