Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 34
This session will be an in-depth session of the reasons for and against using dynamic SQL in applications. We'll look at different ways to write dynamic SQL statements, performance and security considerations that accompany using dynamic SQL, and how and when to take advantage of this powerful tool. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

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:
Track 4

Level: Advanced

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

How do you tell good code from bad?  Bad SQL code makes the system work harder for the same results.  Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity.  Extreme Bad SQL can bring a server to a grinding halt.   This presentation shows you how and why certain commonly used SQL constructions are Bad SQL.  Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 18

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:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 18

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 6

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

At the heart of Kimball’s method, business dimensional modeling is the dominant technique for data warehouse database modeling, and its ties to some SQL Server products have grown stronger over the last years. This session is an introduction to Kimball's  dimensional modeling, and provides the attendee a foundation of what dimensional models are and how they fit in the data warehouse lifecycle
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will look at what text mining tools are available for document classification with DMX (Data Mining Extensions). This example is a powerful yet often underutilized feature of SSAS (SQL Server Analysis Services). We will walk through the process of allowing SSAS aid in document classification. We will look at criteria to decide implementations based on several different implementations. Finally we will evaluate where text mining can help you in a practical business environment.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

When you mention CLR does your DBA run screaming from the room? Have you considered using the CLR but are intimidated by .Net and how foreign it seems compared to T-SQL? Have you ever thought that working with strings and dates in T-SQL is needlessly difficult and painful? This session will help demystify CLR integration, show you how to expose basic CLR functionality to your database, demonstrate how to get large performance gains from very little CLR code and give you the information and evidence you need to convince your DBA that the CLR is not inherently evil, and in the right circumstance, is the best solution to a problem
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including GUI, DMV's, and trace events are demonstrated. This lays a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse.  This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: September 18

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:
Track 1

Level: Beginner

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance.  Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Object Relational Mappers (ORMs) are a tool often praised by developers and despised by DBAs. I'll show that, like most tools, ORMs have their place if used responsibly. They can also get out of hand if they are trusted to always do the right thing. I will demonstrate usage of the most common ORMs for .NET and how each can go awry as well as how to monitor each for proper usage. This will not be a validation or admonishment of their usage; simply a look at their advantages and how to overcome some of their disadvantages.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle.  The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning.  It is simple, efficient. Manageability and performance come part and parcel.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

Some of the most common issues encountered with SSIS are related to configuring and deploying the packages in different environments. There are a number of options for how to configure your package, and more options for how to deploy them. When you combine the available options, the possibilities can be overwhelming. During this session, we will discuss several patterns for handling configurations and deployment in SSIS. Specifically, we’ll cover two patterns for configurations – a simple pattern that can be applied to most scenarios, and a more complex pattern that provides a great deal of flexibility. We’ll also cover two methods of deploying the packages that leverage the configuration patterns.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 18

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:
Track 3

Level: Intermedia

Session Code:

Date: September 18

Time: 12:00 AM - 1:00 AM

Room: TBD

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