Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 44
The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within is the data you need to help solve virtually any performance problem, quickly debug issues, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions--information gleaned from heavy use of the objects in a number of environments. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. Attend this session and you will be the master of your SQL Server instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Track 1

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we'll gain an understanding of what exactly parameter sniffing is and why it's usually so helpful. Then, we'll explore how parameter sniffing can wrong and I'll show you seven different ways you can deal with it when it does. You'll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Track 2

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will describe an ETL-based approach to loading Active Directory (AD) content into a SQL Server DB.  This DB can then be used to provide program-based or interactive access to AD content using familiar SQL syntax without the complexity or limitations of using special AD tools or LDAP queries to directly access AD content.  AD content includes users, computers, groups, and group memberships.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Track 1

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Full title is "Are you a Linchpin? Career management lessons to help you become indispensible."

Are consultants better that people who work for ‘regular’ companies? Perhaps it is the other way around? No classification of IT worker is inherently smarter or better than another. However, I believe that many successful SQL Server professionals share similar characteristics that shape their careers and success. Of course they have interesting differences as well! This session explores 20 years of my ideas, learning, and research on this topic. The session also shares the experience of several top SQL Server professions as they share personal thoughts on what has made them indispensible. This is a panel session. 
Speaker:

Session Type:
Regular Session

Track:
Professional Dev

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

… in which our young hero tells his story of going from lonely developer to community leader.  A discussion of discovery, education, and adventure.  Learn how to grow beyond a cube dweller to become someone recognized in the community as an enabler and educator.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Dev

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I'll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We'll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed.
Speaker:

Session Type:
Regular Session

Track:
Powershell

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered.  Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design.  In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more will be discussed
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The Microsoft BI stack has a few choices for visualization.  We will explore options, flexibility, limitations, and ease of use for creating dashboards & scorecards with:
  * PerformancePoint Services 2010
  * Reporting Services 2008 R2
  * SharePoint Server 2010
  * PowerPivot
  * Crescent.

This session will be a fun one!  We will compare and contrast options available in each tool, such as:  charts, gauges, maps, indicators, sparklines, data bars, and decomposition trees.  The goal is to determine when you might choose one tool in the Microsoft BI stack versus another.
Speaker:

Session Type:
Regular Session

Track:
BI Track 2

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

You know the concepts of normalization, logical modeling, and physical implementation. But what happens when you’ve inherited a less than perfect data model? You need to renovate while keeping the production system humming. In this session, we’ll talk about how to evaluate an existing model, how to approach design when your system is up and running and how to incrementally apply database design changes in a fast-moving environment. Every database, even ones consisting of a collection of flat, unrelated tables, has the potential to become a beautiful database. All you need is an eye for design and a strategy to get you there.   
Speaker:

Session Type:
Regular Session

Track:
BI Track 2

Level: Intermedia

Session Code:

Date: September 17

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 general connectivity.  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:
DBA Track 3

Level: Intermedia

Session Code:

Date: September 17

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 or packages that adhere to a pattern, 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:
BI Track 2

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Studies show that in most cases the Query Tool is not the problem! Today's challenge is Data, and no one can help manage your data better than WhereScape RED.  

WhereScape and Microsoft have partnered for the newly announced Microsoft SQL Server Fast Track Data Warehouse 3.0.  WhereScape RED provides Native support for Microsoft SSIS, SSAS, and T/SQL for the agile production of enterprise-level data integration and transformations solutions.

WhereScape RED is an IDE for managing data warehouses, marts, stores and vaults.  RED is the only product that supports the entire data management life cycle by integrating source system exploration, schema design, metadata management, scheduling and enhancement into a single integrated design.
Speaker:

Session Type:
Regular Session

Track:
BI Track 1

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

EMC will be presenting it's overall EMC strategy in conjunction with Microsoft technology solutions including SQL, Sharepoint and Exchange with an emphasis on best practices around Microsoft SQL. EMC has a long history of partnership with Microsoft in terms of integration and solution deployment and EMC will walk through the partnership synergies and it's product portfolio innovation around SQL Server including storage, backup and recovery, virtualization and security.
Speaker:

Session Type:
Regular Session

Track:
DBA Track 3

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You'll see a battle between two database professionals (Aaron Nelson and Julie Smith), attempting to load a database in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the ETL Smackdown
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Powershell

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Powershell is becoming an essential skill for any IT professional working with Microsoft products.  Many of the concepts upon which Powershell is built are new to non-developers .  In this session, we learn the skills necessary to get started.  You will learn the object-oriented concepts that are essential to understanding Powershell and see some examples of how Powershell can change the way you think about your job.
Speaker:

Session Type:
Regular Session

Track:
Powershell

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

What does a plane crash have to do with technical skills? You might be surprised.  There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; It’s the same for us.  Even if a freak accident occurs, training and preparation can make all the difference; it's the same for us.  In this session we’ll discuss as a group some real-life disasters and see what skills, attitudes and thought processes we can take back to our day jobs. We'll look at a handful of aviation disasters and look for patterns of behavior at fault or that saved the day. Hopefully you'll leave looking for those behaviors in yourself and on your project teams. Fasten your seatbelt!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Track 3

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have ever monitored a SQL Server closely, you know you can’t escape latches. Come to this advanced session exploring the internals of how SQL Server uses the concept of latches for synchronization of key internal data structures. This talk is a very advanced “500” session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests
Speaker:

Session Type:
Regular Session

Track:
DBA Track 2

Level: Advanced

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever encountered a wait type with SQL Server but can’t find any information on what it means? Perhaps you have thought the meaning of these is hidden away somewhere in a dark closet? In this talk, we will explore the internals of wait types within the SQL Server Engine. Rather than cover some of the more common wait types such as lock and latches, we will explore the more advanced and obscure wait types that may be surfaced by the engine. The ones you can’t find much information about.
Speaker:

Session Type:
Regular Session

Track:
DBA Track 2

Level: Advanced

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2011 "Denali" unveils the Business Intelligence Semantic Model (BISM) that will support the full spectrum of BI needs for personal, team, and organizational business intelligence. This session introduces you to BISM and focuses on its tabular capabilities. My goal is bring you up to speed on the new developments in Analysis Services and PowerPivot for the "Denali" release.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Track 2

Level: Beginner

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

TEMPDB is just for temporary data right?  It is installed by default and gets recreated each time SQL is restarted so what does it matter right?  WRONG.  This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.  
Speaker:

Session Type:
Regular Session

Track:
Professional Dev

Level: Intermedia

Session Code:

Date: September 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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