SQLSaturday #416 - Odessa 2015
Event Date: 07/25/2015 00:00:00
Event Location:
- Impact Hub Odessa
- Grecheskaya str. 1a
- Odessa, Odessa 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: Effective T-SQL. To be effective or not to be.
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
Track and Room: Other - Room 1
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.
Speaker(s):
- Denis Reznik
Track and Room: Other - Room 1
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
Speaker(s):
- Andrii Zrobok
Track and Room: Other - Room 1
Title: Транзакционная репликация - это не страшно.
Abstract: Когда я в первые столкнулся с репликацией, я подумал: “Да что в ней может быть сложного?”. Но как оказалось на деле, это достаточно не простая штука для понимания с первого раза. Второй момент, когда начинаются с ней проблемы, в виде рассинхронизации данных между её узлами, появлением каких-либо других ошибок, то не знаешь куда бежать.
В докладе я расскажу о том, что такое транзакционная репликация, как и для чего ее используют, как ее настроить и что делать если что-то пошло не так.
Speaker(s):
- Evgeny Khabarov
Track and Room: Track 1 - Room 2
Title: Тарас Бобровицкий - Columnstore Indexes
Abstract: About columnstore Indexes
Speaker(s):
- Denis Reznik
Track and Room: Other - N/A
Title: NoSQL - MongoDB. Agility, scalability, performance (Part 2)
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
Track and Room: Track 1 - Room 2
Title: MS SQL data types: features of conversion
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
Track and Room: Other - Room 1
Title: Поговорим об ожиданиях и очередях
Abstract: Ожидания - очень точно отражают, что же происходит внутри SQL Server’a. Потоки в сиквеле всего чего-нибудь да ждут, иногда в этом нет ничего плохого, но когда ожидание затягивается, то надо разбираться, почему же так долго. Что такое ожидание? Почему приходится ждать, когда это плохо, и как с этим бороться (если требуется) мы рассмотрим в этом докладе
Speaker(s):
- Evgeny Khabarov
Track and Room: Track 1 - Room 2
Title: Upgrading to SQL Server 2014
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
Track and Room: Track 1 - Room 1
Title: Continuous integration and delivery of databases in web development
Abstract: The session is about methods and tools for continuous integration and delivery of databases in web development
Speaker(s):
- Konstantin Proskurdin
Track and Room: Track 1 - Room 1
Title: NoSQL - MongoDB. Agility, scalability, performance (Part 1)
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
Track and Room: Track 1 - Room 2
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.
Speaker(s):
- Konstantin Proskurdin
Track and Room: Other - Room 2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Konstantin Proskurdin
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
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.
Andrii Chebukin
Twitter: - https://twitter.com/xperiandri
LinkedIn: Andrii Chebukin
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#
Evgeny Khabarov
Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.
Konstantin Proskurdin
.NET developer with more than 10 years of experience, experience with MS SQL Server - 8 years.
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.
Evgeny Khabarov
Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.
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.
Vlad Samoylenko
More than 10 years in IT working with Microsoft products, all around data migration and Application Performance Management (APM)
Viktoriia Mala
MongoDB and SQL Server.
Michal Sadowski
Twitter: - SadowskiMichal
LinkedIn: Michal Sadowski
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.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: