Event Location:
RUS Hotel
4 Hospitalna Str
Kiev, , Ukraine
Abstract:
Microsoft released SQL Azure more than two years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services (and not only). In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker(s): Tobias Koprowski,
Abstract:
This talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and in March 2014 EF 6.1. This is the first new major version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures Functions in Code First, Connect and also... how to use in Microsoft Azure
Speaker(s): Mihail Mateev,
Abstract:
How often do you wonder why SQL Server executes the query in such a way? Why is selecting few records from the table takes a long time? Why SQL Server eats lot of memory? etc. I invite you to join me in this session and look at the architectural components of SQL Server, look at the internal processes of SQL Server, and discuss how it affect performance of your queries.
Speaker(s): Denis Reznik,
Abstract:
Давайте напишем целую пачку маленьких, простых, но умных и полезных приложений, которые помогут нам решить ежедневные задачи наблюдения за сервером.
Speaker(s): Oleksii Kovalov,
Abstract:
Доклад будет посвящен блокировкам диапазона ключей (Key-Range Locking). Вначале будет рассказано о базовых механизмах, после чего, мы поговорим о некоторых аспектах которые не описаны в MSDN. Дополнительно рассмотрим неявное использование блокировок диапазона ключей в уровне изоляции READ COMMITTED.
Speaker(s): Vitaliy Popovych,
Abstract:
Query and Plan Fingerprints впервые появились в SQL Server 2008 и являются довольно мощным механизмом для улучшения производительности систем, генерирующих большое количество ad-hoc запросов, даже если они непараметризированы. В докладе вы услышите о таких понятиях как parametrization (simple и forced), DMV, plan cache. Немного обсудим работу relational engine и его составных частей - parser, algebrizer, optimizer.
Speaker(s): Olena Smoliak,
Abstract:
В данном докладе мы познакомимся с хранилищами данных, методами построения хранилища данных, проектирование справочников и таблиц данных. И в конце доклада построим хранилище данных на MS SQL.
Speaker(s): Eugene Polonichko,
Abstract:
Maintenance Plans for Beginners (but not only) | Each of experienced administrators used (to some extent) what is called Maintenance Plans - Plans of Conservation. During this session, I'd like to discuss what can be useful for us to provide functionality when we use them and what to look out for. Session at 200 times the forward-300, with the opening of the discussion.
Speaker(s): Tobias Koprowski,
Abstract:
Type of NULL (usage of functions nullif(), isnull(), coalesce()), features of function STR(), implicit conversion and indexes in SQL queries, etc.
Speaker(s): Andrii Zrobok,
Abstract:
Одно из самых ожидаемых нововведений в SQL Server 2014 - это технология In-Memory OLTP, ранее известная под кодовым именем Hekaton. В этом докладе будут обсуждать особенности архитектуры и специфические настройки системы. Также много внимания будет уделено тем особенностям, с которыми вам придется столкнуться при разработке приложений с использованием In-Memory OLTP.
Speaker(s): Sergey Olontsev,
Abstract:
Одно из самых ожидаемых нововведений в SQL Server 2014 - это технология In-Memory OLTP, ранее известная под кодовым именем Hekaton. В этом докладе мы рассмотрим ее архитектуру, особенности и ограничения. Также уделим внимание некоторым аспектам практического применения In-Memory OLTP.
Speaker(s): Sergey Olontsev,
Abstract:
SSIS пакет при выполнении съедает много ресурсов? Или очень долго выполняется? Тогда заходите на доклад, посвященный оптимизации обработки потоков данных! Здесь Вы узнаете, как определять размер буфера, устанавливать число потоков выполнения и многое другое.
Speaker(s): Maksim Garnets,
Abstract:
Power BI tools within Excel are available in the cloud with Office 365, allowing customers to access and share BI reports and models across the desktop and web, and all within a managed environment. Power BI for Office 365 includes Power Pivot and Power View, and two new Excel capabilities have been added to allow the over one billion Office 365 users the ability to do more with their data! These two new features are Power Query which was formerly Project Codename “Data Explorer”, and Power Map formerly Project Codename “Geoflow”.
Speaker(s): Mihail Mateev,
Abstract:
В докладе поговорим о логирование и аудите ssis пакетов. А также об уровнях изоляции, контрольных точках и обработчиках событий пакета.
Speaker(s): Eugene Polonichko,
Abstract:
Так всё-таки, в чем же разница между обычными индексами и индексами с included columns?
Speaker(s): Oleksii Kovalov,
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.
Speaker(s): Konstantin Proskurdin,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://linkedin.com/in/sergeyolontsev
Contact: http://SergeyOlontsev.com/
I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I'm a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.
LinkedIn: https://www.linkedin.com/in/azrobok/
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.
LinkedIn: https://ua.linkedin.com/in/vitaliipopovych
Senior Database Developer at TFG an Intapp Company. Опыт работы с MS SQL Server — более 5 лет.
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
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.
DBA and DB developer with more than 10 year expirience. SQLSat/SSUG speaker. MCTS, MCITP. Author of pet-projects ExpressProfiler and SQL Code Guard
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
DBA and DB developer with more than 10 year expirience. SQLSat/SSUG speaker. MCTS, MCITP. Author of pet-projects ExpressProfiler and SQL Code Guard
LinkedIn: https://uk.linkedin.com/in/koprowskit
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador. Traveler. Coffee Addicted.
LinkedIn: https://uk.linkedin.com/in/koprowskit
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador. Traveler. Coffee Addicted.
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
LinkedIn: https://www.linkedin.com/in/olenasmoliak
Senior Software Engineer at Adver-Online Microsoft Certified Solution Associate (MCSA): SQL Server 2012 Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development Vinnitsa Data Platform User Group Leader (#vssug) Speaker at local user group meetings in Kyiv, L#39;viv, Dnipropetrovsk, SQLSaturday #290 (Kyiv, 2014), Global Russian Virtual Chapter Participated in organization of Kyiv SQLSaturdays #377, #290 (2014, 2015)
Contact: http://djeki.blogspot.com/
Немного о себе: Являюсь лидером Донецкой SQL User Group. BI от Microsoft работаю более 6 лет, начиная с Microsoft Sql Server 2000. В основном работаю с проектами, которые связаны с построением хранилища данных, кубов, аналитических порталов.
SQL/BI Developer at The Frayman Group Опыт разработки приложений и баз данных более 5-х лет. Увлекается процессами интеграции данных, оптимизацией запросов. Решить сложную задачу - дело чести!
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
LinkedIn: http://linkedin.com/in/sergeyolontsev
Contact: http://SergeyOlontsev.com/
I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I'm a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.
LinkedIn: https://www.linkedin.com/in/eugenepolonichko/
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.
The following is a list of sponsors that helped fund the event.