SQLSaturday #219 - Kiev 2013
Event Date: 05/25/2013 00:00:00
Event Location:
- Microsoft Ukraine
- str. Zhilyanskaya, 75
- Kiev, , 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: SQL Azure from Plan, to Backup, to Cloud
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. 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
Track and Room: Track 4 - N/A
Title: Rewrite your queries with SQL Server 2012
Abstract: Compared with other programming languages, T-SQL isn’t difficult to learn and clear-cut of any syntax errors it can be very tolerant. In the IT area, T-SQL language is used by many people, but often they tend to learn only fundamental statements and basic development techniques without going in depth. Only those invests more time discovers the declarative nature of this language and the importance to have the SQL Server Query Optimizer. In this session we will learn how to improve our queries through the use set-based statements that there are from a long time in T-SQL as well as those implemented in SQL Server 2012 with particular reference to Windows Functions.
Speaker(s):
- Sergio Govoni
Track and Room: Track 3 - N/A
Title: Analyzing Twitter Data
Abstract: This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis.
Speaker(s):
- Niko Neugebauer
Track and Room: Track 1 - N/A
Title: HA DR with SQL Server 2012 AlwaysOn Availability Group
Abstract: The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. In this session we will talk about what’s coming with Always On, and how does it help to improve high availability and disaster recovery solutions.
Speaker(s):
- Turgay Sahtiyan
Track and Room: Track 3 - N/A
Title: Microsoft SSIS: Best practices, ETL –patterns
Abstract: Демонстрационные примеры для типовых ETL – задач. Сравнительный анализ различных вариантов решений и результатов выполнения Будет много ссылок наресурсы по теме (руководства, блоги и т.п.) и Демонстрации примеров из практики проектов, после каждого раздела – секция вопросов и ответов
Speaker(s):
- Alexandr Domashev
Track and Room: Track 1 - N/A
Title: Inheriting a database for Developers, version 2
Abstract: There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations.
Speaker(s):
- Niko Neugebauer
Track and Room: Track 1 - N/A
Title: Все о журнале транзакций в SQL Server
Abstract: Очень часть приходится слышать такие вопросы, как: зачем вообще нужен журнал транзакций, почему он занимает столько места на диске, как им лучше управлять, какая модель восстановления подходит больше всего и т.д. На эти и многие другие вопросы будут даны подробные и развернутые ответы.
Speaker(s):
- Sergey Olontsev
Track and Room: Track 3 - N/A
Title: Не делай так! Немного об ошибках
Abstract: Небольшой рассказ о том, чего мы не делаем и не должны делать - об ошибках при написании T-SQL кода.
Speaker(s):
- Oleksii Kovalov
Track and Room: Track 3 - N/A
Title: 2 AM. A Disaster just began…
Abstract: 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I’ll show You how to be BEST prepared.
Speaker(s):
- Tobias Koprowski
Track and Room: Track 2 - N/A
Title: Архитектура и функциональность аналитических хранилищ SQL Server Parallel Data Warehouse 2012
Abstract: Microsoft SQL Server Parallel Data Warehouse (PDW) – это высокопроизводительная платформа для организации аналитического хранилища данных (DWH). Parallel Data Warehouse использует архитектуру обработки больших объемов данных, состоящую в распределении данных и параллельной обработки на разных серверах. Такой подход называется обработкой с массовым параллелизмом (MPP). В докладе рассмотрены базовые принципы, архитектура, а также подробности о новой версии Parallel Data Warehouse 2012.
Speaker(s):
- Андрей Резник
Track and Room: Track 1 - N/A
Title: Extended Events in SQL Server 2012
Abstract: Extended Events in SQL Server 2012
Speaker(s):
- Oleg Alekseev
Track and Room: Track 3 - N/A
Title: Deadlock – всё пропало,или ещё рано бить тревогу
Abstract: Deadlock – всё пропало,или ещё рано бить тревогу
Speaker(s):
- Denis Reznik
Track and Room: Track 4 - N/A
Title: Spatial Data and Windows Azure SQL Database
Abstract: Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data from Windows Azure SQL Database Spatial, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure SQL Database Spatial and will create a several sample Windows Azure applications, that use this data.
Speaker(s):
- Mihail Mateev
Track and Room: Track 4 - N/A
Title: Azure Storage overview - blobs, table and Queues
Abstract: The session will provide an overview of Azure Storage service - blobs, table and Queues.
Speaker(s):
- Denys Kholod
Track and Room: Track 4 - N/A
Title: Оптимизация запросов в SQL Server
Abstract: Оптимизация запросов в SQL Server
Speaker(s):
- Dmitriy Kostylev
Track and Room: Track 2 - N/A
Title: Повреждение данных и как с ним бороться
Abstract: Случайное повреждение данных – это ночной кошмар любого администратора баз данных, но рано или поздно каждый с ним сталкивается. В докладе будут подробно освещены такие темы, как почему возникает повреждение баз данных, как минимизировать риски и на примерах будет показано, как восстановить поврежденные данные.
Speaker(s):
- Sergey Olontsev
Track and Room: Track 2 - N/A
Title: MS SQL Server: почему не стоит использовать*
Abstract: Поведение представления с использованием «» в определении в MS SQL Server отличается от поведения в других базах данных и может привести к неожидаемым результатам в случае любых модификаций базовой таблицы: добавление\удаление\ переименование колонок, пересоздание таблицы с тем же именем. MS SQL Server документация умалчивает о нестандартном поведении представлений, содержащих «» в определении.
Speaker(s):
- Andrii Zrobok
Track and Room: Track 4 - N/A
Title: SQL Injection - вы готовы к защите?
Abstract: Этой проблеме очень много лет, но начинающие (и не только) разработчики баз данных продолжают совершать ошибки, которые делают возможным этот тип атаки. Узнайте как сделать правильное решение и защитить ваши базы данных
Speaker(s):
- Andrey Korshikov
Track and Room: Track 2 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
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.
Alexandr Domashev
Александр Домашев Lead Software Engineer в EPAM Systems. Более 12 лет опыта работы с MS SQL Server, из них последние 6 лет - в области Business Intelligence (бизнес-аналитики) и Data Warehouse (хранилищ данных). Участвовал в проектах с применением практически всего спектра продуктов и решений Microsoft в области построения баз данных, хранилищ данных, систем анализа и отчетности, информационных порталов.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
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.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Denys Kholod
Denys Kholod has worked at Frayman Group (Lead software engeneer,RD)
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Dmitriy Kostylev
Работает в Лаборатории Касперского ведущим разработчиком баз данных. С SQL Server работает с 2000 года, участвуя в разнообразных проектов - от небольшого производства до одной из крупнейших баз знаний о программном обеспечении. Сконцентрирован на эффективности применяемых решений - от отдельных запросов и архитектуры решений до методологии разработки ПО. Активно участвует в жизни SQL-сообщества, выступая на конференциях с докладами об эффективном применении SQL Server.
Turgay Sahtiyan
Twitter: - https://twitter.com/turgaysahtiyan
LinkedIn: Turgay Sahtiyan
Contact: http://www.turgaysahtiyan.com/
Turgay Sahtiyan has been working in IT industry over a decade and he currently works as a PMC (Premier Mission Critical) Solution Engineer at Microsoft.He is based in Turkey and primarily giving proactive and reactive services with solution based approach to top enterprise customer in the MEA region.Before joined to Microsoft, he was one of the SQL Server MVP in Turkey,in addition he is founder and former president of SQLPass Turkey Chapter.(Detailed BIO http://www.turgaysahtiyan.com/about.aspx)
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
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.
Oleksii Kovalov
DBA and DB developer with more than 10 year expirience. SQLSat/SSUG speaker. MCTS, MCITP. Author of pet-projects ExpressProfiler and SQL Code Guard
Denis Reznik
Speaker Bio
Andrey Korshikov
Работать с SQL Server начал в 2003 году. Довелось работать и сдавать сертификационные экзамены по версиям SQL Server от 2000 до 2012. Участник конференций SQLSaturday, Платформа, DevCon и TechEd. География выступлений от Тампы до Красноярска, от Санкт-Петербурга до Тбилиси. Основатель сообществ Krasnodar SQLamp;BI Usergroup и Global Russian Virtual Chapter. На данный момент являюсь PASS Regional Mentor for Central Eastern Europe.
Sergey Olontsev
Twitter: - SergeyOlontsev
LinkedIn: Sergey Olontsev
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.
Oleg Alekseev
Работаю в майкрософт Украина, занимаюсь сложными решениями
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.
Sergey Olontsev
Twitter: - SergeyOlontsev
LinkedIn: Sergey Olontsev
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.
Sergio Govoni
Twitter: - @segovoni
LinkedIn: Sergio Govoni
Contact: https://mvp.microsoft.com/it-it/PublicProfile/4029181?fullName=Sergio%20Govoni
Since 1999 Sergio Govoni has been a software developer; in 2000 he got a degree in Computer Science at “Università degli Studi” in Ferrara (Italy). He has worked for over 18 years in Centro Software, a software house that produces the best ERP for manufacturing companies that are export oriented. Now, he manages the development product team and he is constantly involved on several team projects, where he focues his attention on the architecture and the mission-critical technical details. Since 2016 he is the vice president of the UGISS (www.ugiss.org). For the provided help to technical communities and for sharing his own experience, since 2010 he has received the Microsoft Data Platform MVP award.
Андрей Резник
Работаю в Microsoft CEE, занимаюсь решениями для разработки хранилищ данных на базе SQL Server PDW
Sponsors
The following is a list of sponsors that helped fund the event: