Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 29
In this session we'll discuss the common causes of poor overall performance in a SQL instance.  We'll cover the tools and techniques for identifying typical performance issues, and ways to address them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Development - RM122

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing & Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM118

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production and how this can be avoided.
Speaker:

Session Type:
Regular Session

Track:
DB Development - RM122

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I have given this talk over a dozen times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
DBA - RM120

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Utilizing TFS 2010 and Visual Studio Database Projects, databases can be included with the Application's CI build.  We will discuss Database Projects, walk through a basic scenario, and finish with an enterprise solution that performs the following: Drop DB > Create to Prod > Create Development Delta > Apply Development Delta > Run Data Generation plan > Run Database Tests.
Speaker:

Session Type:
Regular Session

Track:
DB Development - RM122

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Is Business Intelligence a critical strategy within your organization?  Companies that have a depth of analytic support, that use it across their entire organization, and value the insights they gain from their analytic solutions—these are companies far more likely to be high corporate performers.  And as such, availability of analytics across the enterprise, and the USE of those analytics—this can drive competitive differentiation for an organization.  In this session, we will move past the technology and discuss the value of focusing on some very basic, but very critical components to be considered when developing your Business Intelligence strategy.  

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Development - RM121

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Trying to manage many database instances is no easy task.  SQL Server Service Broker and Event Notifications are just one way to get near-real time feedback of what is occurring across all instances.  This session will demonstrate how Blue Cross and Blue Shield have implemented Event Notifications to monitor database changes, logins, permission changes, log/data file growths, etc...
Speaker:

Session Type:
Regular Session

Track:
DBA - RM120

Level: Advanced

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Denali has something for everyone: new HA/DR flexibility, an SSIS overhaul, unmatched data warehouse query speeds and much more. Have you heard about all the new T-SQL features and functions that will be delivered with Denali? Attend this session to learn how you will benefit from Microsoft's continued investment in T-SQL!
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA - RM120

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server offers several isolation levels beyond the default "READ COMMITTED".  But understanding when to use each one can be daunting.  Whether you are a developer who needs to understand how isolation works and  and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you.  We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
Speaker:

Session Type:
Regular Session

Track:
DB Development - RM121

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. 
Speaker:

Session Type:
Regular Session

Track:
DBA - RM119

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples.
Speaker:

Session Type:
Regular Session

Track:
DB Development - RM122

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM120

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

A comparison of SQL HA & DR options, by a practitioner who has implemented & managed all the SQL HA and DR approaches (& various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up & running & optimized for managed-services customers. We will compare trade-offs between the various SQL HA & DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM120

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM118

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. Additionally, you will be armed with a list of transformations and perfmon counters to 
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence - RM117

Level: Beginner

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker:

Session Type:
Regular Session

Track:
DB Development - RM122

Level: Advanced

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

As SQL Server Analysis Services becomes commonly used in various business intelligence solutions, many administrators are looking for ways to monitor and tune performance on the platform. This session will cover various monitioring techniques and tools and how to use that information to tune Analysis Services. 
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence - RM117

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

As a Premier Field Engineer I use Performance Monitor much more heavily in troubleshooting than I did before coming to Microsoft. The problem with measuring performance using this tool is that no one knows what counters are important, and if they do, they don't know what values are desired. i will discuss the few most significant counters for diagnosing performance problems.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM118

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

New to 2008, Extended Events allow granular performance analysis of individual queries that wasn't possible in prior versions of SQL.  In this session we'll cover the collection and analysis of poorly-running queries via extended events.
Speaker:

Session Type:
Regular Session

Track:
DBA - RM119

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data. This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well. 
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence - RM117

Level: Intermedia

Session Code:

Date: August 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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