Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 55
Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won't ever need to show a plain, boring report again!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 9

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 9

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are new to the role of DBA, being "forced" to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the "itties" of Database Administration (Recoverability, Availability - Health & Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the "itties" of Database Administration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Most administrative functions consist of repetitive sequences of tasks which just take time.  PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time.  This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.
Speaker:

Session Type:
Regular Session

Track:
Track 8

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn to write (or at least recognize) T-SQL code that consumes hundreds of times more I/O and CPU Resources than optimal code.  More importantly, see what the optimal counterpart looks like.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will use the features of the PowerPivot add-in for Excel to import data from various sources, cleanse and prepare the data for analysis and finally use the data to build complex reports and publish. We will also take a look at Data Analysis Expressions (DAX) and how to use them to extend the functionality of the model and the reports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Since SQL Server 2000 we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server.  More specifically these are the File & Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL 2008 currently has over 480 events so far. This session will show you how to efficiently capture and analyze the information provided by a set of DMV’s in SQL Server 2005 & SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This sessions provides a high level overview and comparison of various Microsoft SQL Server Replication technologies including 1) Snapshot, 2) Change Tracking, 3) Change Data Capture, 4) Transactional, 5) Peer-2-Peer, 6) Merge Replication, 7) Web Sync, 8) Sync Services.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover the different forms of compression in SQL 2008, Backup and Data compression. The session will also explore best practices and how to overcome some of the limitations within the different compression technologies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server, Integration Services, and Analysis Services are used together to deliver BI solutions but development efforts are carried out separately, without sharing of metadata between the products. This creates duplicate effort and compromises the ability to develop agile, iterative solutions.  Vulcan is an open source project from Microsoft (http://vulcan.codeplex.code) that helps bridge this gap, while also providing many of the benefits of code focused approaches used in application development. It allows you to define the relational data marts, ETL, and OLAP cube portions of your BI solution in a common language, and seamlessly uses that information to generate the appropriate database schemas, SSIS packages, and SSAS cubes.          
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 9

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

If you never click on the estimated/actual query plan icons because it looks like a foreign language to you AND you want your queries to really run fast...  This session is for you.  Starting from the beginning, we'll go through the key things to look for when reviewing your queries' estimated and actual plans.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Evan will show you how to diagnose and solve common connectivity issues.  This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers.  He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Advanced

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow, steady rate. Then next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you're coworkers are running in circles screaming for their lives. In this session, we will examine best practices to apply to reporting databases that grow to become much larger than expected.  We will examine a real-world scenario and discuss the strategies and techniques implemented in order to get the database back on track.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot (project Gemini) introduces an innovative platform for self-service analysis. In this session, we will very briefly look at the user-facing features and functionality of PowerPivot before we dive deep into a behind-the-scenes look at PowerPivot, understand limitations and finally drill into some best practices and lessons learnt from actual customer implementations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you already have a SharePoint implementation and now you need reporting capabilities?  Attend this session to learn about incorporating SQL Server Reporting Services into your existing SharePoint installation.  We will discuss the reasons why you would want to do this, and how to install, use, and access SSRS reports from SharePoint.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 9

Level: Beginner

Session Code:

Date: March 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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