Event Location:
Impact Hub Odessa
Grecheskaya str. 1a
Odessa, Odessa Oblast, Ukraine
Abstract:
Almost any database query can be written in several ways. T-SQL, as any other query language, contains many language constructions and has a lot of aspects, that can both make life easier and more complex. Under "complex life", I understand bad readability and poor performance. In this session we will consider a number of typical tasks, solved with the help of T-SQL, and will look at effective and ineffective task solutions.
Speaker(s): Denis Reznik,
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.
Speaker(s): Denis Reznik,
Abstract:
About dependency between query syntax (adhoc query, query with local variables, stored procedures, local variable ) and query execution plan
Speaker(s): Andrii Zrobok,
Abstract:
Когда я в первые столкнулся с репликацией, я подумал: "Да что в ней может быть сложного?". Но как оказалось на деле, это достаточно не простая штука для понимания с первого раза. Второй момент, когда начинаются с ней проблемы, в виде рассинхронизации данных между её узлами, появлением каких-либо других ошибок, то не знаешь куда бежать. В докладе я расскажу о том, что такое транзакционная репликация, как и для чего ее используют, как ее настроить и что делать если что-то пошло не так.
Speaker(s): Evgeny Khabarov,
Abstract:
About columnstore Indexes
Speaker(s): Denis Reznik,
Abstract:
NoSQL - MongoDB. Agility, scalability, performance. I am going to talk about the basis of NoSQL and MongoDB. Why some projects requires RDBMs and another NoSQL databases? What are the pros and cons to use NoSQL vs. SQL? How data are stored and transefed in MongoDB? What query language is used? How MongoDB supports high availability and automatic failover with the help of the replication? What is sharding and how it helps to support scalability?. The newest level of the concurrency - collection-level and document-level. Join the session, I promise that it will be interesting! :)
Speaker(s): Viktoriia Mala,
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’a. Потоки в сиквеле всего чего-нибудь да ждут, иногда в этом нет ничего плохого, но когда ожидание затягивается, то надо разбираться, почему же так долго. Что такое ожидание? Почему приходится ждать, когда это плохо, и как с этим бороться (если требуется) мы рассмотрим в этом докладе
Speaker(s): Evgeny Khabarov,
Abstract:
In this sessions you will learn how to perform seamless upgrade from previous version of SQL Server (yes, even from version 2000!) to latest and greatest version of SQL Server. No matter if reason of upgrade is end of support or consolidation, you are upgrading from Express Edition or Enterprise – you will get set of best practices how to avoid most common issues and perform successful upgrade. On the session there will be not only theoretical knowledge but real life examples with demos.
Speaker(s): Michal Sadowski,
Abstract:
The session is about methods and tools for continuous integration and delivery of databases in web development
Speaker(s): Konstantin Proskurdin,
Abstract:
NoSQL - MongoDB. Agility, scalability, performance. I am going to talk about the basis of NoSQL and MongoDB. Why some projects requires RDBMs and another NoSQL databases? What are the pros and cons to use NoSQL vs. SQL? How data are stored and transefed in MongoDB? What query language is used? How MongoDB supports high availability and automatic failover with the help of the replication? What is sharding and how it helps to support scalability?. The newest level of the concurrency - collection-level and document-level. Join the session, I promise that it will be interesting! :)
Speaker(s): Viktoriia Mala,
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.
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
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/xperiandri
Contact: http://xperiandri.azurewebsites.net/
Founder of The Secret Circle Solutions Teacher in IT Step computer academy Microsoft Certified Solutions Developer for Windows 8 with C#
Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
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.
Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.
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.
More than 10 years in IT working with Microsoft products, all around data migration and Application Performance Management (APM)
MongoDB and SQL Server.
LinkedIn: https://pl.linkedin.com/pub/michal-sadowski/4/b33/717
Contact: https://sqlplayer.net/michal-sadowski
Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.
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.
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.
MongoDB and SQL Server.
The following is a list of sponsors that helped fund the event.