Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 31
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data! 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot of database professionals today  do not have a Computer-Science Degree  so they never attended a  “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific  join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions.  The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions.  The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be.
There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be.
There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and "involuntary" DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring  maintenance on their servers, and handle some of the common issues these tasks present
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This 400 (or maybe 500) level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way.
Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. 
In this session, I will explain some of Tufte's most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don't have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand.  You just have to know that a Tally Table is involved somewhere in this. ;-)
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you buidling systems to monitor and analyze mountains of data, and querying that from the typical relational database just isn't cutting it? Well, my friend, StreamInsight might just be the ticket for you! StreamInsight is Microsoft's platform for building high throughput, low-latency complex event processing (CEPs) systems. In this session, we will delve into what StreamInsight is and how to use it along with other entities such as Analysis Services and Integration Services to provide you big data customers the operational intelligence solutions that they deserve! 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a powerful and east to use data Extract, Transform, Load (ETL) tool SSIS providing a rich set of components to perform the most common ETL tasks with “drag-and-drop” ease. Packages can be constructed with rigorous error and exception handling as well as verbose logging allowing deployment of robust ETL processes.. This session will demonstrate a process for loading a comma-delimited data file into a staging table for further processing then validating the data and moving specific data into host tables using a a thorough example of a non-trivial ETL project with “real” data. The intended audience includes beginning SSIS developers, DBAs, and anyone with a desire to experience the magic of data management with this remarkable tool. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wondered how to scale Analysis Services across the globe? 

This session will cover a unique approach to load balancing SQL Server Analysis services using a unique approach created by Carl Rabler and Josh Caplan to load balance SQL Server Analysis services using features already built in to SQL Server Analysis Services and some standard Microsoft technologies. 

Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Advanced

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It's enough to drive a lesser DBA crazy-insane.  That's why it's important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can't control.  In this session Tim will go over many of performance-enhancing methods he's developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to create snazzy reports to impress the boss but aren't a BI expert?  Don't climb the clock tower just yet, go get yourself PowerPivot 2012 and come to my session.  We'll go over some very real world issues and ways PowerPivot can help solve it.  Demos will be jam packed with many of the new features in 2012 at same time giving you a good base to get you started.  And this session wouldn't be complete without covering BISM.  We will definitely will cover how the BI world is all coming together as one to have hold and cherish in the BI Semantic Model. 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: September 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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