sqlpasshistory

ID: 726

Back to Main list

PASS Summit 2008

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
19-11-2008 10:00	Brian Knight	Regular Session (60 minutes)	Business Intelligence	Performance Tuning SSIS 2005 and 2008
19-11-2008 10:00	Erik Veerman	Regular Session (60 minutes)	Business Intelligence	Overcoming SSIS Deployment and Configuration Challenges
19-11-2008 10:00		Regular Session (60 minutes)	Business Intelligence	Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools
19-11-2008 10:00	Allen White	Regular Session (60 minutes)	Database Administration	Using PowerShell to Get the Most out of SQL Server
19-11-2008 10:00	Greg Low	Regular Session (60 minutes)	Database Administration	Avoiding Stored Procedure Recompilations
19-11-2008 10:00	Mark Souza	Regular Session (60 minutes)	Database Administration	SQLCAT - Overall Lessons Learned from SS2008 Experiences
19-11-2008 10:00		Regular Session (60 minutes)	Database Administration	SQL Server 2008 on SAN; Lessons Learned and Best Practices
19-11-2008 10:00	Adam Machanic	Regular Session (60 minutes)	Application Development	Supporting Highly Concurrent Business Processes with SQL Server 2005 and 2008
19-11-2008 10:00	Itzik Ben-Gan	Regular Session (60 minutes)	Application Development	Introduction to T-SQL Enhancements in Microsoft SQL Server 2008
19-11-2008 10:00		Regular Session (60 minutes)	Application Development	Improving the performance of your enterprise data modeling processes
19-11-2008 10:00		Regular Session (60 minutes)	Application Development	Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions
19-11-2008 13:00	Il-Sung Lee	Regular Session (60 minutes)	Database Administration	SQLCAT - Security (Auditing, Encryption) -- Data Security, Admin Security
19-11-2008 13:00	Erland Sommarskog	Regular Session (60 minutes)	Application Development	Much Ado: A Panel Discussion About ""Nothing""
19-11-2008 13:00		Regular Session (60 minutes)	Database Administration	Reaching Compliance with SQL Server 2008
19-11-2008 13:00	Jeremy Kadlec	Regular Session (60 minutes)	Database Administration	Capitalizing on the SQL Server 2005 System Information
19-11-2008 13:00	Warren Thornthwaite	Regular Session (60 minutes)	Business Intelligence	Putting the Business in Business Intelligence — Using Business Requirements to Drive DW/BI System Development
19-11-2008 13:00		Regular Session (60 minutes)	Business Intelligence	BI Power Hour
19-11-2008 13:00	Andrew Novick	Regular Session (60 minutes)	Application Development	Big Data: Working with Terabytes in SQL Server
19-11-2008 13:00	Andy Warren	Regular Session (60 minutes)	Professional Development	Should You Move Into Management?
19-11-2008 13:00	Rick Heiges	Regular Session (60 minutes)	Professional Development	Are you cut out to be a consultant?
19-11-2008 13:00	Brad McGehee	Regular Session (60 minutes)	Database Administration	DBA 101: Best Practices for All DBAs to Follow
19-11-2008 13:00	Kun Cheng	Regular Session (60 minutes)	Database Administration	SQLCAT - SS2008 developer and ISV experiences
19-11-2008 13:00	Brent Ozar	Regular Session (60 minutes)	Database Administration	Interpreting Perfmon and Profiler Results with Cloud-Based BI
19-11-2008 15:00	Denny Lee	Regular Session (60 minutes)	Business Intelligence	SQLCAT - Building SSRS SS2008 Large Scale Solutions
19-11-2008 15:00		Regular Session (60 minutes)	Business Intelligence	How to build an effective Date dimension (in SSAS)
19-11-2008 15:00	Grant Fritchey	Regular Session (60 minutes)	Application Development	Deploying DB Pro to Multiple Environments
19-11-2008 15:00	Edwin M Sarmiento	Regular Session (60 minutes)	Professional Development	Using Emotional Intelligence in Information Technology
19-11-2008 15:00	Andy Leonard	Regular Session (60 minutes)	Business Intelligence	SSIS Scripting
19-11-2008 15:00		Regular Session (60 minutes)	Database Administration	Understanding and troubleshooting transactional replication performance
19-11-2008 15:00		Regular Session (60 minutes)	Database Administration	Database Unit Test Why-How-Now
19-11-2008 15:00		Regular Session (60 minutes)	Database Administration	So You Inherited The DBA Position; Now What?
19-11-2008 15:00	Stacia Varga	Regular Session (60 minutes)	Business Intelligence	Troubleshooting MDX Query Performance
19-11-2008 15:00		Regular Session (60 minutes)	Database Administration	Identifying Performance Bottlenecks
19-11-2008 15:00		Regular Session (120 minutes)	Database Administration	SQL Server 2008 Failover Clustering
19-11-2008 15:00		Regular Session (60 minutes)	Application Development	WiE, a Location-Based Social Networking Application Built with SQL Server, SQL Server Data Services, Sync Framework, SQL Server Compact and Virtual Earth.
19-11-2008 16:00	J May	Regular Session (60 minutes)	Database Administration	Disk Partition Alignment: Increase I/O Throughput by up to 10%, 20%, 30% or More
19-11-2008 16:00	Paul Randal	Spotlight Session (120 minutes)	Database Administration	Corruption Survival Techniques
19-11-2008 16:00	Michael Thomassy	Regular Session (60 minutes)	Database Administration	SQLCAT - Service Broker Performance & Scalability Techniques from Real-World Implementations
19-11-2008 16:00	Allen White	Regular Session (60 minutes)	Database Administration	Automating SQL Server Administrative tasks with PowerShell
19-11-2008 16:00	Sharon Dooley	Regular Session (60 minutes)	Database Administration	SQL Server 2008 Policy-based Management
19-11-2008 16:00	Kevin Kline	Regular Session (60 minutes)	Professional Development	Team Management Fundamentals
19-11-2008 16:00	David Baldauff	Regular Session (60 minutes)	Application Development	Designing a Secure SQL Server 2008 Solution
19-11-2008 16:00		Regular Session (60 minutes)	Application Development	Building embedded, occasionally connected database applications with SQL Compact
19-11-2008 16:00	Joe Yong	Spotlight Session (120 minutes)	Database Administration	Upgrading to SQL Server 2008: Lessons learned and recommended practices
19-11-2008 16:00	Bob Beauchemin	Spotlight Session (120 minutes)	Application Development	Using spatial data in SQL and in clients
19-11-2008 16:00	Paul Turley	Spotlight Session (120 minutes)	Business Intelligence	Super Reports: One Report for Many Requirements
19-11-2008 16:00	Rushabh Mehta	Spotlight Session (120 minutes)	Business Intelligence	Building an SSIS Management Framework
20-11-2008 10:00	Chris Webb	Regular Session (60 minutes)	Business Intelligence	Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS
20-11-2008 10:00	Steve Simon	Regular Session (60 minutes)	Application Development	DTS 2000 migration to SSIS...makes financial sense !!
20-11-2008 10:00	Thomas Kejser	Regular Session (60 minutes)	Business Intelligence	SQLCAT - World Record ETL and ELT (SS2005/2008)
20-11-2008 10:00	Shawn Weisfeld	Regular Session (60 minutes)	Application Development	SQL Server CLR
20-11-2008 10:00	Don Kiely	Regular Session (60 minutes)	Application Development	Table Value Parameters Revolutionize Data Programming!
20-11-2008 10:00		Regular Session (60 minutes)	Database Administration	ROI of SQL Server 2008: A Presentation by Forrester Research
20-11-2008 10:00	Kalen Delaney	Regular Session (60 minutes)	Database Administration	Guiding Your Query Plans
20-11-2008 10:00	Andrew Kelly	Regular Session (60 minutes)	Database Administration	Capturing and Analyzing File & Wait Stats
20-11-2008 10:00	Bob Ward	Regular Session (60 minutes)	Database Administration	CSS - Debugging the Memory of SQL Server 2008
20-11-2008 10:00	David Darden	Regular Session (60 minutes)	Database Administration	Effectively using the Resource Governor in SQL Server 2008
20-11-2008 10:00		Regular Session (60 minutes)	Database Administration	How to Protect SQL Server with Microsoft Data Protection Manager 2007
20-11-2008 10:00		Regular Session (60 minutes)	Business Intelligence	Key to MDX formulas in the new (2005/2008) world
20-11-2008 13:00	Richard Tkachuk	Regular Session (60 minutes)	Business Intelligence	SQLCAT - Performance Troubleshooting for AS (SS2005, SS2008)
20-11-2008 13:00	Brian Larson	Regular Session (60 minutes)	Business Intelligence	Combining Disparate Data in an SSRS Report
20-11-2008 13:00	Thomas LaRock	Regular Session (60 minutes)	Database Administration	SCOM and Database Monitoring
20-11-2008 13:00		Regular Session (60 minutes)	Application Development	Programming T-SQL in SQL Server 2008, and Beyond!
20-11-2008 13:00	Paul Nielsen	Regular Session (60 minutes)	Application Development	Smart Database Design with MVPs Dr. SQL and Paul
20-11-2008 13:00	Eric Hanson	Regular Session (60 minutes)	Business Intelligence	Scaling up your data warehouse with SQL Server 2008
20-11-2008 13:00	Kevin Cox	Regular Session (60 minutes)	Database Administration	SQLCAT - Performance Troubleshooting - MDW / Xevents / etc (2008)
20-11-2008 13:00	Juergen Thomas	Regular Session (60 minutes)	Database Administration	SQLCAT - Building High Performance systems for SQL Server relational (SS2005/2008)
20-11-2008 13:00	Prem Mehra	Regular Session (60 minutes)	Database Administration	SQLCAT - Building HA SQL Server (SS2005/2008) Deployment Solutions Using LL from Cust Deployments
20-11-2008 15:00	Jerome Halmans	Regular Session (60 minutes)	Database Administration	Advanced Troubleshooting with SQL Server Extended Events
20-11-2008 15:00	Eric Kang	Regular Session (60 minutes)	Database Administration	Query Editing Enhancements in SSMS That Will Rock Your World
20-11-2008 15:00	Prash Shirolkar	Regular Session (60 minutes)	Business Intelligence	Reporting Services 2008 Integration with SharePoint
20-11-2008 15:00		Regular Session (60 minutes)	Database Administration	Storage considerations when running SQL Server in a virtualized environment
20-11-2008 15:00		Regular Session (60 minutes)	Business Intelligence	SQLCAT - Large Scale Relational Data Warehouse Learnings
20-11-2008 15:00	Andy Leonard	Regular Session (60 minutes)	Application Development	Test-Driven Development for Database Professionals
20-11-2008 15:00	Jeremy Kadlec	Regular Session (60 minutes)	Application Development	Building Data Models with SQL Server 2005 Management Studio
20-11-2008 15:00	Michael Lato	Regular Session (60 minutes)	Professional Development	Telecommuting
20-11-2008 15:00	Hugo Kornelis	Regular Session (60 minutes)	Application Development	Cursors or setbased? Why not both?
20-11-2008 15:00		Regular Session (60 minutes)	Application Development	SQL Server 2008: Deep Dive into Spatial Data Type and Indexing
20-11-2008 16:00	Steve Hughes	Regular Session (60 minutes)	Application Development	XML Data Type Methods in the Real World
20-11-2008 16:00	Sunil Agarwal	Regular Session (60 minutes)	Database Administration	Reducing Storage Cost in SQL Server 2008
20-11-2008 16:00	Brad McGehee	Regular Session (60 minutes)	Professional Development	How to Become an Exceptional DBA
20-11-2008 16:00	Shon Hauck	Regular Session (60 minutes)	Database Administration	CSS - Implementing and Supporting SQL 2008 Failover Clustering
20-11-2008 16:00	Joe Webb	Spotlight Session (120 minutes)	Application Development	Tips & Tricks for Writing Better Queries
20-11-2008 16:00	Maciej Pilecki	Regular Session (60 minutes)	Database Administration	The Most Persistent Microsoft SQL Server Myths: Perceptions and Realities
20-11-2008 16:00	Craig Utley	Regular Session (60 minutes)	Business Intelligence	Do It Right: Best Practices for Analysis Services 2005 and 2008
20-11-2008 16:00	Erin Welker	Spotlight Session (120 minutes)	Business Intelligence	High-performance Data Warehouses in SQL Server 2008
21-11-2008 10:00		Regular Session (120 minutes)	Professional Development	How to manage a Team of Technical Professionals
21-11-2008 10:00	Sanjay Mishra	Regular Session (120 minutes)	Database Administration	SQLCAT - Data Compression & Backup Compression Lessons Learned from Customer Deployments
21-11-2008 10:00		Regular Session (120 minutes)	Database Administration	SQL Server 2008 Failover Clustering
21-11-2008 10:00	Il-Sung Lee	Regular Session (120 minutes)	Application Development	Protecting Your Data — Security from the Application to the Database
21-11-2008 10:00	Thomas Grohser	Regular Session (120 minutes)	Database Administration	Failure is not an Option, 24x7 OLTP Database Management for VLDB
21-11-2008 10:00		Regular Session (120 minutes)	Database Administration	CSS - Upgrading to SQL Server 2008 - Avoid Gotchas and Known Issues
21-11-2008 10:00	Robert Dorr	Regular Session (120 minutes)	Database Administration	CSS - How it Works: File Streams
21-11-2008 10:00	Il-Sung Lee	Regular Session (120 minutes)	Application Development	Protecting Your Data — Security from the Application to the Database
21-11-2008 10:00	Brian Knight	Regular Session (120 minutes)	Application Development	Hacking SQL Server
21-11-2008 10:00	Dan Bulos	Regular Session (120 minutes)	Business Intelligence	Architecting a PerformancePoint Planning Solution
21-11-2008 10:00		Regular Session (120 minutes)	Business Intelligence	Incremental data warehouse loads with MERGE and Change Data Capture
21-11-2008 10:00	John Welch	Regular Session (120 minutes)	Business Intelligence	Unit Testing SSIS Packages
21-11-2008 13:00	Buck Woody	Regular Session (60 minutes)	Database Administration	Advanced Powershell and SQL Server
21-11-2008 13:00		Regular Session (60 minutes)	Database Administration	Monitoring Object Changes with Event Notification
21-11-2008 13:00	Victor Isakov	Regular Session (60 minutes)	Database Administration	Implementing Partitioned Views with Table/Index Partitioning
21-11-2008 13:00	James Luetkehoelter	Regular Session (60 minutes)	Database Administration	What`s the Fuss? Collecting and Analyzing Performance Metrics in SQL Server 2005 and 2008
21-11-2008 13:00	Michael Thomassy	Regular Session (60 minutes)	Database Administration	SQLCAT - Pan-STARRS: Building 100TB+ Scientific VLDBs with SQL Server 2008
21-11-2008 13:00	Bill Ramos	Regular Session (60 minutes)	Database Administration	Performance Troubleshooting using SQL Server 2008 Management Studio
21-11-2008 13:00		Regular Session (60 minutes)	Application Development	Entity Framework Futures: Empowering the data developer
21-11-2008 13:00	Maciej Pilecki	Regular Session (60 minutes)	Application Development	SQL Server User-Defined Functions - The Good, The Bad, The Ugly
21-11-2008 13:00	Dave Fackler	Regular Session (60 minutes)	Business Intelligence	Optimizing Dimension Designs in SSAS
21-11-2008 13:00	Lara Rubbelke	Regular Session (60 minutes)	Application Development	Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management
21-11-2008 13:00		Regular Session (60 minutes)	Business Intelligence	Integrating Predictive Analysis Throughout the Data Lifecycle
21-11-2008 14:00	Allan Hirt	Regular Session (60 minutes)	Database Administration	Deep Dive Into SQL Server Consolidation
21-11-2008 14:00		Regular Session (60 minutes)	Database Administration	SQL Server 2008 on SAN; Lessons Learned and Best Practices
21-11-2008 14:00	Linchi Shea	Regular Session (60 minutes)	Database Administration	Benchmarking Server Hardware Platforms for SQL Server Performance
21-11-2008 14:00	Kathi Kellenberger	Regular Session (60 minutes)	Professional Development	Writing Technical Articles
21-11-2008 14:00	Denise McInerney	Regular Session (60 minutes)	Database Administration	XML in My Database! Implementation on a Live e-Store Using SQL Server 2005
21-11-2008 14:00	Joy Mundy	Regular Session (60 minutes)	Business Intelligence	Populating a Kimball Method DW with SQL Server and Integration Services 2008
21-11-2008 14:00	Carl Rabeler	Regular Session (60 minutes)	Business Intelligence	SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008
21-11-2008 14:00		Regular Session (60 minutes)	Application Development	Optimizing bulk operations involving data cleansing and merging with Table-Valued Parameters
21-11-2008 14:00	Stacia Varga	Regular Session (60 minutes)	Business Intelligence	Configuring Reporting Services Security Correctly
21-11-2008 14:00	Ross LoForte	Regular Session (60 minutes)	Database Administration	Applying Workload Resource Governance with SQL Server 2008
21-11-2008 16:00	Craig Utley	Regular Session (60 minutes)	Business Intelligence	Avoid Slow SSAS Queries: MDX Query Troubleshooting
21-11-2008 16:00		Regular Session (60 minutes)	Application Development	[Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong
21-11-2008 16:00	Srini Acharya	Regular Session (60 minutes)	Professional Development	Working with Semi-structured data in SQL Server 2008
21-11-2008 16:00	Carolyn Chau	Regular Session (60 minutes)	Business Intelligence	Designing sophisticated and Data visualization rich Reports using Microsoft SQL Server 2008 Reporting Services
21-11-2008 16:00	Krzysztof Kozielczyk	Regular Session (60 minutes)	Application Development	SQL Server 2008 .NET integration programming
21-11-2008 16:00		Regular Session (60 minutes)	Database Administration	SQLCAT - SQL Server 2008 Virtualization with Windows Server 2008 Hyper-V
21-11-2008 16:00		Regular Session (60 minutes)	Database Administration	Advanced Policy-Based Management with Microsoft SQL Server 2008
21-11-2008 16:00		Regular Session (60 minutes)	Database Administration	Effective usage of SQL Server 2005 Database Mirroring, what`s new in SQL 2008
21-11-2008 16:00	Louis Davidson	Regular Session (60 minutes)	Application Development	Why Normalization Matters
21-11-2008 16:00	Gail Shaw	Regular Session (60 minutes)	Application Development	The dirty dozen... 12 Ways to write badly performing T-SQL
21-11-2008 16:00	Kevin Kline	Regular Session (60 minutes)	Database Administration	End-to-End Troubleshooting for SQL Server 2005

SessionID: 61966

Performance Tuning SSIS 2005 and 2008

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Brian Knight

Title: Performance Tuning SSIS 2005 and 2008

Description:

In this demo-rich presentation, Brian and Devin show you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server`s resourcing. Lastly, discover SQL Server 2008 features that will make SSIS more efficient.

SessionID: 61965

Overcoming SSIS Deployment and Configuration Challenges

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Erik Veerman

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? Youre not alone. This session will be more than just SSIS deployment anger management. Well look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don`t miss the Visio decision tree that will help you down the right path depending on your situation!

SessionID: 61964

Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools

Description:

Microsoft`s data integration and business intelligence (DI and BI) suite of tools based upon the SQL Server platform (Integration, Analysis, and Reporting Services, or SSIS, SSAS, and SSRS) comprise a rich opportunity for metadata integration with other popular modeling tools. In particular, data modeling tools, such as CA ERwin Data Modeler, may contain and/or maintain the metadata required for source and/or target DI specifications in SSIS, SSAS relational databases. Other design tools, like Kalido, maintain warehouse and BI designs which may be forward engineered into SSAS. In addition, with multiple producers and consumers of metadata there is a great need for multi-vendor metadata management, as well as end-to-end lineage and impact analysis. This session will explore the means by which these other vendors are able to exchange relational, OLAP and reporting design metadata with SSIS, SSAS and SSRS. In addition, the session will show end-to-end lineage and impact analysis for complete IM solutions based upon a collection of the products. Finally, the metadata management implications of such a heterogeneous environment will be discussed.

SessionID: 61995

Using PowerShell to Get the Most out of SQL Server

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Allen White

Title: Using PowerShell to Get the Most out of SQL Server

Description:

PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before. Whether you need to access data or manage SQL Server, PowerShell makes it possible. This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.

SessionID: 61998

Avoiding Stored Procedure Recompilations

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Greg Low

Title: Avoiding Stored Procedure Recompilations

Description:

In this session, Greg describe the process by which SQL Server executes stored procedures and how it decides whether or not recompilations are necessary. He discusses how to monitor recompilations and explains in detail the specific triggers that cause recompilation. Greg then discusses techniques to be used when writing database code to help avoid the need for recompilations and to help keep systems performing well.

SessionID: 61997

SQLCAT - Overall Lessons Learned from SS2008 Experiences

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Mark Souza

Title: SQLCAT - Overall Lessons Learned from SS2008 Experiences

Description:

We have worked with more than 100 customers who have deployed SQL Server 2008. Like any new release there are some interesting surprises on the experience both good and not as good. This session will cover the overall implementation of SQL Server 2008 experiences across the box.

SessionID: 61996

SQL Server 2008 on SAN; Lessons Learned and Best Practices

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: SQL Server 2008 on SAN; Lessons Learned and Best Practices

Description:

In this session we will discuss experiences and lessons learned from the SQL Server customer advisory team working with real customer deployments of SQL Server on SAN. Focus will be on the following: In depth characteristics of SQL Server IO operations; storage configuration best practices when deploying SQL Server on SAN, as well as common configuration pitfalls; how to monitor IO performance of SQL on SAN; and current and emerging SAN technologies that relate to SQL Server.

SessionID: 61935

Supporting Highly Concurrent Business Processes with SQL Server 2005 and 2008

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Adam Machanic

Title: Supporting Highly Concurrent Business Processes with SQL Server 2005 and 2008

Description:

SQL Server 2005 and 2008 are designed to be able to massively scale, enabling support for huge, highly concurrent workloads. Thousands of users hitting your database at the same time is no problem at all. But sometimes, due to business demands, we actually need to go the other way and put controls in place to limit concurrency. This session focuses on techniques for designing your databases and applications in order to satisfy the business requirements of concurrency, rather than just shooting for a high number of transactions per second. Considering the potential business impact of our concurrency decisions brings up numerous interesting questions; for example, what happens when you need to support business processes that may last hours or days, and how do you design data workflows into your database? The session starts with a discussion of some of the designs that can contribute to concurrency problems, as well as the categories of business requirements that should be used as drivers when considering how to fix concurrency issues. We will then take a look at how SQL Server handles concurrency at the transactional level, with a quick overview of isolation levels—including the newest member of the group, snapshot isolation. We will next move on to an analysis of how to use SQL Server`s various features to help solve many of the problems that concurrency brings to the table: Database designs to support pessimistic and optimistic concurrency at the business process level, multivalue concurrency control to support versioning and snapshot views of data at the table level, and examples from a real-world project where SQL Service Broker was used as a vehicle to greatly drive up the concurrency potential of a mixed-workload application.

SessionID: 61934

Introduction to T-SQL Enhancements in Microsoft SQL Server 2008

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Itzik Ben-Gan

Title: Introduction to T-SQL Enhancements in Microsoft SQL Server 2008

Description:

This session provides an introduction to T-SQL Enhancements in Microsoft SQL Server 2008. Among the features that will be covered in this session: T-SQL Delighters, MERGE Statement, Composable DML, Grouping Sets, Date and Time Datatypes and Functions, the HIERARCHYID Datatype, Table Types and Table-Valued Parameters, and more. The session will incorporate many demos and code samples to demonstrate the new features.

SessionID: 61932

Improving the performance of your enterprise data modeling processes

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Improving the performance of your enterprise data modeling processes

Description:

This session will outline techniques to address the challenges of real-world modeling within your enterprise. In particular, we will examine ways to improve the performance of potentially time consuming enterprise data modeling processes.

SessionID: 61933

Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions

Back to calendar

Event Date: 19-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions

Description:

How often have you written XQueries or FOR XML queries or used XML datatype and have not been happy with the performance? This presentation analyses commonly encountered query patterns and provides best practices and improved queries that can provide improved performance up to an order of magnitude.

SessionID: 62001

SQLCAT - Security (Auditing, Encryption) -- Data Security, Admin Security

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Il-Sung Lee

Title: SQLCAT - Security (Auditing, Encryption) -- Data Security, Admin Security

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 Transparent Data Encryption and how it compelemnts Data Encryption introduced in SQL server 2005. We also will look at a new feature called `All Actions Audited and how it can be used and where the limitations are

SessionID: 61937

Much Ado: A Panel Discussion About ""Nothing""

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Erland Sommarskog

Title: Much Ado: A Panel Discussion About ""Nothing""

Description:

What is NULL? How do you use it? And should it in fact be used at all? These questions are always good for hefty debate, even among specialists. Attend this session to see and hear some of the sharpest SQL Server experts battle it out over the seemingly inconsequential issue of nothingness.

SessionID: 62002

Reaching Compliance with SQL Server 2008

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Reaching Compliance with SQL Server 2008

Description:

This session will look at some of the new features of SQL Server 2008 and how they can be used to help an organization address their compliance needs. This will be a instructive session that will be heavy on demos and light on slides. During the presentation the following concepts will be demonstrated: • Identity Management • Surface Area Configuration • Data Protection • Separation of Duties • Auditing and Reporting • Policy Based Management Here are the objectives for attendees: • Learn how to use SQL Server 2008 to address compliance • Learn how to setup Transparent Data Encryption • Learn how to configure SQL Audit • Learn how to configure Policy-Based Management for compliance • Learn how to define mitigating controls

SessionID: 61999

Capitalizing on the SQL Server 2005 System Information

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Jeremy Kadlec

Title: Capitalizing on the SQL Server 2005 System Information

Description:

All of the rules have changed when it comes to accessing SQL Server 2005 system information. System tables are out and the new Dynamic Management Views and Functions are here to stay. Come learn how to incorporate the SQL Server system and database information properly via T-SQL under this new paradigm. Whether it is the traditional server, database, object or security related information you are looking for or accessing to new performance counters, the CLR or Service Broker, this session will deliver the information you need.

SessionID: 61967

Putting the Business in Business Intelligence — Using Business Requirements to Drive DW/BI System Development

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Warren Thornthwaite

Title: Putting the Business in Business Intelligence — Using Business Requirements to Drive DW/BI System Development

Description:

It doesnt matter how good your tools are if youre working on the wrong problems. This session helps you identify the right problems by using the Kimball Method to define the business requirements. Business requirements drive all major design and development tasks in a DW/BI system, including the data model, the ETL system, and of course, the BI applications. The more you understand the business needs for information, the better you can apply your technical skills and the more likely you will be to succeed. Well start by defining business requirements and the role they play in the overall DW/BI Lifecycle context. We next cover a powerful technique for working with senior management to prioritize the business requirements so you know where to start. The session concentrates on the practical steps and techniques required to capture business requirements and build strong partnerships with the business folks. Well also cover some of the pitfalls to avoid along the way.

SessionID: 61968

BI Power Hour

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: BI Power Hour

Description:

Back by popular demand, the Microsoft BI team again presents a fast-paced session devoted entirely to demos, bad jokes, and cheap SWAG. As usual, these demos will be entertaining as well as educational. Have fun and learn some tricks and techniques that will help you in your BI endeavors.

SessionID: 61936

Big Data: Working with Terabytes in SQL Server

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Andrew Novick

Title: Big Data: Working with Terabytes in SQL Server

Description:

A data warehouse can grow to billions of rows and several terabytes. This presentation is a look at the techniques used to manage all that data. It is geared to application developers and dbas. The topics: - What`s Big? - The concerns that are raised when a database gets big: - Load speed - Query performance - Backup/Recovery time - Addressing each of the concerns: - Loading into empty tables - Partitioned Tables and Partitioned Views for improved query performance - Managing Read_Only status on filegroups to minimize backup time. - Organizing data through files and filegroups. - Sliding window techniques to combine the above. The demonstrations takes the user through creating, loading and querying using multiple filegroups and both partitioned tables and partitioned views. The implication for query optimization of each technique and a comparison of the results on a 2 terabyte database will be shown. New relevant features of SQL Server 2008 will be discussed and demonstrated.

SessionID: 62055

Should You Move Into Management?

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Andy Warren

Title: Should You Move Into Management?

Description:

Moving into management is nothing short of a career change and most of us that take the step are badly prepared for it. Well talk about reasons why you might want to manage, why you might NOT want to manage, and what you can expect in your first year on the job. This isnt a pep talk or a rant, it`s a pragmatic look at the life of a manager and what you need to do if you want to succeed as one.

SessionID: 62058

Are you cut out to be a consultant?

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Rick Heiges

Title: Are you cut out to be a consultant?

Description:

This session will look at the skill set needed to become a successful consultant. We will also examine the various ""modes"" of employment as well as the business aspect of being a consultant. If you are looking for a career change or just want find out more before taking the plunge, come listen and participate in this session.

SessionID: 62000

DBA 101: Best Practices for All DBAs to Follow

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Brad McGehee

Title: DBA 101: Best Practices for All DBAs to Follow

Description:

As the popularity of SQL Server continues to grow, so is the demand for new SQL Server DBAs. Unfortuntely, you cant go to school to learn how to become a DBA. Most DBAs learn from books, seminars, short classes, and trial and error. This session is designed for novice DBAs who want to learn what it takes to become a DBA. It includes best practices for what DBAs need to do on a day-to-day basis. This is the kind of information you wont find in most books. It is the kind of information that can only be learned on the job, and shared directly by an experienced DBA with novice DBAs.

SessionID: 62003

SQLCAT - SS2008 developer and ISV experiences

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Kun Cheng

Title: SQLCAT - SS2008 developer and ISV experiences

Description:

SQL Server 2008 introduced hundreds of new features and improvements. In this session we will share overall experience and lessons learned from ISV partners using some of the most important and popular features/improvements.

SessionID: 62004

Interpreting Perfmon and Profiler Results with Cloud-Based BI

Back to calendar

Event Date: 19-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Brent Ozar

Title: Interpreting Perfmon and Profiler Results with Cloud-Based BI

Description:

So youve heard the buzz about cloud-based Business Intelligence, but you cant figure out how it affects your job as a production database administrator. In this session, Brent Ozar will explain how to use Microsoft`s Table Analysis Tools for the Cloud to get SSAS-type analytics to help tune your servers. This session will help novice and hard-core DBAs alike become better performance tuners.

SessionID: 61969

SQLCAT - Building SSRS SS2008 Large Scale Solutions

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Denny Lee

Title: SQLCAT - Building SSRS SS2008 Large Scale Solutions

Description:

In this breakout session, you will learn about successful configuration and architecture principles to maximize the scalability of your enterprise Reporting Services environment. Based on real customer scenarios, we will provide you the details on how to make the most of your SSRS 2008 environment.

SessionID: 61970

How to build an effective Date dimension (in SSAS)

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: How to build an effective Date dimension (in SSAS)

Description:

Dates are arguably the single most important dimension in an SSAS cube. It is hard to imagine a cube without one. Date is often the most useful dimension to tie measure groups together, allowing integration of multiple sources. Dates are often one of the most problematic dimensions in an SSAS cube. Dates for different fact tables are often at different grain (e.g., orders by day, plan by month). Date dimensions often have multiple hierarchies (e.g., Calendar Month, Fiscal Week), and often need attributes split across multiple axes (e.g. Years on rows, Months on Columns). Dates dimensions often appear multiple times in different roles (e.g., Order Date, Ship Date), which multiplies the impact of less-optimal design. As if that weren`t enough, dates are very often used in calculations (e.g., growth from previous month, YTD), and the formulas are highly affected by attribute relationships, which can be particularly complex with dates. This session will teach you effective design practices for dates, and demonstrate how good design can make it much easier to create date-related formulas that work as expected.

SessionID: 61939

Deploying DB Pro to Multiple Environments

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Grant Fritchey

Title: Deploying DB Pro to Multiple Environments

Description:

Description This session will show attendees a series of TSQL scripts, command line scripts and various Visual Studio settings and configurations that will enable the attendee to use Visual Studio DB Pro to deploy to multiple environments. Its extremely easy to configure DB Pro to deploy to a single environment. However, when multiple developers or DBAs have to deploy the same project to various disparate environments, the tool becomes more difficult to use. This session will introduce concepts to make this task easier. To begin, attendees will be introduced to project properties that need to be configured to allow for multiple environments. This will also introduce the concept of variables within the DB Pro environment. Visual Studio Configuration Manager will be covered as a method for establishing different settings for different environments. The session will move on to show how the Pre and Post deployment scripts can be manipulated to deal with the requirements of different environments with an emphasis on file placement and security. Command line builds using parameters will be shown. These make all of the previous concepts available for automation. Finally, a method for saving all this information and sharing it with multiple users through source code management (TFS or VSS) will be shown. All the methods and approaches demonstrated are currently in use in a live environment. Attendees will learn mechanisms that allow them to create their own build process that will be repeatable and can be automated.

SessionID: 62056

Using Emotional Intelligence in Information Technology

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Edwin M Sarmiento

Title: Using Emotional Intelligence in Information Technology

Description:

In today`s fast changing world, every professional needs more than just skills and IQ to succeed.The degree of Emotional Intelligence possessed by an IT professional is now a key predictor of successful leadership and personal effectiveness, distinguishing the outstanding IT professional from the average. This session provides an understanding of what emotional intelligence is and its relevance to IT professionals today in achieving their mission critical objectives

SessionID: 61971

SSIS Scripting

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Andy Leonard

Title: SSIS Scripting

Description:

Can`t find an SSIS Task that does what you need? Script it! The Script Task and Script Component in SSIS are extremely powerful and flexible. In this session you will learn how to customize SSIS functionality using Script objects, best practices for script development, script troubleshooting techniques, and script lifecycle management.

SessionID: 62008

Understanding and troubleshooting transactional replication performance

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Understanding and troubleshooting transactional replication performance

Description:

One of the main considerations when using transactional replication is the impact of latency and how quickly you can get to the root cause of latency issues. The sessions gives you a detailed insight into the various components in the replication stack and how to effectively narrow down the source of the latency problem.

SessionID: 62007

Database Unit Test Why-How-Now

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Database Unit Test Why-How-Now

Description:

Your database schema is a contract between the data store and the applications that are using it. Any change in the schema has the potential to break the contract. Database Unit testing is an effective way to mitigate this risk and provide a repeatable and automatable validation layer. This session cover SQL Server 2000, 2005 and 2008.

SessionID: 62006

So You Inherited The DBA Position; Now What?

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: So You Inherited The DBA Position; Now What?

Description:

The veteran DBA left and your boss decided you should become the new DBA. And now youve come to the Summit to learn everything you can about SQL Server so you can be a great DBA. But where do you start? Which questions should you ask? You dont even know what it is you dont know. This is the session for you! Of course one session cant cover everything, but well hit the major areas of SQL Server so youll at least have a basic understanding of the breadth of SQL Server. Well discuss correctness, concurrency, maintenance, replication, high availability and disaster recovery, storage, performance, and monitoring. Well touch on many other areas as well so youll at least have heard a bit about them and youll know to learn more and ask questions on them. Itll take more than just this presentation for you to be able to answer your customers questions, but at least youll have a chance at understanding the questions .. and youll be able to follow along in some of the other in-depth sessions at the Summit. So congratulations on becoming the DBA! We hope to help you meet some of those challenges!

SessionID: 61972

Troubleshooting MDX Query Performance

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Stacia Varga

Title: Troubleshooting MDX Query Performance

Description:

There are lots of ways to optimize your Analysis Services environment, but tuning the server or improving the database design doesn`t help if your MDX queries are not efficient. Learn how to determine whether a query is the root cause of your performance issues and how to use MDX best practices to improve query performance.

SessionID: 62005

Identifying Performance Bottlenecks

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Identifying Performance Bottlenecks

Description:

When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory help? What about adding additional processors? Or maybe some indexes are missing? In this session, we will explore how SQL Profiler and Performance Monitor can be used to uncover your SQL Server`s bottleneck.

SessionID: 62009

SQL Server 2008 Failover Clustering

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s):

Title: SQL Server 2008 Failover Clustering

Description:

This session will cover the SQL Server 2008 failover clustering setup, underlying Windows Server cluster and how SQL Server uses it, what is new in SQL Server 2008 for failover clustering, differences from previous versions of SQL Server and future directions. This will also cover details of SQL Server 2008 failover clustering setup operations together with demos to illustrate the new setup.

SessionID: 61938

WiE, a Location-Based Social Networking Application Built with SQL Server, SQL Server Data Services, Sync Framework, SQL Server Compact and Virtual Earth.

Back to calendar

Event Date: 19-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: WiE, a Location-Based Social Networking Application Built with SQL Server, SQL Server Data Services, Sync Framework, SQL Server Compact and Virtual Earth.

Description:

Session will describe an internal project to build a location aware social networking application that leverages most of the SQL Server product offerings, including SQL Server Compact, SQL Server Data Services, Sync Framework and SQL Server 2008 spatial support.

SessionID: 62013

Disk Partition Alignment: Increase I/O Throughput by up to 10%, 20%, 30% or More

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): J May

Title: Disk Partition Alignment: Increase I/O Throughput by up to 10%, 20%, 30% or More

Description:

Now that SQL Server wait stats are formally documented & DMVs are available, disk partition alignment may be the best-kept secret related to database performance optimization. In combination with allocation unit size, learn how you can increase I/O throughput by 10%, 30%, or more!

SessionID: 62014

Corruption Survival Techniques

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Database Administration

Speaker(s): Paul Randal

Title: Corruption Survival Techniques

Description:

Your database is corrupt - what do you do? Well, it depends! How critical is the data? Do you know whats really wrong with the database? What does all that DBCC CHECKDB output mean? Should you restore or repair? Its all about limiting downtime and data-loss when a corruption occurs - from knowing the tools to understanding the implications of choices you make. In this demo-heavy session Paul and Kimberly will give you insight into how to recover from corruption without making things worse. Most importantly you`ll get step-by-step instructions for dealing with the more common scenarios.

SessionID: 62012

SQLCAT - Service Broker Performance & Scalability Techniques from Real-World Implementations

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Michael Thomassy

Title: SQLCAT - Service Broker Performance & Scalability Techniques from Real-World Implementations

Description:

This session will describe 2 real-world service broker customer implementations: 1) data intensive batch processing and 2) scale-out approach. For each customer implementation, the session will detail the architecture and provide benchmark numbers.

SessionID: 62010

Automating SQL Server Administrative tasks with PowerShell

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Allen White

Title: Automating SQL Server Administrative tasks with PowerShell

Description:

Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.

SessionID: 62011

SQL Server 2008 Policy-based Management

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Sharon Dooley

Title: SQL Server 2008 Policy-based Management

Description:

SQL Server 2008 introduces policy-based management. This new capability allows you to enforce rules for how things should be on one or more servers. The terminology is complex, and the capabilities are immense. In this presentation, youll learn how to actually put this valuable feature to use in your organization. Youll see how this capability incorporates both the SQL Server Best Practices Analyzer and the SQL Server 2005 Surface Area Configuration tool. You will come away from this demo-rich presentation with a good understanding of how you can apply policy-based management in your organization and how you can find out about attempts to violate your policies.

SessionID: 62057

Team Management Fundamentals

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Kevin Kline

Title: Team Management Fundamentals

Description:

Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, conflict resolution skills, communication skills and project/job tracking skills.

SessionID: 61940

Designing a Secure SQL Server 2008 Solution

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): David Baldauff

Title: Designing a Secure SQL Server 2008 Solution

Description:

In Designing a Secure SQL Server 2008 Solution we will go into many practical concerns a DBA or developer has when securing SQL Server and designing a secure solution. We will cover how SQL Server Authentication is susceptible to hacking attempts, and how you can avoid SQL Server Authentication with the use of Windows Authentication and Kerberos. We will also cover how to improve security when SQL Server Authentication is desired by encrypting the connection using SSL. Further this presentation will go into some practical suggestions on how to improve application authentication design. This presentation will describe Kerberos at a high level, and then go into detail on how to setup Delegation and Kerberos authentication using SQL Server, IIS and a client. Additionally, we will delve into delegation across two SQL instances and a client. The presentation will include a review of the tools necessary to setup delegation and Kerberos and the debugging techniques used to resolve Kerberos authentication problems. If you are looking for a way to improve your security, eliminate the need for SQL authentication and understand the tools needed to do this, then this presentation is for you. If you know what a double-hop is and could never quite find a way around the problem before, then this presentation is for you. And, if you ever wondered how to get a client app authenticated through IIS to SQL server and maintain auditing, then this presentation is for you. On the side of improving application authentication, we will discuss how to best utilize application roles, database roles and Active Directory integration. We will demonstrate the use of a database role to authenticate Active Directory groups and how this method results in low security maintenance for DBAs, and instead keeps this activity in the network administration realm where possible. Furthermore, we will discuss how Application Roles can be used in conjunction with Database Roles to prevent other clients from accessing your database, while facilitating minimal maintenance on SQL Server logins and permissions. Generally, this presentation is intended to give you a detailed tour of authentication issues in SQL Server 2008.

SessionID: 61941

Building embedded, occasionally connected database applications with SQL Compact

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Building embedded, occasionally connected database applications with SQL Compact

Description:

SQL Server Compact Edition is a small footprint embedded database targeting client applications ranging from mobile devices to the desktop. With support for synchronizing data to a SQL Server backend, it supports building a wide range of data-aware client applications which leverage their periodic connectivity to the backend data source. This talk focuses on the capabilities of the SQL Compact database engine, its programming model and synchronization capabilities. It also differentiates SQL Compact from the SQL Server Express edition and talks about the appropriate situations when to use one versus another. It also talks about considerations for SQL Server DBAs in terms of configuring and managing replication of SQL Server data to SQL Compact and the various development and administration tools available for this purpose.

SessionID: 62015

Upgrading to SQL Server 2008: Lessons learned and recommended practices

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Database Administration

Speaker(s): Joe Yong

Title: Upgrading to SQL Server 2008: Lessons learned and recommended practices

Description:

w did you test your application before upgrading to SQL Server 2005 a few years back? Read the marketing glossies that said ""No major changes, it just works!"" so you ""plonked"" it in and hoped it worked? Did it? How about running Upgrade Advisor? Did you encounter problems after UA said there werent any? Ever heard of the Upgrade Assistant tool? Performing a major version upgrade can be a daunting task considering how many moving parts todays applications typically have. Verifying that your application will work without problems is no small feat. Issues such as TSQL compatibility, system and user function, deprecated features, security models, etc... all contribute to making your testing efforts harder. This session will cover both tools and application compatibility testing methodology developed joint by Microsoft and Scalability Experts. Beyond just static analysis of your database, this session will also provide detailed guidance on how to test actual code execution against SQL Server 2008 including dynamic SQL for both in-place upgrade and side-by-side (migrate) methods.

SessionID: 61942

Using spatial data in SQL and in clients

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Application Development

Speaker(s): Bob Beauchemin

Title: Using spatial data in SQL and in clients

Description:

SQL Server 2008 will include two new data types, GEOGRAPHY and GEOMETRY, and a spatial library that is compliant with OpenGIS SQL standards. This library not only applies to geographers but permits you to ""spatialize"" your line of business data. This session will cover common use cases for spatial data functionality, show how to populate, query, and optimize spatial data, and how to integrate SQL Server 2008 data with applications such as Virtual Earth. I cover using spatial data (including GML and GEORSS) in stored procedures, client code, and Virtual Earth/Javascript code.

SessionID: 61974

Super Reports: One Report for Many Requirements

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Business Intelligence

Speaker(s): Paul Turley

Title: Super Reports: One Report for Many Requirements

Description:

Learn how to simplify your life by designing fewer reports that meet the needs and requirements of many business users. With a little planning and some advanced report design techniques, you can create reports that behave differently for different users. Use expressions, parameters and simple custom programming to hide and show columns, rows and fields conditionally. Apply dynamic sorting, grouping and visibility to make one report do the job of several different reports. Reduce your design overhead, maintenance costs and improve usability.

SessionID: 61973

Building an SSIS Management Framework

Back to calendar

Event Date: 19-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Business Intelligence

Speaker(s): Rushabh Mehta

Title: Building an SSIS Management Framework

Description:

As more and more organizations and teams within organizations have started adopting SQL Server Integration Services for data processing and other management task automation, there is increasing need for standardization early in the process to avoid common management problems that arise from lack of standardization and good management techniques. In this session, Jessica and Rushabh help you identify areas of standardization and pitfalls that arise from lack of standards, reviews some common standardization approaches and best practices and finally walks you through a standardized template example that can be customized, deployed and used as a starting point for an SSIS project.

SessionID: 61975

Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Chris Webb

Title: Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS

Description:

The Microsoft BI stack is now mainstream, and mission-critical implementations can be found in the largest businesses worldwide. However, the kind of monitoring tools that we take for granted with the relational engine simply dont exist yet for Integration Services, Analysis Services and Reporting Services. How do we know if our Integration Services packages are taking longer and longer to run every day, whos running that big query that`s slowing Analysis Services down, or if the boss ever looks at that Reporting Services report you took three weeks to create for him? Luckily the solution is close at hand: we can use SSIS, SSAS and SSRS to build an application for monitoring SSIS, SSAS and SSRS. This session will describe how you can do this.

SessionID: 61943

DTS 2000 migration to SSIS...makes financial sense !!

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Steve Simon

Title: DTS 2000 migration to SSIS...makes financial sense !!

Description:

While the migration of DTS 2000 packages to SSIS is relatively efficient utilizing the Package Migration Wizard, mutual fund and other financial packages are often more involved and thus require a bit more hands on effort. This ""best practices"", hands-on presentation will show the attendee the practices that we have implemented to convert our existing ""far east"" packages to run efficiently and effectively within the SQL Server 2005 environment. The discussion will also include ways and means that we have undertaken to reduce as many back end scripts as possible by replacing them with more Control and Data Flow objects.

SessionID: 61976

SQLCAT - World Record ETL and ELT (SS2005/2008)

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Thomas Kejser

Title: SQLCAT - World Record ETL and ELT (SS2005/2008)

Description:

We will describe how how the 1TB in 30 minutes load was achieved and summarize the lessons learned from it. During the session you will learn about Important design patterns for creating and troubleshooting scalable Integration Service solutions. We will also cover package baselining and resource requirements

SessionID: 61944

SQL Server CLR

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Shawn Weisfeld

Title: SQL Server CLR

Description:

The .NET CLR inside of SQL Server allows developers and DBAs to utilize the power and flexibility of .NET languages (C#, VB.NET) from inside of the SQL Server Relational Engine. These managed languages provide untold opportunities for the developers and DBAs to fully leverage the power of the data they have in their SQL Server to do things that TSQL was not designed or capable of doing. All of this without the need to pull the data out of the database and into the application tier. In this talk we will discuss and give examples of all the different types of objects (Stored Procedures, Triggers, Functions, and User Defined Types) you can build with the .NET CLR inside of SQL Server. We will also discuss the pros and cons of the CLR vs. TSQL. We will conclude with a discussion of the security model surrounding the .NET CLR in SQL Server.

SessionID: 61945

Table Value Parameters Revolutionize Data Programming!

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Don Kiely

Title: Table Value Parameters Revolutionize Data Programming!

Description:

Such an innocuous name—table value parameters—for a radical new feature in SQL Server 2008! Its the sort of thing that sounds like only a geek could love: pass a table to a procedure and/or get a table back. But it will change the way you think about programming SQL Server forever! If youve ever passed a comma or other delimited list of data values to a stored procedure, then split them up and processed them, or bumped up against the parameter limits, you know the pain that is now forever gone. In this session well explore this new features, including the syntax and how to make use of it, both in SQL Server code as well as client code. Youll leave the session wondering how you ever programmed without them!

SessionID: 62018

ROI of SQL Server 2008: A Presentation by Forrester Research

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: ROI of SQL Server 2008: A Presentation by Forrester Research

Description:

Forrester Research recently concluded a study in which it analyzed customer`s investment in SQL Server. In this Session, Noel Yuhanna, principal analyst at Forrester Research, will share best practices and methodologies adopted by customers that have produced significant ROI on SQL Server 2008 deployment. Besides covering data management trends, he will also talk about why customers are finding SQL Server 2008 to be more productive, optimized and can lower cost of data management.

SessionID: 62019

Guiding Your Query Plans

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Kalen Delaney

Title: Guiding Your Query Plans

Description:

Changing your production code to add query hints can be problematic for any number of reasons. You might be using a vendor application that doesnt allow changes, or you might have a long approval process in your organization that must be strictly adhered to. And until (or unless) these hints can be added, your users will suffer the consequences of poorly performing queries. SQL Server 2005 introduced the ability to create Plan Guides which provide SQL Servers execution engine with guidelines for processing your queries, without having to change the actual code. In this session well look at the uses and best practicing for Plan Guides, and the details of how to set them up and how they work. Well also look at the enhancements to plan caching, query hints and Plan Guides in SQL Server 2008.

SessionID: 62020

Capturing and Analyzing File & Wait Stats

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

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: 62021

CSS - Debugging the Memory of SQL Server 2008

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Bob Ward

Title: CSS - Debugging the Memory of SQL Server 2008

Description:

One of the biggest requests I receive each year Ive spoken at PASS is to talk more about the internals of memory for the SQL Server Engine and how it affects an application. So this year I will be presenting a very deep technical look at how the SQL Server Engine manages memory. Ill present this topic though from a ""practical"" approach talking about these internals in a manner that you can apply as an administrator or developer of SQL Server. In other words, I`ll show you ""How it Works"" as a means to help you solve possible problems you may encounter involving memory with the SQL Server Engine. Because that is what ""debugging"" is all about....

SessionID: 62016

Effectively using the Resource Governor in SQL Server 2008

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): David Darden

Title: Effectively using the Resource Governor in SQL Server 2008

Description:

One of the new features in SQL Server 2008 is the resource governor. With increasingly consolidated SQL Server environments, and particularly with applications with complex performance requirements, this new feature will provide more fine grained control over how your solutions work. During this session we will review the functionality included in this feature, identify scenarios where it can be used, and show how to implement it.

SessionID: 62017

How to Protect SQL Server with Microsoft Data Protection Manager 2007

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: How to Protect SQL Server with Microsoft Data Protection Manager 2007

Description:

Who better to protect Microsoft SQL Server than Microsoft? In this session, we will introduce you to Microsoft System Center Data Protection Manager 2007 - and talk specifically how DPM protects SQL Server databases and transaction logs, how DPM leverages the SQL VSS writer, recovery options for SQL databases - and discuss DPM versus other SQL specific backup methods. In addition, we will preview the upcoming enhancements for DPM 2007 around SQL protection in our SP1. We will also discuss how to leverage DPM as part of a SQL Server 2005 to SQL Server 2008 migration strategy, and how DPM aligns with SQL Server 2008 backup methods and disaster recovery goals.

SessionID: 61977

Key to MDX formulas in the new (2005/2008) world

Back to calendar

Event Date: 20-11-2008 10:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: Key to MDX formulas in the new (2005/2008) world

Description:

This session pinpoints the single biggest source of confusion regarding MDX formulas—why doesn`t the ""current member"" mean what you expect it to mean? The session explains why it is different from previous MDX (2000 era); shows some very common situations where the new behavior causes apparently paradoxical consequences; and shows the secret to making the new behavior work as your best friend. (Prior experience with MDX formulas strongly encouraged.)

SessionID: 61979

SQLCAT - Performance Troubleshooting for AS (SS2005, SS2008)

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Richard Tkachuk

Title: SQLCAT - Performance Troubleshooting for AS (SS2005, SS2008)

Description:

Learn from the experiences of the SQL Server Customer Advisory team how they diagnose and troubleshoot query and processing performance issues. Weve had experiences with large and small cubes and complex and simple calculations. In this session, well discuss how different types of issues manifest themselves differently and how they can often be resolved with a number of best practices in partitioning, aggregation design, MDX optimizations and processing tuning.

SessionID: 61978

Combining Disparate Data in an SSRS Report

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Brian Larson

Title: Combining Disparate Data in an SSRS Report

Description:

One of the limitations of Reporting Services is the inability to relate data from two disparate data sources within a report. This session explores various techniques for overcoming this limitation. When security restrictions or other constraints make linked servers an impossibility, these approaches allow you to combine data from multiple sources and provide your users with the analysis they require.

SessionID: 62025

SCOM and Database Monitoring

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Thomas LaRock

Title: SCOM and Database Monitoring

Description:

Effective monitoring of your database server environment is critical for your company. Many of us have our own toolbox, or home grown monitoring systems that we rely on each and every day. This session will give an introduction to SCOM and how it can be used to augment (or replace) some of your existing monitoring systems. Attendees will learn how to use SCOM to handle routine tasks such as service availability, disk space thresholds, and job failures. More advanced topics will include configuration of alerts, notifications, performance counters, and customizing of scripts. Leave this session with greater confidence in your ability to provide a stable environment for your end users.

SessionID: 61947

Programming T-SQL in SQL Server 2008, and Beyond!

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Programming T-SQL in SQL Server 2008, and Beyond!

Description:

Join Lenni and Jim for a session that will get you up to speed on the most exciting new T-SQL programmability features and enhancements in SQL Server 2008. Lenni will start by guiding you through new SQL Server 2008 T-SQL features, with live demos that clarify what`s going on. Learn how to use Table Valued Parameters (TVPs) to marshal entire sets of rows across from client to server, and pass them between stored procedures. Then dig into MERGE, a powerful new DML statement that combines the capabilities of four (or more) separate operations. Next find out about INSERT OVER DML, which enhances our ability to capture change data from the OUTPUT clause of any DML statement. Finish with new date and time features, time zone awareness, and improvements in date and time range, storage, and precision. Then Jim will look ahead and share early thoughts from the Product Team on how to bring even more power to T-SQL, and more productivity to developers.

SessionID: 61946

Smart Database Design with MVPs Dr. SQL and Paul

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Paul Nielsen

Title: Smart Database Design with MVPs Dr. SQL and Paul

Description:

Are your database designs a pure joy to query? blazingly fast? bristling with data integrity? When changes are required and the team roadmaps the future - is the database an enabling component or a roadblock? Usability, Scalability, Integrity, and Extensibility - do you believe its even possible to achieve all four in a single design? Can you have it all? We think so. In this lively, interactive session Louis Davidson and Paul Nielsen, both authors and MVPs who focus on data architecture and database design, will tell revealing stories, give away tons of swag, show off their coolest work, and discuss the pros and cons of several database design options, patterns, and how to design a database with usability, performance, integrity and a future. This is the session youll Twitter about.

SessionID: 61980

Scaling up your data warehouse with SQL Server 2008

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Eric Hanson

Title: Scaling up your data warehouse with SQL Server 2008

Description:

SQL Server 2008 introduces many new functional and performance improvements for data warehousing. This talk discusses how to use the features of SQL Server 2008 to get great performance as your data warehouse scales up, focusing on the SQL Server relational DBMS. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large scale SQL Server customers. We cover techniques to improve manageability and performance at high scale, encompassing data loading (extract-transform-load, or ""ETL""), query processing, hardware selection, storage configuration, partitioning, index maintenance, compression, indexed view (aggregate) management, and backup and restore.

SessionID: 62024

SQLCAT - Performance Troubleshooting - MDW / Xevents / etc (2008)

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Kevin Cox

Title: SQLCAT - Performance Troubleshooting - MDW / Xevents / etc (2008)

Description:

Reduce the time it takes you to troubleshoot problems in and around SQL Server with the new tools. Management Data Warehouse and Xevents will be shown.

SessionID: 62023

SQLCAT - Building High Performance systems for SQL Server relational (SS2005/2008)

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Juergen Thomas

Title: SQLCAT - Building High Performance systems for SQL Server relational (SS2005/2008)

Description:

This session will go through different server hardware components like processor, storage, memory, network interfaces and related Windows and SQL server functionality to explain what a balanced system design means and how this design approach is needed for high-end systems. new technologies like latest 6-Core processors and SSD storage and its performance characteristics will be presented

SessionID: 62022

SQLCAT - Building HA SQL Server (SS2005/2008) Deployment Solutions Using LL from Cust Deployments

Back to calendar

Event Date: 20-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Prem Mehra

Title: SQLCAT - Building HA SQL Server (SS2005/2008) Deployment Solutions Using LL from Cust Deployments

Description:

This session is for you if you want to learn techniques some customers have used to minimize downtime while migrating from SQL Server 2005 to 2008. If you use SQL Server 2005 failover clustering and want to learn about upgrading to Windows Server 2008 and SQL Server 2008, this is the session for you. If you are new to SQL Server environment, you will learn how some customers are using various technologies together to achieve high HA and minimize data loss in the event of a disaster. This session is about learning from other customers` deployment experiences.

SessionID: 62027

Advanced Troubleshooting with SQL Server Extended Events

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Jerome Halmans

Title: Advanced Troubleshooting with SQL Server Extended Events

Description:

Diagnosing production issues affecting Microsoft SQL Server can be difficult and time consuming. Microsoft SQL Server 2008 introduces Extended Events, which provide deep visibility into the inner workings of SQL Server and give the power to diagnose what were once impossible problems while having minimal impact on a running system. In this webcast, we introduce the SQL Server Extended Events features, describe the architecture of Extended Events, and explain how you can use Extended Events to diagnose real issues.

SessionID: 62028

Query Editing Enhancements in SSMS That Will Rock Your World

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Eric Kang

Title: Query Editing Enhancements in SSMS That Will Rock Your World

Description:

This session shares insights of Transact-SQL IntelliSense, Debugger with practical solutions that enhance the productivity of query editing experience with SSMS 2008. In addition, it covers the deployment considerations in enterprise environment.

SessionID: 61982

Reporting Services 2008 Integration with SharePoint

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Prash Shirolkar

Title: Reporting Services 2008 Integration with SharePoint

Description:

Learn how to extend the SharePoint Server 2007 with the power of SQL Server Reporting Services to integrate rich reporting into the SharePoint portal, Report Center or dashboards. SQL Server Reporting Services enables end-users to view, manage and deliver enterprise reports through one centralized SharePoint user interface via deep integration with MOSS 2007 and WSS 3.0. Reports are managed and secured as standard SharePoint document library objects. In Reporting Services 2008 we add support for data-driven subscriptions, passing report parameters on the URL and in-place upgrade of the Reporting Services 2005 SP2 Add-in.

SessionID: 62026

Storage considerations when running SQL Server in a virtualized environment

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Storage considerations when running SQL Server in a virtualized environment

Description:

Virtualization seems to be everywhere these days. Many companies have embraced virtualization, not only in the dev and QA environments, but also in production. What are the storage implications of running SQL Server in a virtualized environment? Are there any additional benefits or problems that are incurred through virtualization? This presentation is intended to help answer your questions and provide you with tools to determine your specific organization`s needs.

SessionID: 61981

SQLCAT - Large Scale Relational Data Warehouse Learnings

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: SQLCAT - Large Scale Relational Data Warehouse Learnings

Description:

A central priority for SQL Server 2008 was to improve support for large scale data warehouse workloads. In this talk we will explore how several customers have successfully exploited Relational Database engine features to build successful, high performance Warehouses larger than 10TB. We will also discuss application design innovations that have been used to achieve continuous data availability, scale-out, and near-real-time data updates in multi-Terabyte settings.

SessionID: 61950

Test-Driven Development for Database Professionals

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Andy Leonard

Title: Test-Driven Development for Database Professionals

Description:

This session covers practical Test-Driven Develpment (TDD) using Visual Studio 2008 Team System Database Edition. We examine how to apply Test-Driven methodologies to database development. Demonstrations build a set of unit tests during the project development phase. These tests then become regression tests for the next version.

SessionID: 61951

Building Data Models with SQL Server 2005 Management Studio

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Jeremy Kadlec

Title: Building Data Models with SQL Server 2005 Management Studio

Description:

Need to start data modeling, but don`t know where to start? Come learn how to build data models rapidly with SQL Server 2005 Management Studio, reverse engineer existing databases, build online documentation, migrate objects with the toolset and more! Attend this demo intensive session a beginner and walk away with the skills to tackle your next data modeling project!

SessionID: 62059

Telecommuting

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Michael Lato

Title: Telecommuting

Description:

Would you rather work from home or fight traffic to the office every day? Telecommuting has grown exponentially in recent years but it doesn`t work for everyone. This session explores the positives and pitfalls of telecommuting along with techniques for avoiding the downsides. Presented by someone who has been telecommuting for the past three years — come learn from real-world experience.

SessionID: 61949

Cursors or setbased? Why not both?

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Hugo Kornelis

Title: Cursors or setbased? Why not both?

Description:

The ""cursor or setbased"" debate is a heated one. There are countless sites telling us that cursors are bad and setbased is best (except of course in for those situations where setbased is bad and cursors are best). With all this debate going on, it gets hard not to see this as an either or question. And that`s a shame, since some problems are best approached with a solution that uses a bit of both. In this session, Hugo will present some of those problems and demonstrate how the best performance can be achieved by thinking out of the box and implementing a solution that combines setbased and iterative characteristics.

SessionID: 61948

SQL Server 2008: Deep Dive into Spatial Data Type and Indexing

Back to calendar

Event Date: 20-11-2008 15:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: SQL Server 2008: Deep Dive into Spatial Data Type and Indexing

Description:

SQL Server 2008s new spatial data support gets most of its performance and scalability from the ability to define indexes on the spatial data. This presentation will show you in detail how SQL Server 2008s spatial indexes work and how to use them to improve your spatial application`s performance even when it needs to scale to large amounts of spatial data.

SessionID: 61952

XML Data Type Methods in the Real World

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Steve Hughes

Title: XML Data Type Methods in the Real World

Description:

Tired of trying to extract values from comma separated lists? Need a more efficient way to handle flexible parameters? This session is intended to show the power in SQL Server 2005 in relation to the XML data type. SQL Server has a number of methods which make using XML simpler. This session will demonstrate the usage of the XML data type methods in the real world that makes database development easier. This session will also discuss performance implications and any issues discovered while using these methods. Finally, this session will cover the enhancements to the XML data type methods in SQL Server 2008.

SessionID: 62030

Reducing Storage Cost in SQL Server 2008

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Sunil Agarwal

Title: Reducing Storage Cost in SQL Server 2008

Description:

Are increasing storage costs hurting your bottom line as data sizes keep growing throughout your organization? In this session, we explore how SQL Server can help you lower your storage costs. We start with Microsoft SQL Server 2005 partitioning to transparently migrate older data to lower-cost storage tiers over time. We then discuss new storage cost-saving functionality in Microsoft SQL Server 2008 such as data compression, backup compression, and sparse columns, filtered indexes, file stream which can get you to 50% or more reduction in storage requirements for typical applications. Throughout the session, we share experiences, insights, and best practices from SQL Server customers and Microsoft-internal deployments. Learn how to make good use of these technologies in combination.

SessionID: 62060

How to Become an Exceptional DBA

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Brad McGehee

Title: How to Become an Exceptional DBA

Description:

Becoming a DBA doesnt have to be just a job; it can be a very rewarding career. While many DBAs are happy with just getting by, the Exceptional DBA is not only outstanding in their knowledge of SQL Server, they are consummate professionals who are in high demand, and command high salaries. Unfortunately, there is no guidance on how to become a successful and Exceptional DBA, you have to learn it on your on. In this session, I will focus on the following topics: • Why You Should Become an Exceptional DBA • Characteristics of the Exceptional DBA • Specialize: You Cant Do It All • How to Hone Your Skill Set • Is Professional Certification Really Necessary • How to Participate in the SQL Server Community • Manage Your Career, Don`t Let it Manage You • How to Manage Your Brand Within Your Organization • How to Manage Your Online Brand With the information provided in this session, attendees will be well-prepared to become an Exceptional DBA.

SessionID: 62029

CSS - Implementing and Supporting SQL 2008 Failover Clustering

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Shon Hauck

Title: CSS - Implementing and Supporting SQL 2008 Failover Clustering

Description:

In this session we cover an overview of the changes made in SQL 2008 Clustering from previous SQL versions. We will also discuss some basics OS tasks required to build a proper foundation for the installation of SQL 2008 Failover Clustering into the cluster as well as talk about the installation process. In Addition we will quickly review installation and post installation troubleshooting and administrative tasks. Finally we will take a look at the upgrade process and how to ensure that you have a minimal downtime and some advanced SQL 2008 Failover Clustering installation options.

SessionID: 61953

Tips & Tricks for Writing Better Queries

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Application Development

Speaker(s): Joe Webb

Title: Tips & Tricks for Writing Better Queries

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: 62031

The Most Persistent Microsoft SQL Server Myths: Perceptions and Realities

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Maciej Pilecki

Title: The Most Persistent Microsoft SQL Server Myths: Perceptions and Realities

Description:

I wish I had a dime every time someone out there says something like: ""table variables are in-memory-only"" or ""when you do SELECT * FROM XYZ, you receive the rows in clustered index order."" If you look on the Internet, the Web sites and the newsgroups are, unfortunately, full of such misleading statements. During this session we debunk some of the most popular and dangerous misconceptions around SQL Server Database Engine features. Come and learn why common wisdom is sometimes not as wise as one may believe.

SessionID: 61983

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

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

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: 61984

High-performance Data Warehouses in SQL Server 2008

Back to calendar

Event Date: 20-11-2008 16:00 - Category: Spotlight Session (120 minutes) - Track: Business Intelligence

Speaker(s): Erin Welker

Title: High-performance Data Warehouses in SQL Server 2008

Description:

This session will address the things to consider when architecting a large, high-performance relational data warehouse, especially one that is host to unpredictable ad hoc queries. The discussion includes some of the new features and enhancements in SQL Server 2008, some of which result in a change in the approach taken in prior versions of the product. It also includes methodologies for creating and storing pre-aggregated result sets to facilitate mainstream queries and reports. Live demos will support the assertions made during the presentation.

SessionID: 62061

How to manage a Team of Technical Professionals

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Professional Development

Speaker(s):

Title: How to manage a Team of Technical Professionals

Description:

Finding the right people to form a team can be a difficult task, but once you have them, retaining them can be just as challenging. With budget strings tight, pay raises are few and far between, so how can you keep your team satisfied? This session will cover what it takes to keep your team motivated and focused.

SessionID: 62039

SQLCAT - Data Compression & Backup Compression Lessons Learned from Customer Deployments

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s): Sanjay Mishra

Title: SQLCAT - Data Compression & Backup Compression Lessons Learned from Customer Deployments

Description:

In this session you will learn how various customers are using backup compression and data compression SQL Server 2008. What are the considerations for performance and resource utilization. What are the strategies for implementing these technologies.

SessionID: 62037

SQL Server 2008 Failover Clustering

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s):

Title: SQL Server 2008 Failover Clustering

Description:

This session will cover the SQL Server 2008 failover clustering setup, underlying Windows Server cluster and how SQL Server uses it, what is new in SQL Server 2008 for failover clustering, differences from previous versions of SQL Server and future directions. This will also cover details of SQL Server 2008 failover clustering setup operations together with demos to illustrate the new setup.

SessionID: 62038

Protecting Your Data — Security from the Application to the Database

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Application Development

Speaker(s): Il-Sung Lee

Title: Protecting Your Data — Security from the Application to the Database

Description:

Securing a database is a difficult task and most efforts typically focus on locking down the server while still allowing authorized connections to occur. Applications need to be security conscious as well, not only because they can be a target of attack, but also because they can facilitate the further lockdown of the server. This talk discusses some of the considerations that both the application developer and the DBA should consider to help increase data security. Topics discussed will include securing the network channel, using proper authentication, new authorization features introduced in SQL Server 2005, and the use of database encryption.

SessionID: 62034

Failure is not an Option, 24x7 OLTP Database Management for VLDB

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s): Thomas Grohser

Title: Failure is not an Option, 24x7 OLTP Database Management for VLDB

Description:

Database Mirroring, Replication, Log Shipping, Backup, Security, Maintenance, ... BUT how to combine them to archive Zero Data loss and 99.999% availability in a 24x7 environment with the highest possible performance. Lets hear from a real life installation how its done. The Session describes how to setup SQL Server to meet this goals step by step first showing how to archive zero data loss (this is shown with standard servers and settings but already heaving the final system in mind) then pushing the availability to 99.999% including descriptions on how maintenance and rollouts are done too still meet this requirements and then for the grand finale I will show how to scale from 4 to 8, 16 and 32 sockets what to consider, influences on database design, storage, network connections and more. Tasks like replication and backup are also shown with real examples like how to backup 2 TB over the network in less than 1 hour without any 3rd party products.

SessionID: 62035

CSS - Upgrading to SQL Server 2008 - Avoid Gotchas and Known Issues

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s):

Title: CSS - Upgrading to SQL Server 2008 - Avoid Gotchas and Known Issues

Description:

In the past as we have released new versions of SQL Server, it always seems that there is a wealth of known issues and gotchas that have been gleaned early on from development, CSS support experiences and early adopters. Nothing is more frustrating than encountering a problem or behavior change only to find out that it is by design or a known issue that could have been easily avoided with advance knowledge. In this presentation I will reveal this cumulative knowledge that has been harvested from our experiences with SQL Server 2008 deployments and upgrades. I will show you how to avoid common pitfalls, quickly search and identify known issues, as well as cover some of the hidden gems and key engine behavior changes that have been discovered by CSS and our development teams.

SessionID: 62036

CSS - How it Works: File Streams

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Database Administration

Speaker(s): Robert Dorr

Title: CSS - How it Works: File Streams

Description:

Using a mini-filter design and MUP redirection file streams extends BLOB capacities in SQL Server 2008. This session will dive into the internals of the File Streams feature showing how file streams introduces a kernel driver to allow direct file system access and maintain transaction integrity with the database

SessionID: 61955

Protecting Your Data — Security from the Application to the Database

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Application Development

Speaker(s): Il-Sung Lee

Title: Protecting Your Data — Security from the Application to the Database

Description:

Securing a database is a difficult task and most efforts typically focus on locking down the server while still allowing authorized connections to occur. Applications need to be security conscious as well, not only because they can be a target of attack, but also because they can facilitate the further lockdown of the server. This talk discusses some of the considerations that both the application developer and the DBA should consider to help increase data security. Topics discussed will include securing the network channel, using proper authentication, new authorization features introduced in SQL Server 2005, and the use of database encryption.Preventing SQL Injection

SessionID: 61954

Hacking SQL Server

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Application Development

Speaker(s): Brian Knight

Title: Hacking SQL Server

Description:

In this presentation, .NET MVP Bayer White plays the part of a developer protecting his application and SQL Server MVP Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!

SessionID: 61985

Architecting a PerformancePoint Planning Solution

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Business Intelligence

Speaker(s): Dan Bulos

Title: Architecting a PerformancePoint Planning Solution

Description:

Planning is a distinct and unique type of application. While planning shares some aspects with data warehousing and OLAP, it also has aspects of OLTP and therefore must be approached differently. Planning is more than just write-back, it is the system of record for the plan and as such requires workflow and process control. There are many different types of planning applications including financial, manufacturing, or entering targets for a corporate scorecard. This session will cover the how to analyze the application subject to determine an appropriate architecture that correctly uses the features of PPS in an effective and efficient manner. Can you have too many models? Or too few? What is the best use of subsites? Can vanilla PPS handle the application or must you go outside the box?

SessionID: 61987

Incremental data warehouse loads with MERGE and Change Data Capture

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Business Intelligence

Speaker(s):

Title: Incremental data warehouse loads with MERGE and Change Data Capture

Description:

This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If youre interested in learning best practices for this new SQL Server 2008 functionality, you won`t want to miss this session!

SessionID: 61986

Unit Testing SSIS Packages

Back to calendar

Event Date: 21-11-2008 10:00 - Category: Regular Session (120 minutes) - Track: Business Intelligence

Speaker(s): John Welch

Title: Unit Testing SSIS Packages

Description:

Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. We will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. We will also highlight how to automate the testing of SSIS packages, using the open source ssisUnit framework. We`ll cover several of the common questions about automated unit testing, including: - How to handle test data - How to set up the environment for multiple developers - How to make tests flexible - How to ensure that the tests remain valuable over time

SessionID: 62045

Advanced Powershell and SQL Server

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Buck Woody

Title: Advanced Powershell and SQL Server

Description:

This session delves into the details of how to use SQL Server PowerShell and its cmdlets to administer SQL Server in an optimal fashion. It also describes the architecture and implementation of the SQL Server PowerShell.

SessionID: 62040

Monitoring Object Changes with Event Notification

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Monitoring Object Changes with Event Notification

Description:

Have you ever want to know every change to every database or schema on your server? Do tables or procedures appear or, worse still disappear and you ask ""Who did that?"" Even if you have total control of your server, would you just like a nice log of when you made changes to objects for later attestation or auditing? Would you just like to get more horsed up on Service Broker and Event Notifications? If so, then you need to come to ""Monitoring Object Changes with Event Notification"". We will present a real-world solution that uses SQL Server 2005s Service Broker and Event Notification technology to constantly monitor your servers for object changes - deletes, adds, and modifications. Well simplify for you exactly how the Service Broker technology works, how Event Notification ride on top of Service Broker, and how to leverage the techology. Well present an ideal blend of theory and demonstration with real world scripts to leave you with an solution that you can immediately use on your servers. Time permitting, well do a brief review of SQL Database Mail since a key point of our solution is in the concept of messaging you with object changes. We`ll also point out how you might use the Event Notification technology for other purposes besides recording object changes.

SessionID: 62042

Implementing Partitioned Views with Table/Index Partitioning

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Victor Isakov

Title: Implementing Partitioned Views with Table/Index Partitioning

Description:

Should you take advantage of partitioning? Or should you implement partitioned views? Both have their pros and cons... Why not take advantage of both! In this session Victor Isakov explorers why and how you would take advantage of both features to achieve an optimal database solution.

SessionID: 62041

What`s the Fuss? Collecting and Analyzing Performance Metrics in SQL Server 2005 and 2008

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): James Luetkehoelter

Title: What`s the Fuss? Collecting and Analyzing Performance Metrics in SQL Server 2005 and 2008

Description:

In any discussion that revolves around SQL Server, DBAs and developers alike are invariably drawn towards a single core topic: that of performance tuning. And while performance is a key factor influencing success or failure of a database project, it is also a complex area. Fully tuning a system requires interrogation of metrics at the hardware, database, and application layers, plus external factors including networks and shared I/O systems. SQL Server exposes dozens of performance counters, DMVs, and DBCC commands that expose most--if not all--of the information you need to tune your system, but looking at the list can be a dizzying experience if you dont have a roadmap to guide you. In this session we will cover the most important sources of performance data and discuss the best ways to collect and analyze the information in order to determine what performance issues you may have, and to help you track down (and eliminate) the culprits. We will focus on techniques designed to help you be proactive rather than reactive, and find performance problems before your users start knocking down your door. If youve ever received a call at 4:59 p.m. from an unhappy executive wondering why his report is taking so long to run, this session is for you.

SessionID: 62044

SQLCAT - Pan-STARRS: Building 100TB+ Scientific VLDBs with SQL Server 2008

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Michael Thomassy

Title: SQLCAT - Pan-STARRS: Building 100TB+ Scientific VLDBs with SQL Server 2008

Description:

This session will describe the Pan-STARRS architecture for designing a very large, 100TB+, scientific database implemented with SQL Server 2008. While the primary goal of the Panoramic Survey Telescope and Rapid Response System, Pan-STARRS, is to detect and characterize near-Earth objects that might threaten our planet, the collected data will contain relevant information for other interesting scientific projects such as the discovery of extra-solar planets, supernovae and Universe evolution, among many others. After telescope images are processed, catalogs with hundreds of billions of individual detections are generated. These astronomical numbers pose a special architectural challenge not only to load, organize, and query the database but also regarding fault-tolerance and recovery. The session will focus on how Pan-STARRS is taking advantage of key SQL Server 2008 features that make this challenge feasible.

SessionID: 62043

Performance Troubleshooting using SQL Server 2008 Management Studio

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Bill Ramos

Title: Performance Troubleshooting using SQL Server 2008 Management Studio

Description:

For version 2008, SQL Server introduces the Data Collector and Management Data Warehouse for troubleshooting common performance issues for a SQL Server database engine instance. This session demonstrates how to troubleshoot various problem scenarios using the new tools within SQL Server Management Studio (SSMS). It demonstrates how to plan for a deployment of the data collection tools taking into account lessons learned from deploying the tools within Microsoft IT. Learn how you can create your own collection sets and get the data out of the Management Data Warehouse.

SessionID: 61957

Entity Framework Futures: Empowering the data developer

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Entity Framework Futures: Empowering the data developer

Description:

In V1.0 of the Entity Framework we laid the foundation for a new data platform. The new data platform is based on a new data model and a new persistence framework that embodies the characteristics of ORM frameworks while extending the ADO.NET programming model. In v2.0 of the Entity Framework we are making the next logical step for the delivery of a comprehensive data platform. In version 2.0 of the Entity Framework we lay the foundation for adoption of the technology by solutions like SQL Reporting Services and SQL Sync Services. We are also providing expanded stored procedure, custom type and TVF/TVP support to empower DBA`s and mid-tier developers alike to better leverage these concepts in their applications. You are invited to come and see how we started with version 1.0 of the technology and are building out these new services for the data developer.

SessionID: 61958

SQL Server User-Defined Functions - The Good, The Bad, The Ugly

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Maciej Pilecki

Title: SQL Server User-Defined Functions - The Good, The Bad, The Ugly

Description:

User-defined functions are a nice feature for improving code reuse and lowering code maintenance burden. But what most developers do not know, they come with a cost. During this session we will look at different types of functions: scalar-valued and table-valued, both in T-SQL as well as SQLCLR, and their behavior and performance impact. We will go through real-life examples of how, why and when use of functions in your queries can backfire and cause performance problems. We will also establish some best practices for use of UDFs, based on the lessons learned.

SessionID: 61989

Optimizing Dimension Designs in SSAS

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Dave Fackler

Title: Optimizing Dimension Designs in SSAS

Description:

Designing effective and optimized dimensions in SSAS requires knowledge of your reporting and analysis requirements as well as an understanding of various dimension design options and alternatives, dimension and attribute properties, and attribute relationships for hierarchies and aggregations. In this session, well discuss all of these topics to gain a better understanding of how to optimize your dimension designs within SSAS. Well look at several design scenarios along with various alternatives for creating and dealing with different types of dimensions. Well discuss dimension design differences between SSAS 2005 and SSAS 2008 and how to take optimize your dimension designs in each environment. Finally, well discuss common dimension performance and design issues, offering thoughts on how to overcome these issues (or at least understand the workarounds and options).

SessionID: 61956

Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Lara Rubbelke

Title: Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management

Description:

Policy Based Management is poised to change the way all of us manage the complexity of our enterprise SQL Server environments. We are challenged with maintaining consistency across large distributed environments. We are challenged with strict regulatory requirements stipulating database configurations and server settings. These challenges are even greater when we introduce multiple versions of SQL Server. Policy Based Management will eliminate the complexity and enforce our business and regulatory requirements — and we need this solution across all versions of SQL Server in our enterprise. We will demonstrate strategies to extend Policy Based management across all instances in the enterprise — including SQL Server 2008, SQL Server 2005 and SQL Server 2000. Learn how to automate policies and centralize compliance reporting for the entire enterprise.

SessionID: 61988

Integrating Predictive Analysis Throughout the Data Lifecycle

Back to calendar

Event Date: 21-11-2008 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s):

Title: Integrating Predictive Analysis Throughout the Data Lifecycle

Description:

For many people predictive analysis and data mining is a special activity taking place outwith their common applications and workflows. However, the true value of these technologies — the discovery and reuse of patterns and relationships in data — really only becomes clear when used seamlessly as part of your data lifecycle. This session will show how predictive analysis can be used and embedded throughout the lifecycle of your data, from integration through data analysis to reporting and performance monitoring.

SessionID: 62048

Deep Dive Into SQL Server Consolidation

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Allan Hirt

Title: Deep Dive Into SQL Server Consolidation

Description:

Consolidation is a reality in most organizations. Have you ever wondered what the thought process is in deciding what gets consolidated? This session will reveal the methods on how to gather and analyze information about your environment so you can embark on your consolidation projects armed with the right information, not a lot of guesswork. This session is not the usual high level walk through with only theory and why you need to consolidate, but is the real world information that you need to know to tackle a SQL Server consolidation project based on real-world experience.

SessionID: 62050

SQL Server 2008 on SAN; Lessons Learned and Best Practices

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: SQL Server 2008 on SAN; Lessons Learned and Best Practices

Description:

In this session we will discuss experiences and lessons learned from the SQL Server customer advisory team working with real customer deployments of SQL Server on SAN. Focus will be on the following: In depth characteristics of SQL Server IO operations; storage configuration best practices when deploying SQL Server on SAN, as well as common configuration pitfalls; how to monitor IO performance of SQL on SAN; and current and emerging SAN technologies that relate to SQL Server.

SessionID: 62049

Benchmarking Server Hardware Platforms for SQL Server Performance

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Linchi Shea

Title: Benchmarking Server Hardware Platforms for SQL Server Performance

Description:

Before deploying SQL Server on a new server platform, or a new release of SQL Server on an existing hardware platform, you must do due diligence to find out how SQL Server performs on that platform. With new builds of SQL Server being released at a regular pace and new processors and servers being introduced at a dazzling speed, this is not a one-time exercise but needs to be done regularly and systematically. This session draws on the presenter`s extensive experience in certifying and benchmarking SQL Server on hardware platforms, and covers a general engineering methodology that you can use to deliver that due diligence with useful information for hardware platform decision making. The session will also review the general architecture of commodity servers, and discuss benchmark tools you can use to help collect empirical data points with respect to running SQL Server on a hardware platform.

SessionID: 62062

Writing Technical Articles

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Kathi Kellenberger

Title: Writing Technical Articles

Description:

Have you ever wondered how the authors writing SQL Server articles get published? It may be easier than you think to share your experience and knowledge with other DBAs and developers all over the world. Learn how to get published and the impact it can make on your career

SessionID: 62047

XML in My Database! Implementation on a Live e-Store Using SQL Server 2005

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Denise McInerney

Title: XML in My Database! Implementation on a Live e-Store Using SQL Server 2005

Description:

The introduction of the native XML datatype in SQL Server opened up many possibilities for how we manage the data in our databases. It also struck terror in the hearts of some DBAs. When does it make sense to store data as XML in a SQL Server database? What are the potential problems with doing so? This session will analyze a real-life example of a project that was successfully implemented using the XML datatype as the foundation of the database design. This project was executed on a database that was already in production and had millions of users whose data needed to be preserved. The session will examine the database design and explore details of the implementation, including XML schema validation and utilization of XML data type methods. It will explain how collaboration between the DBA and application developers was crucial to the project`s success. The complex process of converting millions of relational rows into XML documents will be reviewed. Finally, the session will describe how the inclusion of XML actually reduced the size and improved the performance and maintenance of a busy production database.

SessionID: 61991

Populating a Kimball Method DW with SQL Server and Integration Services 2008

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Joy Mundy

Title: Populating a Kimball Method DW with SQL Server and Integration Services 2008

Description:

The Kimball Method is a proven methodology for building a data warehouse / business intelligence system. This session offers practical advice on how to design and implement the ETL application for your DW/BI system in SQL Server 2008. Which are the most valuable new features of the SQL Server 2008 Database Engine and Integration Services for you to include in your ETL design? If there are several ways to solve a problem — and there always are! — how do you decide whats the best approach in your circumstance? In this session, Joy will illustrate common design techniques for the ETL system that populates a Kimball Method data warehouse. Well demonstrate components of the ETL system, including how to: - Design the ETL system - Extract changed data - Manage changes in dimension attributes - Implement the fact table surrogate key pipeline

SessionID: 61992

SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Carl Rabeler

Title: SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008

Description:

In this session, you will learn how to collect Analysis Services query and processing performance data through the use of custom reports that query system performance counters, Analysis Services profiler trace information and Analysis Services Dynamic Management View (DMV) data collected in Management Data Warehouse (MDW). You will learn how the SQL CAT team has extended Management Data Warehouse through the use of custom data collectors and reports. In this session, we will demonstrate how the SQL CAT Best Practices team uses MDW for performance testing and analysis of test runs during stress and configuration testing of Analysis Services

SessionID: 61959

Optimizing bulk operations involving data cleansing and merging with Table-Valued Parameters

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: Optimizing bulk operations involving data cleansing and merging with Table-Valued Parameters

Description:

SqlBulkCopy provides the fastest way to insert data in bulk, but when the data must be processed on the server prior to insertion application have had to resort to traditional APIs using row-by-row logic on the client side which have much lower performance. Table-valued parameters have row-streaming capabilities similar to SqlBulkCopy but with the added capability of processing the data on the server before rows are persisted in the database. Two common scenarios that will benefit from this feature are data transformation and merging. We will walk through a solution based on SQL Server 2005, and then look at a solution based on TVPs and compare.

SessionID: 61990

Configuring Reporting Services Security Correctly

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Stacia Varga

Title: Configuring Reporting Services Security Correctly

Description:

Understanding the relationship between Reporting Services 2005 and ASP.NET, IIS, database, and Windows security is vital to establishing the appropriate security policy for your environment and configuring the report server correctly. This session starts with a review of the security architecture of Reporting Services in native and SharePoint integrated mode. This session also includes a series of practical examples that show you how to set up IIS authentication, service accounts, and Reporting Services data sources for various deployment scenarios, including single server or multiple server environments. This session will also explain how the security architecture changes in Reporting Services 2008.

SessionID: 62046

Applying Workload Resource Governance with SQL Server 2008

Back to calendar

Event Date: 21-11-2008 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Ross LoForte

Title: Applying Workload Resource Governance with SQL Server 2008

Description:

A major trend is that current hardware is getting more powerful and able to support a greater number of applications on the same database server. As a result, there is a great deal of interest around SQL Server consolidation. After consolidation, how do you prevent one application from using more database workload resources while starving another? To solve this problem, the Microsoft platform has strategies with Windows Resource Manager, Hyper-V Virtualization, SQL Server 2008 resource governor and other SQL Server resource governances. This including workload governance in multiple SQL Server instances, data mirroring and failover cluster implementations. This session first describes the concept, advantages and disadvantages of each technology and then provides real-life examples with best practices applying each of these technologies by themselves and in combinations to solve the resource governance situations.

SessionID: 61994

Avoid Slow SSAS Queries: MDX Query Troubleshooting

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Craig Utley

Title: Avoid Slow SSAS Queries: MDX Query Troubleshooting

Description:

Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.

SessionID: 61963

[Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s):

Title: [Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong

Description:

Time and again you hear people talk about how you should implement software using established patterns and best practices. Online forums, books, and conferences about .NET and SQL Server are filled with advice about how to do things correctly. But rarely do people focus on the other side of the equation: What are the potential pitfalls that exist, and how will you know when you`ve fallen into them? Software developers need to know more than just what they should do; knowing what not to do is half the battle. In this session you will learn how to make your SQL server prone to SQL Injection, how to use SQLCLR for all data access, how to use cursors instead of DML, exploit the Tumbling Data pattern, and so on. Come and learn what not to do -- and how to fix it -- from the masters of [anti]patterns and [mal]practices!

SessionID: 62063

Working with Semi-structured data in SQL Server 2008

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Professional Development

Speaker(s): Srini Acharya

Title: Working with Semi-structured data in SQL Server 2008

Description:

Semi-structured data like property bags and type system information associated with mixed heterogeneous contents, documents, catalogs, etc have always been hard to model in relational systems. SQL Server 2008 adds a series of new features like Sparse columns, Wide Tables, Filtered indexes/statistics, enhanced XML support and hierarchy IDs to improve the storage, querying and manipulation of such semi-structured data and hierarchical information. In this presentation we will go over the semi-structured storage scenarios, language and storage level functionality and demonstration of these features.

SessionID: 61993

Designing sophisticated and Data visualization rich Reports using Microsoft SQL Server 2008 Reporting Services

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence

Speaker(s): Carolyn Chau

Title: Designing sophisticated and Data visualization rich Reports using Microsoft SQL Server 2008 Reporting Services

Description:

This session will explore the many new features for report authoring in the SQL Server 2008 Reporting Services environment. Learn how to create new data visualizations with charts and gauges that will make your reports pop, build complex report structures and layouts with the new tablix report item, and other enhancements to create richly formatted reports for your organizations. In addition, we will explore some of the new functionality in Report Builder 2.0, Microsofts new end user report authoring application that will allow Information Workers to gain new insight from their data sources. This session will also provide an overview of the different report authoring (""designer"") tools, and how they solve your organizations reporting needs, and some insight into the future.

SessionID: 61962

SQL Server 2008 .NET integration programming

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Krzysztof Kozielczyk

Title: SQL Server 2008 .NET integration programming

Description:

This talk focuses on end-to-end programming experience of SQL Server .NET integration (aka SQLCLR). We show how to use Visual Studio 2008 to implement new data types, functions, aggregates and stored procedures using .NET programming languages and SQL Server-hosted CLR. We present the deployment process for all of those objects as well as common usage scenarios. We also discuss typical issues developers may stumble onto and unveil future plans for SQL Server .NET integration.

SessionID: 62053

SQLCAT - SQL Server 2008 Virtualization with Windows Server 2008 Hyper-V

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: SQLCAT - SQL Server 2008 Virtualization with Windows Server 2008 Hyper-V

Description:

In this session we will discuss the following: Consolidation considerations - when to consolidate with multiple SQL instances vs. when to consider Hyper-V. Best practices for running SQL Server workloads within Hyper-V Virtual Machines, monitoring Strategies, sample data points related to performance of SQL Server running within Hyper-V Virtual Machines.

SessionID: 62052

Advanced Policy-Based Management with Microsoft SQL Server 2008

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Advanced Policy-Based Management with Microsoft SQL Server 2008

Description:

Over the past few years, the role of database servers has dramatically increased its importance in almost every industry. Meanwhile, SQL Server has increased its feature set and its ability to scale in enterprise environments. As a result, the management of database servers has become a complex, manual and brittle process, with limited insight for troubleshooting problems. Aiming at improving, SQL Server manageability, as part of an ongoing effort by Microsoft to reduce the total cost of ownership, SQL Server 2008 introduces Policy-Based Management. Policy-Based Management enables users to manage SQL Servers by declarative intent, a.k.a., policies, that is, by specifying how the system should be and not the means to achieve it. By raising the level of management abstraction, Policy-Based Management simplifies the management process, provides policy automation, and provides greater insight into the system. This session focuses on the advanced features including: advanced condition building, target filtering, policy alert notification, and PowerShell integration.

SessionID: 62051

Effective usage of SQL Server 2005 Database Mirroring, what`s new in SQL 2008

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s):

Title: Effective usage of SQL Server 2005 Database Mirroring, what`s new in SQL 2008

Description:

High Availability solution from SQL Server, since version 2005 your SQL Server database availability and high performance solution can be delivered using Database Mirroring. With fast failover and minimal data loss has traditionally involved higher hardware cost and greater software complexity? This session highlights effective usage of SQL Server 2005 Database mirroring, that can fail over quickly with no loss of committed data, does not require proprietary hardware, and is easy to set up and manage. So what`s new within SQL Server 2008 version in this high availability ranch.

SessionID: 61961

Why Normalization Matters

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Louis Davidson

Title: Why Normalization Matters

Description:

In this session I will give an overview of the common normal forms and show 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: 61960

The dirty dozen... 12 Ways to write badly performing T-SQL

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Application Development

Speaker(s): Gail Shaw

Title: The dirty dozen... 12 Ways to write badly performing T-SQL

Description:

Database performance is a hot topic and there are often questions asked pertaining to the best way to write T-SQL queries.

SessionID: 62054

End-to-End Troubleshooting for SQL Server 2005

Back to calendar

Event Date: 21-11-2008 16:00 - Category: Regular Session (60 minutes) - Track: Database Administration

Speaker(s): Kevin Kline

Title: End-to-End Troubleshooting for SQL Server 2005

Description:

Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate: - Performance Monitor (PerfMon) - SQL Profiler/Server-side Trace - Correlating PerfMon and Profiler results - Graphic Explain Plan and Transact-SQL Showplan - SQL Server 2005 and 2008 DMVs - When to use Trace Flags These tools and techniques can make your long days shorter and make difficult troubleshooting activities much faster and easier. Every DBA needs to know how to keep their SQL Server in tip-top condition, and you`ll need these skills to do it.