SQLSaturday #259 - Kharkov 2013

Event Date: 12/07/2013 00:00:00

Event Location:

  • Sun City Plaza
  • Moskovskiy ave, 199-A
  • Kharkiv, , 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: Entity Framework 6 New Features

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 EF 6.01. This is the first new 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, Connecti

Speaker(s):

  • Mihail Mateev

Track and Room: Track 2 - N/A


Title: High Performance SQL Server on Cloud – Best Practices

Abstract: This session covers real-world lessons and best practices learned running SQL Server in a Windows Azure Virtual Machine . Your considerations for querying, deployment, I/O, configuration, HA/DR, and performance when SQL Server is running in an Azure VM are covered during this session. Deep-dive information related to capacity, storage and networking planning for cloud will be covered. Session objective is to train SQL Server on Cloud Ninjas:)

Speaker(s):

  • Umit Sunar

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 1 - N/A


Title: SQL Server Full-Text Search - это не для меня, или Построение своей системы

Abstract: На примерах мы рассмотрим принципы и подходы к построению поисковой системы - аналога полнотекстового поиска - методами SQL Server.

Speaker(s):

  • Oleg Rakitskiy

Track and Room: Track 3 - N/A


Title: Конкуренция за ресурсы в многоядерных системах.

Abstract: В настоящее время все больше старых серверов с небольшим количеством ядер выводятся из эксплуатации и заменяются современными многоядерными системами, основанными на архитектуре NUMA. В таких системах все чаще можно наблюдать конкуренцию при доступе к различным системным объектам в связи с параллельным выполнением большого количества запросов. В докладе пойдет речь о LATCHах и SPINLOCKах, основных типах проблем, связанных с конкурентным доступом, и методах их решения.

Speaker(s):

  • Evgeny Khabarov

Track and Room: Track 4 - N/A


Title: BigData -NoSQL - MongoDB

Abstract: BigData is nowdays bottleneck in the current systems. SQL can’t provide a good way to store and treat a huge amount of data. NoSQL databases were designed to support BigData. MongoDB is one of the NoSQL databases, which is easy-scalable, productive and free for most of the cases. This session is about MongoDB in general and in comparison with MS SQL Server vendor.

Will be very interesting! I promise ;)

Speaker(s):

  • Viktoriia Mala

Track and Room: Track 3 - N/A


Title: SQL Server Reporting Services - дюжина советов

Abstract: Существует много полезных мелочей, о которых не подозревают разработчики отчетов. напрмер, все привыкли, что отчёты в SSRS получаются статическими. Но использование встраиваемого программного кода позволяет не только упростить последующее внесение изменений в отчёты, но и создать интерактивные отчёты. Например, можно реализовать функционал, похожий на срезы в Excel 2010. В докладе мы рассмотрим 12 интересных и полезных возможностей SSRS.

Speaker(s):

  • Andrey Korshikov

Track and Room: Track 4 - N/A


Title: Top 10 Performance Tips for SQL Server Developers

Abstract: Performance of a SQL Server depends on many factors and due to the nature of development SQL Server developers sometimes miss basic performance tips. Easily implemented tips such as using an appropriate index or solving a data mismatch problem on where conditions could affect the application performance significantly. In this session, we will cover the top 10 tips to improve the performance of your SQL Server with real life examples.

Speaker(s):

  • Turgay Sahtiyan

Track and Room: Track 1 - N/A


Title: Maintenance Plans ad Hoc

Abstract: Maintenance Plans for Beginners | 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

Track and Room: Track 3 - N/A


Title: Сommon MS SQL Server DBA issues.

Abstract: Health and risks. Typical issues of customer infrastructure related to:

  1. Security
  2. Cluster
  3. Environment
  4. SQL Configuration
  5. Performance
  6. Business Continuity
  7. Maintenance

Speaker(s):

  • Oleg Alekseev

Track and Room: Track 3 - N/A


Title: In-Memory OLTP (Hekaton) в SQL Server 2014

Abstract: Одно из самых ожидаемых нововведений в SQL Server 2014 - это технология In-Memory OLTP, ранее известная под кодовым именем Hekaton. В этом докладе мы подробно рассмотрим ее архитектуру, особенности и ограничения. Также уделим внимание некоторым аспектам практического применения In-Memory OLTP.

Speaker(s):

  • Sergey Olontsev

Track and Room: Track 1 - N/A


Title: Повышаем производительность обработки данных с использованием SSD

Abstract: Microsoft Windows Azure SQL Reporting is a cloud-based reporting service for the Windows Azure Platform built on SQL Server Reporting Services technologies. SQL Reporting provides many benefits, including rapid provisioning, cost-effective scalability, high availability, reduced management overhead and secure access for viewing and managing reports.VM SSRS provides SQL Reporting service under IaaS model which will be consumed by client application or service. This SSRS is hosted on the Azure VM. This presentation compares SQL Azure reporting with IaaS VM reporting.

Speaker(s):

  • Mihail Mateev

Track and Room: Track 2 - N/A


Title: Replay your workload as it’s your actual one!

Abstract: Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there’s a feature for that! It’s called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!

Speaker(s):

  • Boris Hristov

Track and Room: Track 2 - N/A


Title: Я построю свой профайлер, с гридами и кнопками!

Abstract: Давайте напишем целую пачку маленьких, простых, но умных и полезных приложений, которые помогут нам решить ежедневные задачи наблюдения за сервером.

Speaker(s):

  • Oleksii Kovalov

Track and Room: Track 2 - N/A


Title: Использование uniqueidentifier в качестве первичного кластерного ключа

Abstract: В своем докладе я хочу расказать зачем Вам может понадобиться использовать данный тип данных, о достоинствах и недостатках такого первичного кластерного ключа. А так же как обойти проблемы возникающии при неправильном использовании данного типа.

Speaker(s):

  • Evgeny Garaev

Track and Room: Track 4 - N/A


Title: Оптимизация использования памяти для запросов

Abstract: Речь пойдет о Workspace Memory (Query Memory) - той памяти, которая выделяется запросу на время его выполнения. Я расскажу, что это такое, как происходит выделение, с какими проблемами можно столкнуться, если статистика не совсем точно отражает распределение данных в таблице. Мы поговорим также об одновременно выполняющихся запросах и как можно с помощью Resource Governor оптимально скорректировать их выполнение.

Speaker(s):

  • Sergey Olontsev

Track and Room: Track 2 - N/A


Title: Облака белоснежные лошадки или История одного BI проекта c SQL Azure

Abstract: В данном докладе будет рассказана история одного проекта, где в качестве хранилища использовался SQL Azure. Расскажу с какими проблемами мы столкнулись, как искали решения и кончено же рекомендации как жить дальше с этим :)

Speaker(s):

  • Eugene Polonichko

Track and Room: Track 4 - N/A


Title: Keynote. Ukrainian Comunity and Future of the Community.

Abstract: Вступительное слово лидера украинского сообщества разработчиков - Владимира Лещинского. История того, как развивалось украинское сообщество и о том какие перспективы развития имеет сейчас в свете новых технологий.

Speaker(s):

  • Vladimir Leshchinsky

Track and Room: Track 4 - N/A


Title: Внутри оптимизатора: стоимость и планы выполнения

Abstract: В основу оптимизатора SQL Server положено понятие стоимости планов выполнения запроса (cost based query optimization). Именно стоимость определяет выбор того или иного оператора в плане и число предпринимаемых усилий для поиска оптимального варианта. В докладе будут рассмотрены некоторые механизмы, используемые оптимизатором для вычисления стоимости, а также решения оптимизатора, принимаемые на ее основе.

Speaker(s):

  • Dmitry Pilugin

Track and Room: Track 1 - 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.

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.

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.

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)

Oleg Rakitskiy

В данный момент занимаюсь разработкой поисковой системы и всем, что с этим связано, в компании Frayman Group.

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.

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.

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.

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.

Evgeny Khabarov

Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.

Oleg Alekseev

12 years of experience with MS SQL Server. Used to work for Banks, International IT-companies, Microsoft. The main specializations - SQL core, DBA.

Dmitry Pilugin

Twitter: - https://twitter.com/SomewereSomehow

LinkedIn: Dmitry Pilugin

Contact: http://www.queryprocessor.com/

Dmitry Pilugin, is a SQL Server DB developer from Russia, Moscow. He works with SQL Server for more than ten years. Currently he works as a database developer lead, responsible for the development of production databases in the media research company.

Dmitry holds a blog about SQL Server query processing: QueryProcessor.com, where he writes about a query optimization and execution, and also likes to share his knowledge about it speaking at various community events and tech conferences. Data Platform Microsoft MVP since 2014.

Viktoriia Mala

MongoDB and SQL Server.

Umit Sunar

Twitter: - @umitsunar

LinkedIn: Umit Sunar

Umit Sunar has been working in IT Industry since 2000 and he is currently working as Cloud Solution Architect (Azure) at Microsoft MEA HQ. Based in Dubai and traveling a lot for business and entertainment. Formerly, he is an aeronautics engineer originally supposed to build airplanes.

In technical keywords, he received his first development certificate from Borland at 1992 and continued development in many platforms including C, PHP, Pascal Fortran, Python, Java, C#, Node.js and maybe couple more that he forgot writing this.

He is passionate about Cloud Computing for 8+ years and even created a small cloud environment in 2008

He doesn’t like the word “geek” but likes a lot traveling, cooking and smiling.

Boris Hristov

Twitter: - https://twitter.com/BorisHristov

LinkedIn: Boris Hristov

Contact: http://borishristov.com/blog/

Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.

Vladimir Leshchinsky

Contact: http://dctua.com

Владимир - эксперт в технологиях Microsoft. Компания DCT, которой он управляет, стала партнером Microsoft в сфере развития ПО. Владимир работает в индустрии IT на протяжении 16 лет и отлично разбирается в современных тенденциях рынка.

Evgeny Garaev

Evgeny Garaev is MCM SQL Server 2008 from St. Petersburg, Russia.

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

Eugene Polonichko

Contact: http://djeki.blogspot.com/

Немного о себе: Являюсь лидером Донецкой SQL User Group. BI от Microsoft работаю более 6 лет, начиная с Microsoft Sql Server 2000. В основном работаю с проектами, которые связаны с построением хранилища данных, кубов, аналитических порталов.

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.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page