Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 19
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:

Session Type:
Regular Session

Track:
C

Level: Beginner

Session Code:

Date: May 30

Time: 4:00 PM - 5:00 PM

Room: C

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:

Session Type:
Regular Session

Track:
B

Level: Intermedia

Session Code:

Date: May 30

Time: 1:15 PM - 2:15 PM

Room: B

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
C

Level: Intermedia

Session Code:

Date: May 30

Time: 10:15 AM - 11:15 AM

Room: C

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:

Session Type:
Regular Session

Track:
B

Level: Intermedia

Session Code:

Date: May 30

Time: 4:00 PM - 5:00 PM

Room: B

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:

Session Type:
Regular Session

Track:
A

Level: Advanced

Session Code:

Date: May 30

Time: 2:30 PM - 3:30 PM

Room: A

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:

Session Type:
Regular Session

Track:
C

Level: Intermedia

Session Code:

Date: May 30

Time: 1:15 PM - 2:15 PM

Room: C

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
A

Level: Advanced

Session Code:

Date: May 30

Time: 10:15 AM - 11:15 AM

Room: A

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
B

Level: Advanced

Session Code:

Date: May 30

Time: 5:15 PM - 6:15 PM

Room: B

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
B

Level: Beginner

Session Code:

Date: May 30

Time: 2:30 PM - 3:30 PM

Room: B

Keynote and opening
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
A

Level: Intermedia

Session Code:

Date: May 30

Time: 9:00 AM - 10:00 AM

Room: A

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
A

Level: Beginner

Session Code: TBA

Date: May 30

Time: 4:00 PM - 5:00 PM

Room: A

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
C

Level: Intermedia

Session Code:

Date: May 30

Time: 11:30 AM - 12:30 PM

Room: C

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:

Session Type:
Regular Session

Track:
B

Level: Intermedia

Session Code:

Date: May 30

Time: 10:15 AM - 11:15 AM

Room: B

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
C

Level: Beginner

Session Code:

Date: May 30

Time: 2:30 PM - 3:30 PM

Room: C

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:

Session Type:
Regular Session

Track:
A

Level: Advanced

Session Code:

Date: May 30

Time: 11:30 AM - 12:30 PM

Room: A

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:

Session Type:
Regular Session

Track:
A

Level: Advanced

Session Code:

Date: May 30

Time: 1:15 PM - 2:15 PM

Room: A

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:

Session Type:
Regular Session

Track:
B

Level: Intermedia

Session Code:

Date: May 30

Time: 11:30 AM - 12:30 PM

Room: B

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:

Session Type:
Regular Session

Track:
A

Level: Intermedia

Session Code:

Date: May 30

Time: 5:15 PM - 6:15 PM

Room: A

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:

Session Type:
Regular Session

Track:
C

Level: Beginner

Session Code:

Date: May 30

Time: 5:15 PM - 6:15 PM

Room: C

Sessions Found: 19
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids