SQLSaturday #416 - Odessa 2015

Event Date: 07/25/2015 00:00:00

Event Location:

  • Impact Hub Odessa
  • Grecheskaya str. 1a
  • Odessa, Odessa Oblast, Ukraine

PDF of Schedule

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:

Back to the SQLSaturday Event List

Back to the home page