Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
SharePoint 2010 offers the elusive single sign-on solution to the Microsoft BI stack.  On the edge of new authorization schemes in the Enterprise, SharePoint 2010 offers a single sign-on solution via SAML Claim authentication.  In this session we will run through configuring SharePoint 2010 for SAML Claims authentication using ADFS 2.0 as an Identity Provider.  We will also demonstrate one solution for using Reporting Services 2008 R2 in this solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-1

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server Analysis Services is the semantic layer in the Microsoft BI technology platform that allows users to see and interact with their information in a faster and more dynamic way compared to static reports. Analysis Services provides business users the ability to perform analysis and mine their Data to understand and uncover business issues/drivers leading to better decisions and new business opportunities. In this presentation we take a look at buidling your first Analysis Services cube and using cubes to answer questions at the speed of thought.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document.   In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.” 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data?  There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help.  This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs.
  The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Creating individual SSIS Packages for individual business-to-business data files is not only time consuming, but becomes a maintenance nightmare.  This presentation will show you how to create a single SSIS package that can generate varying length and formatted text files.  By utilizing stored procedures and executing dynamic T-SQL you will see how the time from specification to file delivery can be greatly reduced and simplified.  Additional areas we will cover include the support tables to control file run times, creating file variables at run time, and how to report file success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Often, as DBAs, we are presented with the prospect of resolving performance issues. Consider when Bob the Developer shows up accusing the server of inadequacies and expecting resolution. After hours digging through log files and traces and you are able to identify code that Bob deployed that was the root of the problem. What if there was a way to do this type of performance tuning before Bob the Developer shows up and before Sue the User figures out there are performance issues? In this session we’ll take a look at Extended Events and how you can leverage it in every day scenarios. We’ll discuss the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to understand the information. 
Speaker:

Session Type:
Regular Session

Track:
DBA-2

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Start with a simple proposition: a process is either working or waiting.  You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting - a lock, memory, disk, CPU, and much more.  When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems - and proving the changes worked.  After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases.  Stop guessing, start knowing!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA-1

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

A comparison of SQL HA & DR options, by a practitioner who has implemented & managed pretty much every SQL HA and DR approach (& various combinations thereof). Tim is an operational SQL DBA, charged with keeping SQL servers up & running & optimized, for managed-services customers. We will compare trade-offs between the various SQL HA & DR options: for complexity, usability, hardware requirements, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.
Speaker:

Session Type:
Regular Session

Track:
DBA-1

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Report Models can be a great way to empower your end users to create their own reports through a drag and drop tool. This presentation will discuss how to create, maintain and secure SSRS Report Models. Although the focus is on implementation, we will use Report Builder 3.0 to demonstrate report model consumption. We will also cover some tips and tricks learned through real-world experience implementing and supporting report models for clients.
Speaker:

Session Type:
Regular Session

Track:
BI-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-1

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Transactional replication: if you're like most who I've met that are tasked with supporting it, it can appear somewhat mystical.  There are many (many, many) configurable options for each step in the process, which can make the whole topic daunting.  In this session, we'll be setting up a simple topology from scratch and talk about what you should be mindful of and what you should save for further study.
Speaker:

Session Type:
Regular Session

Track:
DBA-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many different pieces in the Microsoft BI toolset. In this session, we will take a look at all of the different pieces and utilize each of them to create a unified dashboard, where each component is being leveraged. The tools that will be utilized during this session will include SQL Server 2008, SSRS 2008, SSAS 2008, Excel 2007, Excel Services, PPS 2007, Dashboard Designer, SharePoint Server 2007 and possibly more. Goals - (1) Understanding all of the Microsoft BI components (2)  Learn how all of the Microsoft components can work together (3) Provide insight and tips/tricks on leveraging the Microsoft tools 
Speaker:

Session Type:
Regular Session

Track:
BI-1

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Maintenance plans fail - often with no fanfare or warning. Without dependable maintenance plans you can end up with no backups when disaster strikes.    

In this session we will dig into real-world examples of how maintenance plans break and and how to fix them.  We'll also identify the contributing factors that play a part in these failures.  Armed with this knowledge, you'll get sent off with specific tips and general principles you can use to make your Maintenance Plan jobs as dependable as they can be. 
Speaker:

Session Type:
Regular Session

Track:
DBA-1

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This discussion addresses operational questions about using "SQL in the cloud" -- Questions like:  Just what is SQL Azure?  Where does it make sense  to use it (or not)?  HOW do I use it?  How do I get stuff in and out of it? How much does it really cost?  How do I manage it?  The session covers SQL Azure "how-to" and "why" questions from the viewpoint of operational DBA's and system architects (vs. developers).
Speaker:

Session Type:
Regular Session

Track:
DBA-1

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server's resourcing. Lastly, discover SQL Server 2008 features that will make SSIS more efficient.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-1

Level: Advanced

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with some SMO to not only be proactive, but productive in monitoring the servers in your environment. Attendees will come away from the session with an understanding of how to read the SQL and Server event logs, check backups, find which servers have pending reboots and more. In order to get the most out of this session, it is suggested that those attending have a basic knowledge of Powershell or another administrative scripting language.
Speaker:

Session Type:
Regular Session

Track:
DBA-2

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Data is the core of why we build systems and solutions and look for opportunities to automate and simplify. What are the options and when do you make the tradeoffs? In this session, we look at what's new with the Microsoft ADO.NET Entity Framework and explain how it works with Windows Communication Foundation (WCF), Representational State Transfer (REST), and RIA Data Services. We also explore the technologies and the trends that are driving the ADO.NET Entity Framework to see how to take advantage of these new technologies.
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query 
every time by utilizing response time analysis and SQL Diagramming techniques.  Regardless of the complexity of the statement or 
database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct 
tuning path with no guessing.  If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA-2

Level: Beginner

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data.  This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well.  
Speaker:

Session Type:
Regular Session

Track:
BI-2

Level: Intermedia

Session Code:

Date: October 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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