Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 28
“Hasta la vista, Profiler.”  – Introduction into Tracing with Extended Events. Focus: historical deadlock Analysis. - 
Extended Events, although in the product since SQL Server 2008 have been known to Insiders as an extremely well performing and flexible Tracing-Framework. Since SQL Server 2012 this important feature, which will replace SQL Trace, is available in SSMS.
In this introductory to advanced session we will also especially have a look at the System Health Session and how it can be used for historical deadlock-analysis right out of the box. („Hasta la vista, Profiler. Hasta la vista Traceflags 1204, 1222“)
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

A DBA running SQL Server 2008 or above will often think he has no alternative to shared storage in order to run High availability Clustering in terms of both performance as well High Availability. Understand if it is worth trading high latency Shared Storage with low Price/GB to Local, Low latency OS integrated NAND Flash with high price/GB by trading Host Memory and CPU cycles for I/O Using NAND Flash from Fusion-io  Also, is there a potential License saving by running lower latency I/O and reducing CPU count?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

The aim of this session is to take the audience in a quest for the original (or equivalent) T-SQL, that was in the origin of the different transactions recorded, by inspecting the transaction log records and dissecting its data. In a session that tackles several internals storage issues, needed to fulfill its objective, we will go in a travel that starts by the end of the log and will, hopefully, only end at the birth of the database.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

You have migrated your SQL Server database to Windows Azure SQL Database (AKA SQL Azure), and you have migrated your application to Windows Azure. Now what? As the load on your database begins to increase, the need to scale your new SQL Database instance becomes a realization. In this demo-filled session we'll explore SQL Federation, Microsoft's solution for cloud database scalability. This session will look at the scalability model for the cloud and how SQL Federation solves the scale-out issue. We'll look at the architecture of SQL Federation and you can apply SQL Federation to your cloud database solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be an introduction to options available in Analysis Services for data mining. We will discuss Data mining project life-cycle (CRISP-DM), Target variables (categorical vs continuous), What models are available in SSAS and a bit on configuring them, Model viewing, Model evaluation , What is a categorization matrix and gain chart? DMX langauge and integration to SQL Studio and SSIS
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development. In this session we'll dive into Online and Offline development as well as the Productivity and tools that the SSDT team keeps providing to us.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services provides data-driven subscriptions to render reports based on information in a database table. This is a very nice feature but the down side is that you are required to purchase an Enterprise license (or BI license in SQL 2012) of SQL Server in order to use this feature. Customers like this feature but don't want to pay for the Enterprise license so I searched for an alternative with standard licenses. In this session I will show the alternative where the end user can still create his own subscription in SharePoint. Step-by-step  I will create an SQL Server Integration Services package that renders reports to a SharePoint library on values stored in the database.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Decision-trees are the bread-and-butter of predictive modeling. Conceptually simple, fast to build and easy to interpret - yet quite powerful and versatile. They come in many flavors, from the smallest tree to vast (random) forests
This session will explain the basics of decision trees and demonstrate the process of building, interpreting, tuning, pruning and validating a simple model using the Data Mining components of SQL Server Analysis Services.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

See how you can implement a Metro Style Dashboard in Excel based on a PowerPivot model in excel and how to make it dynamic with the Excel CUBE functions.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

I know what you're thinking, Powershell is not an ETL tool. And you're probably right.
But I keep running into weird requests that were just easier to fix with Powershell.
I'll show you why some things are not easy in SSIS. 
I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did.
This session will be around 70% "why is this hard in SSIS and can you work around it?"  and 30% "Look how cool Powershell is"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use.  That feature is the Microsoft SQL Server Service Broker.  The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing.  We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting (as time allows).
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Loading and managing large data sets in your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

So your CTO wants you to migrate your mission critical database application to the cloud. What's involved and what are the pitfalls?

In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:

- investigate Power View based on current cognitive research around Data Visualisation principles
- look at the features of Power View
- look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack

Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes you really need an EAV model. In most cases they are ugly and slow.
After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.

There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

 Secure, Enable, Maintain, Sustain.   In depth discussion on a SSAS security framework with SSIS maintenance toolkits.   Create security roles in the cube that enable the business based on underlying data patterns.   Presentation covers creation of roles in the cube, with a demo creating SSIS roles with a toolkit based on the adventureworks db model and cube.   Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports.   This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use 
advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data 
from Windows Azure SQL Database Spatial, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure SQL Database Spatial and will create a several sample Windows Azure applications, that use this data.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 20

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:
Track 4

Level: Advanced

Session Code:

Date: April 20

Time: 12:00 AM - 1:00 AM

Room: TBD

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