Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 25
When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.
Speaker:

Session Type:
Regular Session

Track:
A - Administration

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

You have worked with SQL Server Integration Services (SSIS) for a few years, but would like to know what is happening behind the scene. Join this session to get a deep dive into the internals of SSIS, and find out what is happening when your packages are executed. You will learn about the data flow engine, what buffers are used for, how the different transformations behave, and what execution trees are and why they are important.

Understanding the SSIS internals is not only very interesting in itself, but will also make you able to respond to design and performance problems – as well as solve them.
Speaker:

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Query allows users to incorporate public data and organizational data seamlessly in Excel. The purpose of this session is to take a deeper dive into the capabilities of Power Query and of the "M" language.
The more I use Power Query and the M language that underpins it, the more I see how useful it is – quite apart from its abilities to import data from other data sources – as a third option to solve problems in Excel itself. Furthermore it provides a simple interface over the data transformation engine (powered by M), and it has become a tool of choice anytime I need to get data into Excel. 
In this demo-driven session I will show how you can use Power Query to do some initial data shaping, visualize, and then automate the data loading process through SSIS.
Speaker:

Session Type:
Regular Session

Track:
C - Cloud

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker:

Session Type:
Regular Session

Track:
D - Development

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing.  You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes.  We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes.  There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
A - Administration

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The process of entering data into corporate dictionary is not as simple as you can see at the first glance. Just imagine the process of collection information about the new retail store. It starts from discovering the possible place, then estimating the size, format and revenue, making a decision to buy or rent this place and so on. At the end you have to liquidate the goods remained unsold, reassign you workers to another store, demount all equipment, close accounts, etc.  This process may involve 5, 10 and even 20 different workers who collect and enter different pieces of information about a retail store.
At this session we will talk about the approaches of creating a master data management solution and take a look at the implementation with the services of Microsoft SQL Server 2012.
Speaker:

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Opening and Keynote
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
D - Development

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can't optimize our BI solutions with this new feature.  
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process. 
The session will use the latest CTP release and is constantly updated to include the latest news on the topic.
Speaker:

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will describe how to prepare a tabular data model (PowerPivot or Tabular Project) to fully exploit the reporting capabilities of Power View. Theory and demonstrations will describe why and how to configure the Reporting Properties, and how to enable images to surface within Power View reports.
Speaker:

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Product-Demo: cubido
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Product-Demo: Idera
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
A - Administration

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Product-Demo: MelissaData
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
D - Development

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there's a feature for that! It's called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!
Speaker:

Session Type:
Regular Session

Track:
A - Administration

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Over the last years Analysis Services has proven its scalability with big data volumes and also with many users. Those high-end solutions are usually very strongly tied to the hardware they are running on. When moving those solutions to the cloud we need to reconsider this whole setup as a single on-premise hardware still outperforms a cloud machine by far. In order to achieve the same overall performance we need to scale out our Analysis Services instances across multiple hosts in the cloud and that's what this session is about.
Speaker:

Session Type:
Regular Session

Track:
C - Cloud

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

With Project Siena Microsoft has introduced a beta release of a new technology for business experts, business analysts, consultants, and other app imagineers. This session will review if Siena is useful for Business analysts. We will show how to combine simple app development (Rapid R Business Intelligence BI Development D) with different data sources from Excel Sheets (Power Query driven) , RSS Feeds, SharePoint Lists or Windows Azure Tables and how to deploy your little app in minutes. We will discuss the use cases of Siena from a BI perspective, what you can do already and what is missing.
Speaker:

Session Type:
Regular Session

Track:
B - Business Intelligence & Big Data

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
D - Development

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Since March 2012, SQL Server Data Tools (SSDT) are available for database developers as a project-based development environment within Visual Studio.

Although SSDT is installed automatically with Visual Studio 2012, this method of database development and the functions provided are completely new to many developers.

This session aims to change that and to provide an overview of the advantages and potentials of SSDT. You will see how you can develop, debug, refactor, deploy and maintain SQL Server and Azure databases from a single IDE.
Speaker:

Session Type:
Regular Session

Track:
D - Development

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.
Speaker:

Session Type:
Regular Session

Track:
C - Cloud

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The session is centered around what was codenamed "Hekaton", the SQL 2014 inMemory OLTP Engine. It Shows an overview of the most critical Feature Areas (from a Migration Point of view), Shows the limitations of those Features and Workarounds where they exist. There will also be a Focus on explaining the reasons and thoughts behind some limitations.
Speaker:

Session Type:
Regular Session

Track:
A - Administration

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Although temporal data is part of many business applications, most RDBMS’, including SQL Server, do not support it out of the box. However, SQL Server provides full infrastructure to build your own temporal data support. After introduction of temporal problems, we are going to develop interval CLR data type that supports validity time. Then we are going to discuss what kind of constraints pertain to temporal data, and how we can implement those constraints. We are going to use T-SQL to develop two very useful temporal operators: PACK and UNPACK. In addition, we are going to introduce the proposed sixth normal form that deals with temporal data, and show how you can implement it correctly.
Speaker:

Session Type:
Regular Session

Track:
D - Development

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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