Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 14
Do you find yourself battling to describe the difference between a clustered and a non-clustered index. Do you struggle with unhappy users and bad performance. Do you want to know how to identify missing indexes or duplicate indexes? Indexes are a vital cog in the SQL Server engine and getting them right is one of the best performance tuning techniques available. A simple index can make the difference between a sub-second result or waiting 30 minutes for data. A simple index can also make the difference between happy and unhappy users. So what are indexes exactly and why do they make my life so much easier? Find out here.
Speaker:

Session Type:
Regular Session

Track:
Auditorium 3

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Creating a Federated Sql Database in Azure can allow your data to scale out as it grows. Session will primarily be demos cover Setting up and configuring a Federated Sql Database in Azure as well as how to monitor growth of federations and how to split federations. Will also cover some limitations and disadvantages that need to be taken into consideration when deciding if using a Federated Sql Database is suitable for your business. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 2

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some 
In this session we’ll look at
•	Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption
•	Best practices for handling a database that you suspect may be corrupted
•	Actions that can worsen the problem
•	Appropriate steps to take and methods of recovery
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 3

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

When you think of SQL Server, the first thing you think about is probably not SQL as host for messaging / queuing applications. However, in certain scenarios it definitely makes sense to implement messaging inside the SQL engine. In this session we will see the benefits of messaging applications inside SQL as well as what options you have when implementing it and their respective performance implications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 3

Level: Advanced

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will look at how you can easily get started with your first tabular cube. We will importing multiple data sources and creating relationships between them. This data will then be enriched through the use of calculated columns, and custom calculations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 1

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL server 2012 functions and techniques you wish you knew about before writing that 1000 line UDF.
In this session we will explore some interesting and useful tips,tricks, functions and DMVs.
Speaker:

Session Type:
Regular Session

Track:
Breakout room

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Overview and introduction to Microsoft's latest self-service BI offering - PowerBI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduction to the PDW: Gary Hope and Laura Kotlinksi
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 1

Level: Advanced

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This Session is an introduction to Master Data Services and the role it can play in Data Management and Data Warehouse. 
Session Highlights:
* Managing Slowly Changing Dimensions (SCD)
* Managing Hierarchies relationships
* managing Version control etc...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

With a wide variety of products & services, Microsoft has really changed the game with their new BI capabilities. In this session Greg will take you through Microsoft Business Intelligence (SQL 2012/2014, SharePoint 2013 and Office 2013) providing useful insights into the present and the future of Microsoft Business Intelligence 

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 2

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

in this session I will cover 10 mistakes I see developers make on a regular basis. sometimes simple to fix other times just plain stupid.
Speaker:

Session Type:
Regular Session

Track:
Auditorium 1

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

The Microsoft "Big Data" and "In Memory" Data Management Story.

A 360' view of Microsoft's latest investments in scale out, unstructured and high speed transaction processing technologies that form the new Microsoft Data Platform (including PDW, Polybase, HDInsight and Hekaton)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 1

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

“Column dbo.xyz' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.” Seen it; fixed it, but can we explain why we’re getting a syntax in the first place? The optimizer must follow a very specific hierarchy in order to generate a plan. When you understand the hierarchy, then you better understand the behavior of the optimizer.
 
This all-demo session will explain the logical processing hierarchy, giving you the foundation knowledge you need to build well-structured queries that keep the optimizer happy. Learn how the FROM clause is processed, why a calculated column’s alias can’t be addressed in the JOIN, why WHERE isn’t the only filter, and why NULL confuses everything. When you leave, you will think very differently about how you build your queries, and the query optimizer will love you for learning to speak its language.
Speaker:

Session Type:
Regular Session

Track:
Breakout room

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Azure SQL Database is a fully-managed, scalable service based on SQL Server technology. It is also a shared-environment service which means that you can’t and shouldn’t avoid best practices when it comes to query tuning. Microsoft has put mechanisms in place to ensure that your queries and processes don’t use up too many resources which could seriously impact performance of not only your database, but the database of other organizations as well. This demo-filled session will look at tools and options available to help identify poor performing queries, such as dynamic management views. This session will help identify problem queries and help you understand why a query is running slow through execution plans and other tools in the SQL Database Portal. Ultimately, you will be enabled to find and fix your poorly performing queries and do it all in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Auditorium 3

Level: Advanced

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 14
Back to Top