SQLSaturday #384 - Varna 2015
Event Date: 05/30/2015 00:00:00
Event Location:
- Interhotel Cherno More
- 33 Slivnitsa Blvd
- Varna, Bulgaria
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: Deadlocks. Everything that developer needs to know.
Abstract: It’s no secret that a deadlock - it’s not very good. This is an exceptional situation, when two concurrent queries request same resources, but in a different order. Classic deadlock can occur when two concurrent transactions modifying data from the two tables in a different order. Unfortunately in a real life deadlocks can be more complex and unobvious. One of the rules, which I always keep in mind, sounds: “ You can not design a database, in which the occurrence of deadlock is impossible”. And we should deal with them. The algorithm is simple: catch, analyze, fix. But in practice the process can be challenging and can require different types of analysis. In this session we will analyse and solve as many deadlock as we can in 60 min.
Speaker(s):
- Denis Reznik
Track and Room: A - A
Title: Memory-Optimized tables - Querying at the speed of light
Abstract: One of Microsoft SQL Server 2014’s big features was the all new In-Memory OLTP (or Hekaton) addition to the SQL Server engine. Microsoft estimates a query performance increase of 5-to-20 times by just putting your disk-based tables into the RAM of your server! If we can gain that much of a performance increase that easily, then why aren’t Memory-Optimized tables the default go-to solution for all your performance problems? Because, of-course, it isn’t as easy as just a drag-and-drop to move your tables from disk into memory…
Transforming your disk-based tables to Memory-Optimized tables takes careful planning and a good understanding of the limitations and restrictions of In-Memory OLTP. In this demo-filled session, we will take a look underneath the hood of Memory-Optimized tables, helping you with the first steps towards light speed querying!
Speaker(s):
- Enrico van de Laar
Track and Room: B - B
Title: SQL Server Power BI Geographic and Temporal Predictions
Abstract: Data science, predictive analytics, insights, statistics… There are so many buzzwords around these days. These words are frequently used in an introduction to some technical article, at the beginning of a presentation, and even in regular talk. However, when it comes down to a real analysis, you typically get reports with very nice Power BI graphs, but without real forecasting. It is up to you to recognize the patterns and then probably make some kind of interpolation by yourself. Data mining is the part that is based on statistics and can really make forecasts automatically. Data mining is part of SSAS installed in multidimensional mode. Is it possible to get the best from both words? This advanced session explains the forecasting algorithms and shows how you can integrate geographic and temporal predictions in Power View and Power Map visualizations and interactive animations. Popular buzzwords finally get some real meat behind them.
Speaker(s):
- Dejan Sarka
Track and Room: A - A
Title: Lets cook SQL Server Management practices for the Non-DBA
Abstract: DBA trade is still in-demand and will remain as long as databases are alive! If you are an average IT person/Developer/SysAdmin who has been managing development and databases in your organisation, now you want to manage SQL Server databases using tricks of DBA trade and you’ve got no idea what to do with it!
In this session we will overview range of topics that every DBA handles, such as: backup/restore strategy, high availability, scalability and performance tuning. We will touch base on how best SQL Server technology will offer home-grown tools to keep your BAU tasks.
Not giving opportunity of riding a super-duper car, but best learning techniques on how to manage your SQL Server database and make it efficient enough to run like a fast car on performance aspects. You will get o know what is needed to get that new features to implement, how best they can fit in.
All the examples and demos in this session are originated from real-world work from my Consulting experience.
Speaker(s):
- Satya Jayanty
Track and Room: A - A
Title: BIML – the best friend of SSIS developers
Abstract: Many BI developers use SSIS. It’s great tool. But exists many routine tasks. For example, you need create package for incremental updating of 10 tables. You did it. But structure of tables was changed. Or you need add to package 5 (or may be 50) additional tables. In this situation you need help. And you have new assistant. His name is BIML (Business Intelligence Markup Language).
Speaker(s):
- Andrey Korshikov
Track and Room: C - C
Title: Managing 999 MS SQL Servers
Abstract: Managing many SQL server instances is difficult and more importantly it requires a lot of efforts from the DBAs. How can we reduce and save these efforts? Let’s dive into a session covering some great examples and best practices of multi-server management – from building a Central Management Server through gathering performance data with customized Management Data Warehouse. We will do also a showcase for proactive capacity management and see many other ideas for automating of the daily DBA tasks.
Speaker(s):
- Kaloyan Kosev
Track and Room: C - C
Title: Transactional replication. It’s not scary.
Abstract: When I’ve encountered with replication first time, I’ve thought “Hmm, replication is not so hard for configuring and troubleshooting”. It was mistake :).The replication is not as easy to understand from the first time. The next moment when you got problem with it, such as desync of data between publishers and subscribers and vise versa. Replication sometimes is not readily to troubleshooting.
In the presentation I’ll tell you about transactional replication, about what is it, how to configure different replication schemas and how to determine the cause of problem which can arise.
Speaker(s):
- Evgeny Khabarov
Track and Room: C - C
Title: Extended events in action
Abstract: In this session we will walk through the world of Extended Events and their power in monitoring SQL server instances. We will explore some real-world scenarios and see how we can benefit from Xevents in solving them. You will be able to see how to track a specific application behavior and how to troubleshoot connectivity issues
Speaker(s):
- Miroslav Dimitrov
Track and Room: C - C
Title: Keynote
Abstract: Keynote and opening
Speaker(s):
- Mihail Mateev
Track and Room: A - A
Title: Introduction to SQL Server high availability solutions
Abstract: This presentation is about the high availability solutions in SQL Server starting w/ SQL 2005 SP1 until the latest versions. It is for those who just started working with SQL Server and interested about the different options. The followings will be covered:
- DBM
- FCI
- AAG
- Log Shipping
- Replications
Presentation will try to show all in cost and feature set point of view along with their pro’s and con’s.
Demos:
- DBM: basic setup + failover + monitoring
- FCI: basic setup + failover
- AAG: basic setup + failover + monitoring
Speaker(s):
- Janos Berke
Track and Room: B - B
Title: Boosting DWH-Performance with SQL Server 2014
Abstract: SQL Server 2014 is all about in-memory. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: columnar storage, in-memory tables and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: B - B
Title: Data quality with DQS components in Integration Services
Abstract: To integrate data quality in ETL-Jobs some preliminary considerations and preparatory work are necessary. The session shows the preparing steps on DataQualityClient, continues with configuration of some validation-rules and then uses the configuration for a first data-import in SSIS. The DQS meta-information (stored in a DQS-project) is subsequently evaluated by Data-Stuard (a new role of staff member in the company’s organigramm). The result of the evaluation is imported via DQS_stagingDB into DQS_Main Database. This provides import after import, i.e. with each ETL-job there is a continuous improvement of data quality.
Speaker(s):
- Alexander Karl
Track and Room: B - B
Title: How to Forecast in C# with ADOMD and TimeSeries
Abstract: In this presentation we will start with description of the Data Mining Process, then we will Introduce the Microsoft Time Series Algorithm for Forecasting. Then we will demonstrate production of forecast by: SQL Server Data Tools (SSDT) Project. And we will show haw to implement complete process as part of your application by using ADOMD on real data.
Speaker(s):
- Daniel Joskovski
Track and Room: B - B
Title: MS-SQL Basic Features
Abstract: Basic fеаtures specific for MS-SQL. Overview of basic fеаtures and tips that will help developers that are just entering SQL programming or transitioning from other RDBMS to get to know the power of T-SQL.
Speaker(s):
- Rosen Kolev
Track and Room: C - C
Title: SQL Server as a Data Warehousing platform
Abstract: Defining the business problem. Contrasting OLTP and OLAP environments. Overview of the Data Warehousing concepts and architectures. Exploring the SQL Server components and features as part of a Data Warehousing solution. SQL server Integration Services for Data Integration. Comparing the various Microsoft Business Intelligence tools for data-driven decision making and business analysis.
Speaker(s):
- Sylvia Takvorian
Track and Room: B - B
Title: The nightmare of locking, blocking and isolation levels!
Abstract: I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!
Speaker(s):
- Boris Hristov
Track and Room: A - A
Title: SQL Server Advanced indexing techniques
Abstract: SQL Server indexing is an art. Choosing the right index for the right solution might just not be enough. Options are also without boundaries, but still there are several rules you must always apply to design an effective indexing strategy. Join me in this session and find out about these rules, how the SQL Server optimizer chooses an index and most importantly - is your index useful enough or is just a burden to your database.
Speaker(s):
- Ivan Donev
Track and Room: A - A
Title: Find and tune those queries!
Abstract: There are queries that we usually play a mouse and cat game with, while trying to catch them! When the query is performing badly every time it executes, it is easy to find and tune it. But it could be difficult to isolate those that have inconsistent execution behavior. What is the problem with them, do we need to re-write, to plan guide or to create yet another index? Well, you need to find them first. In this session you will learn how to find and tune queries with inconsistent execution behavior and how to tune them. Getting a predictable query response time is one of the main goals of performance tuning and optimization and this session will definitely help you achieve that goal.
Speaker(s):
- Margarita Naumova
Track and Room: A - A
Title: Building Great Business Intelligence Semantic Models for Power View
Abstract: In this session, we’ll explore what it takes to create the right BI Semantic Models to help your users get the answers they need and insightful results with Power View.
Speaker(s):
- Boriana Petrova
Track and Room: C - C
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Margarita Naumova
LinkedIn: Margarita Naumova
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
Markus Ehrenmueller-Jensen
Twitter: - MEhrenmueller
LinkedIn: Markus Ehrenmueller-Jensen
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
Miroslav Dimitrov
Twitter: - @miro_dd
LinkedIn: Miroslav Dimitrov
Contact: http://www.sqlshack.com/author/miroslav-dimitrov/
Miroslav Dimitrov is a Senior Big Data and Analytics Engineer at DXC Technology, regular speaker at various events and Microsoft Certified Trainer. He is MCSE: Data Platform for SQL Server and MCITP on SQL 2008. In the last years he had worked on great variety of customers’ environments and involved in complex transitions and transformation projects as well as developing private and public cloud solutions. Miroslav is also leading database courses at Sofia University.
Janos Berke
Twitter: - @JanosBerke
LinkedIn: Janos Berke
Contact: http://www.iamberke.com
I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Kaloyan Kosev
Twitter: - https://twitter.com/nosqltillcoffee
LinkedIn: Kaloyan Kosev
Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.
Boriana Petrova
Twitter: - borianapetrova
LinkedIn: Boriana Petrova
Contact: http://itraining.bg/category/itraining-blog/
Microsoft Certified Trainer with over 10 years experience as an IT instructor and Consultant. She has many qualifications and professional certifications, including: Excel MVP, MCT, MCITP, MCTS, MOS Master. In 2008 she is among the TOP 25 of the best instructors in Microsoft World Company business evaluation and measurement - Knowledge Advisors.
Ivan Donev
Twitter: - https://twitter.com/ikdonev
LinkedIn: Ivan Donev
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
Rosen Kolev
Contact: http://rosenkolev.blogspot.com/
Microsoft .NET developer with over 5 years experience in programming mobile, web and desktop applications. Likes to learn new things and revisit old ones.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
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.
Sylvia Takvorian
LinkedIn: Sylvia Takvorian
Sylvia Takvorian is a Senior Data Warehouse and .NET Consultant at Adastra with over 7 years of experience in various projects in banking, financial services and e–commerce industries. She is Microsoft certified professional (MCSA), experienced in designing, developing and automating ETL processes and Business Intelligence solutions with a wide range of technical tools including but not limited to Microsoft SQL Server, IBM InfoSphere DataStage, IBM DB2 and Teradata.
Evgeny Khabarov
Разработчик и администратор SQL Server. Область применения знаний в основном устранение проблем с производительностью систем, в основе которых лежит SQL Server.
Alexander Karl
Twitter: - sqlfabrik
Alexander Karl is database-developer and certified MCT for Windows and SQL Server with .net-CDE GmbH. For more than 18 years he has been working with Database-, Datawarehouse- and Reporting-Solutions for companies from medium-sized enterprises to Group level. His spectrum includes Serversizing, Programming to optimize performances as well as Report- and Chartdesign; in trainings and seminars he conveys participants well-founded theoretical knowledge complemented with his practical.
Enrico van de Laar
Twitter: - twitter.com/evdlaar
LinkedIn: Enrico van de Laar
Contact: https://www.enricovandelaar.com
Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com
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.
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.
Daniel Joskovski
Daniel Joskovski work in IT since 1985, he is a database-centric application developer and architect, instructor, course author, user group leader. Over the Past 17 Years as MCT he#39;s been teaching Microsoft SQL Server and .NET Development courses to premier customers in Macedonia, Serbia, Norway, Kosovo and Albania. From 2009 He is being awarded with Microsoft MVP award for SQL Server 8 times in a row. At the moment Daniel works for CloudCoder DOOEL Skopje.
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.
Sponsors
The following is a list of sponsors that helped fund the event: