sqlpasshistory

ID: 727

Back to Main list

PASS Summit 2009

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
03-11-2009 10:15 Grant Fritchey Spotlight Session (75 minutes) Application Development Best Practices for Working With Execution Plans
03-11-2009 10:15 Denny Lee Regular Session (75 minutes) Enterprise Database Administration and Deployment SQLCAT: Addressing Security and Compliance Issues with SQL Server 2008
03-11-2009 10:15 Glenn Berry Regular Session (75 minutes) Application Development Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment
03-11-2009 10:15 Bob Ward Regular Session (90 minutes) Enterprise Database Administration and Deployment Inside SQL Server Wait Types (90 Mins)
03-11-2009 10:15 Liam Cavanagh Regular Session (75 minutes) Application Development Building Applications with SQL Azure and Windows Azure
03-11-2009 10:15 John McAllister Regular Session (75 minutes) BI Platform Architecture Introducing Master Data Services
03-11-2009 10:15 Regular Session (75 minutes) BI Information Delivery Business Intelligence with Excel 2010 and PowerPivot for Excel
03-11-2009 10:15 Wayne Snyder Spotlight Session (75 minutes) BI Platform Architecture SSRS in the Enterprise - How to survive with a smile
03-11-2009 10:15 Steve Simon Regular Session (75 minutes) Application Development Data Access Layers.. A road map to smarter, efficient, and effective queries
03-11-2009 10:15 Meir Dudai Regular Session (75 minutes) Enterprise Database Administration and Deployment The magic of replication: What's new in SQL Server 2008 Replication?
03-11-2009 10:15 Trevor Barkhouse Regular Session (75 minutes) Enterprise Database Administration and Deployment Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting
03-11-2009 10:15 Regular Session (75 minutes) Application Development SQL Server Data-tier Application Lifecycle Management: Why and How
03-11-2009 10:15 Chuck Heinzelman Regular Session (75 minutes) Professional Development Soft Skills - Now More Than Ever
03-11-2009 10:15 Michelle Ufford Regular Session (75 minutes) Application Development Super Bowl, Super Load - A Look at Performance Tuning for VLDB's
03-11-2009 13:30 J May Regular Session (75 minutes) Enterprise Database Administration and Deployment Disk Partition Alignment: Increase Disk I/O Throughput By 10%, 30%, or More - The Best Kept Secret in SQL Server Disk I/O Performance
03-11-2009 13:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment SQL Server Always On Series: Part 1: Building a High Availability Strategy for your Enterprise
03-11-2009 13:30 Michael Tejedor Regular Session (75 minutes) BI Platform Architecture Microsoft Business Intelligence in 2010
03-11-2009 13:30 Il-Sung Lee Regular Session (75 minutes) Enterprise Database Administration and Deployment Auditing in SQL Server 2008
03-11-2009 13:30 Brad McGehee Regular Session (75 minutes) Professional Development Manage Your DBA Career, Dont Let it Manage You
03-11-2009 13:30 Regular Session (75 minutes) BI Information Delivery What's new in PerformancePoint Services 2010
03-11-2009 13:30 Regular Session (75 minutes) Application Development What is MS Sync. Framework
03-11-2009 13:30 Amir Netz Regular Session (75 minutes) BI Information Delivery Introducing PowerPivot for Excel
03-11-2009 13:30 Marco Russo Regular Session (75 minutes) BI Platform Architecture SQLBI Methodology
03-11-2009 13:30 Paul Bertucci Regular Session (75 minutes) Enterprise Database Administration and Deployment Upgrade to SQL Server 2008 Database Mirroring as fast as you can! For HA and distributed workloads topologies
03-11-2009 13:30 Craig Utley Regular Session (75 minutes) BI Platform Architecture Do It Right: Best Practices for Analysis Services 2005 and 2008
03-11-2009 13:30 Shon Hauck Regular Session (75 minutes) Enterprise Database Administration and Deployment Implementing and Supporting SQL 2008 Failover Clustering
03-11-2009 13:30 Joe Webb Regular Session (75 minutes) Application Development Enhance your T-SQL to perform better
03-11-2009 13:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment To Partition or Not To Partition The questions .. and the answers
03-11-2009 13:30 John Cook Regular Session (75 minutes) Application Development Solving the Bill of Materials Problem
03-11-2009 13:30 Glenn Berry Regular Session (75 minutes) Enterprise Database Administration and Deployment Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
03-11-2009 15:00 Dave Fackler Regular Session (75 minutes) BI Information Delivery Self-Service Analytics with SQL Server 2008 R2 (Kilimanjaro)
03-11-2009 15:00 Grant Fritchey Regular Session (75 minutes) Application Development DMV's as a Shortcut to Procedure Tuning
03-11-2009 15:00 Maciej Pilecki Regular Session (75 minutes) Enterprise Database Administration and Deployment SQL Server Execution Plans From Compilation To Caching To Reuse
03-11-2009 15:00 Charley Hanania Regular Session (75 minutes) Application Development Understanding time zones and using them effectively in your database applications
03-11-2009 15:00 Regular Session (75 minutes) Enterprise Database Administration and Deployment The Ultimate Free SQL Server Toolkit
03-11-2009 15:00 Regular Session (75 minutes) Enterprise Database Administration and Deployment DBAs and the Dynamic Datacenter of the Future
03-11-2009 15:00 Andy Leonard Regular Session (75 minutes) Professional Development A Tale of Careers and User Groups
03-11-2009 15:00 Dipti Sangani Regular Session (75 minutes) Enterprise Database Administration and Deployment TempDB Configuration and Management in SQL Server 2008
03-11-2009 15:00 Jason Massie Regular Session (75 minutes) Professional Development Social Computing for the Database Professional
03-11-2009 15:00 Regular Session (75 minutes) Application Development Developing with SQL Server Spatial: Flat Maps to Round Earth
03-11-2009 15:00 Pej Javaheri Regular Session (75 minutes) BI Information Delivery Business Intelligence in Microsoft SharePoint Server 2010
03-11-2009 15:00 Regular Session (75 minutes) Enterprise Database Administration and Deployment Resource Governor? What is that?
03-11-2009 16:30 Regular Session (75 minutes) Application Development SQL Server 2008 - Create powerful XML Schema collections to validate your XML documents
03-11-2009 16:30 Stacia Varga Regular Session (75 minutes) BI Information Delivery Enabling Analysis with Excel Services
03-11-2009 16:30 Brian Knight Spotlight Session (75 minutes) BI Platform Architecture Loading a Data Warehouse with SSIS
03-11-2009 16:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment Scaling SQL Server beyond 64 hardware threads on Window 2008 R2: Challenges, Scalability numbers, and Best Practices
03-11-2009 16:30 Peter Ward Spotlight Session (75 minutes) Enterprise Database Administration and Deployment SQL Server 2008 Manageability Features
03-11-2009 16:30 Herain Oberoi Regular Session (75 minutes) BI Platform Architecture Overview of Business Intelligence capabilities in SQL Server 2008 & R2
03-11-2009 16:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment SQL Server 2008 - What's in for SAP - First Experience and Features used
03-11-2009 16:30 Greg Low Spotlight Session (75 minutes) Application Development Making Effective Use of the Plan Cache
03-11-2009 16:30 Regular Session (75 minutes) Application Development Entity Framework in the .NET Framework 4.0 and Visual Studio 2010
03-11-2009 16:30 Kalen Delaney Spotlight Session (75 minutes) Enterprise Database Administration and Deployment Exploring Index Internals
03-11-2009 16:30 Allen White Regular Session (75 minutes) Enterprise Database Administration and Deployment Gather SQL Server Performance Data with PowerShell
03-11-2009 16:30 Sarah Barela Regular Session (75 minutes) Enterprise Database Administration and Deployment Designing and Building Private SQL Server Clouds
03-11-2009 16:30 SpeakerName Spotlight Session (75 minutes) BI Platform Architecture Automating your Data Warehouse
03-11-2009 16:30 Joe Yong Spotlight Session (75 minutes) Enterprise Database Administration and Deployment SQL Server Consolidation and Virtualization: Myths, Realities and Best Practices
04-11-2009 10:15 Stacia Varga Regular Session (75 minutes) BI Platform Architecture A Checklist of Best Practices for Securing Reporting Services
04-11-2009 10:15 Andy Leonard Spotlight Session (75 minutes) BI Platform Architecture Applied SSIS Design Patterns
04-11-2009 10:15 Regular Session (75 minutes) Enterprise Database Administration and Deployment SQL Server Always On Series: Part 2: SQL Server Failover Clustering Deep Dive (90 Mins)
04-11-2009 10:15 Lara Rubbelke Regular Session (75 minutes) Enterprise Database Administration and Deployment Advanced Policy-Based Management for the Enterprise using the Enterprise Policy Framework (90 Mins)
04-11-2009 10:15 Brad McGehee Regular Session (75 minutes) Enterprise Database Administration and Deployment Identifying SQL Server Performance Problems Using SQL Trace
04-11-2009 10:15 Regular Session (75 minutes) Professional Development Doing more with less - Dell I/T's 7 steps to a highly effective Database management organization
04-11-2009 10:15 Paul Randal Spotlight Session (75 minutes) Enterprise Database Administration and Deployment Understanding Logging and Recovery in SQL Server
04-11-2009 10:15 Rod Colledge Regular Session (75 minutes) Enterprise Database Administration and Deployment DBAs Behaving Badly... Worst Practices for Database Administrators
04-11-2009 10:15 Regular Session (75 minutes) BI Platform Architecture An End-to-End Introduction to SQL Server Reporting Services
04-11-2009 10:15 Klaus Aschenbrenner Spotlight Session (75 minutes) Application Development Building FILESTREAM solutions with SQL Server 2008
04-11-2009 10:15 Steve Simon Regular Session (75 minutes) BI Platform Architecture SQL Server Integration Services and the modern financial institution.
04-11-2009 10:15 Regular Session (75 minutes) Application Development What's New in SQL Azure
04-11-2009 10:15 John Welch Regular Session (75 minutes) BI Platform Architecture SQL Server BI in the Cloud
04-11-2009 10:15 Regular Session (75 minutes) Application Development Developing with SQL Server Spatial: Deep Dive into Spatial Indexing (90 Mins)
04-11-2009 13:30 Pej Javaheri Regular Session (75 minutes) BI Platform Architecture BI Power Hour
04-11-2009 13:30 Louis Davidson Regular Session (75 minutes) Application Development Database Design
04-11-2009 13:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment How the Query Optimizer Works
04-11-2009 13:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment Scaling Online Transaction Processing Applications with SQL Server 2008
04-11-2009 13:30 Andras Belokosztolszki Regular Session (75 minutes) Application Development Passing Information to SQL Server - Parameters
04-11-2009 13:30 Jay Kint Regular Session (75 minutes) Application Development SQL Server Driver for PHP
04-11-2009 13:30 Joe Yong Regular Session (75 minutes) Enterprise Database Administration and Deployment Practical Performance Monitoring and Troubleshooting for the graduated beginner but not yet expert.
04-11-2009 13:30 Brian Larson Regular Session (75 minutes) BI Information Delivery Creating a Digital Dashboard with SQL Server 2008
04-11-2009 13:30 Brent Ozar Regular Session (75 minutes) Enterprise Database Administration and Deployment DRP101: Learn The Difference Between Your Log And Your Cluster
04-11-2009 13:30 Rick Heiges Regular Session (75 minutes) Enterprise Database Administration and Deployment Don't Wait! Consolidate on SQL Server 2008!
04-11-2009 13:30 Chris Webb Regular Session (75 minutes) BI Platform Architecture Designing Effective Aggregations in Analysis Services 2008
04-11-2009 13:30 Regular Session (75 minutes) BI Platform Architecture Looking Inside the Beast: Dissecting Complex MDX Formulas
04-11-2009 13:30 Sanjay Mishra Regular Session (75 minutes) Enterprise Database Administration and Deployment SQLCAT: Customer Experiences with Data Compression
04-11-2009 13:30 John Sirmon Regular Session (75 minutes) BI Platform Architecture Top customer support issues in Analysis Services 2005/2008 and how to resolve them
04-11-2009 15:00 Gail Shaw Regular Session (75 minutes) Enterprise Database Administration and Deployment Insight into Indexes
04-11-2009 15:00 Jessica Moss Regular Session (75 minutes) BI Information Delivery Adding SSRS Report Bells and Whistles
04-11-2009 15:00 Prem Mehra Regular Session (75 minutes) Enterprise Database Administration and Deployment SQLCAT: SQL Server Always On Series. Part 3: SQLCAT Customer Deployments, Best Practices & Panel Discussion
04-11-2009 15:00 Regular Session (75 minutes) Enterprise Database Administration and Deployment The Impact of Native SQL Server 2008 Compression and Encryption on Various Database Workloads
04-11-2009 15:00 Jonathan Kehayias Regular Session (75 minutes) Enterprise Database Administration and Deployment Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events
04-11-2009 15:00 Tobias Ternstrom Regular Session (75 minutes) Application Development Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE
04-11-2009 15:00 Regular Session (75 minutes) BI Information Delivery Introduction to PerformancePoint Services - Creating Dashboards is as easy as 1, 2, 3
04-11-2009 15:00 Rob Garrison Regular Session (75 minutes) Professional Development Working in Management Will Rot Your Brain - How to Stay Technical and Advance Your Career
04-11-2009 15:00 Warren Thornthwaite Regular Session (75 minutes) BI Platform Architecture The DW/BI System Lifecycle Overview the Kimball Approach
04-11-2009 15:00 Davide Mauri Regular Session (75 minutes) BI Platform Architecture Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
04-11-2009 15:00 Rushabh Mehta Regular Session (75 minutes) BI Platform Architecture Overcoming SSIS Deployment and Configuration Challenges
04-11-2009 15:00 Roman Schindlauer Regular Session (75 minutes) Application Development Building Event-driven, Low-latency Applications with Microsoft's Platform for Complex Event Processing
04-11-2009 15:00 Plamen Ratchev Regular Session (75 minutes) Application Development Panel Discussion: SQL Injection
04-11-2009 15:00 Pablo Castro Regular Session (75 minutes) Application Development Program, analyze and share data with almost any data source using ADO.NET Data Services
04-11-2009 16:30 Don Kiely Regular Session (75 minutes) Application Development SQL Server Efficiencies: Sparse Columns and Filtered Indexes
04-11-2009 16:30 Kimberly Tripp Spotlight Session (90 minutes) Enterprise Database Administration and Deployment SQL Server Covering: Concepts, Concerns, & Costs
04-11-2009 16:30 Lukasz Pawlowski Regular Session (75 minutes) BI Platform Architecture Security and Deployment with Reporting Services 2008 R2
04-11-2009 16:30 Paul Nielsen Spotlight Session (75 minutes) Application Development Nordic - turn SQL Server into an Object Db
04-11-2009 16:30 David Pless Regular Session (90 minutes) Enterprise Database Administration and Deployment SQL Server 2005 / 2008 Performance Tuning and Optimization Techniques (90 Mins)
04-11-2009 16:30 Ralf Dietrich Regular Session (75 minutes) Enterprise Database Administration and Deployment Securing SQL Server from inside-attacks
04-11-2009 16:30 Ross Mistry Regular Session (75 minutes) Enterprise Database Administration and Deployment Designing a Highly Available SQL Server Infrastructure - Notes from the Field
04-11-2009 16:30 Buck Woody Regular Session (75 minutes) Enterprise Database Administration and Deployment Manageability Series: Understand and Troubleshoot with Policy-Based Management and Data Collector
04-11-2009 16:30 Maciej Pilecki Spotlight Session (90 minutes) Enterprise Database Administration and Deployment Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management
04-11-2009 16:30 Dejan Sarka Regular Session (75 minutes) Application Development Understanding XQuery
04-11-2009 16:30 Peter Myers Spotlight Session (75 minutes) BI Platform Architecture How to Get Rich (Quicker) Using the Time Series Data Mining Algorithm!
04-11-2009 16:30 Richard Bolesta Regular Session (75 minutes) Professional Development The Accidental Leader
04-11-2009 16:30 Erik Veerman Spotlight Session (75 minutes) BI Platform Architecture Data Profiling and Cleansing with Integration Services 2008
04-11-2009 16:30 Marco Russo Regular Session (75 minutes) BI Platform Architecture Custom Security in SQL Server Analysis Services
05-11-2009 10:45 Regular Session (75 minutes) BI Platform Architecture Advanced Techniques for SSIS Package Development
05-11-2009 10:45 Regular Session (75 minutes) BI Platform Architecture Creative Approaches to Large Dimensions in Analysis Services
05-11-2009 10:45 Eric Hanson Regular Session (75 minutes) Enterprise Database Administration and Deployment SQL Server Data Warehouse Query Acceleration: Under the Hood
05-11-2009 10:45 Spotlight Session (75 minutes) Application Development Managing Hierarchies in SQL Server 2008 with HIERARCHYID
05-11-2009 10:45 Dave Wickert Regular Session (75 minutes) BI Platform Architecture SQLCAT: A Preview of PowerPivot Best Practices
05-11-2009 10:45 Itzik Ben-Gan Spotlight Session (75 minutes) Application Development T-SQL Tips & Tricks
05-11-2009 10:45 Lindsey Allen Regular Session (90 minutes) Enterprise Database Administration and Deployment SQLCAT/SQL Server Consolidation Series - Consolidation and virtualization best practices and recommendations (90 Mins)
05-11-2009 10:45 Warren Thornthwaite Spotlight Session (75 minutes) BI Platform Architecture Kimball Approach Dimensional Modeling Across SQL Server and SSAS
05-11-2009 10:45 Joe Webb Spotlight Session (75 minutes) BI Platform Architecture Creating Data-Driven Subscriptions in SSRS
05-11-2009 10:45 Carl Rabeler Regular Session (75 minutes) BI Platform Architecture SQLCAT: Analysis Services Consolidation & Virtualization
05-11-2009 10:45 Michael Thomassy Regular Session (75 minutes) Application Development SQLCAT: SQL Service Broker: High Performance Distributed Applications in Real World Deployments
05-11-2009 10:45 Kevin Kline Regular Session (75 minutes) Professional Development Team Management Crash Course
05-11-2009 10:45 Andrew Kelly Spotlight Session (90 minutes) Enterprise Database Administration and Deployment Capturing and Analyzing File & Wait Stats
05-11-2009 10:45 CLIFFORD DIBBLE Regular Session (90 minutes) Enterprise Database Administration and Deployment SQL Server Consolidation Series - Anatomy of a SQL Server consolidation Project
05-11-2009 10:45 Regular Session (75 minutes) Application Development Entity Framework 4.0 for DBAs
05-11-2009 13:00 Paul Turley Regular Session (75 minutes) BI Platform Architecture Super Reports: Patterns & Recipes
05-11-2009 13:00 Joy Mundy Regular Session (75 minutes) BI Platform Architecture ETL: The Linchpin for the Complete Data Warehouse
05-11-2009 13:00 Matt Masson Regular Session (75 minutes) BI Platform Architecture Maximize Your SSIS Investment with Tuning Tricks and Tips
05-11-2009 13:00 Buck Woody Regular Session (75 minutes) Enterprise Database Administration and Deployment Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support
05-11-2009 13:00 Joe Celko Regular Session (75 minutes) Application Development Advanced Nested Sets model in SQL
05-11-2009 13:00 Regular Session (75 minutes) Enterprise Database Administration and Deployment SQLCAT: Customer Experiences Deploying Data Warehouse Solutions using the FastTrack Architecture
05-11-2009 13:00 Prash Shirolkar Regular Session (75 minutes) BI Platform Architecture Reporting Services - Sharepoint 12 & 14 Integration
05-11-2009 13:00 Allan Hirt Regular Session (75 minutes) Enterprise Database Administration and Deployment Advanced Failover Clustering Installation Techniques with SQL Server 2008 and Windows Server 2008
05-11-2009 13:00 Regular Session (75 minutes) BI Platform Architecture What All Microsoft BI Developers Need to Know About MDX so that They Can Create Required Business Calculations
05-11-2009 13:00 Regular Session (75 minutes) Application Development Troubleshooting applications accessing SQL Server
05-11-2009 13:00 Brent Ozar Regular Session (75 minutes) Application Development Yes, I'm Actually Using The Cloud
05-11-2009 13:00 Denise McInerney Regular Session (75 minutes) Professional Development Achieving Work-Life Balance - What does it really mean?
05-11-2009 13:00 Diego Oppenheimer Regular Session (75 minutes) BI Information Delivery Advanced BI Capabilities in Excel & Excel Services
05-11-2009 14:30 Boris Baryshnikov Regular Session (75 minutes) Application Development Advanced Physical Database Design for SQL Server 2008
05-11-2009 14:30 Rick Heiges Regular Session (75 minutes) Professional Development Are You Cut Out to be a Consultant?
05-11-2009 14:30 Randy Dyess Regular Session (75 minutes) Enterprise Database Administration and Deployment Using Policy Based Management to Mange your Environment
05-11-2009 14:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment SQLCAT: SharePoint on SQL Server - Implementation, Configuration and Tuning
05-11-2009 14:30 Regular Session (75 minutes) Application Development Developing Java Applications Against SQL Server 2008"
05-11-2009 14:30 Jason Strate Regular Session (75 minutes) Enterprise Database Administration and Deployment Getting To Know Your Indexes
05-11-2009 14:30 Buck Woody Regular Session (75 minutes) Enterprise Database Administration and Deployment Using SQL Server 2008 for Performance Tuning
05-11-2009 14:30 Regular Session (75 minutes) BI Information Delivery Advanced Dashboard creation with PerformancePoint Services
05-11-2009 14:30 Dan Bulos Regular Session (75 minutes) BI Platform Architecture Building Planning Applications without PerformancePoint
05-11-2009 14:30 Ross LoForte Regular Session (75 minutes) Enterprise Database Administration and Deployment Proactive DBA: Manage SQL Server Better
05-11-2009 14:30 Regular Session (75 minutes) Enterprise Database Administration and Deployment Solid State Disks and SQL 2008: High Availability and Performance
05-11-2009 14:30 Regular Session (75 minutes) BI Platform Architecture Understanding Master Data Management and the Benefits
05-11-2009 14:30 Regular Session (75 minutes) BI Platform Architecture SQLCAT: Madison Overview and Madison Technology Preview Results
05-11-2009 14:30 Victor Isakov Regular Session (75 minutes) Enterprise Database Administration and Deployment The Problem with Parallelism...
05-11-2009 16:00 John Hancock Regular Session (75 minutes) BI Platform Architecture Managing PowerPivot
05-11-2009 16:00 Craig Utley Regular Session (75 minutes) BI Information Delivery Monitor Your Business with PerformancePoint Services Monitoring and Analytics
05-11-2009 16:00 Denny Cherry Regular Session (75 minutes) Enterprise Database Administration and Deployment Storage for the DBA
05-11-2009 16:00 Howie Dickerman Regular Session (75 minutes) BI Information Delivery Data Analysis Expressions in PowerPivot for Excel 2010
05-11-2009 16:00 Dave Fackler Regular Session (75 minutes) BI Platform Architecture ETL from the Trenches: Using SSIS in the Real World
05-11-2009 16:00 Bob Meyers Regular Session (75 minutes) BI Information Delivery Introducing Reporting Services 2008 R2: Report Builder 3.0 and the new visualization capabilities (Maps, Sparkline, Indicators)
05-11-2009 16:00 Thomas Kejser Regular Session (90 minutes) Enterprise Database Administration and Deployment SQLCAT: Designing High Performance I/O for SQL Server (90 Mins)
05-11-2009 16:00 Tobias Ternstrom Regular Session (75 minutes) Application Development What's New in T-SQL Programmability in SQL Server 2008
05-11-2009 16:00 Adam Machanic Spotlight Session (90 minutes) Enterprise Database Administration and Deployment Advanced SQL Server 2008 Extended Events: Performance Profiling and Troubleshooting Techniques
05-11-2009 16:00 John Welch Regular Session (75 minutes) BI Platform Architecture Using Agile Development Techniques with Integration Services
05-11-2009 16:00 Kendal Van Dyke Regular Session (75 minutes) Enterprise Database Administration and Deployment Transactional Replication: Beyond The Basics
05-11-2009 16:00 Thomas Grohser Spotlight Session (90 minutes) Enterprise Database Administration and Deployment Sizing SQL Servers for (unknown) Workload
05-11-2009 16:00 Ross Mistry Regular Session (75 minutes) Enterprise Database Administration and Deployment Securing and Hardening a SQL Server Implementation - Notes from the Field
05-11-2009 16:00 Gail Shaw Spotlight Session (90 minutes) Enterprise Database Administration and Deployment Lies, damned lies and statistics

SessionID: 62097

Best Practices for Working With Execution Plans

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s): Grant Fritchey

Title: Best Practices for Working With Execution Plans

Description:

This extended session will focus on how best to use and access execution plans. The use of execution plans will focus on identifying and fixing common performance and execution problems within TSQL. The methods defined for using execution plans will follow a problem/solution paradigm in order to show practical ways that execution plans can help solve common problems. Access of execution plans is normally only defined as being from the Management Studio GUI. This session will show methods of access that include direct queries into the procedure cache using dynamic management views and functions and plans captured through the use of trace events defined in Profiler. Access through XQuery against the XML will be demonstrated through several practical applications. The overall focus of the session will be towards practical methods that can be applied in the attendees systems immediately.

SessionID: 62189

SQLCAT: Addressing Security and Compliance Issues with SQL Server 2008

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Denny Lee

Title: SQLCAT: Addressing Security and Compliance Issues with SQL Server 2008

Description:

We will describe how new security features in SQL Server 2008 will work and how these features complement already existing features. In the focus of this presentation, we will look at how SQL Server 2008 features can be applied to Payment Credit Industry (PCI) and Health Information Portability and Accountability Act (HIPAA) compliance.

SessionID: 62095

Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Glenn Berry

Title: Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment

Description:

Full Text Search has been completely rewritten in SQL Server 2008 to be natively integrated with the SQL Engine. This can give very significant performance improvements compared to previous versions of Full Text Search. In order to realize all the performance benefits of SQL Server 2008 iFTS, you need to be aware of how to configure, monitor, and maintain your full text catalog/indexes, and the relational base tables that they are based on. This session will give you real-world proven techniques and T-SQL code that you can use to monitor and optimize your full text performance, especially with a volatile, high volume OLTP workload.

SessionID: 62215

Inside SQL Server Wait Types (90 Mins)

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Bob Ward

Title: Inside SQL Server Wait Types (90 Mins)

Description:

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.

In this talk, we will cover (but not limited to) the following topics: -Internal algorithms of wait types in the engine -Exploring some of the more advanced wait types in the engine -PREEMPTIVE wait types in SQL Server 2008 -What are some of the wait types that you can safely ignore and why? -Learning to use Extended Events to debug wait types -How to interpret information about wait types in SQL Server DMVs and metadata

This talk is a very advanced 500 level 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 and sys.dm_os_wait_stats.

SessionID: 62090

Building Applications with SQL Azure and Windows Azure

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Liam Cavanagh

Title: Building Applications with SQL Azure and Windows Azure

Description:

Are you looking to reduce the costs of building and maintaining enterprise applications? Do you want to extend the reach of your applications across multiple devices, locations and partners? SQL Data Services and Windows Azure provides you a friction free, highly scalable platform for building applications. The scale and reach of the cloud lights up a new class of application scenarios. Come see how easy it is to consume SQL Data Services from within Windows Azure. In addition, we will dive into Microsofts new Data Hub for businesses and see how this SQL Data Services powered synchronization service allows for data aggregation within the Hub to provide straight-forward data sharing between on-premises databases, business partners, remote offices and mobile users.

SessionID: 62104

Introducing Master Data Services

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): John McAllister

Title: Introducing Master Data Services

Description:

Master Data Services is a component of SQL Server 2008 R2 that will enable you to improve the quality of key data assets such as products, customers, locations, accounts, cost centers and many others. Come learn how MDS can serve a wide range of analytic (dimension management) and operational (master data management) scenarios. The talk will cover product architecture and include an extensive demonstration.

SessionID: 62145

Business Intelligence with Excel 2010 and PowerPivot for Excel

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s):

Title: Business Intelligence with Excel 2010 and PowerPivot for Excel

Description:

Learn what's new in Microsoft Office Excel for Business Intelligence, and how Excel will work together with the new PowerPivot (formerly known as Project Gemini) to deliver enterprise self-service analysis. This session will also cover how you can create custom BI solutions using the new programmability capabilities.

SessionID: 62139

SSRS in the Enterprise - How to survive with a smile

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Wayne Snyder

Title: SSRS in the Enterprise - How to survive with a smile

Description:

If you plan to use SSRS in a large enterprise there are many things you should do be successful... How should folder structure and security be set up? Are there best practices around data sources? Are SSRS 2008 Report Models ready for the enterprise? How should projects be organized? Is Report Builder 2.0 good enough yet? What works well and what will cause you pain? We will spend our time in a very practical discussion to help you get SSRS deployed and working. We will cover only non-integrated mode, and we will take a look at the Object model if we have time.

SessionID: 62066

Data Access Layers.. A road map to smarter, efficient, and effective queries

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Steve Simon

Title: Data Access Layers.. A road map to smarter, efficient, and effective queries

Description:

How often have our SQL Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. Nowhere is this truer than within the financial world where heavy number crunching is par for the course. This beginners to intermediate level hands-on presentation is aimed at the SQL Server developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating a data access layer which provides our end users with a suite of well developed and tuned SQL Server FUNCTIONS and UDT's with which to render their data. The presentation will discuss the high level principles and concepts behind our data access layer, the scenarios under which we have benefited from its usage and then compare and contrast some of the poorly performing queries that we once had..with some more efficient and effective queries that we have now provided to our end users.

SessionID: 62184

The magic of replication: What's new in SQL Server 2008 Replication?

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Meir Dudai

Title: The magic of replication: What's new in SQL Server 2008 Replication?

Description:

Many organizations require challenging scalability and high availability solutions for database implementations. Replication in SQL Server 2008 is one of the most powerful tools: Peer-to-Peer, transactional and merge replication are now robust technologies that every DBA and system architect should be aware of. In the session, we will reveal the new replication features in SQL Server 2008. We will then demonstrate some real-life scenarios in which replication can provide an optimal solution for the business requirements.

SessionID: 62171

Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Trevor Barkhouse

Title: Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting

Description:

Over the years, Microsoft Customer Service and Support has developed a number of amazing tools for troubleshooting SQL Server. Thankfully many of these tools have been shared with the public. In this session I will demonstrate the configuration and usage of PSSDiag (for SQL Server 2000) and SQLDiag (for SQL Server 2005 and 2008), which collect valuable diagnostic data. We will then analyze the data using RML Utilities as well as a few scripts of my own. Come and see how these tools can save you massive amounts of troubleshooting time!

SessionID: 62075

SQL Server Data-tier Application Lifecycle Management: Why and How

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: SQL Server Data-tier Application Lifecycle Management: Why and How

Description:

DBAs and developers alike find it hard to effectively develop, deploy and manage a database application throughout its lifecycle. The absence of a single unit of reasoning aggravates the problem. SQL Server developers today want to create a data-tier application they can test and deploy it across multiple instances while SQL Server DBAs find the need to manage data-tier applications more than just a bunch of scripts. Microsoft's investment in the SQL Server data-tier application space brings in concepts and tools to simplify development and deployment of data-tier applications. Application and multi-server management was announced at SQL PASS 2008. In this session we dive into the scenarios for developing a data-tier application and deploying it on SQL Server using features in SSMS and in Visual Studio.

SessionID: 62230

Soft Skills - Now More Than Ever

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Chuck Heinzelman

Title: Soft Skills - Now More Than Ever

Description:

With the economy in a downturn and many companies reducing forces, many of us have seen ourselves thrown back into the job market for the first time in many years. Those of us who still have jobs are quite often being asked to take on additional responsibilities. What will set you apart from the crowd in a tight economy with many skilled individuals vying for the same job? Soft skills are those interpersonal and professional differences that could be extremely important in either keeping your job or finding your next job. In this session, we will discuss resumes, interview skills and how to successfully deal with others in the workplace. We will also talk about how to be one of the people who survive a reduction in forces within your company.

SessionID: 62073

Super Bowl, Super Load - A Look at Performance Tuning for VLDB's

Back to calendar

Event Date: 03-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Michelle Ufford

Title: Super Bowl, Super Load - A Look at Performance Tuning for VLDB's

Description:

Few DBAs have the opportunity to experience a real-life load test in their production environment. Michelle Ufford works for GoDaddy.com, a company that has experienced phenomenal success with its Super Bowl ads. These ads are designed to drive traffic to the company's websites, which puts the database servers under high load. In her presentation, Michelle will explore the performance tuning techniques that have resulted in an 80% reduction in server response times and allowed her VLDBs to reach rates of 27k transactions per second. Topics will include vertical and horizontal partitioning, bulk operations, table design, and indexing.

SessionID: 62175

Disk Partition Alignment: Increase Disk I/O Throughput By 10%, 30%, or More - The Best Kept Secret in SQL Server Disk I/O Performance

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): J May

Title: Disk Partition Alignment: Increase Disk I/O Throughput By 10%, 30%, or More - The Best Kept Secret in SQL Server Disk I/O Performance

Description:

The following presentation is the recording from the 2008 Summit and replaces the 2009 presentation as per the request of the presenter, Jimmy May.

SessionID: 62168

SQL Server Always On Series: Part 1: Building a High Availability Strategy for your Enterprise

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: SQL Server Always On Series: Part 1: Building a High Availability Strategy for your Enterprise

Description:

Every business has mission critical applications running on SQL Server that require maximum uptime. Some application data is more critical than others and requires strict guarantees with regard to data loss. Depending on various factors the availability strategy and corresponding technology choices will vary. As an architect or DBA it is important to develop the right HA strategy and corresponding solution which meets the availability requirement and at the same time provide the cost benefit for your organization. Microsoft SQL Server 2008 Always On Technologies provide a full range of options to minimize downtime and maintain appropriate levels of application availability. Come learn how to develop a comprehensive HA solution using the Always On technologies. The session walks you through the various technologies and features, provides a cost-benefit analysis and comparison and talks about the key decision points to consider when choosing a particular technology.

SessionID: 62106

Microsoft Business Intelligence in 2010

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Michael Tejedor

Title: Microsoft Business Intelligence in 2010

Description:

Attendees will hear firsthand the Microsoft BI vision for SQL Server, Office, SharePoint and PerformancePoint. We will identify the capabilities coming in Office 2010, how these align with the Microsoft vision of pervasive BI, and provide prescriptive guidance on the use cases and how each component moves us further to our vision. Come with your questions. This is a session you don't want to miss.

SessionID: 62192

Auditing in SQL Server 2008

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Il-Sung Lee

Title: Auditing in SQL Server 2008

Description:

This session will provide an in-depth introduction to the new auditing feature introduced in SQL Server 2008. Audit is a much anticipated feature for security-sensitive customers, especially those who need to meet regulatory compliance needs, and provides a number of advantages over previous auditing solutions. The key advantages include performance benefits, multiple log targets, and granular auditing, all of which will be explained in detail. In addition to a discussion on the SQL Audit feature, this session will provide demonstrations of end-to-end use cases and scenarios.

SessionID: 62224

Manage Your DBA Career, Dont Let it Manage You

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Brad McGehee

Title: Manage Your DBA Career, Dont Let it Manage You

Description:

It has been my experience that many people tend to "fall into" their career instead of them making a conscious decision as to what their career should be. Because of this, many people wander about in their career, not particular satisfied with how their career (or their life) is going. Instead of letting your career manage you, I strongly urge all DBAs to manage their own career by consciously taking control of it. By doing so, not only will you have a financially rewarding career, but a career that gets you excited about life and your contribution to it. In this session, I will outline specific steps you can follow so that you take control of your career. These steps include: defining your career path, deciding if you want to be an average or exceptional DBA, selecting a career specialty, determining how to match your career with your personal life, developing the appropriate skill sets, and managing your brand. If you want to be successful in your career, it all boils down to the following: 1) deciding what you want out of your career; 2) developing specific goals; and 3) taking action. If you don't take charge of your career, no one else will.

SessionID: 62152

What's new in PerformancePoint Services 2010

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s):

Title: What's new in PerformancePoint Services 2010

Description:

Do you stay up at night thinking about KPIs and Scorecards? Are you currently using PerformancePoint Server 2007 and wondering what the next version will look like? Does a bar chart put a smile on your face? Then this is the session for you! Tim Kashani and Ola Ekdahl, co-authors of PerformancePoint Services 2010 (Sams), will show you what the new version of corporate performance management from Microsoft will look like. With the use of three PowerPoint slides (yup, that's all they need) and a boatload of demos (think enormous oil tanker), Tim and Ola will demonstrate how to build KPIs, Scorecards, Reports, and Dashboards and also discuss how to migrate existing solutions from PerformancePoint Server 2007.

SessionID: 62072

What is MS Sync. Framework

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: What is MS Sync. Framework

Description:

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. It features technologies and tools that enable roaming, sharing, and taking data offline. Using Microsoft Sync Framework, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network. In this presentation I will introduce you to this new platform and we will take a look at how it works and how you can integrate this in your applications.

SessionID: 62144

Introducing PowerPivot for Excel

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Amir Netz

Title: Introducing PowerPivot for Excel

Description:

You have almost certainly read or heard a lot about Project Gemini (now named PowerPivot for Excel) - our new Self Services analysis product. In this session, we'll give you the full business and technical background to PowerPivot. This is essential knowledge, to understand the future directions of Microsoft BI, and to introduce you to the more detailed topics we are also presenting.

SessionID: 62132

SQLBI Methodology

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Marco Russo

Title: SQLBI Methodology

Description:

Data Warehouses have a solid foundation, with different modeling options formalized in several books and whitepapers. Nevertheless, when it comes to implement a Data Warehouse using the SQL Server suite, you have to make several decisions about technology and implementation, which are very specific to SQL Server. These decisions might cause the success or the failure of your Data Warehouse project. This session will introduce you to the SQLBI Methodology. This approach has been developed over the years focusing all the architectural and technological decisions that you have to make when implementing a complete Business Intelligence solution using SQL Server, Integration Services and Analysis Services. This methodology is thought for Data Warehouse of medium-large complexity but, having a reduced overhead compared to the classical Kimball methodology, it is usable on small Data Warehouses too. The great advantages of the SQLBI Methodology are the flexibility in terms of design and maintenance. The draft papers about SQLBI Methodology are downloadable from http://www.sqlbi.com/sqlbimethodology.aspx

SessionID: 62165

Upgrade to SQL Server 2008 Database Mirroring as fast as you can! For HA and distributed workloads topologies

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Paul Bertucci

Title: Upgrade to SQL Server 2008 Database Mirroring as fast as you can! For HA and distributed workloads topologies

Description:

Mr. Bertucci will describe what the current incarnation of Database Mirroring under SQL Server 2008 Database Mirroring is all about and disclose the results around an astounding benchmark from a SQL Server 2005 versus 2008 mirroring configuration. This talk will also include a fairly extensive explanation of what database mirroring is, how and when to use it, how to set it up, and how it can be leveraged for both achieving high availability and distributing workload. He will include a few business use cases of production implementations and demonstrate an actual mirroring topology and test client application. The benchmark results will offer the attendee much fuel in accelerating their upgrade to SQL Server 2008. The results are astonishing!

SessionID: 62134

Do It Right: Best Practices for Analysis Services 2005 and 2008

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Craig Utley

Title: Do It Right: Best Practices for Analysis Services 2005 and 2008

Description:

Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the best practices for properly designing cubes for performance and usability. It discusses some high-level topics but also looks at advanced topics such as alternative approaches to many-to-many dimensions, SCOPE statements, aggregation design, scalability issues, processing techniques, server properties, and more. Craig Utley has been working with Microsoft's BI products for 11 years and is a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he worked with some of the largest Analysis Services installations worldwide. In this session he brings his real-world experience with large, complex SSAS projects and presents best practices uncovered as companies deploy and use Analysis Services.

SessionID: 62221

Implementing and Supporting SQL 2008 Failover Clustering

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Shon Hauck

Title: Implementing and Supporting SQL 2008 Failover Clustering

Description:

In this session we will cover an overview of the changes made in SQL 2008 Clustering since its initial release. We will also discuss some problems customers have encountered when trying to build a proper foundation for the installation of SQL 2008 Failover Clustering Instances. We will take some time to review some techniques or lessons' learned since shipping SQL 2008 Failover Clustering, more specific on how to troubleshooting installation and post installation troubleshooting and administrative tasks. Finally we will take a look to the future of SQL on Clustering Solutions and what should be available soon.

Topics: -Overview of SQL 2008 Failover Clustering including Design changes from previous SQL versions. -Pre-installation tasks of SQL 2008 Failover Clustering -Reported problems during Installation of SQL 2008 Failover Clustering -Basic Troubleshooting Of SQL 2008 Failover Clustering -Proper way to update SQL 2008 Failover Cluster Instance -Lessons learned while trying to upgrade previous SQL Cluster installations to SQL 2008 Failover Clustering -A Look at Advanced Installation Options of SQL 2008 Failover Clustering

SessionID: 62083

Enhance your T-SQL to perform better

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Joe Webb

Title: Enhance your T-SQL to perform better

Description:

Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we'll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.

SessionID: 62213

To Partition or Not To Partition The questions .. and the answers

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: To Partition or Not To Partition The questions .. and the answers

Description:

There are a few ways to partition your data and well talk about the various types of partitioning and the pros and cons of each. Well cover a variety of questions, like: - Can SQL Server's table partitioning be used to move data between databases? - What's the best type of partitioning for scaling up, or for scaling out? - What does it cost me in terms of administration or coding time to add partitioning to my current database? - How do I partition a database that already has a large amount of data in it? Well also discuss some real-world examples of partitioning some that went right, some that went wrong. Partitioning has some great benefits, but be sure to choose the one that's right for your requirements.

SessionID: 62084

Solving the Bill of Materials Problem

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): John Cook

Title: Solving the Bill of Materials Problem

Description:

There has never been a standard for storing and processing hierarchical data. Over the years, multiple approaches have emerged. Oracle provides the START WITH...CONNECT BY PRIOR syntax. Joe Celko even wrote an entire book on the subject. With SQL Server 2008, the new hierarchyid data type offers an easily understand and implemented approach to storing hierarchical data. It can be implemented with either breadth-first or depth-first indexing for navigating the hierarchy, which makes it a flexible and viable solution for handling hierarchical data while delivering good performance. To illustrate the usefulness of the hierarchyid data type, this session will tackle a problem of great financial and business significance to the manufacturing industry: Bill Of Materials (BOM). All of the various forms of the Bill of Materials (engineering, manufacturing, sales, service) are comprised of hierarchical data. Individual parts are assembled into units called subassemblies. Subassemblies and individual parts are assembled into finished goods. The BOM problem is explained in detail so that the application developer thoroughly understands the requirements. Next, the audience is shown how to take the requirements and transform them into a logical hierarchical model. Finally, the audience is shown how to take the logical design and use SQL Server's hierarchyid to implement the physical design. Implementing a BOM solution with SQL Server 2008 provides the developer with the skills to solve similar problems such as modeling an organizational structure, a set of tasks in a project, or web site navigation graphs.

SessionID: 62217

Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads

Back to calendar

Event Date: 03-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Glenn Berry

Title: Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads

Description:

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005 and 2008), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

SessionID: 62153

Self-Service Analytics with SQL Server 2008 R2 (Kilimanjaro)

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Dave Fackler

Title: Self-Service Analytics with SQL Server 2008 R2 (Kilimanjaro)

Description:

In this session, we'll take a look at the new self-service analytics Excel add-in (Gemini) available as part of SQL Server 2008 R2 (Kilimanjaro). Specifically, we'll look at using the new add-in to gather data into Excel, cleanse and model that data, and then use it as a source for pivot-table and pivot-chart analysis. In addition, we'll look at some of the new analysis features available in the next release of Excel, including slicers, improved charting, and improved pivot-table functionality. Finally, we'll discuss how these new features and capabilities are being used within the Department of Veterans Affairs to enable self-service analytics for several user groups at various levels of the organization. 

SessionID: 62091

DMV's as a Shortcut to Procedure Tuning

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Grant Fritchey

Title: DMV's as a Shortcut to Procedure Tuning

Description:

Dynamic Management Views and Functions (DMV/F) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. Most of the time you gather query performance data through server-side traces. This session will show how to gather information from the DMV/Fs for currently executing, and recently executed queries. It will demonstrate combining this information with other DMV/Fs to get the query text. I'll show how to also retrieve execution plans. With the established foundation for what can be retrieved, you can begin to expand out and see what's currently residing in cache and get the execution plan and query text for these objects. I'll show where you can get aggregate information for the queries in cache to determine which queries are being accessed most frequently or which is using the most CPU. I'll demonstrate methods for combining this information with XML queries to retrieve Missing Index recommendations from the query optimizer. I'll show how to determine which indexes are being used in your system and which are not. All of this will be focused, not on the DBA, but on the query writer, the developer or database developer that needs information to tune and troubleshoot data access.

SessionID: 62220

SQL Server Execution Plans From Compilation To Caching To Reuse

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Maciej Pilecki

Title: SQL Server Execution Plans From Compilation To Caching To Reuse

Description:

Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it's also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we will discuss in details the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse and aging. You will leave this session with full understanding of how to improve your servers performance by increasing execution plan reuse (or how to avoid reuse in case this is necessary).

SessionID: 62089

Understanding time zones and using them effectively in your database applications

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Charley Hanania

Title: Understanding time zones and using them effectively in your database applications

Description:

SessionID: 62158

The Ultimate Free SQL Server Toolkit

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: The Ultimate Free SQL Server Toolkit

Description:

Free and useful tools have proliferated since Microsoft launched the CodePlex website. Join Kevin Kline, author of the SQL Server Magazine column "Tool Time", as he profiles the very best of the free tools covered in his monthly magazine column - more than a dozen free tools and utilities! We will cover tools which: - Track database growth - Implement logging in SSIS jobsteps - Stress test your database applications - Automate important preventative maintenance tasks - Automate maintenance tasks for Analysis Services - Help protect against SQL Injection attacks - Graphically manage Extended Events - Utilize PowerShell scripts to ease administration And much more. These tools are all free and independently supported by SQL Server enthusiasts around the world.

SessionID: 62172

DBAs and the Dynamic Datacenter of the Future

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: DBAs and the Dynamic Datacenter of the Future

Description:

SessionID: 62223

A Tale of Careers and User Groups

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Andy Leonard

Title: A Tale of Careers and User Groups

Description:

There is value for your career in the User Group community - for novices and experts alike - especially in this economy. Andy Leonard discusses the value of networking through your local user group. Andy also discusses integrating your user group into the local business community using a proven sponsorship model.

SessionID: 62193

TempDB Configuration and Management in SQL Server 2008

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Dipti Sangani

Title: TempDB Configuration and Management in SQL Server 2008

Description:

This talk describes how to best configure and use TempDB in SQL Server 2008. We cover hardware configuration, file and filegroup layout, and tempdb log management. We also discuss special considerations for OLTP, Line-of-business, Data Warehouse, and Beyond-relational applications.

SessionID: 62226

Social Computing for the Database Professional

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Jason Massie

Title: Social Computing for the Database Professional

Description:

Until a few years ago, the online SQL Server community consisted of Usenet newsgroups, mailing lists and forums. Conversations were mostly, I have a problem and here is the fix. The landscape has changed drastically, but Database Professionals, conservative by nature, can sometimes to be slow to adopt new technologies. In this session, you will learn what new services are available, how to leverage them to build your professional network, get involved in the SQL community and, most importantly, do your job better. We will focus on the mainstay services of the forward thinking IT professional but will also give you a glimpse of the bleeding edge. We will also show you ways to connect SQL Server to this community for data mining, alerting and other creative uses. When you've got these tools and you announce that "I have a problem", the conversation becomes a real-time team event with some of the best SQL Server minds in the community ready to help you tackle the problem. Be prepared for an interactive session that will involve the worldwide online SQL Server community in real time. We won't just tell stories about how social networking helped us do our jobs better - we'll show how it works in real time. We'll show you how database professionals all over the world are staying in touch with the PASS Summit even as we're presenting.

SessionID: 62078

Developing with SQL Server Spatial: Flat Maps to Round Earth

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Developing with SQL Server Spatial: Flat Maps to Round Earth

Description:

With the advent of GPS phones and devices, spatial data is becoming increasingly more central to data processing and everyday applications. This session will provide an overview for the SQL Server 2008 spatial types and methods, focusing on some common pitfalls and differences between the flat map type geometry and round earth type geography.

SessionID: 62149

Business Intelligence in Microsoft SharePoint Server 2010

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Pej Javaheri

Title: Business Intelligence in Microsoft SharePoint Server 2010

Description:

Overview of what's new in SharePoint 2010 including PPS, Excel Services, Visio, and how you can build BI solutions.

SessionID: 62186

Resource Governor? What is that?

Back to calendar

Event Date: 03-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: Resource Governor? What is that?

Description:

Resource Governor is a new feature in SQL Server 2008 that allows you to control, well, the amount of resources used by various processes. These sessions will show you how Resource Governor works and how to implement this great new feature.

SessionID: 62087

SQL Server 2008 - Create powerful XML Schema collections to validate your XML documents

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: SQL Server 2008 - Create powerful XML Schema collections to validate your XML documents

Description:

XML is getting more widely used both inside and outside SQL Server. Stored procedures and functions that accept XML parameters or generate XML documents are part of almost every database project these days. When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. Using an XSD (XML Schema Definition) Schema, you can validate the structure and content of an XML document. SQL Server introduced XML Schema Collections in SQL Server 2005 and added a number of enhancements in SQL Server 2008. An XML data type variable or column that is bound to an XML Schema collection is called TYPED XML. When a TYPED XML column or variable is modified, SQL Server will validate perform the validations defined in the SCHEMA Collection and the operation will succeed only if the validation succeeds. In this session we will discuss SQL Server XML Schema collections and see how to create powerful XML Schema Collections to validate XML documents with diverse structure and content.

SessionID: 62143

Enabling Analysis with Excel Services

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Stacia Varga

Title: Enabling Analysis with Excel Services

Description:

Excel Services is a great way to give users a more interactive experience with data analysis than you can provide with reporting tools, but getting the configuration just right can be challenging. Come to this session to learn how to properly set up your technical environment to support centralized worksheets that provide access to Analysis Services data through Excel Services. You will also learn how to recognize and respond to common configuration problems and how to diagnose and resolve connectivity issues.

SessionID: 62124

Loading a Data Warehouse with SSIS

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Brian Knight

Title: Loading a Data Warehouse with SSIS

Description:

Now that you have a data warehouse designed, how would you go about loading the warehouse from your relational database that has been in production for years. Join Microsoft MVP and author Brian Knight in this session on how to use SSIS to load and synchronize a data warehouse. Brian shows you techniques around fact table and dimension loads and some methods to speed up development and load time.

SessionID: 62187

Scaling SQL Server beyond 64 hardware threads on Window 2008 R2: Challenges, Scalability numbers, and Best Practices

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: Scaling SQL Server beyond 64 hardware threads on Window 2008 R2: Challenges, Scalability numbers, and Best Practices

Description:

SQL Server 2008 R2 release introduces support for greater than 64 hardware threads going up to 256 on Windows Server 2008 R2. We will discuss our motivation to scale beyond 64 hardware threads and methodology to validate performance and scalability of SQL Server. We will provide details on SQL scalability numbers and hardware platforms it ran on. We will give insights into architectural learning and innovations that allowed SQL Server/Windows to scale beyond 64 hardware threads and talk about the SQL Server best practices/recommendations.

SessionID: 62205

SQL Server 2008 Manageability Features

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Peter Ward

Title: SQL Server 2008 Manageability Features

Description:

Microsoft SQL Server 2008 introduces a number of new features for managing SQL Server including Policy Based Management, Management Data Warehouse and Extended Events. These new management features have been designed to assist with diagnosing and resolving common performance issues. This session demonstrates how to troubleshoot various scenarios using the new management tools within SQL Server 2008. It demonstrates how to use the tools to assist with the management of multiple instances, how to monitor the performance of your severs over time and provide a greater insight into SQL Server.

SessionID: 62107

Overview of Business Intelligence capabilities in SQL Server 2008 & R2

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Herain Oberoi

Title: Overview of Business Intelligence capabilities in SQL Server 2008 & R2

Description:

If you are a SQL Server database administrator and have always wondered what Business Intelligence capabilities SQL Server has to offer, this session will provide an end-to-end overview of Business intelligence in SQL Server 2008 as well as a look at the new capabilities shipping in SQL Server 2008 R2.

SessionID: 62196

SQL Server 2008 - What's in for SAP - First Experience and Features used

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: SQL Server 2008 - What's in for SAP - First Experience and Features used

Description:

Examine the latest features coming with Microsoft SQL Server 2008, what they mean to SAP applications. Understand how several new key features, such as database compression and backup compression, can be used transparently in SAP NetWeaver 7.0 and can save substantial disk or tape space. Hear of real world examples in how to get a 6.5TB SAP ERP database reduced by 1.5TB with applying SQL Server 2008 Row Level compression. Look at features like Transparent Data Encryption and Change Data Capture. Learn how these capabilities work transparently with existing and new SAP solutions. See specific examples of new features that help you audit all non-SAP system access to tables. Learn the right way to utilize new performance capabilities such as Query Plan Freezing, which helps you improve and stabilize query performance and predictability. Benefit from the experiences of first customers using new features of SQL Server 2008.

SessionID: 62100

Making Effective Use of the Plan Cache

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s): Greg Low

Title: Making Effective Use of the Plan Cache

Description:

In this session, Greg will explain plan (or procedure) caching in SQL Server and how to ensure it is used effectively. The session will cover plan reuse, recompilation triggers, statistics and optimisation. It will also show how this has changed from SQL Server 2000 and 2005 to SQL Server 2008 and cover common causes of plan cache pollution.

SessionID: 62079

Entity Framework in the .NET Framework 4.0 and Visual Studio 2010

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Entity Framework in the .NET Framework 4.0 and Visual Studio 2010

Description:

In the .NET Framework 4.0 release the Entity Framework is being extended to enable a number of key scenarios previously unavailable with the .NET Framework 3.5 SP1, the first release of the Entity Framework. In this talk well do a quick lap around the scenarios, patterns, and functionality that has been added to the Entity Framework 4.0: Model First, POCO Support, T4 Template support for customized code generation, make building N-Tier application simpler, Query Improvements, and much, much more.

SessionID: 62170

Exploring Index Internals

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Kalen Delaney

Title: Exploring Index Internals

Description:

Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how your indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. In this session we will look at some of the undocumented commands to explore internal index structures, to see just exactly how your indexes are organized.

SessionID: 62210

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Allen White

Title: Gather SQL Server Performance Data with PowerShell

Description:

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.

SessionID: 62212

Designing and Building Private SQL Server Clouds

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Sarah Barela

Title: Designing and Building Private SQL Server Clouds

Description:

There is no hotter term right now than cloud computing, however, exactly what this means is a mystery to many people. We will begin this session by defining what cloud computing is and the benefits the technology offers the DBA. You may see the benefits of cloud computing, but are not yet comfortable trusting your sensitive data to the nebulous cloud. The goal of this session is to provide you a blueprint to design and build a private cloud, where you can control the server availability and performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. We will share how to use the features native to Microsoft Hyper-V and SQL Server 2008 to build a cloud in your data center. Learn how Hyper-V can provide on-demand scalability and improved resource utilization specifically for the unique SQL Server workload characteristics. We will discuss how to use Resource Governor to guarantee predictable performance, as well as, how to automate the allocation of resources based on the servers current performance, and how to contain problem processes. Finally, we will discuss how the Data Collector can be used to provide constant information about the health of the cloud to itself and to the DBA. Throughout the session, we will demonstrate how these ideas work together to create a new SQL Server infrastructure that will change as your needs change.

SessionID: 62131

Automating your Data Warehouse

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): SpeakerName

Title: Automating your Data Warehouse

Description:

A number of best practices exist for administering a Microsoft Business Intelligence solution: maintain your indexes, check for database health, monitor ETL performance, maintain database and cube partitions, periodically redesign cube aggregations, prepare the database and cube for daily consumption by warming the cache, etc. Doing this manually can eat up your day and detract from more proactive activities. This session addresses how to automate all aspects of your back-end BI solution, yet keep you informed of important statistics.

SessionID: 62198

SQL Server Consolidation and Virtualization: Myths, Realities and Best Practices

Back to calendar

Event Date: 03-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Joe Yong

Title: SQL Server Consolidation and Virtualization: Myths, Realities and Best Practices

Description:

Server consolidation has been pursued for years yet not many companies have been truly successful when it comes to database consolidation. The maturation of virtualization technologies further add to the many considerations users have to deal with in a consolidation project. Each vendor you talk to claims they have the best solution and/or technology for SQL Server consolidation while others are just selling snake oil. Who's right? What exactly is the relationship between consolidation and virtualization? Are the one and the same? If so, then why are there so many different technologies, each employing different strategies? Should I get the biggest server or build a server farm? Is automated server/instance provisioning truly automated? Why do I even start thinking about consolidation and/or virtualization? These are some of the questions that will be answered along with key best practices and caveats learned from dozens of consolidation projects that range from a dozen to over 4000 SQL Server databases. This session will explore key considerations in a consolidation project and common oversights that derail the project. It will also review notes from the field on the various solutions available today, the strengths, weaknesses and what scenarios they are most appropriate for. This session is about what happens after the cool demos and flashy presentations are over and users wake up to the good, bad and ugly realities of consolidation and virtualization.

SessionID: 62128

A Checklist of Best Practices for Securing Reporting Services

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Stacia Varga

Title: A Checklist of Best Practices for Securing Reporting Services

Description:

Safeguarding your report server is just as important as securing the database server itself. In this session, you learn about the threats to your report server whether running in native or SharePoint integrated mode in either an intranet or Extranet environment. To defend against these threats, this session will arm you with a checklist of steps that you can use to lockdown your report server. This session includes a review of best practices and recommendations for general deployment as well as for specific security scenarios and the differences between Reporting Services 2005 and Reporting Services 2008.

SessionID: 62141

Applied SSIS Design Patterns

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Andy Leonard

Title: Applied SSIS Design Patterns

Description:

"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! In this spotlight session, Andy Leonard defines design patterns applicable to SSIS, and then demonstrates their use to develop SSIS solutions. The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more; then demonstrate how to leverage the principles just described by applying them to every day SSIS development. Demonstrations will also include migration through the application lifecycle, deployment, and maintenance.

SessionID: 62166

SQL Server Always On Series: Part 2: SQL Server Failover Clustering Deep Dive (90 Mins)

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: SQL Server Always On Series: Part 2: SQL Server Failover Clustering Deep Dive (90 Mins)

Description:

In this session we will cover applicability of SQL Server Failover Clustering for mission-critical scenarios and disaster recovery options. The session will highlight the clustering features of SQL Server 2008 to allow minimal downtime for both unplanned failures and planned events. We will detail new enhancements to achieve rolling upgrades, patches and service packs, resulting in higher availability than previous releases. We will talk about the slipstream setup functionality to streamline the addition of a new node together with the latest updates, to increase high availability capacity of an existing cluster. We will walk you through a live demonstration of a rolling patch of a two-node SQL Server 2008 failover cluster on Windows Server 2008. We will also describe new enhancements in Windows Server Failover Clustering (WSFC) introduced in Windows Server 2008 and Windows Server 2008 R2 and how they can be leveraged for maximizing availability for database applications.

SessionID: 62182

Advanced Policy-Based Management for the Enterprise using the Enterprise Policy Framework (90 Mins)

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Lara Rubbelke

Title: Advanced Policy-Based Management for the Enterprise using the Enterprise Policy Framework (90 Mins)

Description:

Are you challenged with managing multiple versions of SQL Server, including SQL Server 2000, 2005 and 2008? Do you need a solution to maintain your defined standards across the enterprise? Policy-Based Management is an essential new feature to maintain a consistent deployment configuration across large distributed environments, enforce strict regulatory requirements, and manage the complexity of Microsoft SQL Server instances throughout the enterprise. This session will focus on best practices for designing policies, practical models to implement and manage policies, and a solution to centralize business and regulatory compliance reporting by extending Policy-Based Management to all SQL Server instances in your enterprise, including Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000.

SessionID: 62207

Identifying SQL Server Performance Problems Using SQL Trace

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Brad McGehee

Title: Identifying SQL Server Performance Problems Using SQL Trace

Description:

For those who find that the SQL Server 2005/2008 Profiler does not meet all their needs, or for those who prefer working programmatically with Transact-SQL System stored procedures instead of a GUI interface, there is SQL Trace, which is the engine behind the Profiler GUI tool. In this session, you will learn the pros and cons of using SQL Trace, learn what SQL Trace can do, learn how to implement it, learn how to automate it, and learn how to analyze SQL Trace results. This session will make heavy use of demos to explain how it works.

SessionID: 62231

Doing more with less - Dell I/T's 7 steps to a highly effective Database management organization

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s):

Title: Doing more with less - Dell I/T's 7 steps to a highly effective Database management organization

Description:

Recent economic challenges have forced us all to do more with less. Join the experts from Dell I/T's DBA management team to learn how Dell coped with this challenge. Its 7 step methodology dramatically improved the productivity of its DBA staff to support the ever changing demands of Dell's 60 billion dollar business. This session will illustrate how one can implement this methodology in any database management or IT organization. Once implemented, this method will be able to answer key organization questions like below: 1. How to demonstrate leanness (or fatness) of your DBA team in the current lay-off challenges of an IT organization? 2. How do your company compare against the industry DBA productivity benchmark? 3. How to measure the productivity increase of a DBA? 4. How do you methodically differentiate between an experienced and a novice DBA? 5. How do you identify, what training is required for your novice DBAs? 6. How do you identify DBA resource gaps in key areas of your business? 7. How do you identify key database process areas, which need improvement?

SessionID: 62162

Understanding Logging and Recovery in SQL Server

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Spotlight Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Paul Randal

Title: Understanding Logging and Recovery in SQL Server

Description:

Some of the most misunderstood parts of SQL Server are its logging and recovery mechanisms. The fact that the transaction log exists and can cause problems if not managed correctly seems to confound many DBAs. Why is it possible for the transaction log to grow unbounded? Why does it sometimes take so long for the database to come online after a system crash? Why can't logging be turned off completely? Why can't I recover my database properly? Just what is the transaction log and why is it there? In this in-depth session Paul will unravel the mysteries of the transaction log - its architecture and behavior under different recovery models - as well as how logging and recovery work in SQL Server. This is essential knowledge you need for understanding how backup, restore, log-shipping, database mirroring, and other technologies work.

SessionID: 62163

DBAs Behaving Badly... Worst Practices for Database Administrators

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Rod Colledge

Title: DBAs Behaving Badly... Worst Practices for Database Administrators

Description:

There are a vast number of best practices for SQL Server administration, however, depending on the environment, a lot of them may not be applicable or even appropriate. In contrast, worst practices are universally acknowledged by most SQL Server professionals as situations to avoid at all costs. In this session, we'll cover 10 categories of classic DBA mistakes and investigate real world examples of how these practices often end in disaster. We'll also cover tools and techniques that can be used in avoiding these situations, with an emphasis on the new features in SQL Server 2008. Categories covered will include disaster recovery, change control, file configuration, indexing, DBCC, service level agreements, SANs and virtualization.

SessionID: 62108

An End-to-End Introduction to SQL Server Reporting Services

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: An End-to-End Introduction to SQL Server Reporting Services

Description:

SessionID: 62081

Building FILESTREAM solutions with SQL Server 2008

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s): Klaus Aschenbrenner

Title: Building FILESTREAM solutions with SQL Server 2008

Description:

SQL Server 2008 provides the new FILESTREAM storage attribute, which stores binary data in the NTFS file system. In this session you will learn, how you can use this new storage attribute directly within T-SQL code, and how you can it from client applications through the native Win32 Streaming IO API. Furthermore you will learn about the performance impacts and penalties you have to worry about when using FILESTREAM in real-world applications. For very large mission-critical applications you will also see how you can combine FILESTRAM with the partition feature of SQL Server 2008.

SessionID: 62123

SQL Server Integration Services and the modern financial institution.

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Steve Simon

Title: SQL Server Integration Services and the modern financial institution.

Description:

Within the financial world there is often no getting around the fact that most raw data is mainframe based. This raw data in itself is often stored in a plethora formats, currencies and locations to suit local conditions and the corporation as a whole. With the advent of more and more communal SQL Server data warehouses and data marts (within our corporate environment), data clean ups and consolidation have gone from a nice to have to a real necessity. This hands-on presentation will show the attendee the tried and tested steps that we perform to rationalize our financial data. Emphasis is placed on showing the efforts that we undertake to ensure sound data quality and ETL design. It is this sound data quality, sound ETL design and SQL Server Integration Services that ensure that our SQL Server data marts are populated in an efficient and effective manner with a minimal amount of effort and time.

SessionID: 62065

What's New in SQL Azure

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: What's New in SQL Azure

Description:

Come and learn how SQL Data Services has evolved over the past year based on your feedback. In this session you'll learn how SQL Data Services delivers on promise of Database as a Service. You'll see how easy it is to take an existing class of SQL Server applications and extend them to the service using existing SQL Server knowledge, protocols, client libraries and tools. With minimal changes, your application will be running in a highly available and scalable service. Finally well touch on the business model, terms of use and present a roadmap for the service.

SessionID: 62112

SQL Server BI in the Cloud

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): John Welch

Title: SQL Server BI in the Cloud

Description:

These days, it seems like everything is moving to the cloud, and SQL Server is no exception. With SQL Data Services, we now have the option of hosting our relational databases in the cloud. What are the implications of this for business intelligence and data warehousing applications? During this session, we will look at the emerging patterns and practices around hosting relational BI information on SQL Data Services and integrating that data with Analysis Services and Reporting Services. We'll also investigate some of the challenges in moving data to and from the cloud, and what can be done to manage them. We will take an in-depth look at a sample application built using SQL Data Services, SQL Server Analysis Services, and SQL Server Reporting Services. We'll compare the performance of an on-premise solution with a cloud-based solution, and discuss how BI applications and environments can be architected today to support easy transition to the cloud.

SessionID: 62096

Developing with SQL Server Spatial: Deep Dive into Spatial Indexing (90 Mins)

Back to calendar

Event Date: 04-11-2009 10:15 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Developing with SQL Server Spatial: Deep Dive into Spatial Indexing (90 Mins)

Description:

SQL Server 2008's new spatial data support gets most of its performance and scalability from the ability to define indexes on spatial data. This presentation will describe how SQL Server 2008's spatial indexes work and will go through a series of use cases to show you how to improve your spatial application's performance even when it needs to scale to large amounts of spatial data. The target audience are programmers that have a core understanding of the spatial functionality either in other products or SQL Server.

SessionID: 62105

BI Power Hour

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Pej Javaheri

Title: BI Power Hour

Description:

SessionID: 62071

Database Design

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Louis Davidson

Title: Database Design

Description:

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). Properly structured data structures make it easier to work with data in simple SQL statements rather than having to resort to functional programming and cursors.

SessionID: 62211

How the Query Optimizer Works

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: How the Query Optimizer Works

Description:

The Query Optimizer is the component of SQL Server that attempts to determine the best way to execute a query by finding an efficient execution plan. This session will show you how a better understanding on how the Query Optimizer works and what information it needs to generate better execution plans, can help you to improve the performance of your databases. Learn about the high level structures of the Query Optimizer and some important factors that are considered during the optimization phase of query processing. See how you can provide SQL Server with appropriate statistics and indexes so it can perform better cardinality estimation and produce an efficient execution plan. Since the SQL Server Query Optimizer is a cost-based optimizer, this information will help it to better estimate the execution plan cost. Finally, although the Query Optimizer almost always selects a good enough execution plan for a query, it may not create an efficient plan for all the possible scenarios. See how you can troubleshoot these issues and how you can use other alternatives like hints or plan guides to force the query optimizer to produce a better execution plan.

SessionID: 62188

Scaling Online Transaction Processing Applications with SQL Server 2008

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: Scaling Online Transaction Processing Applications with SQL Server 2008

Description:

Microsoft SQL Server 2008 provides excellent support for high-performance transaction processing, from small to very large systems. In this session, we show you how to design your logical and physical database structures, architect and build your application, and select hardware and software to achieve the ultimate performance for online transaction processing (OLTP). We cover both scaling up on a single symmetric multiprocessor (SMP) and creative use of application-level scale out.

SessionID: 62067

Passing Information to SQL Server - Parameters

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Andras Belokosztolszki

Title: Passing Information to SQL Server - Parameters

Description:

Stored procedures and functions encapsulate application logic that can be shared and reused in multiple applications. Invoking these stored procedures and functions is seemingly simple, until you need to pass structured data, like arrays of objects, via the fixed number of parameters. For example adding a sales order via a stored procedure with a variable number of order items requires either multiple round trips to the server, or a way to serialize the order items into a single parameter. The first solution is expensive because of network latency, but for the second solution there is no standard approach to do the serialization. In this session we will explore the various methods available in the last three versions of SQL Server for passing and handling parameters, including manipulating comma separated lists, sql_variants, XML, temporary tables, communication tables and table valued parameters.

SessionID: 62077

SQL Server Driver for PHP

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Jay Kint

Title: SQL Server Driver for PHP

Description:

Are you developing enterprise ready solutions in PHP? If so, come learn about the newest version of the Microsoft SQL Server Driver for PHP. The driver enables reliable, scalable, and performance integration with SQL Server for PHP applications deployed on the Windows platform. The driver is a PHP 5 extension that provides a procedural interface for accessing data in all editions of SQL Server, and makes use of PHP features, including PHP streams to read and write large objects. Version 1.1, current available in community technology preview, introduces support for PHP 5.3, seamless handling of UTF-8 data, and scrollable results with row counts. During the session you will see the driver in action and learn how to rapidly build and deploy enterprise ready PHP solutions on top of SQL Server.

SessionID: 62180

Practical Performance Monitoring and Troubleshooting for the graduated beginner but not yet expert.

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Joe Yong

Title: Practical Performance Monitoring and Troubleshooting for the graduated beginner but not yet expert.

Description:

Are users complaining about slow performance of their SQL Server based applications? Do you know what the 200 rows returned by "SELECT * FROM sys.dm_os_wait_stats" mean? Do you even know where to start when users complains about poor performance (besides adding more RAM)? Performance tuning is a complex subject and many DBAs struggle with the subject. Industry experts that publish articles and books focus on advanced issues when most of the time, even the basics have not been addressed. This session takes a grounds-up approach to performance monitoring and tuning. We will look at the core tenets of designing for performance, key factors that influence performance and how to monitor your SQL Server systems for performance issues. This session is designed to be practical and does not require expert level knowledge of SQL Server. If you are confused with what you've been reading in whitepapers and blogs, or are tired of not knowing what to tell your users/management why performance is poor, this is the session for you.

SessionID: 62155

Creating a Digital Dashboard with SQL Server 2008

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Brian Larson

Title: Creating a Digital Dashboard with SQL Server 2008

Description:

SessionID: 62157

DRP101: Learn The Difference Between Your Log And Your Cluster

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Brent Ozar

Title: DRP101: Learn The Difference Between Your Log And Your Cluster

Description:

SessionID: 62199

Don't Wait! Consolidate on SQL Server 2008!

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Rick Heiges

Title: Don't Wait! Consolidate on SQL Server 2008!

Description:

SQL Server 2008 introduces features such as Resource Governor, Compression, Virtualization, and Policy-Based Management that help organizations consolidate to keep TCO down. A discussion of features since 2000 that enable consolidation along with the limitations of each will be presented. Real-world stories will enhance this discussion. The session will also encompass SQL Server on Virtual Machines.

SessionID: 62121

Designing Effective Aggregations in Analysis Services 2008

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Chris Webb

Title: Designing Effective Aggregations in Analysis Services 2008

Description:

Building aggregations is one of the most important ways of improving query performance in Analysis Services, but simply running the Aggregation Design Wizard doesn't always result in useful aggregations being built. This session shows the steps you need to go through in order to build aggregations that are actually going to be used by the queries that you're running.

SessionID: 62133

Looking Inside the Beast: Dissecting Complex MDX Formulas

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: Looking Inside the Beast: Dissecting Complex MDX Formulas

Description:

SessionID: 62200

SQLCAT: Customer Experiences with Data Compression

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Sanjay Mishra

Title: SQLCAT: Customer Experiences with Data Compression

Description:

SessionID: 62142

Top customer support issues in Analysis Services 2005/2008 and how to resolve them

Back to calendar

Event Date: 04-11-2009 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): John Sirmon

Title: Top customer support issues in Analysis Services 2005/2008 and how to resolve them

Description:

Go behind the front lines to find out what the Analysis Services Support team has learned from hundreds of support issues and numerous conversations with customers and the SSAS Development team. Few people speak to as many Analysis Services customers on a daily basis than Microsoft's Customer Service and Support (CSS) team. The Analysis Services CSS team has seen some of the best and some of the worst SSAS implementations. This session will focus on the top customer issues involving Analysis Services 2005/2008. During this session you will learn how to troubleshoot some of the most complicated Analysis Services problems using the most efficient methods. I will explain how the CSS support team handles issues like MDX query performance and processing performance. Learn what to do when you encounter an "unspecified error" or "the operation has been cancelled" and how to quickly address connectivity problems with your SSAS Clients. Discover tips and tricks you can use to quickly isolate the root cause. Don't have time to read the numerous Analysis Services whitepapers covering performance and design best practices... don't worry, we will take a guided tour of what you should know based on our Support Engineers' real world experience. We will cover the most common design mistakes we see customers make and what can be done to address them.

SessionID: 62164

Insight into Indexes

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Gail Shaw

Title: Insight into Indexes

Description:

SessionID: 62156

Adding SSRS Report Bells and Whistles

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Jessica Moss

Title: Adding SSRS Report Bells and Whistles

Description:

SessionID: 62204

SQLCAT: SQL Server Always On Series. Part 3: SQLCAT Customer Deployments, Best Practices & Panel Discussion

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Prem Mehra

Title: SQLCAT: SQL Server Always On Series. Part 3: SQLCAT Customer Deployments, Best Practices & Panel Discussion

Description:

This session includes real life customer deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. The content is based on various customer deployments. Technologies include: Fail-over Clustering, Database Mirroring, Log Shipping and Peer-to-Peer Replication. You will learn how customers utilize these technologies to achieve their HA and DR goals including reduced time for upgrades. In addition, there will be a panel of SQL Server Development staff members to interact with and respond to questions.

SessionID: 62161

The Impact of Native SQL Server 2008 Compression and Encryption on Various Database Workloads

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: The Impact of Native SQL Server 2008 Compression and Encryption on Various Database Workloads

Description:

SQL Server 2008 provides data compression and encryption natively. This session will share information that has been gained by implementing these features on different types/classes of database systems. Using this information, database designers and administrators can be better prepared to make informed decisions about the suitability of these features for their environment. The session will discuss how the system processor and disk I/O subsystems were affected when compression and encryption were applied to representative transaction-processing and decision-support databases.

SessionID: 62201

Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Jonathan Kehayias

Title: Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events

Description:

New in SQL Server 2008, Extended Events bring a refreshing new deep look at what actually happens inside the Database Engine. This session will focus on how to use the default system health session to perform initial troubleshooting, and how to create custom sessions using the available events, targets and actions available in the Extended Events metadata. The session will wrap up with how to use the information stored in the targets to solve specific problems.

SessionID: 62086

Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Tobias Ternstrom

Title: Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE

Description:

This session covers passing sets of data from a client application to a SQL Server 2008 instance. There are several solutions to this task, including the use of the SQL Server 2008 feature Table Valued Parameters (TVPs). In this session we will describe as well as compare multiple approaches to passing sets of data to SQL Server, such as calling a stored procedure repeatedly, passing the set as XML and passing the set using a TVP. We will also cover combining each solution with the new MERGE statement. A discussion on pros and cons of each approach as well as a look at end-to-end demos on each implementation is a promise!

SessionID: 62154

Introduction to PerformancePoint Services - Creating Dashboards is as easy as 1, 2, 3

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s):

Title: Introduction to PerformancePoint Services - Creating Dashboards is as easy as 1, 2, 3

Description:

Dashboards are most powerful when they provide a tailored experience for users, integrated into existing business processes. SharePoint provides limitless opportunities for creating a custom BI experience for users. This session will cover the basics of working with PerformancePoint Services to build organizational dashboards, scorecards, and analytic reports. We will also provide several examples of how PerformancePoint Services dashboards and reports can be integrated with custom content and SharePoint capabilities, such as workflow, to create an experience that blends perfectly with your existing SharePoint investments.

SessionID: 62228

Working in Management Will Rot Your Brain - How to Stay Technical and Advance Your Career

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Rob Garrison

Title: Working in Management Will Rot Your Brain - How to Stay Technical and Advance Your Career

Description:

Are you feeling the pressure to move into management? Feel that its the only way to advance your career and compensation? Learn how to keep doing the fun stuff and still advance in your career. Work now toward that top-level technical position that will keep you from spending your entire life in meetings. This session will include practical advice on what will help, what wont, how to look for the right position, and tails from highly successful architects and senior administrators who avoided the management track.

SessionID: 62102

The DW/BI System Lifecycle Overview the Kimball Approach

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Warren Thornthwaite

Title: The DW/BI System Lifecycle Overview the Kimball Approach

Description:

Many DW/BI systems struggle and die because the development team was unaware of the range and magnitude of tasks required for success. This session describes the Kimball approach from the best selling Data Warehouse Toolkit, 2nd Ed. (Wiley, 2008). Starting with an enterprise or program view, the lifecycle defines business opportunities from across the organization and works with senior management to identify the top priority opportunities. The core lifecycle project then drills in on business requirements and project definition around the top opportunities. With the business requirements in place, the lifecycle then branches out into three tracks: technical, data and applications. These three tracks make up the core of the design and development effort. The lifecycle flow comes back together when its time to deploy the initial iteration to the business community. The process then loops back to the beginning for another pass with the next priority opportunity and its associated source data set. You can't manage or participate in a project effectively if you don't know what needs to happen in each step, and what the resulting deliverables and dependencies are. You definitely won't be successful if you leave out any significant element of the overall lifecycle.

SessionID: 62136

Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Davide Mauri

Title: Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Description:

SessionID: 62126

Overcoming SSIS Deployment and Configuration Challenges

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Rushabh Mehta

Title: Overcoming SSIS Deployment and Configuration Challenges

Description:

It is no secret that a main deficiency of SSIS is deployment. Have you wanted to punch a wall before when trying to move a package from one server to another? You're not alone. This session will be more than just SSIS deployment anger management. We'll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don't miss the decision workflows that will help you down the right path on choosing the right storage and deployment approaches depending on your situation!

SessionID: 62076

Building Event-driven, Low-latency Applications with Microsoft's Platform for Complex Event Processing

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Roman Schindlauer

Title: Building Event-driven, Low-latency Applications with Microsoft's Platform for Complex Event Processing

Description:

In this session, we will explore how you can build event-driven applications to gain insight from high data rate event stream sources with very low latency. We will discuss the developer experience of Microsoft's new platform for complex event processing (CEP) that is currently being developed in the SQL Server engine team and planned to release in the first half of 2010. The session will focus on the following scenarios: (1) formulating declarative queries in LINQ to express powerful analytics over continuous event streams with high data rates, (2) programming against the object model of the CEP engine, and (3) writing adapters for event stream data sources. Attendees will learn how to use familiar development tools such as Microsoft Visual Studio 2008, .NET, C#, and, of course, LINQ for developing their event-driven applications.

SessionID: 62068

Panel Discussion: SQL Injection

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Plamen Ratchev

Title: Panel Discussion: SQL Injection

Description:

Are your SQL Servers and databases safe from SQL injection attacks? There are increasing reports of data being compromised by hackers. Are the defences against SQL injection best left to the SQL Server administrators? Or should they be left to application developers? How do administrators and developers best coordinate their defensive efforts? What are the ''best'' defenses? How do the attackers approach attacking a server? Should we just stop using dynamic SQL? In this lively panel discussion, SQL Experts Arnie Rowland, Adam Machanic, Peter DeBetta, Plamen Ratchev, Andrew Novick, and Rob Boek will discuss the pros and cons of filtering, rules, exception handling, blacklisting, parameterization, dynamic SQL, and minimal attack vectors. We will explore the questions of "Who is responsible?", "How did it happen to us?", "How to prevent being a victim?", and "We've been hit, now what?" You are likely to hear disagreements and differing opinions, great suggestions, horror stories, and lots of good information. You don't want to miss this session!

SessionID: 62080

Program, analyze and share data with almost any data source using ADO.NET Data Services

Back to calendar

Event Date: 04-11-2009 15:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Pablo Castro

Title: Program, analyze and share data with almost any data source using ADO.NET Data Services

Description:

With ADO.NET Data Services we defined a simple yet powerful RESTful interface for data-centric services. All clients and servers that follow the conventions used by Data Services immediately benefit from having a number of data producers and consumers available to them. In this talk we will introduce the Data Services RESTful service interface, and then discuss and show the new data services support in various Microsoft business intelligence products such as Gemini and Reporting Services, developer tools such as Visual Studio, and other products that will have data services support announced just in time for the PASS conference.

SessionID: 62094

SQL Server Efficiencies: Sparse Columns and Filtered Indexes

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Don Kiely

Title: SQL Server Efficiencies: Sparse Columns and Filtered Indexes

Description:

One of the tools that Microsoft provides to help minimize data storage sizes in SQL Server 2008 is sparse columns. Sparse columns provide an efficient way to store data that is predominantly null by requiring no disk storage space for the null values. This sounds great, but there is a cost: in a field marked as sparse, the non-null data takes up a bit more storage space than if the field weren't sparse, either two or four additional bytes depending on the data type of the field. A new feature in SQL Server 2008 that is useful with sparse columns although usable even if a table doesn't have sparse columns is filtered indexes. This is an index with a WHERE clause that allows you to index only a subset of the rows in a table. The index favors a subset of the data in the table, which is very useful with sparse columns because most of the data in the field is null. You can create a filtered index on the sparse column that includes only the non-null data. Doing so optimizes the use of tables with sparse columns. This session will explore both of these great new features that can raise the efficiency of your databases to new levels, both when used together and used apart.

SessionID: 62177

SQL Server Covering: Concepts, Concerns, & Costs

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Kimberly Tripp

Title: SQL Server Covering: Concepts, Concerns, & Costs

Description:

Covering—using an index to cover a query—is one of the most important tuning strategies possible in SQL Server. In fact, over the past few releases many index tuning features target specifically this—covering. SQL Server 7.0/2000 started the trend with indexed views, SQL Server 2005 added “INCLUDE” to allow non-key columns to be “included” in an index and SQL Server 2008 adds filtered indexes into the mix. In this session, we'll discuss the pros and cons of covering, the different strategies possible to achieve it, when it's a good idea to consider covering and when it's a must! This session focuses on tips and tricks for specific types of queries as well as general best practices to determine what’s best to cover. This session is filled with demos – and tips you can implement immediately. If you have critical queries that just don’t perform to your expectations, this session is for you!

SessionID: 62111

Security and Deployment with Reporting Services 2008 R2

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Lukasz Pawlowski

Title: Security and Deployment with Reporting Services 2008 R2

Description:

This session will cover the SQL Server 2008 and 2008 R2 architecture as well as the most common deployment scenario. This session will highlight some of the authentication limitations that were removed in SQL Server 2008 R2.

SessionID: 62093

Nordic - turn SQL Server into an Object Db

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s): Paul Nielsen

Title: Nordic - turn SQL Server into an Object Db

Description:

Objects and databases don't mix well. But, Nordic is a CodePlex open source T-SQL code-gen project that fully emulates object orientation within SQL Server, supporting class/attribute inheritance, workflow state w/inheritance, and associations with workflow state dependencies and inheritance. Associations with inheritance is very significant feature it takes the 2D relational model and makes it 3D - all inside that database without Entity Framework. Adding workflow state to associations is like adding business logic to foreign keys without any code. Using a generic .Net UI to engage the data, Nordic is makes it easy to model and build an object/relational database with a clean database abstraction layer. And its fast. In this session Paul demos the Nordic UI, walks though the stored procedure calls, and discusses how to design an object database using SQL Server.

SessionID: 62195

SQL Server 2005 / 2008 Performance Tuning and Optimization Techniques (90 Mins)

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): David Pless

Title: SQL Server 2005 / 2008 Performance Tuning and Optimization Techniques (90 Mins)

Description:

This discussion will cover how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008. In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and perfmon analysis. In this discussion I will cover SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally I discuss reading query plans graphically and what you can learn from reading the XML plans. I will also cover Performance Data Warehouse in SQL Server 2008, new features in SQL Server 2008 regarding missing indexes, viewing query plans, and Extended Events if time permits.

SessionID: 62190

Securing SQL Server from inside-attacks

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Ralf Dietrich

Title: Securing SQL Server from inside-attacks

Description:

In this presentation Ralf Dietrich and Andreas Wolter will assume the role of the DBA/DBDev and an external consultant. Playing through different scenarios, the external consultant will resort to all kinds of tricks to access data in a supposedly properly arranged database environment, which was actually not intended by the DBA/DBDev. Of course, he will then have the chance to fix this gap. The match is repeated on different levels with different scenarios until a desirable condition is reached. This session holds in store surprising insights even for experienced administrators, covering topics from schema ownership implication to best practices for user-permissions, while administrators may still allow the external consultants to do all necessary work.

SessionID: 62194

Designing a Highly Available SQL Server Infrastructure - Notes from the Field

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Ross Mistry

Title: Designing a Highly Available SQL Server Infrastructure - Notes from the Field

Description:

DBAs and IT Decision Makers typically feel compelled to choose the right technologies to achieve high availability when designing a SQL Server infrastructure. Some of the challenges they face are illustrated in their questions - Should I use Failover Clustering, Database Mirroring, Log Shipping or Replication? Which alternative provides the best protection? How does Windows Server 2008 impact my decision? Can I combine these technologies for maximum protection? What is the difference between single instance and multiple instance failover clustering? This session will alleviate pressure and concerns by providing DBAs and IT Decision Makers with best practices and tips on how to design and choose the right SQL Server 2008 high availability alternative to meet their organizations HA and disaster recovery needs. Technologies covered include Failover Clustering on Windows Server 2008, Database Mirroring, Log Shipping and Peer-To-Peer Replication.

SessionID: 62178

Manageability Series: Understand and Troubleshoot with Policy-Based Management and Data Collector

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Buck Woody

Title: Manageability Series: Understand and Troubleshoot with Policy-Based Management and Data Collector

Description:

X As a DBA, your job performance is probably based on the uptime of your systems and the speed at which you fix any problems that happen with your systems. SQL Server 2008 provides a new set of tools to help you understand the health of your systems, diagnose problems that may have occurred, and take the necessary corrective action. This session describes how you can use Policy Based Management, the Data Collector and its Management Data Warehouse, and PowerShell to keep your systems up and running so that you can keep your users happy.

SessionID: 62219

Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Maciej Pilecki

Title: Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management

Description:

Have you ever wondered why SQL Server seems to be using all the memory on your server? This session seeks to understand why this is, in fact, an expected behavior. The session discusses details of SQL Server internal memory usage and management and its interaction with the operating system. You will understand how SQL Server acquires, uses and releases memory, how to detect memory pressure and bottlenecks and how to properly configure SQL Server memory for different scenarios, especially on servers running other applications or with multiple instances of SQL Servers. You will leave this session with full understanding of SQL Server memory internals and ready to troubleshoot memory problems in the real world. Memory, how to detect memory pressure and bottlenecks and how to properly configure SQL Server memory for different scenarios, especially on servers running other applications or with multiple instances of SQL Servers. We will also cover differences between 32- and 64-bit architectures and why even on a 64-bit machine you can run out of Virtual Address Space. You will leave this session with full understanding of SQL Server memory internals and ready to troubleshoot memory problems in the real world.

SessionID: 62088

Understanding XQuery

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Dejan Sarka

Title: Understanding XQuery

Description:

XML data type is available from SQL Server 2005 and XML support is even enhanced in SQL Server 2008. However, there are not many DBAs and database developers using all of the XML possibilities in SQL Server. One of the obstacles for broader usage might be XQuery, the XML query language, which is not well known in relational community. In this session, we are going to explain basic XQuery structures and data types. After that, we are going to move to slightly more advanced topics, like using FLWOR expressions. We are going to show how you can iterate through XML nodes and even join two or more XML instances, and finally how you can design the returned XML instance.

SessionID: 62113

How to Get Rich (Quicker) Using the Time Series Data Mining Algorithm!

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Peter Myers

Title: How to Get Rich (Quicker) Using the Time Series Data Mining Algorithm!

Description:

SessionID: 62227

The Accidental Leader

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Richard Bolesta

Title: The Accidental Leader

Description:

The opportunity to lead can be thrust upon us at any time and how we react will be the difference in our teams success. The core of leadership is not the position but the act of leading and is too important, too individual and too complex to neatly reverse engineer into 3 or 5 simple rules or an acronym. Using my career experiences from DBA to Vice President as a backdrop, this presentation will explore Leadership and key aspects to leading successfully. If you are already a manager, planning to lead a team or just want to be prepared when given the opportunity to lead, this presentation will provide perspective on enablers to leadership success. Also, be prepared, I hope that I challenge your thoughts on leadership and generate questions, personal views and/or opinions. Interaction is a key part of this unique presentation.

SessionID: 62127

Data Profiling and Cleansing with Integration Services 2008

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Erik Veerman

Title: Data Profiling and Cleansing with Integration Services 2008

Description:

This session targets the new data profiling capabilities of Integration Services 2008 as well as performing data cleansing. Most data sources have missing values, typographical errors, duplicated rows, mismatched rows, or just plain bad data there's no magic solution, but SSIS will help you understand and clean your data faster and with less stress. Come hear how to best apply the data profiling and cleansing capabilities in SSIS to get a better grip on your bad data.

SessionID: 62118

Custom Security in SQL Server Analysis Services

Back to calendar

Event Date: 04-11-2009 16:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Marco Russo

Title: Custom Security in SQL Server Analysis Services

Description:

A multidimensional database usually contains confidential data that can be shown only to authorized users. Analysis Services allows you to define access rules in several ways, ranging from simple manual authorization to more complex rules, which defines a security boundary customized using properties of the connected user. These rules can be implemented by using either MDX or Stored Procedures of Analysis Services. In this session we'll see strengths and limits of access control in Analysis Services. We will start considering the most simple and common scenarios. Then, we'll consider other configurations with an increasing complexity that will require stored procedures and/or support cubes. Among other things, we will cover the issues of hiding calculated members.

SessionID: 62135

Advanced Techniques for SSIS Package Development

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: Advanced Techniques for SSIS Package Development

Description:

SSIS makes it fairly easy to get started with ETL development, but also contains a number of advanced features that can be employed to make your solutions faster, more robust and more maintainable. Come to this session to learn more about these features, including how to:

SessionID: 62117

Creative Approaches to Large Dimensions in Analysis Services

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: Creative Approaches to Large Dimensions in Analysis Services

Description:

If you have worked with large dimensions in Analysis Services—that is, dimensions with roughly a million or more members—you have undoubtedly worked to optimize query performance. All too often, performance tuning results in a query improvement of perhaps 5-10%, even after investing countless hours fine-tuning server settings or thousands of dollars on hardware. This session presents several real-world situations where sluggish query performance improved by orders of magnitude, not as the result of adjusting server settings nor as the result of adding hardware, but as the result of applying an unorthodox design to one or more large dimensions—sometimes by intentionally violating "best practice" guidelines. The primary goal of the session is not to give you a specific solution to your precise scenario—although that would indeed be fortuitous—but rather to stimulate new ideas about ways you can approach your large dimensions. Likewise, the session does not focus on the complex and esoteric, but on the pragmatic and productive, even include simple dimension properties that often merely go unnoticed.

SessionID: 62214

SQL Server Data Warehouse Query Acceleration: Under the Hood

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Eric Hanson

Title: SQL Server Data Warehouse Query Acceleration: Under the Hood

Description:

Our internal tests showed an across-the-board 2.5X performance improvement on the same hardware using SQL Server 2008 for data warehouse query processing, after enabling PAGE compression, compared with SQL Server 2005. Some customers have experienced as much as a 10X performance gain after a similar transition. Virtually all these performance gains come from four improvements in SQL Server 2008: star join performance, partitioned table parallelism, few outer rows parallelism, and data compression. This talk lifts the hood of SQL Server 2008 and shows you how these features work in detail.

SessionID: 62099

Managing Hierarchies in SQL Server 2008 with HIERARCHYID

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Managing Hierarchies in SQL Server 2008 with HIERARCHYID

Description:

Managing hierarchical and tree structure data in any data store can be challenging. Several techniques exist that can solve the problem of modeling and implementing this type of data. This session shows you how to design and implement these different techniques, including the new HIERARCHYID, for managing hierarchical data structures in SQL Server 2008.

SessionID: 62140

SQLCAT: A Preview of PowerPivot Best Practices

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Dave Wickert

Title: SQLCAT: A Preview of PowerPivot Best Practices

Description:

This session provides a preview to some of the PowerPivot Best Practices that we have already accumulated. These best practices are based on customer interactions with their own data as well as enterprise implementations.

SessionID: 62098

T-SQL Tips & Tricks

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Spotlight Session (75 minutes) - Track: Application Development

Speaker(s): Itzik Ben-Gan

Title: T-SQL Tips & Tricks

Description:

This session covers advanced T-SQL techniques in SQL Server 2005 and 2008. It provides tips regarding how to solve T-SQL problems that are non-trivial, and explains how to address common needs efficiently. This session will cover topics such as calculating non-deterministic row numbers, generating a large virtual auxiliary table of numbers, enforcing uniqueness while allowing multiple NULLs, bushy join plans, date and time manipulation, sorting separated lists of values, inline scalar UDFs, maintaining custom sequences, and more as time permits.

SessionID: 62159

SQLCAT/SQL Server Consolidation Series - Consolidation and virtualization best practices and recommendations (90 Mins)

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Lindsey Allen

Title: SQLCAT/SQL Server Consolidation Series - Consolidation and virtualization best practices and recommendations (90 Mins)

Description:

Come learn the tools, tips and best practices useful when planning a consolidated SQL Server environment. This first session from the two part series will highlight the planning phase of a consolidation project. Steps such as identifying consolidation candidates and evaluating key trade-offs between approaches including ROI, performance, and workload isolation will be covered. Case studies and examples from customer implementations will serve to reinforce key points

SessionID: 62114

Kimball Approach Dimensional Modeling Across SQL Server and SSAS

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Warren Thornthwaite

Title: Kimball Approach Dimensional Modeling Across SQL Server and SSAS

Description:

A well designed dimensional model provides the best performing, most flexible, and most easily understood data foundation for the DW/BI system. The dimensional model underlies every successful Microsoft-based DW/BI project. This is true both for the relational platform, leveraging the Star Join optimization in SQL Server 2008 database engine, and in Analysis Services which was fundamentally re-architected in 2005 to support true dimensional models. This session starts with a review of the core concepts of dimensional modeling and explores most of the basic design patterns. We'll present a simple spreadsheet that you can use to design and build your relational dimensional model. We''ll then talk through how to transpose that model into the Analysis Services environment. We'll also talk about why this two-tier data architecture with the dimensional model in both the relational database and in SSAS is mandatory for long term success.

SessionID: 62129

Creating Data-Driven Subscriptions in SSRS

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Spotlight Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Joe Webb

Title: Creating Data-Driven Subscriptions in SSRS

Description:

Providing information to those that need it when they need it is key for many businesses. But, being able to automatically disseminate critical information in a timely fashion can be a challenge. In this session, we will discover how data-driven subscriptions in SQL Server Reporting Services can be used to effectively deliver reports to a varying list of subscribers.

SessionID: 62130

SQLCAT: Analysis Services Consolidation & Virtualization

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Carl Rabeler

Title: SQLCAT: Analysis Services Consolidation & Virtualization

Description:

In this session you will learn about consolidation and virtualization techniques and practices that the SQL CAT team has used with a variety of customers.

SessionID: 62082

SQLCAT: SQL Service Broker: High Performance Distributed Applications in Real World Deployments

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Michael Thomassy

Title: SQLCAT: SQL Service Broker: High Performance Distributed Applications in Real World Deployments

Description:

SQL Service Broker (SSB) ships with SQL Server 2005 and 2008. Microsoft continues to invest in enhancing SSB. It provides high-performance, exactly-once, messaging deeply integrated with the SQL Engine. In SSB, Services are configured to reside within a deployed SQL engine. A service may initiate a light-weight dialog to another service and engage in a full-duplex asynchronous messaging interaction. This empowers the SSB application to build a loosely-coupled distributed application that can scale and handle intermittent connectivity. SQL Service Broker is designed to be the foundation of a high-performance enterprise and Internet scale application engines. It is in deployment at many of our largest customers. Bank Itau (Sao Paulo, Brazil) is the largest financial institution in Latin America (16th largest in the world). It has numerous applications running on SQL Server including some processing over 8,400 durable messages per second per instance. MySpace is the largest internet social networking site in the world and currently deploys over 400 SSB instances responsible for all of their traffic. Some of their boxes process over 18,000 transaction and durable messages per second. This talk will explain the business goals for SSB, its architecture, how an application uses SSB, and examine 2 customer implementations contrasting large scale batch processing and real-time online processing.

SessionID: 62225

Team Management Crash Course

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Kevin Kline

Title: Team Management Crash Course

Description:

Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team by presenting a variety of common byt challenging workplace scenarios. Topics include motivational skills, conflict resolution skills, communication skills and project/job tracking skills. Attendees will also learn: 1. How to launch a team and keep the members of that team focused and motivated 2. How to resolve conflicts, address performance problems, and handle project/job missteps 3. How to gain support for your ideas, earn upper management support, and communicate with top management

SessionID: 62208

Capturing and Analyzing File & Wait Stats

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Andrew Kelly

Title: Capturing and Analyzing File & Wait Stats

Description:

See how to easy and efficient it can be to capture and analyze file and wait statistics. When it comes to overall system performance these two sets of statistics can help you focus in on the bottlenecks like no others. You can incorporate the demo code immediately into your environment with little effort. More importantly you will now be able to determine exactly what these statistics mean and how to address them. Do you know what your system is waiting on and why? If not you will after this session.

SessionID: 62160

SQL Server Consolidation Series - Anatomy of a SQL Server consolidation Project

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): CLIFFORD DIBBLE

Title: SQL Server Consolidation Series - Anatomy of a SQL Server consolidation Project

Description:

In this second session of the two part consolidation series well demonstrate how to use new Microsoft features when implementing a consolidated SQL Server environment. Key focus areas for this session include the upcoming SQL Server 2008 R2 Utility, Data Tier Application Components and SQL Server Connection Plans. Best practices for Hyper-V deployments will also be covered.

SessionID: 62074

Entity Framework 4.0 for DBAs

Back to calendar

Event Date: 05-11-2009 10:45 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Entity Framework 4.0 for DBAs

Description:

The Entity Framework enables application developers to define domain models for use in their applications. In this setting the Entity Framework can be used to perform CRUD operations with very expressive query capabilities. This session will take a slightly different perspective on the Entity Framework: instead of discussing only the developers’ domain we will also discuss how the Entity Framework can be a compliment to the general concerns that Database Administrators express. In particular this talk will investigate how the Entity Framework enables developers and DBAs to agree on a conceptual model that acts as a shared contract, providing DBAs control over their database and the entry points into the system that developers utilize by using the Entity Framework’s mapping technology and related features. We will focus on the features that are being added in the Entity Framework 4.0 that provide better integration with the DBA along with a discussion of the integration we are doing between the Entity Framework and other SQL Server such as Reporting Services.

SessionID: 62138

Super Reports: Patterns & Recipes

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Paul Turley

Title: Super Reports: Patterns & Recipes

Description:

Design fewer reports to meet more business requirements. You'll learn how apply creative and advanced techniques to design more capable reports with SQL Server 2008 Reporting Services, using expert patterns and recipes. Material will be presented from our forthcoming Wiley book: Super Reports Patterns and Recipes for Reporting Service 2005 and 2008.

SessionID: 62137

ETL: The Linchpin for the Complete Data Warehouse

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Joy Mundy

Title: ETL: The Linchpin for the Complete Data Warehouse

Description:

The Kimball Method always emphasizes the data model as the key to an effective data warehouse / business intelligence system, but the ugly truth is that a lot of power rests with the unappreciated ETL developer. How can we develop ETL systems that dazzle? We can ensure data quality early and often. We can (almost) never break. We can proactively create table and cube partitions. We can even imagine it! Write dynamic ETL components that are kicked off by a business user. The programmability of Integration Services and the entire Microsoft BI product stack makes a SQL Server 2008 data warehouse a good candidate for highly automated excellence in ETL system management. All of these solutions require a bit of coding, but rest assured if Joy can do it, so can you. This session examines several ideas for innovative ETL systems including: - Elegant auditing and data quality checking - Painless partitioning for the RDBMS and Analysis Services - User-initiated processing

SessionID: 62122

Maximize Your SSIS Investment with Tuning Tricks and Tips

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Matt Masson

Title: Maximize Your SSIS Investment with Tuning Tricks and Tips

Description:

Maximize the performance of your packages with this set of best practices and data flow tuning techniques. We'll show you how to improve the operational efficiency of various Integration Services connectors, and take a look at how to efficiently load your data warehouse solutions.

SessionID: 62183

Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Buck Woody

Title: Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support

Description:

As a DBA, performing the same tasks - day in and day out - limits how much you can meet the demands of your organization. SQL Server provides a number of tools to meet your automation needs that includes Maintenance Plans, SQL Server Integration Services, PowerShell, and DB Mail. This session will demonstrate how and when to leverage the various automation tools that are available to you.

SessionID: 62070

Advanced Nested Sets model in SQL

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Joe Celko

Title: Advanced Nested Sets model in SQL

Description:

Most programmers know about the nested sets model for trees and hierarchies, but not the advanced uses. 1) The proper constraints to assure data integrity and why doing it right make the adjacency list model too slow and complex 2) Comparing trees for the same nodes, and/ same structure. 3) Hierarchical aggregation functions at th4e sub-tree level (i.e. accumulating weights up a parts explosion) 4) Manipulating nested set models - moving subtrees, duplicating subtrees, shuffling siblings

SessionID: 62174

SQLCAT: Customer Experiences Deploying Data Warehouse Solutions using the FastTrack Architecture

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: SQLCAT: Customer Experiences Deploying Data Warehouse Solutions using the FastTrack Architecture

Description:

Microsoft recently introduced the FastTrack Data Warehouse Reference Architectures -- providing a set of balanced hardware specifications and software best practices for deploying Relational DW solutions that rely on Sequential IO patterns.

The FastTrack architecture offers high query performance for large databases using cost-effective hardware configurations

This talk will review the principles behind the FastTrack architectures, the best-practices for building a large data warehouse solution in the FastTrack environment, and examples from customers that have prototyped and deployed FastTrack solutions this year.

SessionID: 62116

Reporting Services - Sharepoint 12 & 14 Integration

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Prash Shirolkar

Title: Reporting Services - Sharepoint 12 & 14 Integration

Description:

In SQL Server 2008 R2, SSRS has revisited how they integrate with SharePoint in Office 14 in order to simplify configuration, but also made some improvement in Office 12. This session will cover the major changes about how these two platforms integrate as well as cover some of the innovations that will appear in SharePoint 14 including: Multizone support, Report on SharePoint list and others.

SessionID: 62218

Advanced Failover Clustering Installation Techniques with SQL Server 2008 and Windows Server 2008

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Allan Hirt

Title: Advanced Failover Clustering Installation Techniques with SQL Server 2008 and Windows Server 2008

Description:

With Windows Server 2008 (including the upcoming R2 version) and SQL Server 2008, throw out what you know about installing SQL Server: everything is different. If you want to successfully deploy SQL Server 2008 on Windows Server 2008, whether it is via GUI, command line, PowerShell, or a combination of things, this session will walk you through the myriad of installation options and how to use them. This session is not for beginners new to clustering SQL Server, and will have quite a bit of demos.

SessionID: 62119

What All Microsoft BI Developers Need to Know About MDX so that They Can Create Required Business Calculations

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: What All Microsoft BI Developers Need to Know About MDX so that They Can Create Required Business Calculations

Description:

Many BI Developers create dimensions and cubes without knowing much about MDX. But there is a certain amount of MDX knowledge that is absolutely essential so that cubes can display the information required by a business. This session focuses on teaching the MDX that is needed to create calculated measures and named sets. This is an introductory look at MDX, considering what every BI developer should know and be able to do with MDX. Not every BI developer needs to be able to write MDX queries. But every developer should understand the MDX code needed to create calculated measures and named sets. Every developer should be able to write the MDX needed to create Key Performance Indicators (KPIs) to meet business requirements. A short session cannot teach you everything about MDX, but it can give you a solid introduction to the language, so that you can start using its power to give your business the information it needs.

SessionID: 62101

Troubleshooting applications accessing SQL Server

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Troubleshooting applications accessing SQL Server

Description:

Even the simplest and most common problems in your Data Access applications like Connection timeouts and Authentication can take really long to isolate and resolve. CSS has been solving a lot of these issues over the years and have a collective knowledge of resolving them in a faster and efficient way. In this presentation we will show you how to use publically available tools like Network Monitor, BID Trace, SQL Profiler, Windows Debugger etc to resolve these problems with applications using ADO.Net, SQL Native Client, MDAC etc.

SessionID: 62069

Yes, I'm Actually Using The Cloud

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Brent Ozar

Title: Yes, I'm Actually Using The Cloud

Description:

There's a lot of hype around cloud-based databases. After you get past the knee-jerk reaction about security, what else matters? Is it time to buy in, and what should you watch out for? Brent explains some of the pros and cons he's experienced running SQL Servers in the cloud, and will demonstrate how easy it is to fire up a new SQL Server in the cloud. Brent's involved with StackOverflow.com as an advisor, and he'll talk about the decisions they made about whether to host production and/or disaster recovery servers in the cloud. To read the full session outline, check out http://www.brentozar.com/go/passout - the formatting is a little rough here in the text boxes.

SessionID: 62222

Achieving Work-Life Balance - What does it really mean?

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Denise McInerney

Title: Achieving Work-Life Balance - What does it really mean?

Description:

What does it really mean to have Work-Life Balance? Join this Panel Discussion and find out how real people in the real world deal with the day-to-day issues and how they balance the demands of work and personal life. The discussion will introduce techniques to help balance work, manage stress, set priorities and find time to enjoy life with family, participation in your community, hobbies and other interests. Personal stories and experiences will be shared by the panel as well as interactive participation from the audience. This session was inspired by the discussion at the Women In Technology Luncheon held at the PASS Community Summit in Seattle in November 2008. All Summit attendees are welcome to attend this session. This session will be presented by members of the Women in Technology SIG.

SessionID: 62146

Advanced BI Capabilities in Excel & Excel Services

Back to calendar

Event Date: 05-11-2009 13:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Diego Oppenheimer

Title: Advanced BI Capabilities in Excel & Excel Services

Description:

This session will cover the new advanced capabilities in Excel Services 2010 to help you create detailed analytical reports, showing how you can use dynamic sets leveraging the content in Analysis Services, using write-back to provide closed loop analysis, and taking advantage of the new calc-member filtering and slicers with cube functions.

SessionID: 62092

Advanced Physical Database Design for SQL Server 2008

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Boris Baryshnikov

Title: Advanced Physical Database Design for SQL Server 2008

Description:

In this session we will cover advanced aspects of physical database design such as choice of clustered vs. non-clustered indexes, use of normalization to improve performance, partitioning as a form of indexing, things to consider when working with sparse columns, filtered indexes, indexed views, and partition-aligned indexed views. We will illustrate some of the advanced functionality available in SQL Server 2008 such as missing index DMVs and Database Tuning Advisor (DTA).

SessionID: 62229

Are You Cut Out to be a Consultant?

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Rick Heiges

Title: Are You Cut Out to be a Consultant?

Description:

This session will help you determine if you are ready to be a consultant. We have all worked with external consultants and wondered if this is a job that we can do. We will discuss the business aspects of becoming a consultant as well as the benefits/pitfalls.

SessionID: 62209

Using Policy Based Management to Mange your Environment

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Randy Dyess

Title: Using Policy Based Management to Mange your Environment

Description:

SQL Server 2008 introduces a new component that will allow database administrators to manage multiple databases and instances. In this session, you will learn how to use PBM to create policies that you can use to manage new and existing databases and new and existing instances whether these instances are SQL Server 2000, 2005, or 2008. This session will discuss how to create policies that you can use to configure and audit all your SQL Server instances and databases from a central location.

SessionID: 62173

SQLCAT: SharePoint on SQL Server - Implementation, Configuration and Tuning

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: SQLCAT: SharePoint on SQL Server - Implementation, Configuration and Tuning

Description:

If you or your customer is implementing a SharePoint/SQL Server solution then you will not want to miss this session. We will present the SharePoint architecture as it relates to SQL Server and explain why things work the way they do. We will also cover best practices around SQL Server configuration, maintenance, tuning and high-availability, as well as details about some customer deployments and changes being introduced in Office 2010.

SessionID: 62064

Developing Java Applications Against SQL Server 2008"

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s):

Title: Developing Java Applications Against SQL Server 2008"

Description:

If you are interested in or currently developing a Java application for SQL Server 2008, then find out how the Microsoft SQL Server JDBC driver can help you utilize the features of SQL Server 2008. The JDBC Driver provides access to SQL Server 2008 from any Java application, application server, or Java-enabled applet as a Type 4 JDBC driver. The JDBC Driver provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform Enterprise Edition 5 (Java EE 5). Version 2.0, the current version of the JDBC Driver, is JDBC 4.0 compliant and runs on the Java Runtime Environment (JRE) 5.0 or later providing cross-platform support. During this session you will hear about the enterprise-readiness and major features of the JDBC Driver that will enable you to harness the power of SQL Server.

SessionID: 62181

Getting To Know Your Indexes

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Jason Strate

Title: Getting To Know Your Indexes

Description:

Without proper indexing SQL Server can be hard pressed to create efficient and performance execution plans. Dynamic Management Views (DMV) and system views provide a slew of information about indexes that can be used to analyze indexes within SQL Server. In this session we'll go under the hood of SQL Server to look at DMVs and system views to know what indexes you have, should have, and how they feel about the way applications are treating them.

SessionID: 62179

Using SQL Server 2008 for Performance Tuning

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Buck Woody

Title: Using SQL Server 2008 for Performance Tuning

Description:

There are always lots of performance tuning presentations at PASS. You can learn statements, views, tools and other processes to tune a particular statement or load. But do you know how to go about a "tuning session"? Have you ever taken a baseline of your systems? Do you know where to start? This session is focused not so much on the individual tuning statements (although several are covered) but on the processes and tools you can use in SQL Server 2008 to monitor and tune SQL Server 2008, SQL Server 2005 and even SQL Server 2000 systems. You'll learn what works and what doesn't against each version and edition, and how you can leverage what you've already paid for to form a robust, repeatable performance tuning session on your SQL Server Instances.

SessionID: 62150

Advanced Dashboard creation with PerformancePoint Services

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s):

Title: Advanced Dashboard creation with PerformancePoint Services

Description:

Following the exciting merging of PerformancePoint Services with SharePoint, you can now leverage the dashboard, scorecard, and analytic capabilities of PerformancePoint within SharePoint to manage your company's performance. This demo-based deep-dive into the PPS BI capabilities will highlight the integration with SharePoint, including simplified security and deployment; advanced scorecards, including dynamic hierarchies, multiple actual values, and variance; and enhanced analytics, including value filtering and the Decomposition Tree. Attendees will get an in-depth view of the PerformancePoint Services architecture, including the shared service application server, web front-end web services and web parts, and database. This session will also explain how PerformancePoint Services leverages the power of claims-based authentication and a unified security model. Lastly, the session will discuss the deployment options available for enterprise organizations delivering Business Intelligence to all users.

SessionID: 62120

Building Planning Applications without PerformancePoint

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Dan Bulos

Title: Building Planning Applications without PerformancePoint

Description:

Now that Performance Point-Planning has been discontinued, how can you build planning, budgeting, and forecasting applications? All the tools you need are at hand in the Microsoft tool chest. This session outlines how to build a custom planning application with a Microsoft stack. Learn how to determine what kind of planning application you're building so you can appropriately customize the architecture and design. Gain insights into how to design the Analysis Services cubes, including how to design a write-back and modeling application vs. one focused on reporting metrics and KPI's. Delve into the pros and cons of using Excel vs. the web for your client interface, and get tips on architectures and techniques for each. Finally, learn how to best use Windows Workflow to create a submission path and the implications for the database design. There is no reason to give up on planning applications. Come and find out how to build your own.

SessionID: 62169

Proactive DBA: Manage SQL Server Better

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Ross LoForte

Title: Proactive DBA: Manage SQL Server Better

Description:

At Microsoft we understand that in the current economic climate you are being asked to better manage your database environment and reduce costs; in essence, keep the lights on. We have pulled together best practices for not only keeping the lights on but helping you manage more SQL Servers with less time and expense. The goal is to help you understand your SQL Server environment and teach best practices for managing and maintaining it. At the end of the presentation, you will know how to better manage more SQL Servers with less. The entire discussion is based on you keeping the lights on and there is no need to upgrade your current SQL Servers to take advantage of the bulk of these best practices. The focus of this presentation is around: o Management best practice: SQL Server Discovery

-Microsoft Assessment and Planning Toolkit (MAP) -MAP query and report analysis -SQL Server 2008 management enhancements -Policy Based Management -Performance Data Warehouse -Configure Resource Governor o Management best practice: Cross Platforms

SessionID: 62167

Solid State Disks and SQL 2008: High Availability and Performance

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s):

Title: Solid State Disks and SQL 2008: High Availability and Performance

Description:

Solid State Disks (SSD) have recently become an extremely hot topic in enterprise storage. Extremely High performance databases have led SSD adoption in the Enterprise and the plummeting price has opened the door for more and more databases to benefit from SSDs. This session will present a survey of the styles of SSD options available today focusing on the type of media (RAM, SLC Flash, MLC Flash) and interface method (SAN, Direct attached, Disk form factor, and PCIe). In order to determine if a particular SQL database can benefit from SSDs its IO profile must be determined. Steps to measure the storage metrics to understand a databases IO profile using perfmon and fn_virtualfilestats (Transact SQL2005) will be presented. The SQLIO benchmarking utility can then be used to evaluate both traditional disk storage and SSD approaches to eliminating IO bottlenecks for a particular IO profile. Additionally, various solution architectures will be presented for different types of SSD deployments will be presented with a focus on using SQL Mirroring.

SessionID: 62103

Understanding Master Data Management and the Benefits

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: Understanding Master Data Management and the Benefits

Description:

SessionID: 62109

SQLCAT: Madison Overview and Madison Technology Preview Results

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s):

Title: SQLCAT: Madison Overview and Madison Technology Preview Results

Description:

Madison is a highly scalable, highly available appliance for enterprise data warehousing for data volumes in the petabyte range. Madison uses massively parallel processing (MPP) to deliver high performance and scalability on a platform based on SQL Server 2008, Windows Server 2008, and industry-standard hardware. In this session, we'll review the concepts and principles behind Madison, provide a functional overview of the appliance, demonstrate how the appliance distributes data and queries for optimum performance and provide a timeline of major milestones. This session will also present use-cases and early functional and performance results from the Madison Technology Previews (MTP's).

SessionID: 62206

The Problem with Parallelism...

Back to calendar

Event Date: 05-11-2009 14:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Victor Isakov

Title: The Problem with Parallelism...

Description:

Will adding more processors to your SQL Server automatically improve question? You would think so... But in certain scenarios you will find that performance will actually be degraded. That queries will be executed poorly, or that there will be more contention problems, or a range of other issues. In this session Victor Isakov will present a number of problems that you may encounter due to a "high" degree of parallelism, and how to manage them. In this day and age where quad-core, quad-processor servers are becoming the norm, it is more important for the DBA to understand how to configure and troubleshoot such SQL Server instances.

SessionID: 62115

Managing PowerPivot

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): John Hancock

Title: Managing PowerPivot

Description:

As an IT Professional, you will likely have many questions about PowerPivot for Excel (formerly known as Project Gemini). How does IT manage the self-service process? What are the implications of PowerPivot for data access and provisioning? What server configuration will be needed? And of course many more. In this session, we will explore PowerPivot from the viewpoint of IT. We will introduce the tools and services available for IT Pros to manage the PowerPivot environment, and we'll have a substantial Q&A section to answer your burning, or maybe just smouldering, questions.

SessionID: 62151

Monitor Your Business with PerformancePoint Services Monitoring and Analytics

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Craig Utley

Title: Monitor Your Business with PerformancePoint Services Monitoring and Analytics

Description:

Is your business looking to deliver better information by implementing scorecards, dashboards, and analytic reports? PerformancePoint Services (PPS) allows businesses to easily deliver content from their data warehouses to a wide variety of users throughout the organization. The Monitoring server enables businesses to create powerful, intuitive scorecards that focus on anything from the entire enterprise to an individual employees goals. Analytics provides tools for users to perform in-depth analysis of the data in the warehouse. Learn how to create interactive scorecards and analytic reports and deliver these items to users at all levels of your business.

SessionID: 62203

Storage for the DBA

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Denny Cherry

Title: Storage for the DBA

Description:

One of the biggest issues in database performance is around storage. It's also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, well be looking at storage from both the database and storage perspectives. We'll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we'll be looking at an actual EMC SAN which I'll be bringing with me so that we can translate what we see in the Storage Array with what we see on the actual server.

SessionID: 62147

Data Analysis Expressions in PowerPivot for Excel 2010

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Howie Dickerman

Title: Data Analysis Expressions in PowerPivot for Excel 2010

Description:

PowerPivot for Excel (formerly known as Gemini) introduces some exceptionally powerful features for Excel users. Among them is a new range of expressions that we call DAX. DAX has much of the power of MDX, but has much of the simplicity of Excel syntax. This session introduces the DAX expressions in depth and reveals the simple power of this new tool. Essential for anyone already familiar with MDX, and for anyone who has wanted to code advanced calculations but has found MDX overly challenging.

SessionID: 62125

ETL from the Trenches: Using SSIS in the Real World

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): Dave Fackler

Title: ETL from the Trenches: Using SSIS in the Real World

Description:

Sure you've read the SSIS books. And sure you've seen a lot of SSIS presentations. But how do you put it all together to create a solid ETL framework for loading your data warehouse environment? In this session, we'll look at the ins and outs of a real-world ETL environment built using SSIS. We'll discuss the SSIS design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and several different data transformation requirements. We'll also discuss how the development team responsible for the ETL environment at the Department of Veterans Affairs handles package auditing and logging, team development, package testing, and automated deployments.

SessionID: 62148

Introducing Reporting Services 2008 R2: Report Builder 3.0 and the new visualization capabilities (Maps, Sparkline, Indicators)

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery

Speaker(s): Bob Meyers

Title: Introducing Reporting Services 2008 R2: Report Builder 3.0 and the new visualization capabilities (Maps, Sparkline, Indicators)

Description:

SQL Server 2008 R2 will introduce a new version of Report Builder (3.0) with some major innovations. This session will be very demo intensive and showcase many of the improvements in report design layout. We will design reports using the new Map report item, demonstrate sharing & reusing predefined report parts, design shared data sets, and then show how we can expose these reports as live data sources to other applications such as Microsoft Excel.

SessionID: 62202

SQLCAT: Designing High Performance I/O for SQL Server (90 Mins)

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Thomas Kejser

Title: SQLCAT: Designing High Performance I/O for SQL Server (90 Mins)

Description:

In this session we will try to provide the "full story about I/O". We will start all the way at the hardware level and work our way up the stack, through the OS, Drives, Disk Management and up to the SQL Server and Analysis Services. We aim to provide you with a lot of information and best practices on this naturally complex subject.

SessionID: 62085

What's New in T-SQL Programmability in SQL Server 2008

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: Application Development

Speaker(s): Tobias Ternstrom

Title: What's New in T-SQL Programmability in SQL Server 2008

Description:

This session will cover those TOP and exciting new 2008 T-SQL programmability features and enhancements for SQL data types, SQL language, T-SQL procedure programming, SQL/Common Language Runtime (CLR), T-SQL deployment management, T-SQL supportability, globalization, and etc. There will be code examples for most of the features and exciting demos for some typical ones.

SessionID: 62216

Advanced SQL Server 2008 Extended Events: Performance Profiling and Troubleshooting Techniques

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Adam Machanic

Title: Advanced SQL Server 2008 Extended Events: Performance Profiling and Troubleshooting Techniques

Description:

Imagine tracking and aggregating wait statistics at the session level rather than the server level. Imagine seeing exactly how long each step in your query took and figuring out the real cost of that index scan. Imagine capturing an exception with an associated callstack--no more guessing about exactly which component failed and why. When you're done imagining, open your eyes and attend this session, where you will learn all of these techniques and more, all thanks to Extended Events (XEvents)--SQL Server 2008's powerful new tracing infrastructure. Designed for DBAs and developers who already understand the basics of XEvents, this session will go from 0 to 60 in the first few minutes. You will see a number of code examples and gain an understanding of how to maximize XEvents for performance profiling and troubleshooting purposes. If you are serious about making your SQL Servers fly, this is one session not to be missed.

SessionID: 62110

Using Agile Development Techniques with Integration Services

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture

Speaker(s): John Welch

Title: Using Agile Development Techniques with Integration Services

Description:

Traditionally, data warehouse development has been done with a waterfall approach, but over the last few years, there has been more and more interest in using agile approaches. This session focuses on the use of agile development practices like test driven development, pair programming, continuous integration, and refactoring in projects using SQL Server Integration Services. The benefits and challenges of applying these techniques will be discussed, along with proven approaches to common challenges. Whether you have used agile approaches in the past, but are struggling to apply it to Integration Services, or you haven't used agile approaches at all, but want to understand the benefits, you will find valuable information in this session.

SessionID: 62185

Transactional Replication: Beyond The Basics

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Kendal Van Dyke

Title: Transactional Replication: Beyond The Basics

Description:

At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

SessionID: 62197

Sizing SQL Servers for (unknown) Workload

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Thomas Grohser

Title: Sizing SQL Servers for (unknown) Workload

Description:

We need a SQL Server for the application X. Hardware Requirements: nobody knows.... How many times have you had a request like this. In this session I will share the techniques I use to predict production workloads with hundreds of users based on captured workload from one user testing the software. See how to capture the required information, how to calculate the workload, how to simulate it on various platforms. I will also share which effect adding hardware to your server will have on the performance, starting with a single CPU, single disk, low memory machine and show component by component what you gain from which expansions for OLTP and DSS workloads. All steps are also presented with life demos.

SessionID: 62191

Securing and Hardening a SQL Server Implementation - Notes from the Field

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Ross Mistry

Title: Securing and Hardening a SQL Server Implementation - Notes from the Field

Description:

SQL Server is regularly targeted by hackers as it is a repository of sensitive data for organizations. If breached, hackers can gain access to confidential information including, but not limited to credit card numbers, social security numbers, and marketing information. This presentation covers topics pertaining to best practices and tips on how to secure and harden a SQL Server 2008 & 2005 implementation. Some of the security and hardening topics covered include: minimize surface area with policy based management, encryption, advanced auditing, configuring a Windows Server 2008 firewall, applying security templates with Active Directory, and consolidating SQL Server logs.

SessionID: 62176

Lies, damned lies and statistics

Back to calendar

Event Date: 05-11-2009 16:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Gail Shaw

Title: Lies, damned lies and statistics

Description:

Ever wondered what the things called statistics are, why they're important and what needs to be done to maintain them? If so, this session is for you! In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate. Finally well cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.