Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 12
Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad execution plan? How do you identify one in your system and, once identified how do you go about fixing it?

In this session we’ll look at some things that make a plan ‘bad’, how you might detect such plans and various methods of fixing the problem, both immediately and long-term. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

An overview of building a Data Warehouse using SQL 2012 SSIS (SQL Server Integration Services), DQS (Data Quality Services) and MDS (Master Data Services)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Many companies take data for granted, and see it as a liability instead of an asset. In this session we will discuss some of the elements of how you can start to measure the “cost” of your data and if that data was lost what would it cost the company to recover. Your companies data must be a measurable asset.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Virtual/remote

Level: Intermedia

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

How does one load a large fact table in a Data Warehouse, when the source system can deliver any chunk of the data at any given time? This session will show how to handle this by using layered partitioning. We will walk through table partitioning, partitioned views, and layered partitioning, as well as go through the management and performance benefits (and challenges) partitioning gives us.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Pivot is an amazing tool for mashing up data from a variety of sources ~ in this session, we will combine data from NASA, OpenGOV, and other publicly available sources, as well as from a prebuilt cube, to show the power of user driven analysis, and visualisation in Excel.
Using DAX, you will see how to create time-intelligence driven visualisations, and then dive into the new enhancements for the date table, relationshios, perspectives and KPIs.
As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as Performance Point and Crescent (PowerView)
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide you with the knowledge to effectivelly perform DBA functions with powershell
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SharePoint is to be hosted on your SQL farm... Now what?

In this session, we will cover some need to know for  SQL administrators who are now responsible for SharePoint's DBs.  
In our journey, topics we will cover will be from, Farm sizing's & architecture considerations for SQL , Enterprise Search considerations for crawling public drives, followed by the myriad of SharePoint Databases and which to watch out for.
Also touch on maintenance plans and health analyser rules. 
And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU & RAM.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation.  By session's end you should have a clear overview of what happens when a query hits your server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Virtual/remote

Level: Beginner

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

How is it possible to aggregate 12,000,000 records of sales data in a short time window? In this presentation you will learn the techniques used to make this possible. These include workload distribution, pipeline elimination and thread management.
Speaker:

Session Type:
Regular Session

Track:
Virtual/remote

Level: Advanced

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL server 2012 brings many new features to integration services, the biggest of which has to be the new package deployment model. In this session we will look at how BI developers can use SSDT to develop data integration packages using many of the new features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to find out the changes to existing windowing functions, and the new windowing functions that have been added.
Speaker:

Session Type:
Regular Session

Track:
Virtual/remote

Level: Intermedia

Session Code:

Date: May 05

Time: 12:00 AM - 1:00 AM

Room: TBD

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