Nr: 384
SQLSaturday #384 - Varna 2015
SessionID: 20325
Keynote
Event Date: 30-05-2015 - Session time: 09:00:00 - Track: A
Speaker: Mihail Mateev
Title: Keynote
Abstract:
Keynote and opening
SessionID: 10612
Building Great Business Intelligence Semantic Models for Power View
Event Date: 30-05-2015 - Session time: 10:15:00 - Track: C
Speaker: Boriana Petrova
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.
SessionID: 13799
Memory-Optimized tables - Querying at the speed of light
Event Date: 30-05-2015 - Session time: 10:15:00 - Track: B
Speaker: Enrico van de Laar
Title: Memory-Optimized tables - Querying at the speed of light
Abstract:
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!
SessionID: 31541
Find and tune those queries!
Event Date: 30-05-2015 - Session time: 10:15:00 - Track: A
Speaker: Margarita Naumova
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.
SessionID: 13545
SQL Server Power BI Geographic and Temporal Predictions
Event Date: 30-05-2015 - Session time: 11:30:00 - Track: A
Speaker: Dejan Sarka
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.
SessionID: 17856
Managing 999 MS SQL Servers
Event Date: 30-05-2015 - Session time: 11:30:00 - Track: C
Speaker: Kaloyan Kosev
Title: Managing 999 MS SQL Servers
Abstract:
SessionID: 36305
Event Date: 30-05-2015 - Session time: 11:30:00 - Track: B
Speaker: Sylvia Takvorian
Abstract:
SessionID: 15273
SQL Server Advanced indexing techniques
Event Date: 30-05-2015 - Session time: 13:15:00 - Track: A
Speaker: Ivan Donev
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.
SessionID: 19686
Event Date: 30-05-2015 - Session time: 13:15:00 - Track: B
Speaker: Markus Ehrenmueller-Jensen
Abstract:
SessionID: 20815
Extended events in action
Event Date: 30-05-2015 - Session time: 13:15:00 - Track: C
Speaker: Miroslav Dimitrov
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
SessionID: 13133
Deadlocks. Everything that developer needs to know.
Event Date: 30-05-2015 - Session time: 14:30:00 - Track: A
Speaker: Denis Reznik
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.
SessionID: 15762
Introduction to SQL Server high availability solutions
Event Date: 30-05-2015 - Session time: 14:30:00 - Track: B
Speaker: Janos Berke
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
SessionID: 23449
MS-SQL Basic Features
Event Date: 30-05-2015 - Session time: 14:30:00 - Track: C
Speaker: Rosen Kolev
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.
SessionID: 17931
Data quality with DQS components in Integration Services
Event Date: 30-05-2015 - Session time: 16:00:00 - Track: B
Speaker: Alexander Karl
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.
SessionID: 18821
BIML – the best friend of SSIS developers
Event Date: 30-05-2015 - Session time: 16:00:00 - Track: C
Speaker: Andrey Korshikov
Title: BIML – the best friend of SSIS developers
Abstract:
SessionID: 25043
Lets cook SQL Server Management practices for the Non-DBA
Event Date: 30-05-2015 - Session time: 16:00:00 - Track: A
Speaker: Satya Jayanty
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.
SessionID: 10938
The nightmare of locking, blocking and isolation levels!
Event Date: 30-05-2015 - Session time: 17:15:00 - Track: A
Speaker: Boris Hristov
Title: The nightmare of locking, blocking and isolation levels!
Abstract:
SessionID: 30047
Transactional replication. It's not scary.
Event Date: 30-05-2015 - Session time: 17:15:00 - Track: C
Speaker: Evgeny Khabarov
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.
SessionID: 36304
How to Forecast in C# with ADOMD and TimeSeries
Event Date: 30-05-2015 - Session time: 17:15:00 - Track: B
Speaker: Daniel Joskovski
Title: How to Forecast in C# with ADOMD and TimeSeries
Abstract: