Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4:Mixed & Azure

Level: Advanced

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation is a walk through in-memory data base and DAX queries for better performance of reporting. We will cover: I. Advantages using In Memory Data Bases and Architecture Examples for better performance using In Memory Data Bases II. Tips and tricks using DAX queries, Describe DAX architecture, DAX vs MDX in SSRS and Best practices for DAX queries III. Best Practices using SSRS with Tabular model, Best practices when using DAX queries in SSRS and Common issues in SSRS and tips and tricks to resolve them.
Speaker:

Session Type:
Regular Session

Track:
3:BI

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media.
Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with SQL Server tools.
Speaker:

Session Type:
Regular Session

Track:
3:BI

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

A new feature of SQL Server 2014, Buffer Pool Extension (BPE) promises improvement on OLTP workload like systems, taking advantage of fast persistent disks.
On this session we will enter in some theoretical details regarding this new technology, as well as some demos.
Speaker:

Session Type:
Regular Session

Track:
2:DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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:
5:Mixed & OSS

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

A data warehouse is a database designed for query and analysis rather than for transaction processing. An appropriate design leads to scalable, balanced and flexible architecture that is capable to meet both present and long-term future needs. This session covers a comparison of the main data warehouse architectures together with best practices for the logical and physical design that support staging, load and querying.
Join this session to learn various architectural approaches our team evaluated for a 50’000+ hours EU project.
Speaker:

Session Type:
Regular Session

Track:
3:BI

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

You are a Windows Phone developer or just a mobile developer and you need locally a database, what are your options? What you can do, what you cannot do, and how? How cloud is changing this story?  With focus on Windows Phone (the easiest to demo, but not ignoring the “others”) these are a few of the questions this presentation will try to answer. Of course all with as much demoes and code as possible.
Speaker:

Session Type:
Regular Session

Track:
5:Mixed & OSS

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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. Unfortunatelly in 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". So we should deal with them. The algorythm is following: catch, analyze, fix. The most challenging and interesting here is the analysis part. Once you understand why it was occured, you can fix it. In this session we will focus on the analysis of complex,
Speaker:

Session Type:
Regular Session

Track:
1:Development

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

The Columnstore index specification states that a performance gain between 10 and a 100 times should be expected - This demo intensiv session will show you how to get closer to the 100 than 10 times.
In the session I will explain the details of xVelosity engine in generel and the columnstore index in detail and then move on to take a look on the (many) limitations the index has - and how to Work around then so you can get the full performance gain in all types of queries. 
Speaker:

Session Type:
Regular Session

Track:
3:BI

Level: Advanced

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Azure Virtual Machines provide you the capability to have your SQL Server built and configured by your own DBAs, but with a lot of restrictions, that can limit your productivity and performance. In this session we will talk about optimizing SQL Server, running on Windows Azure Virtual Machines so you get out the most performance out of it.
Speaker:

Session Type:
Regular Session

Track:
4:Mixed & Azure

Level: Beginner

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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 pros and cons of Always On Availability Groups, and how does it help to improve high availability and disaster recovery solutions, what's new in SQL Server 2014 regarding the AlwaysOn Availability Groups.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2:DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session covers the Hekaton challenges for the developers at the 300-400 level including native compiled SPs but also some concerns about hekaton constraints etc.
Speaker:

Session Type:
Regular Session

Track:
1:Development

Level: Advanced

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

High availability starts at database design. This session will show how to design your database supporting partial database availability. 
Session agenda is the follwoing:
- What is RPO/RTO?
- What HA options are available?
- Database physical layout basics
- DEMO: files and filegroups
- Multiple filegroups and files
- Filegroup/file restore options
- DEMO: online restore
- DEMO: offline restore (if time permits)



Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2:DBA

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

What has the biggest impact on SQL Server overall performance? Hardware, SQL Server configuration or maybe query tuning? No, none of those frequently discussed options. They are important, but the single, most important factor is the database design.
A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.
Speaker:

Session Type:
Regular Session

Track:
1:Development

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation we will start with description of the Data Mining Process, then we will Introduce the Microsoft Time Series Algorithm for Forecasting. We will explain the blending of two machine learning algorithms for forecasting of continuous values: ARTxp, ARIMA (since Analysis Services 2008) We will demonstrate production of forecast by: Table Analysis Tools Excel Add-In, Client Tools Excel Add-In, SQL Server Data Tools (SSDT) Project. We will finish this presentation by describing business scenarios
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5:Mixed & OSS

Level: Advanced

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a lot of questions about statistics that I receive in my trainings, projects and during my sessions: Why I have to rebuild statistics, if my auto-update stats option in ON. Why I still have bad plans or high CPU usage? Should I disable it or use full scan instead?
We usually rely on auto-update stats database options and sometimes perform a regular stats updates additionally in order to be sure that the QP has an up to date info about our table data. But there are some specific cases when those thinks just don’t help and even recompiling don’t boost the performance of a query. Let me list and explain for you some statistics updates exceptions cases and you will understand how to proper manage your statistics in order to gain max from them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1:Development

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
4:Mixed & Azure

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Quick guide on why you have to be able to work with MySql and how to successfully accomplish this task.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5:Mixed & OSS

Level: Beginner

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

When you are standing in line at the grocery store you know exactly what you’re waiting for, paying the things you intend to buy. In SQL Server things aren’t usually so simple and many times you have to wait for more than only the length of the queue or the speed of the cashier. Thankfully SQL Server gathers the exact time you have been waiting and what resource you have been waiting on. In this session we will take a look at how SQL Server gathers this information and how it can help you identify, troubleshoot and proactively solve performance issues.
Speaker:

Session Type:
Regular Session

Track:
4:Mixed & Azure

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is to all SQL Server and Windows Azure developers, who want to build sclabble applications using Node.js and MS SQLServer / Windows Azure SQL Database.
Node.js came onto the scene four years ago, offering yet another tool for creating server-side software systems that support scalable Internet applications. 
With the continued support from Microsoft for Nodejs on both Windows and Windows Azure, it is bound to reach great levels. Don't worry if you don't know Node.js - this will not be necessary to understand the session.
Speaker:

Session Type:
Regular Session

Track:
5:Mixed & OSS

Level: Intermedia

Session Code:

Date: October 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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