Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 24
Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 10

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to create reports by retrieving data from SQL Server Analysis Services cubes.   This session will cover setup and layout fundamentals, but will primarily focus on using the Analysis Services MDX Query Designer in both Design and Query modes to meet common reporting requirements.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 10

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 3

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can't promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 10

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 3

Level: Advanced

Session Code:

Date: April 10

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 databases that grow to become very large databases (VLDB).  From hardware configurations (IO, CPU, RAM) to database and index design and partitioning strategies, we will examine which solutions and strategies help and which ones hinder our database on its road to recovery.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will walk through several real life examples of how SQL Server Integration Services (SSIS) was used to meet some interesting requirements quite easily that might have otherwise been difficult for a DBA to accomplish.  Along the way, we will offer up some tips, tricks, and best practices found to be useful by a DBA that has worked extensively with SSIS for over four years. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Everything I wish someone had told me when I started with SQL Server years ago. An overview of using profiler to capture events Clustered, non clustered, covering indexes, looking at query plans (rid lookup, key lookup, scans vs seeks) When to use a table variable vs temp table
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server 2008 was released to much fanfare, excitement and anticipation.  The bevy of enhancements made to the various components coupled with sweeping performance gains made SQL Server 2008 one of the most competitive and feature-rich database platforms on the market.  In this session, we will examine the enhancements made to Reporting Services in SQL Server 2008 as well as what changes to expect in R2 slated for release in early 2010.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

After an overview of partitioning and how to set up partition functions & schemes we'll take a look at how to load data and instantly switch it into production without significant impact to your database availability.
Topics covered:
Partition Functions & Schemes
Creating partitioned tables
The $partition function
Switch Statement
and system tables for viewing partition information
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation Steve Wright will discuss methods used to manage memory in SQL Server Analysis Services, focusing primarily on memory limits and preallocation.  He will also present some examples from the field of performance issues due to mis-configuration, how they were identified, and ultimately resolved.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Many of today’s business applications feature dozens of interfaces feeding a central database.  Interface source-to-target mapping is now common practice, but if there are many interfaces how do you make sure the work of separate teams on tight timelines dovetails smoothly and avoids the all too common death march of correction and rework?
This presentation shows how normalized metadata can help coordinate team efforts, recording data requirements, the target data model, interface sources, source to target mappings, and relationships among analysis components, and enable an effective division of labor that promotes team efficiency, improves planning, and provides the best possible product for developers and testers.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Change Data Capture (CDC) is one of the very best features of SQL Server 2008. It's is easy to set up and it essentially makes the transaction logs for your databases both persistent and queryable. Versioning your data has never been easier. But there are dozens of tools for tuning and reporting on CDC that are either undocumented or "loosely" documented by Microsoft. During this session, Brock will show you 20 tips and tricks for making your CDC implementations much richer and easier to maintain.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will provide an introduction to the spatial data capabilities that were introduced in SQL Server 2008.  We will examine the spatial data types and indexes.  Then we will look at how to work with these data types, including loading data, querying spatial data, and generating reports with spatial data.  We will also discuss interacting with spatial data types from a .Net application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide an overview of Service Brokers, which provides asynchronous messaging capabilities in the SQL Server environment. We will discuss when it is appropriate to use service brokers as well as how to create and manage them. During the session we will build a simple service broker implementation so we can see brokers in action.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will present the basic design of a data warehouse cube from the Data Source View, through Dimensional Design, Fact Table design and the use of Time Intelligence and basic Calculated measures.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation is about what to expect before you start database design and what to do if you don't get it.  We, as SQL Server Database professionals, apply technology solutions to meet business needs.  The problem is that sometimes we're expected to meet business needs that aren't well defined, or not defined at all.  Attendees will learn about the requirements side of data modeling and how it prepares a database developer to design and build the right solution.  Then, the presentation will cover typical scenarios where critical business definition elements are missing and what the database professional can do make up for the missing requirements pieces and produce a successful result.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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