Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
Understanding transaction isolation levels is critical for developing concurrent software as well as administering databases. Unfortunately most of us learn about transaction isolation early in our careers and don't maintain an in-depth knowledge of different isolation levels. This talk will help! We'll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on. This is suitable for developers and DBAs at all levels.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 325

Level: Beginner

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined. 
Speaker:

Session Type:
Regular Session

Track:
Room 315

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

You've got SSAS cubes and they work. Now people are using them and everyone's queries are slow. I'll  cover how to see who's using the cubes, what query they're running. Also, what can we do to make the queries run faster and how to stop bad queries that are hogging system resources. Specifically I'll cover the SSAS DMVs, the SSAS Activity Viewer available from CodePlex that uses theses DMVs. Also the aggregation designer that is available as part of the BIDS  project and how it can be used to speed up queries against the cube database. 
Speaker:

Session Type:
Regular Session

Track:
Room 329

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 330

Level: Beginner

Session Code:

Date: February 05

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 313

Level: Beginner

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2008 provides a great platform for producing Business Intelligence reports.  With the ability to create SSIS packages and SSRS reports, BI can be utilized to provide vital information for running any business.  Learning these skills will help any developer to maximize the full potential of any database application.  In addition, many of the new features in Reporting Services make it easier to provide a rich BI report with little effort.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 329

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2008 once again improves on the classic built-in SQL Server full-text search (FTS) functionality by making FTS more efficient and transparent. In this course attendees will learn both the basics of the new Integrated FTS (iFTS) and how to build user-friendly Google-style search interfaces on top of SQL Server for the benefit of their end users.
Speaker:

Session Type:
Regular Session

Track:
Room 314

Level: Intermedia

Session Code:

Date: February 05

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 325

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

A review of Database Mirroring in the context of operations in the real world. 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 ultra fast upgrades or to move large databases to a different location.
Speaker:

Session Type:
Regular Session

Track:
Room 330

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions.
Speaker:

Session Type:
Regular Session

Track:
Room 329

Level: Intermedia

Session Code:

Date: February 05

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

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards.  Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.
Speaker:

Session Type:
Regular Session

Track:
Room 314

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Starting with Excel 2000, pivot tables have been able to use OLAP cubes as data sources. Since then, Excel has become the most widely adopted OLAP BI client tool for Analysis Services cubes. And new OLAP functionality has been introduced with each successive version of Excel. In this session we'll review Excel OLAP client functionality, survey what's new in Excel 2010 - and see how it all works with Analysis Services 2008 R2.
Speaker:

Session Type:
Regular Session

Track:
Room 329

Level: Beginner

Session Code:

Date: February 05

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 313

Level: Intermedia

Session Code:

Date: February 05

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:

Session Type:
Regular Session

Track:
Room 313

Level: Advanced

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

To begin tuning your system and the queries that run on it, you must begin from a position of knowledge. The knowledge I’m talking about is knowing what is occurring on your systems. What kind of load is the server under? How many times is that stored procedure called? This session will present the basics of gathering and interpreting knowledge about your server and the queries running on it. We’ll cover a variety of topics from performance monitor, to server-side traces, to dynamic management objects. We’ll go over how to set these things up to monitor your system and how to interpret the data returned from them. This session is part of a full day of training which will be presented in May at SQL Rally in Florida.
Speaker:

Session Type:
Regular Session

Track:
Room 330

Level: Intermedia

Session Code:

Date: February 05

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

Level: Beginner

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2008 introduced support for new spatial data features -- providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data.
Speaker:

Session Type:
Regular Session

Track:
Room 325

Level: Intermedia

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Unfortunately, the real world isn't always as cut and dry as third normal form; sometimes things get muddy. What do you do then? This talk will examine the use of NULLs, sparse columns, XML data types, and other ways of storing data with a murky format. This presentation will introduce techniques for common data modeling problems and examine potential patterns and practices for working with flexible data modeling that can be immediately useful in real-world scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 325

Level: Beginner

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Change Data Capture (CDC) is used by data warehouse applications to retrieve Type I and Type II dimension updates. This sessions provides a walk through of Microsoft's newest SQL Replication feature called CDC. Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of Type I and Type II data changes.
Speaker:

Session Type:
Regular Session

Track:
Room 315

Level: Beginner

Session Code:

Date: February 05

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 36
Back to Top