Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 40
The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.
Speaker:

Session Type:
Regular Session

Track:
Room 217

Level: Advanced

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Take this time to ask all the experts any questions you have.  This will also be our raffle time so make sure you attend for your chance to win some awesome prizes from our awesome sponsors
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 116

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment.  PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems.  This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.
Speaker:

Session Type:
Regular Session

Track:
Room 214

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

What does the Bulk Logged recovery model really mean anyway?  Backup and Recovery are two of the most crucial functions a DBA can perform, however they’re also some of the least understood.  We’ll bust some myths and take a good look at how backups & restores really work including a comparison of recovery models, important facts about the transaction log, and tips & tricks for enhancing performance.
Speaker:

Session Type:
Regular Session

Track:
Room 216

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs
Speaker:

Session Type:
Regular Session

Track:
Room 116

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will showcase how to create custom hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will also learn how to optimize SSAS hierarchies by specifying the right cardinality option, relationship type,  and member uniquenes properties.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 215

Level: Advanced

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Building your first Data Warehouse is a long, and often difficult process. How can you get your boss to approve a Data Warehouse project? What’s the best way to explain dimensional modeling and the benefits of a Data Warehouse to a business person? What are the best/most cost effective ways of learning it? What kind of materials, hardware, software, etc do you need? What’s the best way to build a proof of concept that will impress your boss, as rapidly as possible?

Come to this presentation, and I’ll answer all of these questions plus the most important question of all. 

“Is this good for the company?” Absolutely. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 217

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 215

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone H.A. tool for over 5 years. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
Speaker:

Session Type:
Regular Session

Track:
Room 118

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have the need for data-driven subscriptions, but no room in the budget to buy Enterprise Edition? If so, this session is for you.  We'll cover how you can deliver reports, by both file share and e-mail, on a limitless number of schedules, all using one simple package.
Speaker:

Session Type:
Regular Session

Track:
Room 117

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 117

Level: Advanced

Session Code:

Date: March 26

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:

Session Type:
Regular Session

Track:
Room 216

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

There's a lot that goes on under the covers of SQL Server with your indexes.  But it's not as secretive as you might think.  Most of this information is made available to you through DMVs.  While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on.  In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 215

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Most DBA's have heard of indexes, but not everyone understands how they work.  In this in-depth session, Michelle will cover the internals of indexes, including index filtering and partitioning.  She'll compare the B-trees of different index types, explain fragmentation, and use undocumented commands to show you what an actual index page looks like.  Attendees will walk away with a much better understanding of indexes, which is helpful when designing and tuning databases.  If you've ever wondered just *what* goes on in an index, this is the session for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 117

Level: Intermedia

Session Code:

Date: March 26

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:
Room 118

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn!
Speaker:

Session Type:
Regular Session

Track:
Room 116

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have!  
Speaker:

Session Type:
Regular Session

Track:
Room 218

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

BI data store mostly serves scan-centric operations. As such, it is important to minimize fragmentation during data loading process.

I will demonstrate ways to look at fragmentation and how to best avoid them while achieving fast data loading process. BCP, partitions, partition switch, and verifications will be discussed and demonstrated in having data tightly packed with 0 to minimal fragmentation.
Speaker:

Session Type:
Regular Session

Track:
Room 117

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 214

Level: Intermedia

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.
Speaker:

Session Type:
Regular Session

Track:
Room 215

Level: Beginner

Session Code:

Date: March 26

Time: 12:00 AM - 1:00 AM

Room: TBD

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