sqlpasshistory

ID: 4

Back to Main list

PASS SQLRally 2011 Orlando

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
11-05-2011 00:00	Rafael Salas	Data Warehousing	Business Intelligence	Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data Integration
11-05-2011 00:00	Sam Nasr	Misc	Development	Programming with StreamInsight
11-05-2011 00:00	Sam Nasr	Misc	Development	Programming with FileStream Object
11-05-2011 00:00	Evan Basalik	SSRS	Business Intelligence	Troubleshooting SSRS Performance
11-05-2011 00:00	Rafael Salas	New Technology	Business Intelligence	SQL Server Code-Named “Denali”: Exploring the Enterprise Data Integration & Management (EDIM) Promise
11-05-2011 00:00	Ayad Shammout	Summit Spotlight	Business Intelligence	PowerPivot for Excel and SharePoint 2010
11-05-2011 00:00	Evan Basalik	Summit Spotlight	Development	Diagnosing connectivity issues with SQL Server
11-05-2011 00:00	Joe Kuemerle	Source\Version Control	Development	Sharing For DBA's: A Guide To Source Control.
11-05-2011 00:00	Joe Kuemerle	Security	DBA	Protect Your Data's Privacy! Data Encryption with SQL Server
11-05-2011 00:00	Erik Veerman	Summit Spotlight	Business Intelligence	Data Profiling and Cleansing with Integration Services
11-05-2011 00:00	Glenn Berry	Summit Spotlight	Development	DMV Emergency Room!
11-05-2011 00:00	Barry Ralston	Sharepoint/PowerPivot	Business Intelligence	A Year of Living Dangerously, PowerPivot Lessons from the Field
11-05-2011 00:00	Barry Ralston	Sharepoint/PowerPivot	Business Intelligence	Business Intelligence Solutions with PowerPivot for Excel and SharePoint
11-05-2011 00:00	Glenn Berry	Summit Spotlight	Development	Hardware 301: Selecting and Sizing Database Hardware for OLTP Performance
11-05-2011 00:00	Sri Sridharan	Regular session	Professional Development	Turbo Charge your DBA Career
11-05-2011 00:00	Mattias Lind	.NET	Development	A data-logic approach to EF4
11-05-2011 00:00		Responsibilities	DBA	Fundamentals of DBA-ism
11-05-2011 00:00	Sri Sridharan	Storage	DBA	Using SSIS to manage and monitor SAN - Mount Volumes
11-05-2011 00:00	John Welch	Summit Spotlight	Business Intelligence	Do You Know the Data Flow?
11-05-2011 00:00	Michael Stark	Misc	Development	Spatial Data in SQL 2008
11-05-2011 00:00		Monitoring/Auditing	DBA	The Thrill of the Trace
11-05-2011 00:00	Plamen Ratchev	Summit Spotlight	Development	Zen and the Art of Writing SQL Query
11-05-2011 00:00	Plamen Ratchev	Summit Spotlight	Development	T-SQL Enhancements in Denali
11-05-2011 00:00	Ayad Shammout	Summit Spotlight	Development	Building a High Availability SQL Server 2008 R2 environment
11-05-2011 00:00	David Stein	SSRS	Business Intelligence	The Power of Parameters - SSRS Survivor Series
11-05-2011 00:00	Thomas Grohser	Summit Spotlight	Development	SQL Server Storage Engine under the hood: How SQL Server performs I/O
11-05-2011 00:00	Thomas Grohser	Summit Spotlight	Development	100% Availability without 100% Uptime
11-05-2011 00:00	David Stein	SSRS	Business Intelligence	Choose Your Own (Reporting) Adventure – SSRS Survivor Series
11-05-2011 00:00	John Sterrett	PBM	DBA	Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee
11-05-2011 00:00	Wesley Brown	Storage	DBA	Understanding Storage Systems and SQL Server
11-05-2011 00:00	Erin Stellato	Responsibilities	DBA	Who's responsible? The vendor or the DBA?
11-05-2011 00:00	Julie Smith	SSIS	Business Intelligence	Cool Tricks to Pull from your SSIS Hat
11-05-2011 00:00	Wesley Brown	Storage	DBA	Solid State Storage Deep Dive
11-05-2011 00:00	Jennifer McCown	Summit Spotlight	Development	T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code
11-05-2011 00:00	Thomas Norman	Monitoring/Auditing	DBA	Compliance, Auditing and Encryption in Sql Server
11-05-2011 00:00	Thomas Norman	PBM	DBA	Policy Based Management
11-05-2011 00:00	Chris Skorlinski	Monitoring/Auditing	DBA	Using Microsoft Atlanta to Proactively Monitor SQL Servers
11-05-2011 00:00	Chris Skorlinski	Advanced SSIS	Business Intelligence	Integrating Change Data Capture with SSIS
11-05-2011 00:00	Lynn Langit	Summit Spotlight	DBA	Migrating to SQL Azure
11-05-2011 00:00	Ronald Dameron	PowerShell	DBA	Automating SQL Server Login Administration and Compliance Audits with PowerShell
11-05-2011 00:00	Robert Cain	Source\Version Control	Development	Data Dude for Devs and DBAs - Making Database Development Painless and Productive
11-05-2011 00:00	Robert Cain	Indexing & Partitioning	DBA	Searching Unstructured Text Data - SQL Server Full Text Searching for DBAs and Developers
11-05-2011 00:00	Ronald Dameron	PowerShell	DBA	Learn PowerShell using Real World Examples
11-05-2011 00:00	Mark Broadbent	Regular session	DBA	The Great High Availability Hustle
11-05-2011 00:00	Steve Schneider	Security	DBA	Encryption 2005 101
11-05-2011 00:00	Mark Broadbent	Regular session	DBA	Orders of magnitude: Scale-Out your SQL Server Data
11-05-2011 00:00	Scott Schledwitz	Analytics	Business Intelligence	Performance Management Scorecards - Building a process to achieve top performance
11-05-2011 00:00	Erik Veerman	Summit Spotlight	Business Intelligence	Overcoming SSIS Deployment and Configuration Challenges
11-05-2011 00:00	Bradley Ball	Storage	DBA	Page And Row Compression How, When, and Why
11-05-2011 00:00	Sanjay Soni	Summit Spotlight	Business Intelligence	Delivering Data as a Service from the SQL Azure (Cloud), mobile BI and self service BI at Microsoft
11-05-2011 00:00		Regular session	DBA	SQL SERVER 2008 / R2 - TROUBLESHOOTING SQL SERVER STATISTICS
11-05-2011 00:00	Sandra Mueller	Data Warehousing	Business Intelligence	Developing Date and Role-Playing Dimensions
11-05-2011 00:00	Jennifer McCown	Summit Spotlight	Development	T-SQL Code Sins: The Worst Things We Do to Code, and Why
11-05-2011 00:00		Administration	DBA	SQL SERVER 2011 (Denali) - AVAILABILITY AND MANAGEABILITY ENHANCEMENTS
11-05-2011 00:00	Steve Schneider	Monitoring/Auditing	DBA	SQL Server Troubleshooting via DMV's
11-05-2011 00:00	Bryan Oliver	Indexing & Partitioning	DBA	Fragmentation and Performance Issues
11-05-2011 00:00	David Gitner	Administration	Business Intelligence	Revolutionizing Database Performance Through Accelerated Disk IO
11-05-2011 00:00	John Welch	Summit Spotlight	Business Intelligence	Using Agile Development Techniques with Integration Services
11-05-2011 00:00	Kevin Goode	Summit Spotlight	DBA	Things to do in SQL when you’re dead(locked)
11-05-2011 00:00	Jason Strate	Regular session	DBA	Discovering the Plan Cache
11-05-2011 00:00	Jason Strate	TSQL Fundamentals	Development	XQuery Basics for the DBA
11-05-2011 00:00	David Levy	Regular session	Professional Development	Getting Out from Behind the Curtain – The New DBA
11-05-2011 00:00	Russel Loski	SSIS	Business Intelligence	Handling XML Datasource Problems with the XML Task
11-05-2011 00:00	Patrick Gallucci	ETL\BI	Development	Developing Master Data Services Tools using Microsoft Office 2010 and Visual Studio 2010
11-05-2011 00:00	Patrick Gallucci	New Technology	Business Intelligence	Developing an Information Governance Program using Master Data Services
11-05-2011 00:00	Tom Marek	New Technology	Business Intelligence	BI in the Cloud
11-05-2011 00:00	David Darden	SSAS/MDX	Business Intelligence	Enterprise Class Analysis Services Development
11-05-2011 00:00	Eric Wisdahl	SSIS	Business Intelligence	SSIS Configurations, Expressions and Constraints
11-05-2011 00:00	Trevor Barkhouse	Summit Spotlight	DBA	A PowerShell Cookbook for DBAs
11-05-2011 00:00	Kevin Goode	Summit Spotlight	Development	Deploying Visual Studio 2010 Database Projects
11-05-2011 00:00	Jonathan Aneja	.NET	Development	Entity Framework for the DB Administrator
11-05-2011 00:00	Trevor Barkhouse	Summit Spotlight	DBA	Quantitative Analysis of SQL Server Error Logs
11-05-2011 00:00	Arnie Rowland	TSQL Fundamentals	Development	SQL 201: Stored Procedures, Functions, and Triggers
11-05-2011 00:00	Arnie Rowland	Regular session	Professional Development	Ramp-Up Your Presentations!
11-05-2011 00:00	Joshua Jin	Administration	Business Intelligence	Building SQL 2008 BI to Manage Enterprise Multi-Platform Server Capacities
11-05-2011 00:00	Allan Hirt	Summit Spotlight	DBA	Planning and Deploying Failover Clustering for SQL Server 2008 and Denali
11-05-2011 00:00	Grant Fritchey	Peformance	DBA	SQL Server Query Performance Tuning: Start to Finish
11-05-2011 00:00	Allen Kinsel	Regular session	DBA	dba 101 test
11-05-2011 00:00	Allan Hirt	Summit Spotlight	DBA	Clustering, Database Mirroring, Log Shipping, Replication, and HADRON: Oh My!
11-05-2011 00:00	David Levy	Regular session	Professional Development	What To Do When It All Goes So Wrong
11-05-2011 00:00	Aaron Nelson	Summit Spotlight	Development	PowerShell 2.0 Beyond the Dirty Dozen
11-05-2011 00:00	Aaron Nelson	Summit Spotlight	DBA	The Dirty Dozen: PowerShell Scripts for the Busy DBA
11-05-2011 00:00	Carlos Bossy	Mining	Business Intelligence	The Data Mining Lifecycle
11-05-2011 00:00	Said Salomon	Administration	DBA	Overview of SQL 2005 Service Broker
11-05-2011 00:00	Carlos Bossy	Advanced SSIS	Business Intelligence	Real-time Data Integration
11-05-2011 00:00	Said Salomon	Security	DBA	Data Encryption and Key Management in SQL
11-05-2011 00:00	Doug Wheaton	Advanced SSIS	Business Intelligence	Achieving Real-time BI in a Heterogeneous Environment Using CDC Technology & Microsoft SSIS
11-05-2011 00:00	David Moutray	Design	Development	Sun Tzu and the Art of Software Development
11-05-2011 00:00	Eddie Wuerch	Regular session	DBA	Troubleshooting Performance Problems by Reading the Waits
11-05-2011 00:00	David Moutray	Design	Development	Database "Insecurity"
11-05-2011 00:00	A. P. Ward Pond	Tips & Tricks	Development	SQL Tricks
11-05-2011 00:00	Kyle Walker	SSIS	Business Intelligence	Intermediate SSIS Development
11-05-2011 00:00	A. P. Ward Pond	TSQL Fundamentals	Development	Set-Based Thinking for the T-SQL Developer
11-05-2011 00:00	Eddie Wuerch	Regular session	Development	Drive SQL Server Performance: Intro to I/O For Developers
11-05-2011 00:00	Stacia Varga	Summit Spotlight	Business Intelligence	Data Visualizations in SSRS 2008 R2
11-05-2011 00:00	Joe Chang	Regular session	DBA	Automating Execution Plan Analysis
11-05-2011 00:00	Joe Chang	Regular session	DBA	Query Optimizer Cost Formulas
11-05-2011 00:00	Kevin Boles	TSQL Advanced	Development	Advanced TSQL Solutions
11-05-2011 00:00	Brett Hawton	Summit Spotlight	DBA	Are you sure that your network isnt causing SQL Server slowdowns?
11-05-2011 00:00	Stacia Varga	SSRS	Business Intelligence	A Checklist for Reporting Services Security
11-05-2011 00:00	Brett Hawton	Summit Spotlight	DBA	How to maximize SAN Performance in real-world SQL Server situations
11-05-2011 00:00	Kevin Kline	Summit Spotlight	DBA	Performance Proof! Parallel Query Processing on Microsoft SQL Server 2008 R2
11-05-2011 00:00	Kevin Kline	Summit Spotlight	DBA	Performance Proof! Database Compression on Microsoft SQL Server 2008 R2
11-05-2011 00:00	Eugene Asahara	Analytics	Business Intelligence	Predixion PMML Connexion™
11-05-2011 00:00	Wendy Pastrick	Regular session	Professional Development	Recruiting, Retaining & Advancing Women in Technology: Why does it matter?
11-05-2011 00:00	Eugene Asahara	Analytics	Business Intelligence	Bridging Predictive Analytics and Performance Management
11-05-2011 00:00	Edward Stangler	Monitoring/Auditing	DBA	Special Topics in SQL Server Monitoring
11-05-2011 00:00		Analytics	Business Intelligence	Building a visual vocabulary
11-05-2011 00:00	Mark Tabladillo	Mining	Business Intelligence	Enterprise Text Mining with Analysis Services
11-05-2011 00:00	Erin Stellato	Regular session	DBA	Baselines first, troubleshooting second
11-05-2011 00:00	Christian Wade	SSAS/MDX	Business Intelligence	Currency Conversion (and More) in Analysis Services
11-05-2011 00:00	André Kamman	Advanced SSIS	Business Intelligence	Generating SSIS Packages
11-05-2011 00:00	Wendy Pastrick	Azure\Cloud	Development	SQL Azure - Seeing your data through the Cloud
11-05-2011 00:00	Phillip E Rosen	Sharepoint/PowerPivot	Business Intelligence	Business Intelligence dashboards with MS Excel, Excel OLAP formulas, and Share Point
11-05-2011 00:00	Mark Tabladillo	Mining	Business Intelligence	Enterprise Data Mining for SQL Server Professionals
11-05-2011 00:00	Devin Knight	SSAS/MDX	Business Intelligence	Performance Tuning Analysis Services
11-05-2011 00:00	Devin Knight	SSIS	Business Intelligence	Loading a Data Warehouse in SSIS
11-05-2011 00:00	Kendra Little	Tips & Tricks	Development	(NOLOCK) FOR YESFUN: Games with Isolation Levels
11-05-2011 00:00	Allen White	Summit Spotlight	DBA	Automate Policy-Based Management using PowerShell
11-05-2011 00:00	Brad McGehee	Summit Spotlight	DBA	Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less
11-05-2011 00:00	Brad McGehee	Summit Spotlight	DBA	Database Maintenance Essentials
11-05-2011 00:00	Allen White	Summit Spotlight	DBA	Let Service Broker Help You Scale Your Application
11-05-2011 00:00	Ira Warren	SSIS	Business Intelligence	(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matching) Advanced Implementations
11-05-2011 00:00	Ira Warren	ETL\BI	Development	Creating a Metadata Mart with SSIS - Data Governance , Data Profiling & Code Generation
11-05-2011 00:00	Adam Jorgensen	Summit Spotlight	Business Intelligence	Zero to Analytics - PowerPivot, PerformancePoint and Excel Svcs
11-05-2011 00:00	David Dye	Monitoring/Auditing	DBA	SQL Audit
11-05-2011 00:00	Kendra Little	Indexing & Partitioning	DBA	Big and Tall: When to Partition
11-05-2011 00:00	Jeremiah Peschka	TSQL Advanced	Development	Refactoring SQL
11-05-2011 00:00	Jeremiah Peschka	Administration	DBA	Fundamentals of SQL Server Internals
11-05-2011 00:00	Scott Weinstein	Source\Version Control	Development	Taming Database version control and deployments
11-05-2011 00:00	Patrick LeBlanc	Data Warehousing	Business Intelligence	Near Real-Time Data Warehouse
11-05-2011 00:00	Bryan Smith	SSAS/MDX	Business Intelligence	Unlocking the Mystery of MDX
11-05-2011 00:00	Sanjay Soni	Analytics	Business Intelligence	Delivering BI to the masses at Microsoft using CBI - Top 10 challenges
11-05-2011 00:00	Jason Wong	Regular session	Development	Ask Why My Query So Slow?
11-05-2011 00:00	Sandra Mueller	SSRS	Business Intelligence	SSRS Administration - Enter a BIDS Free Zone
11-05-2011 00:00	Scott Weinstein	ETL\BI	Development	Using PowerShell to simplify your ETL
11-05-2011 00:00	Tim Mitchell	Advanced SSIS	Business Intelligence	ETL Head-to-Head: T-SQL vs. SSIS
11-05-2011 00:00	Tim Mitchell	SSIS	Business Intelligence	Dirty Data? Clean It Up!
11-05-2011 00:00	Robert Davis	Summit Spotlight	DBA	Strategies for Working with VLDBs
11-05-2011 00:00	Jorge Segarra	Summit Spotlight	Professional Development	SQL University: Lightning Talks
11-05-2011 00:00	Victor Isakov	Summit Spotlight	Business Intelligence	What Every DBA Should Know About Sharepoint 2010
11-05-2011 00:00	Thomas LeBlanc	Regular session	DBA	Execution Plan Basics
11-05-2011 00:00	Dave Fackler	Summit Spotlight	Business Intelligence	ETL from the Trenches: Using SSIS in the Real World
11-05-2011 00:00	Robert Davis	Summit Spotlight	DBA	Developing a Multilevel Business Continuity Plan
11-05-2011 00:00	Alex Kuznetsov	TSQL Advanced	Development	Developing Robust T-SQL for High Concurrency
11-05-2011 00:00	Mike Walsh	Summit Spotlight	DBA	As A DBA, Where Do I Start?! - Tips to unwind the mess waiting for us
11-05-2011 00:00	Mike Walsh	Regular session	Professional Development	Iceberg, Dead Ahead! - Lessons from real life disasters for the database professional
11-05-2011 00:00	Aaron Bertrand	Misc	Development	What's new in SQL Server 2011 ("Denali")?
11-05-2011 00:00	Karen Lopez	Regular session	Professional Development	Career Success in the Data Profession during Turbulent Times
11-05-2011 00:00	Karen Lopez	Summit Spotlight	Development	Database Design Contentious Issues
11-05-2011 00:00	Wayne Sheffield	Tips & Tricks	Development	Table Variables and Temporary Tables - What you Need to know!
11-05-2011 00:00	Eric Wisdahl	Advanced SSIS	Business Intelligence	SSIS Data Flow Buffer Breakdown
11-05-2011 00:00	Todd Robinson	Regular session	Development	AppFabric Cache and SQL Server 2008
11-05-2011 00:00	Aaron Bertrand	Tips & Tricks	Development	Management Studio Tips & Tricks
11-05-2011 00:00	Klaus Aschenbrenner	Summit Spotlight	DBA	SQL Server 2008 Database Internals
11-05-2011 00:00	Denny Cherry	Summit Spotlight	DBA	Using SQL Server Denali's Always On
11-05-2011 00:00	Denny Cherry	Summit Spotlight	Development	Where should I be encrypting my data?
11-05-2011 00:00	Klaus Aschenbrenner	Summit Spotlight	DBA	SQL Server Index Internals
11-05-2011 00:00	Dan Evans	Sharepoint/PowerPivot	Business Intelligence	EPM using SQL Server and SharePoint
11-05-2011 00:00	Jonathan Kehayias	Summit Spotlight	DBA	Deadlocking for Mere Mortals
11-05-2011 00:00	Jonathan Kehayias	Summit Spotlight	DBA	Using Event Notifications in SQL Server 2005/2008
11-05-2011 00:00	Dan Evans	Administration	Business Intelligence	Agile BI with Microsoft Technologies
11-05-2011 00:00	Michael Wells	Regular session	Professional Development	Navigating your way through the fog of Microsoft Certifications
11-05-2011 00:00	Michael Wells	PowerShell	DBA	Building a truly unattended install of SQL Server using PowerShell
11-05-2011 00:00	Dave Ballantyne	TSQL Fundamentals	Development	TSql Techniques
11-05-2011 00:00	Randy Knight	Responsibilities	DBA	Become a Bilingual DBA! Oracle for the SQL Server DBA
11-05-2011 00:00	Randy Knight	Source\Version Control	Development	Visual Studio 2010 Database Projects
11-05-2011 00:00	Thomas LeBlanc	Design	Development	3rd Normal Form: That's crazy talk!!!
11-05-2011 00:00	Scott Klein	Azure\Cloud	Development	SQL Azure 201 - Cloud Database Deep-Dive
11-05-2011 00:00	Adam Jorgensen	Summit Spotlight	Business Intelligence	Zero To OLAP Cubes in 60 Minutes
11-05-2011 00:00	Brian Mitchell	New Technology	Business Intelligence	SQL Server Parallel Data Warehouse - Under the Hood
11-05-2011 00:00	Scott Klein	Azure\Cloud	Development	Azure Solutions - Using SQL Azure and Azure Storage Solutions
11-05-2011 00:00	Jason Wong	Administration	DBA	Top 10 SQL Server Defaults to Evaluate and Modify
11-05-2011 00:00	Cory Loriot	Design	Development	Unified Data Access in SharePoint 2010
11-05-2011 00:00	Brett Tomson	Design	Development	Growing Pains - A Cautionary Tale
11-05-2011 00:00	Louis Davidson	Summit Spotlight	Development	Database Structures for Programmers
11-05-2011 00:00	Brandie Tarvin	SSIS	Business Intelligence	Variables, Expressions, and XML Configs, Oh My!
11-05-2011 00:00	Brett Tomson	SSRS	Business Intelligence	What's New In SSRS 2008 (With Added R2 Flair)
11-05-2011 00:00	Victor Isakov	Summit Spotlight	DBA	Maximizing Parallelism Performance
11-05-2011 00:00	Joseph D'Antoni	Azure\Cloud	Development	Deploying Data Tier Applications to the Cloud
11-05-2011 00:00	Jen Underwood	Sharepoint/PowerPivot	Business Intelligence	Business Intelligence with SharePoint 2010 and PowerPivot
11-05-2011 00:00	Jana Sattainathan	TSQL Advanced	Development	Bend SQL to your will
11-05-2011 00:00	Jana Sattainathan	Indexing & Partitioning	DBA	Partitioning in SQL Server 2005/2008
11-05-2011 00:00	Scott Shaw	Responsibilities	DBA	The Enterprise SQL DBA
11-05-2011 00:00	Louis Davidson	Summit Spotlight	Development	Characteristics of a Great Relational Database
11-05-2011 00:00	Steve Jones	Summit Spotlight	Professional Development	The Modern Resume - Building Your Brand
11-05-2011 00:00	Jen Underwood	Administration	Business Intelligence	Optimizing a Business Intelligence Solution
11-05-2011 00:00	Michael DeFehr	Indexing & Partitioning	DBA	How to Do an Index Review
11-05-2011 00:00	Erdal Ozkaya	Security	DBA	Administrator's Idol: Secure Database
11-05-2011 00:00	Randy Dyess	Data Warehousing	Business Intelligence	The Fast Track Data Warehouse
11-05-2011 00:00	Hector Hernandez	Regular session	Professional Development	Leadership without Permission
11-05-2011 00:00	Brian McDonald	SSRS	Business Intelligence	Reporting Services Boot Camp
11-05-2011 00:00	Ken Simmons	Summit Spotlight	DBA	The Art of Indexing
11-05-2011 00:00	Ken Simmons	Summit Spotlight	DBA	Automating Routine Maintenance
11-05-2011 00:00	Sandeep Khandelwal	Sharepoint/PowerPivot	Business Intelligence	Dashing Dashboarding
11-05-2011 00:00	Steve Simon	SSAS/MDX	Business Intelligence	The Dirty Dozen: 12 ways to write poorly performing MDX queries
11-05-2011 00:00	Brandie Tarvin	Regular session	Professional Development	Interviewing Tips for Desperate DBA
11-05-2011 00:00	Steve Simon	Mining	Business Intelligence	SQL Server Data Mining… Making $mart financial decision$ in weak financial markets
11-05-2011 00:00	Michael DeFehr	Tips & Tricks	Development	Deadlocks: What to do about the dreaded 1205
11-05-2011 00:00	Erdal Ozkaya	Security	DBA	Social Engineering, the art of Deception!
11-05-2011 00:00	Randy Dyess	Administration	Business Intelligence	The BI DBA
11-05-2011 00:00	Patrick LeBlanc	SSRS	Business Intelligence	Create an Interactive Dashboard with SSRS
11-05-2011 00:00	Jose Chinchilla	Data Warehousing	Business Intelligence	Business Intelligence: Decaffeinated Please!
11-05-2011 00:00	Meredith Ryan-Smith	Responsibilities	DBA	Help Desk to DBA in 60-ish minutes
11-05-2011 00:00	Mike Davis	New Technology	Business Intelligence	New Reporting Features of SQL Server 2011
11-05-2011 00:00	Jose Chinchilla	Regular session	Professional Development	Get Cert! Get Cred!
11-05-2011 00:00	Alex Kuznetsov	TSQL Fundamentals	Development	Avoid Common Mistakes in T-SQL Programming
11-05-2011 00:00	Peter Trast	PBM	DBA	Policy Based Management
11-05-2011 00:00	Ed Wilson	PowerShell	DBA	Windows PowerShell Best Practices for SQL DBA's
11-05-2011 00:00	Janis Griffin	Misc	Development	SQL Server Service Broker – An Overview
11-05-2011 00:00	Janis Griffin	Monitoring/Auditing	DBA	Database Performance Management – 2008 MDW
11-05-2011 00:00	Tim Chapman	TSQL Advanced	Development	Writing faster queries
11-05-2011 00:00	Pam Shaw	SSRS	Business Intelligence	On Demand Subscriptions – no crystal ball required
11-05-2011 00:00	Mike Davis	Advanced SSIS	Business Intelligence	Using Script Task and Components in SQL Server Integration Services (SSIS)
11-05-2011 00:00	Laerte Junior	PowerShell	DBA	Practical Powershell for SQL Server Professional - Success Cases
11-05-2011 00:00	Pam Shaw	SSRS	Business Intelligence	Tips & Tricks for dynamic Reporting Services Reports
11-05-2011 00:00	Michael Antonovich	Sharepoint/PowerPivot	Business Intelligence	Creating and Using Pivot Tables/Cubes Using 3 Microsoft Tools
11-05-2011 00:00	Jorge Segarra	PBM	DBA	Policy-Based Management in a Nutshell
11-05-2011 00:00	Kevin Boles	TSQL Advanced	Development	Death By UDF
11-05-2011 00:00	Troy Ketsdever	Tips & Tricks	Development	So You've Inherited the "DB From Heck" (v2.0)
11-05-2011 00:00	Edwin M Sarmiento	Regular session	Professional Development	Presentation WOW!
11-05-2011 00:00	Edwin M Sarmiento	Regular session	DBA	DBA Disaster Recovery Techniques To Keep Handy
11-05-2011 00:00	Troy Ketsdever	TSQL Advanced	Development	Zero to "MERGE" in 60 minutes
11-05-2011 00:00	Meir Dudai	Regular session	DBA	Peer-to-Peer Replication: Real Life Implementations and Best Practices
11-05-2011 00:00	Dmitri Korotkevitch	Responsibilities	DBA	Adopt, Discover and Improve – How to take ownership of a system and survive on a new job
11-05-2011 00:00	Dmitri Korotkevitch	Monitoring/Auditing	DBA	Baselining, trend analysis and system monitoring with Management Data Warehouse
11-05-2011 00:00	Meir Dudai	Regular session	Professional Development	How to become a SQL Server community celebrity?
11-05-2011 00:00	Geoff Hiten	Summit Spotlight	DBA	Clustering for Mere Mortals
11-05-2011 00:00	Geoff Hiten	Summit Spotlight	Development	Bad SQL
11-05-2011 00:00	Chad Miller	PowerShell	DBA	Real World Administration with SQL Server PowerShell Extensions (SQLPSX)

SessionID: 836

Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data Integration

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Data Warehousing - Track: Business Intelligence

Speaker(s): Rafael Salas

Title: Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data Integration

Description:

You may have heard this: Data integration is the most difficult part of a data warehouse project. But, do you know why? Or better yet, do you know what could increase your chances of success? With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic. In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems. And while this session won’t get you the magic formula for ETL perfection, it will get you one step closer in the right direction.

SessionID: 835

Programming with StreamInsight

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Misc - Track: Development

Speaker(s): Sam Nasr

Title: Programming with StreamInsight

Description:

StreamInsight is one of the new exciting features released in SQL Server 2008 R2. With Data volumes exploding with event data streaming from sources such as RFID, sensors, and web logs, the size and frequency of the data make it challenging to store for data mining and analysis. The ability to monitor, analyze and act on the data in motion provides significant opportunity to make more informed business decisions in near real-time. In this session, we’ll demonstrate how events can be processed with low latency so that action can be taken immediately based on the insights derived.

SessionID: 834

Programming with FileStream Object

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Misc - Track: Development

Speaker(s): Sam Nasr

Title: Programming with FileStream Object

Description:

SQL Server 2008 introduced the FileStream object. This allowed developers to resolve an age long dilemma of storing large binary files in the database or accessing them on the file system. SS08 provides the best of both worlds while allowing applications to access the data readily through the FileStream object via Transact SQL or File I/O.

SessionID: 837

Troubleshooting SSRS Performance

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Evan Basalik

Title: Troubleshooting SSRS Performance

Description:

Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.

SessionID: 840

SQL Server Code-Named “Denali”: Exploring the Enterprise Data Integration & Management (EDIM) Promise

Back to calendar

Event Date: 11-05-2011 00:00 - Category: New Technology - Track: Business Intelligence

Speaker(s): Rafael Salas

Title: SQL Server Code-Named “Denali”: Exploring the Enterprise Data Integration & Management (EDIM) Promise

Description:

ETL, Data Quality and Master Data Management address issues related to data acquisition, standardization and improvement. In SQL Server Code-Named “Denali” with the introduction of Data Quality Services and the concept of Enterprise Data Integration & Management (EDIM) these 3 areas seems to come together – Just like bread, peanut butter and jelly. But, are the new tools ready for prime time? Do they overlap with existing tools? Do they integrate seamlessly? In this session, we will explore the concepts under EDIM cover, look at the capabilities of the new Data Quality Services (DQS), and review the most significant improvements in SQL Server Integration Services (SSIS) and Master Data Services (MDS) available in the latest Community Technology Preview (CTP).

SessionID: 839

PowerPivot for Excel and SharePoint 2010

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Ayad Shammout

Title: PowerPivot for Excel and SharePoint 2010

Description:

In this session, I will cover PowerPivot - a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine, I will interactively explore and perform calculations on very large data sets. This session gives the user the freedom to learn the many uses of PowerPivot from importing, modeling, analyzing and pivoting millions of records to publishing to SharePoint. I will show how IT staff can track and monitor user generated PowerPivot workbooks in SharePoint and explore PowerPivot Management Dashboard

SessionID: 838

Diagnosing connectivity issues with SQL Server

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Evan Basalik

Title: Diagnosing connectivity issues with SQL Server

Description:

Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.

SessionID: 829

Sharing For DBA's: A Guide To Source Control.

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Source\Version Control - Track: Development

Speaker(s): Joe Kuemerle

Title: Sharing For DBA's: A Guide To Source Control.

Description:

Source control systems have been successfully used for years by developers for collaborating without colliding. Todays DBA's must work closely with development teams to ensure that the solutions created are optimal. We will review the outlines of various source control platforms including Microsoft Team Foundation Server, Subversion and Mercurial and how to interact with them. The second half of the session will be an overview and discussion of techniques and practices to provide database versioning and how to ensure that every build of the application is able to have a matching version of the database.

SessionID: 828

Protect Your Data's Privacy! Data Encryption with SQL Server

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Security - Track: DBA

Speaker(s): Joe Kuemerle

Title: Protect Your Data's Privacy! Data Encryption with SQL Server

Description:

Your data at rest is at risk. We take great pains to write secure applications that prevent bad guys from snooping around and stealing confidential information, but what about when we finally write to the database? In this session you will learn to protect your data by leveraging the built in encryption functionality in SQL Server 2005/2008. We will walk through a brownfield application and transparently secure all of the sensitive data it stores without frustrating the overworked developers. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.

SessionID: 827

Data Profiling and Cleansing with Integration Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Erik Veerman

Title: Data Profiling and Cleansing with Integration Services

Description:

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

SessionID: 830

DMV Emergency Room!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Glenn Berry

Title: DMV Emergency Room!

Description:

If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance,resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem. This session will show you how to assemble and use an emergency DMV toolkit that you can use to save the day the next time a sick database shows up on your watch in the Database ER!

SessionID: 833

A Year of Living Dangerously, PowerPivot Lessons from the Field

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Barry Ralston

Title: A Year of Living Dangerously, PowerPivot Lessons from the Field

Description:

Someone once said "Good judgement comes from experience and experience comes from bad judgement". Attend this session to hear some of the lessons learned after a year of using PowerPivot (for Excel and SharePoint) in the field, with customers and live-fire data. We will discuss maxing out a multi-million dollar Teradata installation, nuances (dare I say features) within the user experience and other bits of knowledge gathered over the past year as we look forward to the next release.

SessionID: 832

Business Intelligence Solutions with PowerPivot for Excel and SharePoint

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Barry Ralston

Title: Business Intelligence Solutions with PowerPivot for Excel and SharePoint

Description:

PowerPivot represents a disruptive shift in capabilities for delivering self-service Business Intelligence solutions. Combining advances in SQL Server Analysis Services with a true enterprise monitoring and upgrade path, PowerPivot presents a unique prototype to deployment route. The objective of this session is to share with attendees a sample of the broad range of features that comprise PowerPivot for Excel and PowerPivot for SharePoint and how they can be applied to create self-service Business Intelligence solutions. Using both lecture and software demonstration, this session will prepare attendees to use PowerPivot for Excel immediately.

SessionID: 831

Hardware 301: Selecting and Sizing Database Hardware for OLTP Performance

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Glenn Berry

Title: Hardware 301: Selecting and Sizing Database Hardware for OLTP Performance

Description:

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

SessionID: 850

Turbo Charge your DBA Career

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Sri Sridharan

Title: Turbo Charge your DBA Career

Description:

You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step.

SessionID: 849

A data-logic approach to EF4

Back to calendar

Event Date: 11-05-2011 00:00 - Category: .NET - Track: Development

Speaker(s): Mattias Lind

Title: A data-logic approach to EF4

Description:

We'll discuss the benefits of a data-logic approach to EF4, database modelling, tables, procedures, views and functions and how to integrate this with EF4.

SessionID: 848

Fundamentals of DBA-ism

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s):

Title: Fundamentals of DBA-ism

Description:

Database administrators are required to have a large and varied toolset to do their jobs. We need to have a working knowledge of networks, hardware, .NET development, 3rd party software, and know the impact of all these things on the SQL infrastructure. But at the end of the day there are specific things that they need to do to keep things running. This session will go back to the fundamentals of the DBA - Backups, Index maintenance, performance tracking, how to explain to other departments what needs to be done to keep SQL healthy are some of teh topics that will be covered.

SessionID: 851

Using SSIS to manage and monitor SAN - Mount Volumes

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Storage - Track: DBA

Speaker(s): Sri Sridharan

Title: Using SSIS to manage and monitor SAN - Mount Volumes

Description:

Many organizations struggle to manage space especially in the DB environments. As your SQL Server foot print grows, the love-hate relationship with the SAN increases. Attend this session to get some ideas around how to monitor and trend DB Space using SSIS. You will also learn how to capture SAN / Mount point usage using WMI calls. At the end of the session, you will be able to monitor , forecast and trend your SQL DB footprint along with SAN mountpoint info. This will help your management team to budget for SAN growth etc in a more efficient and predictable manner.

SessionID: 857

Do You Know the Data Flow?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): John Welch

Title: Do You Know the Data Flow?

Description:

The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. We’ll cover the Data Flow from the basic (what’s a component?) to the advanced (how can I determine how many threads my Data Flow is using?). After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.

SessionID: 854

Spatial Data in SQL 2008

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Misc - Track: Development

Speaker(s): Michael Stark

Title: Spatial Data in SQL 2008

Description:

During the session we will cover the new geographic features of SQL 2008. We will cover the reasons for using and the benefits of using. We will construct sql statements to query the data using built in geographic functions like distance and interection. We will then discuss some implementations of spatial data. Finally we will build a quick solution using ASP.net and the Bing Maps control to render the results of our query onto a real map. Time permitting we will quickly show how to render the data to Silverlight and Windows Phone 7.

SessionID: 852

The Thrill of the Trace

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s):

Title: The Thrill of the Trace

Description:

How many times have you been called or emailed by developers or end users tell you the database is running slow and you need to fix it? Unless you have taken steps to monitor before that question is asked, you are suddenly throw into a world of running profiler and trying to recreate the issue. By utilizing server side traces and PerfMon, you can easily have the information at your fingertips. You might even find yourself warning developers that they are going to start seeing some problems with their new code.

SessionID: 843

Zen and the Art of Writing SQL Query

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Plamen Ratchev

Title: Zen and the Art of Writing SQL Query

Description:

Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!

SessionID: 842

T-SQL Enhancements in Denali

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Plamen Ratchev

Title: T-SQL Enhancements in Denali

Description:

Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions.

SessionID: 841

Building a High Availability SQL Server 2008 R2 environment

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Ayad Shammout

Title: Building a High Availability SQL Server 2008 R2 environment

Description:

If you are new to SQL Server 2008 R2 HA features, you will learn how to utilize Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. In this session, I will show how to setup database mirroring, install SQL Failover Cluster instance and upgrade from SQL Server 2005 Cluster to SQL 2008 R2. This session includes real life deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. Technologies covered include Failover Clustering on Windows Server 2008 R2 and SQL 2008 R2 Database Mirroring.

SessionID: 844

The Power of Parameters - SSRS Survivor Series

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): David Stein

Title: The Power of Parameters - SSRS Survivor Series

Description:

Want to know the best techniques to help your user narrow their search in the most efficient ways possible? Come watch me demonstrate which parameter techniques are best for certain situations and field types. Real world problems and applications are stressed, and I’ll demonstrate why some commonly accepted methods simply do not work and should be avoided.

SessionID: 847

SQL Server Storage Engine under the hood: How SQL Server performs I/O

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Thomas Grohser

Title: SQL Server Storage Engine under the hood: How SQL Server performs I/O

Description:

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.   Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 846

 100% Availability without 100% Uptime

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Thomas Grohser

Title:  100% Availability without 100% Uptime

Description:

The problem of globally operating internet sites or any other real 24x7 operation is, that there is no or very little time for maintenance. This session will show how to partition your data across multiple servers and partitions in a way that you can maintain each partition at least once a day without affecting overall availability. You will hear how it works in theory, see a proof of concept and learn how to analyze your data to make the same partitioning for your application.

SessionID: 845

Choose Your Own (Reporting) Adventure – SSRS Survivor Series

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): David Stein

Title: Choose Your Own (Reporting) Adventure – SSRS Survivor Series

Description:

Create a story of guided analytics using Reporting Services drill down, drill through, and expressions. Sure, you may be using drill down already, but I’ll show you how to make the most of Reporting Services interactions, and more importantly how to avoid becoming dragon chow at the end.

SessionID: 826

Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PBM - Track: DBA

Speaker(s): John Sterrett

Title: Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee

Description:

You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to monitor your checklist items against the whole SQL Server farm.

SessionID: 800

Understanding Storage Systems and SQL Server

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Storage - Track: DBA

Speaker(s): Wesley Brown

Title: Understanding Storage Systems and SQL Server

Description:

The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. From how hard drives work, through RAID configurations, and how to configure the file system. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations.

SessionID: 799

Who's responsible? The vendor or the DBA?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s): Erin Stellato

Title: Who's responsible? The vendor or the DBA?

Description:

Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing customers) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start.

SessionID: 798

Cool Tricks to Pull from your SSIS Hat

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Julie Smith

Title: Cool Tricks to Pull from your SSIS Hat

Description:

SQL Server Integration Services--Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer who is relatively new to SSIS, has mastered the basics of the dataflow, and is now looking for elegant ways to automate his/her solutions. It introduces essential components to sophisticated ETL design. The presentation demonstrates several uses of variables, types of variables (including the SSIS workhorse ado.net object), and various ways to populate them. The session will also cover the basics of the SSIS Expression language. This session is demo intensive, using three case studies of real business problems.

SessionID: 801

Solid State Storage Deep Dive

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Storage - Track: DBA

Speaker(s): Wesley Brown

Title: Solid State Storage Deep Dive

Description:

If you have ever wanted to know how SSD's and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. I will also highlight some of the specific vendor implementations and what makes a particular SSD "enterprise ready" vs "Consumer grade". We will also cover SQL Server usage patterns what is a good fit for SSD's and when it may be better to go with hard disks. Solid State Storage isn't a cure-all for every situtation, this presentation will give you the tools you need to make the right choice for your SQL Server environment.

SessionID: 806

T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Jennifer McCown

Title: T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code

Description:

You're a good SQL professional - you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes - just SOMEtimes - some piece of T-SQL slips by you unnoticed, or falls out of memory. Come and revisit old favorites, and brush up on new T-SQL features and enhancements like MERGE, OVER, and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations.

SessionID: 804

Compliance, Auditing and Encryption in Sql Server

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Thomas Norman

Title: Compliance, Auditing and Encryption in Sql Server

Description:

Compliance and Auditing I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.

SessionID: 802

Policy Based Management

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PBM - Track: DBA

Speaker(s): Thomas Norman

Title: Policy Based Management

Description:

Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

SessionID: 792

Using Microsoft Atlanta to Proactively Monitor SQL Servers

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Chris Skorlinski

Title: Using Microsoft Atlanta to Proactively Monitor SQL Servers

Description:

Microsoft Codename Atlanta (http://beta.microsoftatlanta.com) is an online service that analyzes installations of Microsoft SQL Server 2008 and provides proactive alerts to help you avoid system downtime and follow best practices with regard to configuration and usage. Atlanta is developed by the Microsoft Atlanta product group in partnership with Microsoft Support engineers to ensure that the issues customers report to Microsoft are detected before they affect your environment. Atlanta is regularly updated to reflect the most recent experiences of these engineers, who support SQL Server customers around the world.

SessionID: 791

Integrating Change Data Capture with SSIS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Chris Skorlinski

Title: Integrating Change Data Capture with SSIS

Description:

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

SessionID: 790

Migrating to SQL Azure

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Lynn Langit

Title: Migrating to SQL Azure

Description:

Are you looking to migrate your on-premise applications and database from MySql or other RDBMs to SQL Azure? Or are you simply focused on the easiest ways to get your SQL Server database up to SQL Azure? Then, this session is for you. We cover two fundamental areas in this session: application data access tier and the database schema data. In Part 1, we dive into application data-access tier, covering common migration issues as well as best practices that will help make your data-access tier more resilient in the cloud and on SQL Azure. In Part 2, the focus is on database migration. We go through migrating schema and data, taking a look at tools and techniques for efficient transfer of schema through Management Studio and Data-Tier Application (DAC). Then, we discover efficient ways of moving small and large data into SQL Azure through tools like SSIS and BCP. We close the session with a glimpse into what is in store in future for easing migration of applications into SQL Azure. Using Microsoft Visual Studio 2010 to Build Applications That Run on Windows Azure Azure Services Platform - AZP A platform is only as powerful as the tools that let you build applications for it. This session focuses on using demos, not slides, to show the best way to use Visual Studio 2010 to develop Windows Azure applications. Learn tips, tricks and solutions to common problems when creating or moving an existing application to run on Windows Azure. Come see how Visual Studio 2010 supports all parts of the development cycle as we show how to take an ASP.NET application running on IIS and make it a scalable cloud application running on Windows Azure. Advanced Business Intelligence with Microsoft Excel and Excel Services Business Intelligence - BIN This session covers the new advanced capabilities in Microsoft Excel 2010 to help you create detailed analytical reports. We cover new capabilities, such as how to use dynamic sets leveraging the content in Analysis Services, using write-back to provide closed loop analysis, and taking advantage of the new calc-member filtering and slicers with cube functions. We also show you how to share this in Excel Services to create a real-time view and use the new REST API to empower your users. Architecture of Master Data Services in Microsoft SQL Server 2008 R2 Business Intelligence - BIN While your enterprise applications and infrastructure technology change rapidly, the underlying Information Architecture must transcend those evolutions

SessionID: 793

Automating SQL Server Login Administration and Compliance Audits with PowerShell

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Ronald Dameron

Title: Automating SQL Server Login Administration and Compliance Audits with PowerShell

Description:

Do you have hundreds of servers? Are your internal auditors asking that the administration of SQL Server logins be handled by a third party? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who the sysadmins are on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX). This automation is capable of adding or dropping logins and adding or dropping members in database or server roles on any database server. Also, I will demonstrate how to automate compliance reporting via PowerShell, SMO and Excel automation to report on the usage of password complexity/expiration policies, database owner, sysadmin role members, and other security related information.

SessionID: 796

Data Dude for Devs and DBAs - Making Database Development Painless and Productive

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Source\Version Control - Track: Development

Speaker(s): Robert Cain

Title: Data Dude for Devs and DBAs - Making Database Development Painless and Productive

Description:

Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude".

SessionID: 795

Searching Unstructured Text Data - SQL Server Full Text Searching for DBAs and Developers

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Indexing & Partitioning - Track: DBA

Speaker(s): Robert Cain

Title: Searching Unstructured Text Data - SQL Server Full Text Searching for DBAs and Developers

Description:

Users have become accustomed to the simple interfaces of search engines such as Microsoft BING and Google. They want to be able to enter key words and have their applications sift through vast quantities of text to get results quickly. Did you know that you can give your users that search ability? SQL Server Full Text Searching is the key. And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server. Chock full of demonstrations this session will start with setting up full text searching on the database and end with issuing a full text query from within a WPF .Net application.

SessionID: 794

Learn PowerShell using Real World Examples

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Ronald Dameron

Title: Learn PowerShell using Real World Examples

Description:

PowerShell is a springboard to learning more about Windows Management Instrumentation, SQL Server Management Objects, .NET, Automation and object-oriented programming. This session will teach you PowerShell the way I learned it, by example. I will review the fundamentals you'll need to understand examples that automate repetitive tasks and help you better manage your workload. Then, we will review several REAL WORLD examples that I as a Senior IT Pro use regularly to manage issues encountered in a 600 server inventory.

SessionID: 819

The Great High Availability Hustle

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Mark Broadbent

Title: The Great High Availability Hustle

Description:

You have just started your new position and are very proud to be joining ACME Corp. Unfortunately for you, they are running several SQL Server Clusters and you happened to tell that little white lie about understanding Clustering. Actually it wasn't so much a lie, but you always had the support of a Windows Clustering expert and now you are on your own. In this presentation I will demonstrate:- How to setup and install SQL Server 2008 Clustering, troubleshooting and administration, repairing a SQL Cluster and disaster recovery techniques in the event of failure. ..and much more.

SessionID: 818

Encryption 2005 101

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Security - Track: DBA

Speaker(s): Steve Schneider

Title: Encryption 2005 101

Description:

Learn how to implement SQL 2005 Encryption using 2-way and 1-way encryption and why you would use either. Learn what a DBA needs to know and what the developer needs to know. Learn how to maintain encryption...backup and restore issues as well as cross-server issues. This will include a live demonstration of the concepts presented. Implementation: Encryption Types DBA responsibilities Developer’s role Encryption, Speed, and 1 way hashes Maintenance: Backup/restore Storage of backup keys Cross Server ... (all with just 16 slides and two Demo’s)

SessionID: 817

Orders of magnitude: Scale-Out your SQL Server Data

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Mark Broadbent

Title: Orders of magnitude: Scale-Out your SQL Server Data

Description:

Your company is about to embark on a major overhaul of your current IT infrastructure and applications and want you to start thinking about their Data Tier. Your remit is that "this is a one off investment and an opportunity for change" and due to the speed of growth of your organization, you should plan for capacity and scalability requirements to accommodate for long term growth and expansion. It is now your job to start investigating possible ways to achieve and implement this goal In this presentation I will discuss many different methods and techniques to enable server and enterprise based scaling of your data covering diverse subjects including (but not limited to) database schemas, indexing, horizontal partitioning and what I believe is SQL Server's best kept secret!

SessionID: 820

Performance Management Scorecards - Building a process to achieve top performance

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Analytics - Track: Business Intelligence

Speaker(s): Scott Schledwitz

Title: Performance Management Scorecards - Building a process to achieve top performance

Description:

Performance Management relies on optimal performance from the repository. Understanding the requirements of the business user and applying it to the process and architecture guarantees a successful deployment. We will step through the delivery of a Performance Management/Balanced Scorecard solution beginning with the business requirements and applying it to our data model as well as the business intelligence tool used to create the front end.

SessionID: 825

Overcoming SSIS Deployment and Configuration Challenges

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - 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? You’re not alone. This session will be more than just SSIS deployment anger management. We’ll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don’t miss the decision workflows that will help you down the right on choosing the right storage and deployment approaches depending on your situation!

SessionID: 823

Page And Row Compression How, When, and Why

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Storage - Track: DBA

Speaker(s): Bradley Ball

Title: Page And Row Compression How, When, and Why

Description:

Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.

SessionID: 821

Delivering Data as a Service from the SQL Azure (Cloud), mobile BI and self service BI at Microsoft

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Sanjay Soni

Title: Delivering Data as a Service from the SQL Azure (Cloud), mobile BI and self service BI at Microsoft

Description:

See a live demo of how Microsoft IT is distributing terabytes of data from the Enterprise Data Warehouse to various business and IT groups at Microsoft using SQL Azure cloud and on premise platform. Learn about Data Services Layer (DSL) which is a distribution platform that provides a single location for Microsoft users to explore, publish & consume data. See how Windows phone is being used to deliver BI (including scorecards) on mobile phones. Top 10 best practices in running and providing Data as a Service and empowering business users to consume data using various MS BI tools will be discussed. See how PowerPivot and other BI tools are enabling self service BI at Microsoft from EDW. Mobile BI is also being used to consume and deliver that data.

SessionID: 811

SQL SERVER 2008 / R2 - TROUBLESHOOTING SQL SERVER STATISTICS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s):

Title: SQL SERVER 2008 / R2 - TROUBLESHOOTING SQL SERVER STATISTICS

Description:

Statistics issues can be one of the most difficult to troubleshoot. Often, DBAs and developers narrow down the expensive statement using DMVs. The DBA discovers that statistics are the root cause, but the effort to understand and correct the issue becomes difficult. There are situations where recompilation will not help and recompiles have their own performance drawbacks. This session is all about understanding and correcting statistics issues. Statistics are an internal BLOB (statblob) representing data about data. This statistical data is maintained by SQL Server to help build query plans making decisions on accessing data based on the size and distribution of your actual data. Most DBAs maintain these statistics by using the default auto update statistics and auto create statistics settings. This is a good start. However, there are cases where the auto update of statistics is not enough and may not help address certain poorly performing queries and conditions. Additionally, the auto update statistics setting can cause performance issues on large tables forcing the DBA to turn this setting off. In this session we will discuss several case scenarios where statistics are not being leveraged optimally. Statistics can be out of date or have missing statistics, the optimizer might "guess" rather than leveraging statistics, the distribution of statistics may not be optimal, and other conditions can occur where the query plan is not constructed to best leverage statistics. One of the first signs of statistics issues is slow and unpredictable query execution times. This can be due to statistical 'guessing', parameter sniffing, and other query plan conditions. Statistics issues can occur after large insert operations on ascending or descending key columns and after certain maintenance operations. We will discuss how to respond to these situations and how to designing queries that use statistics effectively. To troubleshoot these situations it is often necessary to examine the query plans and to look at the SET STATISTICS PROFILE output. We will cover these troubleshooting efforts and others. Finally we will cover new capabilities in SQL Server 2008, R2 / 2011 to address statistics issues by influencing plans and keeping plans when a good one is found. Using AUTO_UPDATE_STATISTICS_ASYNC, Filtered Statistics, plan freezing, and plan guides, and more will be covered to help get the upper hand on statistics issues.

SessionID: 810

Developing Date and Role-Playing Dimensions

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Data Warehousing - Track: Business Intelligence

Speaker(s): Sandra Mueller

Title: Developing Date and Role-Playing Dimensions

Description:

Let's go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn't know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be. What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and then configure SSAS to use the table as the time dimension. We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions.

SessionID: 807

T-SQL Code Sins: The Worst Things We Do to Code, and Why

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Jennifer McCown

Title: T-SQL Code Sins: The Worst Things We Do to Code, and Why

Description:

It's impossible to follow every best practice all the time. "Code sins" are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.

SessionID: 812

SQL SERVER 2011 (Denali) - AVAILABILITY AND MANAGEABILITY ENHANCEMENTS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: DBA

Speaker(s):

Title: SQL SERVER 2011 (Denali) - AVAILABILITY AND MANAGEABILITY ENHANCEMENTS

Description:

In this session we will cover the Availability and Manageability enhancements to SQL Server 2011 "Denali" For availability SQL Server "Denali" introduces the "HADR" solution for enhancing availability of user databases. "HADR" is a high-availability and disaster recovery solution to enable you to maximize availability for one or more of your user databases. "HADR" involves configuring one or more availability groups. Each availability group establishes the context within which a selected set of user databases can fail over as a single unit. Similar to Database Mirroring, "HADR" involves a set of failover partners, known as availability replicas. Each availability replica possesses a local copy of each of the databases in the availability group. One of these replicas, known as primary replica, maintains the primary copy of each database. The primary replica makes these databases, known as primary databases, available to users for read-write access. For each primary database, another availability replica, known as a secondary replica, maintains a failover copy of the database known as a secondary database. The SQL Server instances can be either failover cluster instances or stand-alone instances. In this session we will discuss the "HADR" architecture and connectivity and discuss how it compares to other high availability options, we will discuss setting up and configuring "HADR", we will discuss role switching and failover methods. We will also discuss allowing Read-Only Access to Secondary Replicas and monitoring "HADR" Availability Groups. New Manageability features are: The Query Editor introduces enhanced functionality for T-SQL debugging and IntelliSense. The Watch window now supports watching Transact-SQL expressions. T-SQL IntelliSense introduces the following: * Breakpoint validation prevents setting a breakpoint in an invalid location. * T-SQL code snippets are templates you can use as starting points when building statements. * T-SQL Surround with snippets are templates you can use as starting points when enclosing sets of Transact-SQL statements in a BEGIN, IF, or WHILE block. Other changes include: Moving databases from one instance of the SQL Server Database Engine to another instance is simplified. Users in a contained database are no longer associated with logins on the instance of SQL Server. Startup options are now configured by using a new Startup Parameters tab of Configuration Manager.

SessionID: 816

SQL Server Troubleshooting via DMV's

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Steve Schneider

Title: SQL Server Troubleshooting via DMV's

Description:

I will present the custom stored procedure I use first whenever an event happens on my 2005 servers. This presents a condensed view the server as drawn through DMV's. I will describe and drill through a SQL Server Troubleshooting Framework down to the DMV level, briefly scoping the tools available at the various levels of trouble detection. At the DMV level, we will focus on specific examples, discussing the selection of DMV-oriented queries and interpret the output in the context of real-life examples. There are four examples which i will walk thru and give the audience the chance to use what I have taught to solve the performance issue. Then, I will discuss the interpretation of the output and the underlying code that extracts that information.

SessionID: 815

Fragmentation and Performance Issues

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Indexing & Partitioning - Track: DBA

Speaker(s): Bryan Oliver

Title: Fragmentation and Performance Issues

Description:

Three types of fragmentation often affect the Perfromance of SQL Server and although as DBA's we often understand them little is often done about two of them. Non Clustered Index fragmentation is the one fragmentation that is often monitored and fixed by DBA's, so what of the other two. The first and often most seen is file fragmentation. The impact this has on queries can be significant. I will discuss ways to monitor this fragmentation, what often causes this fragmentation and how to resolve this type of fragmentation once it has reached a critical level. The second type of fragmentation is extent. I will discuss ways to optimize the design of the database to reduce extent fragmentation, ways to monitor the level of fragmentation and final how to resolve extent fragmention in tables.

SessionID: 814

Revolutionizing Database Performance Through Accelerated Disk IO

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: Business Intelligence

Speaker(s): David Gitner

Title: Revolutionizing Database Performance Through Accelerated Disk IO

Description:

Speaker: Eyal Markovich, Principal Consultant Over the past several decades, data storage has evolved to today’s highly distributed storage systems capable of storing petabytes of data and servicing hundreds of users and applications. Yet the technology to deliver the data efficiently has lagged far behind other technologies. With today’s SSD technology the capability now exists to significantly increase data throughput by reducing or eliminating IO wait times; resulting in the highest levels of application performance. Eyal Markovich of Kaminario will discuss the latest storage technology leveraging DRAM SSD and HDD components to greatly improve your database performance and data availability.

SessionID: 858

Using Agile Development Techniques with Integration Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): John Welch

Title: Using Agile Development Techniques with Integration Services

Description:

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

SessionID: 900

Things to do in SQL when you’re dead(locked)

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Kevin Goode

Title: Things to do in SQL when you’re dead(locked)

Description:

Do you have some weird ideas in your head about things to do in SQL when you're dead(locked)? Well, then; this is the session for you. This session will give an over-view of what a deadlock is and several ways to capture information about deadlocks. The captured deadlock will be dissected with XQuery -exposing what resources were deadlocked and what statements caused the deadlock. To wrap up the session, several techniques will be demonstrated that can be used to eliminate, or at least gracefully recover from, deadlocks.

SessionID: 899

Discovering the Plan Cache

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Jason Strate

Title: Discovering the Plan Cache

Description:

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.

SessionID: 898

XQuery Basics for the DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Fundamentals - Track: Development

Speaker(s): Jason Strate

Title: XQuery Basics for the DBA

Description:

For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery. Oh, and if you aren’t a DBA you can come too.

SessionID: 903

Getting Out from Behind the Curtain – The New DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): David Levy

Title: Getting Out from Behind the Curtain – The New DBA

Description:

The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. DBAs that want to hide in their foxhole, focusing purely on operational tasks are quickly being outsourced. This session will cover the steps to becoming a highly valued leader in your organization by building relationships, automating mundane tasks, standardizing processes, and making education a priority.

SessionID: 907

Handling XML Datasource Problems with the XML Task

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Russel Loski

Title: Handling XML Datasource Problems with the XML Task

Description:

SQL Server Integration Services provides an XML Datasource to extract data from XML documents. This datasource works well for simple XML files, but has problems with some common XML structures. For example, the XML Datasource has problems with multiple XML namespaces. Also, the XML Datasource is clumsy working with deep XML hierarchies. This session will explore how to use the XML Task to handle issues like these XML problems. At the end of the session the attendees will be able to import these more complex XML document after applying simple XSLT (XML Style sheet) transformations to their XML documents. They will be able to extract information from the root node of their documents. This session will review briefly how to use the XML Datasource. We will extract data from an XML document that is a list of one element. Next we will look at how to extract data from a hierarchically structured document. This involves using the Merge Join transformation to merge the different outputs that SSIS produces. After this introduction, we will look at a couple problem cases. We will introduce a second XML namespace to the document. The XML Datasource will not be able to process that file. To extract the document, we will preprocess the document using the XML Task using a simple XSLT stylesheet to remove the namespace prefix from all of the node names. Then we will import the data using this revised XML form. Then we will try importing a complex, multilayered XML document. To do this in the Dataflow, it is necessary to merge multiple outputs together. This involves several other steps. To simplify the XML that we need to process, we build an XSLT stylesheet to flatten the data structure. The resulting structure is much easier to process in the Dataflow

SessionID: 905

Developing Master Data Services Tools using Microsoft Office 2010 and Visual Studio 2010

Back to calendar

Event Date: 11-05-2011 00:00 - Category: ETL\BI - Track: Development

Speaker(s): Patrick Gallucci

Title: Developing Master Data Services Tools using Microsoft Office 2010 and Visual Studio 2010

Description:

In this session we will focus on developing tools for modeling and managing Microsoft Master Data Services as well as Governance tools that can be used in your organization. We will look at an Excel add-in for modeling your master data. The add-in will create all necessary scripts to create your model, entities and attributes as well as reverse engineer an existing model into the spreadsheet. We will then show how to create reports in word and SQL Server Report Builder 3.0 that can aid in compliance in your Governance Program. Finally we will look at how to develop SharePoint 2010 webparts to manage your member data. In this session we will focus on the different development tools that you can use to deploy Master Data Services solutions, including Visual Studio 2010 C#, Excel VBA, PowerShell Scripting SQL Server Report Builder 3.0.

SessionID: 904

Developing an Information Governance Program using Master Data Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: New Technology - Track: Business Intelligence

Speaker(s): Patrick Gallucci

Title: Developing an Information Governance Program using Master Data Services

Description:

In this session we will focus on developing an Information Governance Program and how this can be delivered with Microsoft Master Data Services. Listed below are some of the key factors to a successful Information Governance Program. This session will focus on how to deliver these concepts utilizing Microsoft Master Data Services and the Microsoft Office 2010 tools. • Accountability. Because of the ways in which information is captured--and how it flows across the enterprise, everyone has a role to play in how it is governed. Many of the most important roles are played by individuals fairly junior in the organization. They typically play a key role data capture stage and often cause--or see-errors on a first-hand basis. Certain individuals need to be dedicated to Governance. These roles are filled by senior executives such as the CIO, Information Architects, and Data and Content Stewards. • Efficient Operating Models. The Governance approach should define an organizational structure that most effectively handles the complexities of both integration and IM across the whole of the organization. Of course, there will typically be some degree of centralization as information flows across the business. However, this organizational model need not be a single, hierarchical team. The common standards, methods, architecture, and collaborative techniques so central to Governance allow this model to be implemented in a wide variety of models: physically central, virtual, or offshore.. • A Common Methodology. A Governance program should include a common set of activities, tasks, and deliverables. Doing so builds specific information management-based competencies. This enables greater reuse of artifacts and resources, not to mention increased productivity out of individuals. It also manifests the commonalities of different IM initiatives across the organization. • Standard Models. A common definition of terms, domain values, and their relationships is one of the fundamental building blocks of Governance. This should go beyond a traditional data dictionary. It should include a lexicon of unstructured content. Defining common messaging interfaces allows for easy inclusion of “data in motion.” Business and technical definitions should be represented and, just as important, the lineage between them easy to navigate . • Architecture. An IM architecture should be defined for the current-state, transition points, and target vision. The inherit complexity of this initiative will require the representation of this architecture through multiple views. Use of archite

SessionID: 893

BI in the Cloud

Back to calendar

Event Date: 11-05-2011 00:00 - Category: New Technology - Track: Business Intelligence

Speaker(s): Tom Marek

Title: BI in the Cloud

Description:

One of the next jumps to cloud computing will be Business Intelligence (BI). During this presentation we will showcase some of the ways Microsoft's Windows Azure platform can advance your organization's BI strategy and help you to make full use of the on-premises data and analytical tools you rely on today to make critical business decisions, rapidly and accurately. We will also highlight some of the main features that combine your on-premises BI with the cloud during the demonstrations. The first round of adopters of BI in the cloud will have two major focus areas, the first being the usage of cloud services to create BI for a current cloud based application and the latter being an extension of on-premise data from either transactional or dimensional data. The two areas will be covered extensively to highlight ways this can be done and also show you the many ways to do each highlighting which path best suites your organization’s needs.

SessionID: 891

Enterprise Class Analysis Services Development

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSAS/MDX - Track: Business Intelligence

Speaker(s): David Darden

Title: Enterprise Class Analysis Services Development

Description:

SSAS is one of the most popular tools for OLAP, but many organizations experience challenges when attempting to use their standard development best practices with the tool. This session will cover many topics around enterprise development practices for SSAS, including how to effectively use source control with multiple developers, enable robust automated build/deployment strategies, implement usage monitoring and tracking solutions, and support unit testing for SSAS solutions.

SessionID: 889

SSIS Configurations, Expressions and Constraints

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Eric Wisdahl

Title: SSIS Configurations, Expressions and Constraints

Description:

This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. With a greater knowledge of these skills the developer will be in a better position to ensure that packages can be promoted across environments without modification, to use the control flow engine to conditionally execute tasks and to dynamically set object properties.

SessionID: 894

A PowerShell Cookbook for DBAs

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Trevor Barkhouse

Title: A PowerShell Cookbook for DBAs

Description:

This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008/2008 R2. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.

SessionID: 897

Deploying Visual Studio 2010 Database Projects

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Kevin Goode

Title: Deploying Visual Studio 2010 Database Projects

Description:

Declarative database development has made great strides forward with the Visual Studio 2010 data tools allowing developers to focus on the model instead of the implementation. But once you have the model, what are the options for deployment and what if your solution doesn’t match the Books Online example? The session will demonstrate multiple ways to deploy database projects using TFS Build, MSBuild, VSDBCMD, Powershell and more. For each deployment method, automation and customization techniques will be examined and demonstrated (including the common requirement of deploying one model to multiple targets.) Attendees will leave with a better understanding of database deployment options when using Visual Studio 2010

SessionID: 896

Entity Framework for the DB Administrator

Back to calendar

Event Date: 11-05-2011 00:00 - Category: .NET - Track: Development

Speaker(s): Jonathan Aneja

Title: Entity Framework for the DB Administrator

Description:

ADO.NET Entity Framework 4 (EF4) is Microsoft’s recommended data access layer for new applications. EF4 can be used to perform CRUD operations with very expressive query capabilities. After a brief overview of EF4 use from a developer perspective we will discuss how the Entity Framework can be a compliment to the general concerns that Database Administrators express. In particular this talk will investigate how the Entity Framework enables developers and DBAs to agree on a conceptual model that acts as a shared contract, providing DBAs control over their database and the entry points into the system that developers utilize by using the Entity Framework’s mapping technology and related features. We will then look at EF query performance including dynamic SQL generation, stored procedure use, and views and will outline recommendations for how to use each with EF.

SessionID: 895

Quantitative Analysis of SQL Server Error Logs

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Trevor Barkhouse

Title: Quantitative Analysis of SQL Server Error Logs

Description:

The SQL Server error log is essential for administering SQL Server, especially when troubleshooting. Unfortunately the error log has existed in its current form, a flat text file, for at least seventeen years. Parameters are combined with message templates and the resulting strings are written to the log file. These entries are useful for review by administrators, but are not suitable for automatic processing (categorization, summarization, or trending). Regular expressions enable extraction of data from the logs; however most administrators do not think the benefit is worth the effort. A newly developed, open-source tool (a PowerShell module), lets you decompose error log contents into each entry's message ID and a delimited list of message parameters. In this atomic state, you can perform quantitative analysis of the error log data. I will demonstrate the PowerShell Cmdlets, analyze data in the new format, and then discuss the algorithm for decomposing error log entries.

SessionID: 917

SQL 201: Stored Procedures, Functions, and Triggers

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Fundamentals - Track: Development

Speaker(s): Arnie Rowland

Title: SQL 201: Stored Procedures, Functions, and Triggers

Description:

Arnie will demonstrate how to create rock solid and efficient T-SQL stored procedures, functions, and triggers. He will demonstrate the ‘best’ way to handle input and output parameters, how to deal with return parameters, how to make sure that errors are properly handled. Sometimes overlooked, yet simple coding can make the difference between ‘mostly OK’ and ‘without a doubt’ confidence levels in your SQL code objects. Just one tip from this packed session will make your PASS SQL Rally experience worthwhile. Don’t miss it!

SessionID: 916

Ramp-Up Your Presentations!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Arnie Rowland

Title: Ramp-Up Your Presentations!

Description:

Whether you are presenting a project status report to a small group of co-workers, a technical presentation to a user group, or even your debut presentation to the PASS Community Summit or other large conference, you feel your voice cracking or your knees shaking -because your confidence is just not quite supporting you. Learn how to get and keep the audience's attention. Hear proven methods for keeping the presentation, and the audience, on topic, and engaged. Arnie will discuss how to get and stay organized, how to understand and engage the audience, how to present yourself naturally, how to communicate your passion about the topic, and how to succeed as an outstanding presenter. Come prepared to be invigorated, ready to take on new insights, and leave enthused and ready to present!

SessionID: 915

Building SQL 2008 BI to Manage Enterprise Multi-Platform Server Capacities

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: Business Intelligence

Speaker(s): Joshua Jin

Title: Building SQL 2008 BI to Manage Enterprise Multi-Platform Server Capacities

Description:

At Intel IT, one of challenges is to manage and report virtual servers performance and capacities by application and by organizations. We will explain how we overcome this challenge by utilizing SQL Server 2008 BI capabilities. In this case study session, we will share how to make ETL system scalable, how we deployed a 3-Terabyte data warehouse on a VM. We will cover how we use BI performance data to report overall and detailed capacities in our virtualization environment; also how we use the BI data to manage Virtual Machines to achieve optimal performance in production.

SessionID: 919

Planning and Deploying Failover Clustering for SQL Server 2008 and Denali

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Allan Hirt

Title: Planning and Deploying Failover Clustering for SQL Server 2008 and Denali

Description:

Failover clustering is one of the most popular options to make SQL Server available in environments both large and small. However, clustering is something that must be properly planned and has many aspects to consider. This session will demystify what you need to do to have rock solid cluster deployments using Windows Server 2008 and Windows Server 2008 R2 for SQL Server, including how clustering will need to be thought about for the upcoming Denali release. Also discussed will be the top tips for deploying and administering a clustered SQL Server failover clustering instance.

SessionID: 1297

SQL Server Query Performance Tuning: Start to Finish

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Peformance - Track: DBA

Speaker(s): Grant Fritchey

Title: SQL Server Query Performance Tuning: Start to Finish

Description:

One of the most common problems encountered in SQL Server is the slow running query. Once a query is identified as running poorly, people frequently don’t understand how diagnose and fix the problem. This one day seminar focuses exclusively on these two topics, identifying the queries that are performing badly and figuring out how to fix them. We start by learning how to gather performance metrics including both server metrics and query metrics using tools available directly from Microsoft such as performance monitor, DMVs and Profiler. From there we’ll move into learning how the optimizer works and how it uses statistics to determine which indexes and other database objects can be used to assist the performance of a query. The session takes considerable time to show exactly how to generate and read execution plans, the one best mechanism for observing how the optimizer works. We’ll then look at other DMVs that can also assist you when performance tuning queries. With all this knowledge gathered, we’ll move into looking at common performance problems, how they evidence themselves in the metrics and execution plans, and how to address them. Finally, we’ll explore advanced methods for solving some of the more difficult query performance problems introducing such concepts as query hints, plan guides and plan forcing. Through all of this, best practices and common techniques will be reviewed. Attendees will go home with a working knowledge of query performance tuning, a set of methods for identifying poorly performing queries, scripts to assist in these processes and the knowledge of how fix performance problems in their own systems.

SessionID: 921

dba 101 test

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Allen Kinsel

Title: dba 101 test

Description:

SessionID: 920

Clustering, Database Mirroring, Log Shipping, Replication, and HADRON: Oh My!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Allan Hirt

Title: Clustering, Database Mirroring, Log Shipping, Replication, and HADRON: Oh My!

Description:

Are you confused by the buffet of options available to you now or that soon will be available to you in Denali for making your instances and databases available? There are many built-in features such as failover clustering, replication, database mirroring, log shipping, and soon, HADRON. This session will compare and contrast all of them in a practical way so you can think about how and where you would use them. MOre importantly, this session will cover what it takes to truly have mission critical SQL Server deployments. Also discussed will be the non-SQL Server options for making instances and databases highly available.

SessionID: 910

What To Do When It All Goes So Wrong

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): David Levy

Title: What To Do When It All Goes So Wrong

Description:

As IT Professionals we inevitably will see situations where everything goes wrong. At times we are somewhat lucky and this just means diminished functionality or a slow system. Other times our organization is temporarily out of business. Regardless of the scope of the issue, how we react can have a direct impact on how quickly things are returned to normal. This session will cover how to communicate issues, including what to say, who to say it to and when to say it. Part of managing communication is to get everyone into a room, forcing them to talk, so time will be spent on designing an effective war room. The session will also cover how by setting out to prove that an issue is ours we are able to more quickly get at a root cause and a solid solution to the problem at hand.

SessionID: 909

PowerShell 2.0 Beyond the Dirty Dozen

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Aaron Nelson

Title: PowerShell 2.0 Beyond the Dirty Dozen

Description:

Now that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment.

SessionID: 908

The Dirty Dozen: PowerShell Scripts for the Busy DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Aaron Nelson

Title: The Dirty Dozen: PowerShell Scripts for the Busy DBA

Description:

For DBAs PowerShell provides a simple but powerful way to automate everyday tasks. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space, Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 911

The Data Mining Lifecycle

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Mining - Track: Business Intelligence

Speaker(s): Carlos Bossy

Title: The Data Mining Lifecycle

Description:

Modern day computing power and SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services by going through a live demo of the data mining lifecycle and to incorporate these complex algorithms seamlessly into your databases. Attendees will be shown how to create, train, test and deploy a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample web application that seamlessly uses a mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications...and learn how to win your fantasy football league and beat the stock market too!

SessionID: 914

Overview of SQL 2005 Service Broker

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: DBA

Speaker(s): Said Salomon

Title: Overview of SQL 2005 Service Broker

Description:

This session will be a basic review of SQL 2005 Service Broker. It will explain what SQL 2005 Service Broker is, and how can it be used. The presentation will include a number example applications and demos of basic SQL 2005 Service Broker.

SessionID: 913

Real-time Data Integration

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Carlos Bossy

Title: Real-time Data Integration

Description:

This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Use SQL Server features such as Replication, Change Data Capture, and SSIS to extract, transform and load data fast and dependably and view a real demonstration of the system in action.

SessionID: 912

Data Encryption and Key Management in SQL

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Security - Track: DBA

Speaker(s): Said Salomon

Title: Data Encryption and Key Management in SQL

Description:

Overview of data encryptions and key management that is build into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.

SessionID: 888

Achieving Real-time BI in a Heterogeneous Environment Using CDC Technology & Microsoft SSIS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Doug Wheaton

Title: Achieving Real-time BI in a Heterogeneous Environment Using CDC Technology & Microsoft SSIS

Description:

This session will focus on the various options for using Change Data Capture (CDC) and Microsoft SSIS to achieve real-time business intelligence efficiently and cost-effectively. Participants will learn how to enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), when working with heterogeneous source data from Oracle, DB2 and others. Additionally, this session will cover considerations for leveraging CDC technologies integrated with the Microsoft BI platform to enable data replication. Use cases highlighting real-time data warehousing and successful BI, MDM, and operational reporting initiatives will also be outlined. Doug Wheaton is a CDC expert and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences, SQL Saturdays and user groups throughout the US on the topics of BI and data integration using Microsoft SSIS.

SessionID: 868

Sun Tzu and the Art of Software Development

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Design - Track: Development

Speaker(s): David Moutray

Title: Sun Tzu and the Art of Software Development

Description:

Most software development projects fail. They are either cancelled outright, vastly exceed their allotted budgets or are considered failures by the hapless end-users that are stuck with applications that have more bugs than a Roach Motel, run slowly and lock if more than two users try to use the same function at the same time. Developing good software on budget and on time is a battle. Sun Tzu on the Art of War, an ancient Chinese treatise on military strategy is required reading in the United States and around the world for military officers, business executives, attorneys and many others. Readers from all walks of life have found key advice in its pages on leadership and overcoming life's challenges. War may seem an odd metaphor for software development, but it is apt in at least two key respects: The first is simply the difficulty of the basic problem. Carl von Clausewitz famously said that "In war, everything is very simple, but even the simplest things are very hard, because the will is directed against an object which reacts." Software development has its own version of this: the Wicked Problem. A Wicked Problem is a problem which cannot be solved until you have tried and failed at least once. This is because you do not properly understand the problem when you first attack it. Software development is filled with Wicked Problems. Wicked Problems are the reason that estimating software development schedules is so difficult. The second key similarity between war and software development is a four-letter word: T-E-A-M. With all due respect to the US Army, there is no such thing as an "Army of One". An army is a large team of people working to achieve a common goal under difficult, dangerous and arduous conditions. Likewise, all but the most insignificant software is developed by teams. Maintaining motivation, morale and focus during a long and difficult software development project is crucial to success. During this session we will explore examples not only from the history of war, but also politics, business and even culture to illustrate the intimate connection between war and all human endeavor. A great 19th century general said it best, "Strategy is more than a science: it is the application of knowledge to practical life, the development of thought capable of modifying the original guiding idea in the light of ever-changing situations; it is the art of acting under the pressure of the most difficult conditions."

SessionID: 867

Troubleshooting Performance Problems by Reading the Waits

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Eddie Wuerch

Title: Troubleshooting Performance Problems by Reading the Waits

Description:

Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Session includes all scripts to get started, plus an overview of the most common wait types and ways to resolve the problems they indicate. Stop guessing, start knowing!

SessionID: 866

Database "Insecurity"

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Design - Track: Development

Speaker(s): David Moutray

Title: Database "Insecurity"

Description:

Although we have had terrific tools for implementing fine-grained security since SQL 2005, database security remains one of the most neglected areas of database development. Database security is left to the Network Administrator and System Administrator, yet over 500,000 personal records have been breeched in the United States alone just in the past few years. Clearly, we as database professionals need to do our part, too. It is also not enough to leave security to the Database Administrator. Like Data Integrity, data security is difficult (if not impossible) to retrofit into an application after development. (Question: Why is the average database administrator paid 25% more than the average database developer? I'll talk about that.) Database security, like Data Integrity or Data Access Performance, must be a design goal if we are to achieve it. This session is intended to get the participant to think about security from a design perspective and to illustrate some basic strategies for implementing security at the database level.

SessionID: 870

SQL Tricks

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): A. P. Ward Pond

Title: SQL Tricks

Description:

A number of T-SQL coding tricks for improved performance are discussed, and demonstrations of each are provided.

SessionID: 873

Intermediate SSIS Development

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Kyle Walker

Title: Intermediate SSIS Development

Description:

In this presentation, Kyle and Patrick will dig a little deeper into SSIS, and explore some intermediate level developing methods, including package configurations, using the expression language within SSIS, as well as go over the commonly overlooked tool, Checkpoints, that can save the developer from having to do restart a time consuming package from the beginning. For each topic, we’ll begin with how the feature works, and then move into the steps one would take to set up Configurations, Expressions, and Checkpoints in a package. You will also see a demonstration of each feature in action from start to finish.

SessionID: 872

Set-Based Thinking for the T-SQL Developer

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Fundamentals - Track: Development

Speaker(s): A. P. Ward Pond

Title: Set-Based Thinking for the T-SQL Developer

Description:

This is an interactive “chalk talk” session. I intend to lead with a brief discussion of the differences between set-based and procedural code, and then show and discuss three “before and after” examples. The first example concerns finding all of the prime numbers less than one million. A trivial exercise, but there are a sufficient number of ways to do it, with dramatically different results, that the techniques applied are very interesting. We’ll start with a script that takes 36 hours to complete, and end with one that takes three seconds. The second example involves extracting data from multiple levels of an XML document in a single statement. “Parent axis access” works across all platforms, but has performance issues due to the query plan it generates. As of SQL Server 2005, the CROSS APPLY operator can be used to address this requirement with markedly improved performance. The final example involves making 100% reliable daylight savings time adjustments in a global scheduling system. This requirement is addressed through a data modeling approach intended to enable a specific T-SQL statement. We’ll then move on to questions and examples from the participants.

SessionID: 871

Drive SQL Server Performance: Intro to I/O For Developers

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Development

Speaker(s): Eddie Wuerch

Title: Drive SQL Server Performance: Intro to I/O For Developers

Description:

An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs. The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.

SessionID: 861

Data Visualizations in SSRS 2008 R2

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Stacia Varga

Title: Data Visualizations in SSRS 2008 R2

Description:

Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.

SessionID: 860

Automating Execution Plan Analysis

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Joe Chang

Title: Automating Execution Plan Analysis

Description:

The execution plans contain a wealth of details not found else where, including specific index usage and improperly formed search arguments. Critical tables often have an excessive number of indexes. Some are outright not used, but others are infrequently used. It should be possible to consolidate indexes with similar keys, and others can be dropped. But which SQL would be impacted? By analyzing all execution plans, it is possible to determine where infrequently used indexes are referenced. And this is practical only with automation.

SessionID: 859

Query Optimizer Cost Formulas

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Joe Chang

Title: Query Optimizer Cost Formulas

Description:

There are many SQL Server experts, yet very few can say exactly when the execution plan changes from an index seek with key lookup to a table scan. Several best practice writers have suggested this might occur when index selectivity is a few percent of the total number of rows. The Query Optimizer cost formulas determine the actual cross over point in terms of the number of rows relative to the number of leaf level pages, which no one else has suggested as the true determinant. Understanding the plan cost formulas also allows a better understanding of parallel execution plans, for which plan cost is a poor model for parallel plan scaling. The current SQL Server cost based optimizer has no useful capability to determine when to limit the degree of parallelism, so this strategy must be set manually.

SessionID: 862

Advanced TSQL Solutions

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Kevin Boles

Title: Advanced TSQL Solutions

Description:

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

SessionID: 865

Are you sure that your network isnt causing SQL Server slowdowns?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Brett Hawton

Title: Are you sure that your network isnt causing SQL Server slowdowns?

Description:

Network latency and queues are often overlooked by the DBA when trying to determine performance problems with their SQL Servers. This session shows DBA's how to accurately gauge the network performance and demanands being made by SQL Server as the typical OS performance counters and wait stats don't always show the whole picture. The session then goes on to show a DBA how network performance problems can be relatively inexpensively corrected or mitigated.

SessionID: 864

A Checklist for Reporting Services Security

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Stacia Varga

Title: A Checklist for Reporting Services Security

Description:

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

SessionID: 863

How to maximize SAN Performance in real-world SQL Server situations

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Brett Hawton

Title: How to maximize SAN Performance in real-world SQL Server situations

Description:

In this session DBA's and administrators are shown precisely how to measure the real-world performance of the SAN as it handles SQL Server's IO requests. The overload points (in terms of IO/s) are clearly identified. Then the session takes these scenarios and overload points and describes for each scenario how to re-configure in order to relieve the situation, thereby improving overall performance.

SessionID: 883

Performance Proof! Parallel Query Processing on Microsoft SQL Server 2008 R2

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Kevin Kline

Title: Performance Proof! Parallel Query Processing on Microsoft SQL Server 2008 R2

Description:

The Query Optimizer in SQL Server 2008 R2 is a finely tuned machine that enables applications to quickly process and retrieve data. A key element of query processing speed is delivered by parallel query processing by exploiting the modern multicore hardware accessing large amounts of data. But not every workload is able to fully exploit the promise of parallelized queries. But how do you know when parallel queries give the most bang for the buck? In this session, you learn the answer to this question and many more including the use of high-end TPC scalability tests on applications supporting up to 2,000 concurrent users. Here’s what you’ll learn in this session: • Goal 1: Understand how query processing, in general, and parallel query processing in particular work within SQL Server 2008 R2 • Goal 2: Identify the most common parallel query performance problems, as revealed by high-end TPC scalability tests supporting up to 2,000 concurrent users. • Goal 3: Discover work-arounds that enable you to fully exploit parallel query processing for the most commonly occurring problems.

SessionID: 882

Performance Proof! Database Compression on Microsoft SQL Server 2008 R2

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Kevin Kline

Title: Performance Proof! Database Compression on Microsoft SQL Server 2008 R2

Description:

Database compression technologies in SQL Server 2008 R2 enable you to store more data within an active database in less space. But did you know database compression can also enable your applications to run faster? This session will teach you all about planning and implementing database compression. Not only that, we’ll take you through high-end scalability tests using the TPC benchmarks to show you the actual impact that database compression has on database performance with up to 2,000 concurrent users! Here’s what you’ll learn in this session: • Goal 1: Learn how to plan, prepare for, and implement database compression on your SQL Servers. • Goal 2: Learn the GUI and Transact-SQL commands, through live demos, that implement database compression. • Goal 3: Learn about the performance impact of database compression, where it is most and least helpful for performance through high-end TPC scalability tests of up to 2,000 concurrent users.

SessionID: 881

Predixion PMML Connexion™

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Analytics - Track: Business Intelligence

Speaker(s): Eugene Asahara

Title: Predixion PMML Connexion™

Description:

Although the OLAP side of Analysis Services is #1, the Data Mining side is not. There are many entrenched players particularly in the predictive analytics realm, SAS and IBM (with Cognos and SPSS) being the best examples. "R" may be dominant in a few years as it has captured the minds of today's academics. Predictive Analytics practitioners on the Microsoft BI Stack will very likely need to work with existing systems built on those platforms as well as analysts preferring those platforms. The problem is that these platforms require extensive training. That is, compared to Predixion Software’s predictive analytics offerings which include products for modeling, deploying, and querying. However, because developing a predictive analytics system can still be an intense endeavor even with tools that are easier to use, the ability to integrate existing models in a system based on the Microsoft BI Stack is crucial. Predictive Analytics consultants can take advantage of Predixion Software’s offerings and include existing models built on other platforms within the Microsoft BI stack using Predixion PMML Connexion™, Predixion PMML integration layer. PMML (Predictive Model Markup Language) is the XML markup language used as the standard for sharing data mining and predictive analytics models between various platforms and visualization tools.

SessionID: 884

Recruiting, Retaining & Advancing Women in Technology: Why does it matter?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Wendy Pastrick

Title: Recruiting, Retaining & Advancing Women in Technology: Why does it matter?

Description:

Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s bottom line? What does it mean for women and their families when they have access to hi-tech jobs?

SessionID: 887

Bridging Predictive Analytics and Performance Management

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Analytics - Track: Business Intelligence

Speaker(s): Eugene Asahara

Title: Bridging Predictive Analytics and Performance Management

Description:

Performance Management (PM) can take a quantum step forward in terms of value to an enterprise by applying a heavy dose of Predictive Analytics (PA) to the seemingly secondary PM object known as the Strategy Map. After a few years of PerformancePoint Server 2007 (PPS 2007), most information workers are now well familiar with PM concepts such as KPIs, Scorecards and Dashboards. The object of primary focus in PPS 2007 was the Scorecard which points out what needs attention. This is of great value since recognizing that there is a problem is half the battle. However, it doesn’t do much in assisting with a diagnosis or a treatment, which is the other half of the battle. Further development of the Strategy Map can be instrumental in advancing the capabilities of PM in assisting in the diagnosis and treatment for business problems. It is currently usually implemented as an alternate view of a scorecard, displaying the KPIs in a high-level cause and effect web of relationships. But if we expand upon the Strategy Map and drill deeper into how changes in one KPI affects other KPIs, the compelling world of assisting in diagnosis and treatment is opened. The problem we then run into is that mapping cause and effect to significant depths is a daunting task to say the least. However, Predictive Analytics can play a crucial role in easing the task by assisting with the discovery of cause and effect, validation of long-held assumptions, the automatic adjustment of the weights of the "rules", and provide a good guess of a cause’s effect in lieu of more precise information. The real-life complexities of an enterprise means that nothing is certain, rendering Strategy Maps alone appearing to be rather naive and at times almost worthless. The probabilistic "best guesses" provided by PA smooths out the brittleness of the theories espoused by the Strategy Map. The bridging of PM and PA will result in a magnitude of increased value for PM and an explosion of the number of "species" of data mining models for PA. Further discussion of these notions can be found in my blog titled, Bridging Predictive Analytics and Performance Management: http://softcodedlogic.spaces.live.com/blog/cns!16E8F49BF3B4CF07!172.entry

SessionID: 886

Special Topics in SQL Server Monitoring

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Edward Stangler

Title: Special Topics in SQL Server Monitoring

Description:

This session will cover special difficult topics in monitoring Microsoft SQL Server. Using the Dynamic Management (DM) views and functions, as well as legacy DBCC commands and perfmon, we will discuss how to get at these metrics, with textual and graphical views to illustrate. Specific topics include: how to find the owner of a temp table, breakdown of tempdb space usage, speeding up measuring space usage of one thousand databases in an instance, watching multiple instances compete for CPU and memory resources on the same box, identifying idle SQLOS threads, timed event monitoring, and more.

SessionID: 885

Building a visual vocabulary

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Analytics - Track: Business Intelligence

Speaker(s):

Title: Building a visual vocabulary

Description:

Data visualization is a hot topic. In this session we will cover two of the most common data visualization patterns - time series and Part to Whole analysis. We will discuss how to identify them, common problems, best practices and what visualizations work best for each.

SessionID: 876

Enterprise Text Mining with Analysis Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Mining - Track: Business Intelligence

Speaker(s): Mark Tabladillo

Title: Enterprise Text Mining with Analysis Services

Description:

In this session we will look at text mining tools for document classification with Integration Services and DMX (Data Mining Extensions). Based on the speaker’s experience with several enterprise text mining projects, we will walk through a demo of Integration Services and Analysis Services aiding in document classification. Finally we will evaluate where Microsoft text mining can help you in a practical business environment, which may include Oracle and SAS.

SessionID: 875

Baselines first, troubleshooting second

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Erin Stellato

Title: Baselines first, troubleshooting second

Description:

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs

SessionID: 874

Currency Conversion (and More) in Analysis Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSAS/MDX - Track: Business Intelligence

Speaker(s): Christian Wade

Title: Currency Conversion (and More) in Analysis Services

Description:

Want to learn more about Analysis Services and MDX? This session covers numerous features in Analysis Services (2005 to 2008 R2) including dimension/cube design, measure expressions, MDX scripting and the Business Intelligence Wizard. It is all tied together to discuss and apply the options available for currency conversion. Leave the session understanding some of the nuances of Analysis Services to get the most out of your OLAP implementation.

SessionID: 877

Generating SSIS Packages

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): André Kamman

Title: Generating SSIS Packages

Description:

I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward. The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into. After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc. This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)

SessionID: 880

SQL Azure - Seeing your data through the Cloud

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Azure\Cloud - Track: Development

Speaker(s): Wendy Pastrick

Title: SQL Azure - Seeing your data through the Cloud

Description:

SQL Azure is still new on the scene and promises a variety of features, yet many are apprehensive to consider it. Why would you want to move data to the Cloud? We will take a look at what being in The Cloud really means and why taking advantage of some of the features could save your company money and make your adminstrator's lives a little easier. Learn about where your data is stored, how you interact with it and taking advantage of some flexibility features.

SessionID: 879

Business Intelligence dashboards with MS Excel, Excel OLAP formulas, and Share Point

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Phillip E Rosen

Title: Business Intelligence dashboards with MS Excel, Excel OLAP formulas, and Share Point

Description:

I will demonstrate how to develop MS Excel BI Dashboards in the following ways: 1. Workbook style with Office data connections stored on local PC or networked document drive, 2. excel services style using Reports Library SP 2007 for storage of the Office data connections & workbook that excel services will render, 3. Convert excel pivot table into excel OLAP formulas, 4. Discuss SP 2010 BI Center, 5. Discuss references to cap off session.

SessionID: 878

Enterprise Data Mining for SQL Server Professionals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Mining - Track: Business Intelligence

Speaker(s): Mark Tabladillo

Title: Enterprise Data Mining for SQL Server Professionals

Description:

This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell.  The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.

SessionID: 702

Performance Tuning Analysis Services

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSAS/MDX - Track: Business Intelligence

Speaker(s): Devin Knight

Title: Performance Tuning Analysis Services

Description:

In this session, you will learn how to split your measure group data in to more manageable pieces using partitions. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time. Lastly, Devin will walk you through other alternatives for Performance Tuning like Cache Warming and better cube design.

SessionID: 701

Loading a Data Warehouse in SSIS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Devin Knight

Title: Loading a Data Warehouse in SSIS

Description:

In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). Devin will first cover the terminology to be expected when creating and loading a data warehouse. Then, you’ll learn the benefits and pitfalls of using the Slowly Changing Dimension transform (SCD Wizard) in SSIS and some alternatives to speeding up the load. Lastly, he’ll cover how to load the fact table.

SessionID: 700

(NOLOCK) FOR YESFUN: Games with Isolation Levels

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): Kendra Little

Title: (NOLOCK) FOR YESFUN: Games with Isolation Levels

Description:

Understanding transaction isolation levels is critical for developing concurrent software. Unfortunately most of us learn about transaction isolation early in our careers and don't maintain an in-depth knowledge of different isolation levels. This talk will help! We'll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on.

SessionID: 704

Automate Policy-Based Management using PowerShell

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Allen White

Title: Automate Policy-Based Management using PowerShell

Description:

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

SessionID: 707

Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Brad McGehee

Title: Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less

Description:

While most DBAs know how to perform backups, restoring an entire SQL Server instance under the pressure of having to get the server up and running as soon as possible, is often another story. In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance. By learning how to perform a quick server restore, not only will your manager and users be happier, you will feel a lot less stress when you are under the gun. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use the BACKUP and RESTORE commands. This session is most appropriate for DBAs who manage databases less than 100GB in size.

SessionID: 706

Database Maintenance Essentials

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Brad McGehee

Title: Database Maintenance Essentials

Description:

Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance and reduce up time. In this session, you will learn the key things all DBAs need to know in order to help them maintain their databases at peak performance. As such, this session is targeted towards those who have less than one year’s experience as a SQL Server DBA. In this session you will learn about: Physical File Fragmentation; Database and Log File Management; tempdb Maintenance, msdb Maintenance; Index Maintenance; Statistics Maintenance; Data Corruption Detection; Database and Log File Protection; and Database Maintenance Monitoring. Because of time considerations, and the amount of content to be covered, the focus will be on explaining what needs to be done, not how to perform each task. By learning the best practices suggested in this session, DBAs will be able to go back to their organizations and begin to immediately implement them.

SessionID: 705

Let Service Broker Help You Scale Your Application

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Allen White

Title: Let Service Broker Help You Scale Your Application

Description:

Service Broker was introduced in SQL Server 2005 to provide asynchronous messaging in your database applications, but it's seldom used because it isn't well understood. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.

SessionID: 695

(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matching) Advanced Implementations

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Ira Warren

Title: (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Matching) Advanced Implementations

Description:

We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms. For this post, we will focus on the pragmatic steps required to accomplish identifying the relationships between records, and address how these steps fit into an overall data governance and data quality of MDM architecture. We will review real world implementations of several hundred million records. The steps required are shown here in a basic diagram: The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined. We will then implement this approach in TSQL and SSIS as well as explore the use of Fuzzy Matching in MDS.

SessionID: 694

Creating a Metadata Mart with SSIS - Data Governance , Data Profiling & Code Generation

Back to calendar

Event Date: 11-05-2011 00:00 - Category: ETL\BI - Track: Development

Speaker(s): Ira Warren

Title: Creating a Metadata Mart with SSIS - Data Governance , Data Profiling & Code Generation

Description:

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture, via SSIS, that rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required vs manual coding. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts. After implementation the application can be maintained via the tables and automatically regenerated, providing a pro active or self healing application architecture to respond to changes in incoming source files or target changes.

SessionID: 693

Zero to Analytics - PowerPivot, PerformancePoint and Excel Svcs

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Adam Jorgensen

Title: Zero to Analytics - PowerPivot, PerformancePoint and Excel Svcs

Description:

This all demo session will cover PowerPivot in Excel and SharePoint, PerformancePoint Dashboard development and Excel services. This session will build an analytcs solution covering all major user groups in your organization with PLENTY of audience participation. It's a great session with more than 90% live demo walkthrough content.

SessionID: 696

SQL Audit

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): David Dye

Title: SQL Audit

Description:

SQL Audit provides the ability to track and log activities and changes at the instance or database level. Built upon extended events SQL audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL audit can only be matched by means of using a SQL profiler trace, but provides reduced overhead and better performance. This presentation will provide insight into the internals of SQL audit, along with how to plan, create, and monitor instance and database level audits. Demonstrations of creating and monitoring audits will be provided using t-sql and SQL server management studio.

SessionID: 699

Big and Tall: When to Partition

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Indexing & Partitioning - Track: DBA

Speaker(s): Kendra Little

Title: Big and Tall: When to Partition

Description:

Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand benefits and impacts of the feature to evaluate where it will be useful. This session will cover basic concepts of table partitioning. We'll discuss where the feature should be applied and required changes to schema. Special considerations for management of partitioned tables will be discussed, as well as required changes to application queries. Enhancements in SQL 2008 and later versions will be included.

SessionID: 698

Refactoring SQL

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Jeremiah Peschka

Title: Refactoring SQL

Description:

Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.

SessionID: 697

Fundamentals of SQL Server Internals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: DBA

Speaker(s): Jeremiah Peschka

Title: Fundamentals of SQL Server Internals

Description:

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.

SessionID: 717

Taming Database version control and deployments

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Source\Version Control - Track: Development

Speaker(s): Scott Weinstein

Title: Taming Database version control and deployments

Description:

* Why version control * Why are databases hard to version control? * Issues w/ T-SQL * Issues w/ managing schema changes * An approach & demo * Deployments * CI * Issues * Code review

SessionID: 716

Near Real-Time Data Warehouse

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Data Warehousing - Track: Business Intelligence

Speaker(s): Patrick LeBlanc

Title: Near Real-Time Data Warehouse

Description:

Traditionally data warehouses are built, monthly, weekly, and sometimes daily. In today’s ever evolving and fast pace business environment the use of month old or even day old data is becoming less valuable. Company executives are looking for more up to date data to make faster and better business decisions. In this session Patrick LeBlanc and a co-host will explain how to build a complete Near Real-Time Data Warehouse solution using SSIS, SSAS, and SSRS. This is an interactive and demo-centric session so bring your laptop.

SessionID: 715

Unlocking the Mystery of MDX

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSAS/MDX - Track: Business Intelligence

Speaker(s): Bryan Smith

Title: Unlocking the Mystery of MDX

Description:

Despite widespread adoption of Analysis Services, the MDX query language remains a bit of an enigma. It’s not until a very simple but seldom explored concept is understood that the power and elegance of the language is revealed. Join Bryan Smith, co-author of Microsoft SQL Server 2008 MDX Step by Step, in exploring this central concept, providing a foundation for your success with the MDX language.

SessionID: 718

Delivering BI to the masses at Microsoft using CBI - Top 10 challenges

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Analytics - Track: Business Intelligence

Speaker(s): Sanjay Soni

Title: Delivering BI to the masses at Microsoft using CBI - Top 10 challenges

Description:

See a live demo of how Microsoft IT is delivering BI to the masses (30,000+ active users globally) at Microsoft using SharePoint 2010 and 2007, using Excel, PerformancePoint, SQL Server Reporting Services 2008 R2 and other Microsoft BI products. We will showcase and share technical details and best practices on how Microsoft IT has created a solution (as part of EDW strategy) to consolidate 100+ applications from 50+ business organizations in a single enterprise report catalog and a BI portal. We will also demonstrate how participants can build a solution like Microsoft CBI using a solution offering / SharePoint accelerator for external customers to create enterprise BI catalog where companies can deliver BI to the masses at their own enterprises.

SessionID: 721

Ask Why My Query So Slow?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Development

Speaker(s): Jason Wong

Title: Ask Why My Query So Slow?

Description:

Working with SQL Server for many years, I have rescued a number of organizations from degrading database performance back to outstanding production database. I often see inefficient T-SQL code execution in production databases. In this session, I will elaborate on each of the following topics in detail by presenting real-world codes, and illustrate why they are bad and what is the remedy to improve performance. Configuration: 1. RAM (Memory) 2. RAID (IO) 3. Concurrency – • Dirty Read • Phantom Read • Non-repeatable Read • Select blocking update • Update blocking select Code: 1. inline function and expression 2. select * 3. compiled to incorrect plan 4. recompile plan 5. union (union all) 6. missing join 7. type implicit conversion 8. unfiltered delete (truncate) 9. like operator (and execution plan and index) 10. missing, unused, redundant indexes 11. query hint 12. database version compatibility 13. locking, blocking (isolation level) 14. not in, in, exists, not exists 15. schema naming convention What you can expect to take away from this session: 1. Learn the efficient T-SQL programming. 2. Understand the intertwined server configuration and code execution, such as between query and index, between cache and IO, between isolation level and locking etc. 3. Draw best practice principles based on real world scenarios 4. Learn how to re-factor old code to improve performance 5. Leverage the SQL Server 2008 new features to solve performance issues.

SessionID: 720

SSRS Administration - Enter a BIDS Free Zone

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Sandra Mueller

Title: SSRS Administration - Enter a BIDS Free Zone

Description:

You are about to enter the BIDS Free Zone. Beware! This session is NOT about report design, spatial data, R2 new features or .NET extensions. We will explore what the ReportServer and ReportServerTempDB databases contain. By understanding their purpose we can discuss, for your company, what recovery mode each should be in and select backup strategies. Furthermore, we will talk about two other resources to backup: the ever critical encryption key and XML configuration files. Next, we'll cover the three scalability options: caching, snapshots and scaling out. There are numerous server configurations (memory thresholds, security, timeouts, etc.) that are familiar to administrators just hard to find. Some are so hidden you might not know they exist. Enter the zone and learn the hidden secrets!

SessionID: 719

Using PowerShell to simplify your ETL

Back to calendar

Event Date: 11-05-2011 00:00 - Category: ETL\BI - Track: Development

Speaker(s): Scott Weinstein

Title: Using PowerShell to simplify your ETL

Description:

* SSIS Considered Harmful - Poor example of visual programming - Poor VCS, etc * Intro to Powershell * Examples of common ETL tasks implemented in PowerShell - parallel bulk data transfer - star schema population - extract to csv - import from xls

SessionID: 710

ETL Head-to-Head: T-SQL vs. SSIS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Tim Mitchell

Title: ETL Head-to-Head: T-SQL vs. SSIS

Description:

In this session, we'll compare ETL strategies between SQL Server Integration Services and plain old T-SQL. Is one better than the other? Should I just use SSIS and skip T-SQL altogether, or vice versa? We'll address these questions and more, and will take a look at some practical examples and a few head-to-head comparisons using both tools.

SessionID: 709

Dirty Data? Clean It Up!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Tim Mitchell

Title: Dirty Data? Clean It Up!

Description:

Dirty data is everywhere, and it's headed for a database near you. Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data. Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s). In this session, we will discuss some of the high-level challenges of dealing with dirty data, along with some infrastructure-agnostic recommended practices for doing so. Further, we will dig in and get our fingernails dirty (pun intended) on some specific ways that SQL Server and SSIS can be used to cleanse incoming data.

SessionID: 708

Strategies for Working with VLDBs

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Robert Davis

Title: Strategies for Working with VLDBs

Description:

Very large databases (VLDBs) are just like regular databases, right? There's just more of them to love. Working with very large databases can be difficult and tricky at times. Everything takes longer and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to minimize your maintenance window requirements, and how to efficiently and quickly set up failover partners and replicas. Demos will include how I set up a log shipping secondary and a replica of a 2 TB database in less than half an hour.

SessionID: 711

SQL University: Lightning Talks

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Professional Development

Speaker(s): Jorge Segarra

Title: SQL University: Lightning Talks

Description:

SQL University is a blog-based project created to help folks learn SQL Server from the ground up, directly from the SQL Server experts from all around the world, all for free! In this lightning session event we'll have a collection of our professors who bring you all this great knowledge online present to you this content live! Each professor will present a max of 10 minutes on a variety of topics including administration, business intelligence, professional development and more! At the end of the talks we'll have a Q&A session so you can ask the experts directly! If you wish to get started in the vast world of SQL Server and want a quick primer on various aspects of this platform, or if you've been in the field a bit and just want to brush up on your basics come check this session out!

SessionID: 714

What Every DBA Should Know About Sharepoint 2010

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Victor Isakov

Title: What Every DBA Should Know About Sharepoint 2010

Description:

Sharepoint is becoming more ubiquitous in both the enterprise and SME market as a core business application. With Sharepoint 2010 Microsoft has re-engineered Sharepoint 2010 so as to leverage SQL Server 2008 R2's capabilities. Consequently it is more important than ever for DBAs to be cognisant of Sharepoint's architecture and how to best provision, configure and manage the SQL Server infrastructure for Sharepoint. In this session Victor Isakov (MCT, MCM, MCA) will present the Sharepoint 2010 architecture and considerations that every DBA should know, including capacity planning, performance management, configuration, disaster recovery and high availability.

SessionID: 713

Execution Plan Basics

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Thomas LeBlanc

Title: Execution Plan Basics

Description:

This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. This session will answer quertion like: What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan from the properties window and XML output?

SessionID: 712

ETL from the Trenches: Using SSIS in the Real World

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Dave Fackler

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

Description:

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

SessionID: 691

Developing a Multilevel Business Continuity Plan

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Robert Davis

Title: Developing a Multilevel Business Continuity Plan

Description:

High Availability (HA) and Disaster Recovery (DR) are often treated as distinct entities. These topics are closely related concepts that can fall under a single umbrella of Business Continuity (BC). Business Continuity is more than just being highly available or being able to recover from disaster. Business Continuity is all about keeping the business in business. This should be the end goal of a good HA/DR plan. If you simply come up with an HA/DR plan without thinking about how it will affect the business, you may end up with a lot of unhappy people if disaster strikes or availability is affected in a way that had not been anticipated. This session will guide you through the various high availability and disaster recovery options and will examine how the features compliment each other to form a comprehensive BC plan. This session is about more than just checking items on a checklist. Learn how you can set realistic business expectations for uptime and recoverability that set you up for success in the event of a disaster or unplanned downtime.

SessionID: 669

Developing Robust T-SQL for High Concurrency

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Alex Kuznetsov

Title: Developing Robust T-SQL for High Concurrency

Description:

Many T-SQL modules run correctly when we test them from single connection, but they intermittently break when they are exposed to real life concurrency in OLTP systems. You will learn common real life scenarios when concurrency breaks T-SQL code, such as selects returning incorrect results, deadlocks, lost updates, modifications blowing up with PK or UNIQUE constraint violations In each case you will learn how to develop robust T-SQL which works in those situations.

SessionID: 668

As A DBA, Where Do I Start?! - Tips to unwind the mess waiting for us

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Mike Walsh

Title: As A DBA, Where Do I Start?! - Tips to unwind the mess waiting for us

Description:

You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.

SessionID: 667

Iceberg, Dead Ahead! - Lessons from real life disasters for the database professional

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Mike Walsh

Title: Iceberg, Dead Ahead! - Lessons from real life disasters for the database professional

Description:

What does a plane crash have to do with technical skills? You might be surprised… There are many lessons to be learned from disasters and our response to them. Most accidents are caused not by a single factor, but by a series of seemingly-small missteps. It’s the same in our offices: carelessness or complacency can lead to a resume-altering disaster. Even if a freak accident occurs, training and preparation can make a difference in the outcome. In this session we’ll dig deep into some real-life disasters and see what lessons we can take back to our day jobs. We’ll explore corollaries between the news stories and those heart-pumping times when our cubes are filled with VPs and CIOs. Fasten your seatbelts as Mike Walsh takes us on a journey through the headlines in search of a healthy respect for the unexpected. We'll pick 3 or 4 of the most common disaster causing attitudes and behaviors, show real world examples of them causing disasters and then talk about what they can do to our own projects. We'll also discuss disaster mitigating attitudes and behaviors and how we can work on them in ourselves and our teams.

SessionID: 670

What's new in SQL Server 2011 ("Denali")?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Misc - Track: Development

Speaker(s): Aaron Bertrand

Title: What's new in SQL Server 2011 ("Denali")?

Description:

This presentation will cover many of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Several demos and no marketing.

SessionID: 673

Career Success in the Data Profession during Turbulent Times

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Karen Lopez

Title: Career Success in the Data Profession during Turbulent Times

Description:

A workshop on issues and ideas that today's data architects and database administrators can do to build their careers and networking skills with other data professionals. Workshop topics will include: • Demonstrating your expertise • Building a portfolio of your success stories • Getting others to sell your skills and business value • Building & extending your data skill set • 10 Steps to highlighting you and your work Attendees will have the opportunity to share their experiences with hiring others and finding jobs for themselves.

SessionID: 672

Database Design Contentious Issues

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Karen Lopez

Title: Database Design Contentious Issues

Description:

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Today's vs. Tomorrow's Requirements * Generalization vs. Specificity * Performance vs. Integrity * NoSQL in a RDBMS World * What is DBA work? Data Architect Work? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. In these sessions attendees will vote on how they stand on a range of issues, then discuss, debate, heckle and chuckle at the variety of positions and the foundations used to support them. Also, expect to get some exercise while we are at it.

SessionID: 671

Table Variables and Temporary Tables - What you Need to know!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): Wayne Sheffield

Title: Table Variables and Temporary Tables - What you Need to know!

Description:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. While there are a lot of articles on the internet about both, most are incomplete in one form or another. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?

SessionID: 658

SSIS Data Flow Buffer Breakdown

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Eric Wisdahl

Title: SSIS Data Flow Buffer Breakdown

Description:

This session will examine the different types of data flow components, execution trees, data buffers, performance metrics and logging mechanisms. In determining how the buffers are built and used, the developer will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The developer will further learn how to capture performance metrics to identifiably track these impacts. Finally, the session will take a look at the controls and effects of parallel package and parallel task execution.

SessionID: 657

AppFabric Cache and SQL Server 2008

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Development

Speaker(s): Todd Robinson

Title: AppFabric Cache and SQL Server 2008

Description:

With all the hype about NoSQL going around in the SQL community its about time we looked at a Microsoft's distributed cache-aside solution, AppFabric Cache. In this session we will briefly go over what AppFabric Cache is, what it can and cannot do, as well as some of the compelling features that make it a complimentary product to SQL Server. We will go over some real-world examples on how AppFabric Cache can co-exist with SQL Server and increase performance. In addition, we will compare the speed of the AppFabric Cache in comparison to SQL Server 2008 in both queries and inserts/updates. This chalk-talk will go more in-depth into some of the information presented in the SQLCAT Optimizing application workload & performance by leveraging AppFabric Cache along with SQL Server session.

SessionID: 655

Management Studio Tips & Tricks

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): Aaron Bertrand

Title: Management Studio Tips & Tricks

Description:

A collection of tips, tricks and gotchas revolving around the use of Management Studio for database development, administration and maintenance. Will also outline a few alternative tools, some free tools to complement, and some changes coming in SSMS in SQL Server code-name "Denali."

SessionID: 661

SQL Server 2008 Database Internals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Klaus Aschenbrenner

Title: SQL Server 2008 Database Internals

Description:

Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyze the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution. We will cover: *) Database Structure *) Fixed data types *) Variable data types *) LOB data types *) Sparse Columns

SessionID: 666

Using SQL Server Denali's Always On

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Denny Cherry

Title: Using SQL Server Denali's Always On

Description:

In this session we will look at the features which are provided with Microsoft SQL Server "Denali" as part of the "Always On" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution. Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.

SessionID: 664

Where should I be encrypting my data?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Denny Cherry

Title: Where should I be encrypting my data?

Description:

In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.

SessionID: 663

SQL Server Index Internals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Klaus Aschenbrenner

Title: SQL Server Index Internals

Description:

SQL Server provides two kinds of indexes for relational data: Clustered- and Non-Clustered Indexes. Both of them can be defined as unique and non-unique. In this session you will learn how to use Clustered- and Non-Clustered Indexes in your database and how you can improve the execution time of your queries with those indexes. Furthermore we will have a look into the concrete storage details of both indexes and how they differ when you define them as unique and non-unique and what's the tradeoff between it. Finally you will get some best practices how to deal effectively with Clustered- and Non-Clustered Indexes in your database.

SessionID: 686

EPM using SQL Server and SharePoint

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Dan Evans

Title: EPM using SQL Server and SharePoint

Description:

Learn how to develop an Enterprise Performance Management solution using SharePoint 2010 and SQL Server 2008 R2. Utilize the most recent offerings from Microsoft including PowerPivot and Reporting Services to give an integrated, scalable BI platform for those interested in deploying Microsoft solutions.

SessionID: 684

Deadlocking for Mere Mortals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Jonathan Kehayias

Title: Deadlocking for Mere Mortals

Description:

While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server 2005 and 2008, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server 2005 and 2008; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.

SessionID: 682

Using Event Notifications in SQL Server 2005/2008

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Jonathan Kehayias

Title: Using Event Notifications in SQL Server 2005/2008

Description:

Event Notifications have been a hidden gem in SQL Server 2005 and 2008, just waiting to provide you with real time information inside of events happening inside of SQL Server. This session will provide an overview of the Service Broker components used by Event Notifications and the difference between Event Notifications and other features of SQL Server like SQL Trace and DDL Triggers. You will learn how to build a monitoring solution for common problems in SQL Server like blocking and deadlocks that capture the needed information for troubleshooting in real time and provide email notification that a problem exists.

SessionID: 687

Agile BI with Microsoft Technologies

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: Business Intelligence

Speaker(s): Dan Evans

Title: Agile BI with Microsoft Technologies

Description:

Learn how to deliver BI soutions using Microsoft technoligies in an agile development approach

SessionID: 690

Navigating your way through the fog of Microsoft Certifications

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Michael Wells

Title: Navigating your way through the fog of Microsoft Certifications

Description:

Are you looking to earn a Microsoft certification, but aren't sure where to start? Join us for this session and take a guided tour through the current offerings for SQL, Development, and IT certifications. We will talk about the entry level certifications all the way through the Master and Architect levels and everything in between.

SessionID: 689

Building a truly unattended install of SQL Server using PowerShell

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Michael Wells

Title: Building a truly unattended install of SQL Server using PowerShell

Description:

Have you ever done an unattended install of SQL Server using the command line or a configuration file? How much time did you need to spend after the install getting the instance ready for your environment? Imagine if the install process could be expanded to include everything from installing SQL to applying operating system configurations like MSDTC to deploying SQL objects like sp_WhoIsActive. You could not only decrease the amount of time needed to stand up a server, but also achieve a more standardized deployment. In this session you’ll be taken on a tour through a process that was created for just this purpose. This process is currently in use in a large environment to deploy SQL 2005, 2008, and 2008R2 Servers to development, test, and production. You can see exactly how it works and how to easily customize it for your organizations needs.

SessionID: 688

TSql Techniques

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Fundamentals - Track: Development

Speaker(s): Dave Ballantyne

Title: TSql Techniques

Description:

So, you’ve got good design, got correct indexes, hell, you’ve even got good sargability. But your system is still slow. What’s the problem? The chances are your SQL Code is asking too much of your hardware. In this session, I will demonstrate why a set-based mindset is so critical to performance and some simple techniques to lower resource usage through better use of TSQL code.

SessionID: 676

Become a Bilingual DBA! Oracle for the SQL Server DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s): Randy Knight

Title: Become a Bilingual DBA! Oracle for the SQL Server DBA

Description:

In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.

SessionID: 675

Visual Studio 2010 Database Projects

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Source\Version Control - Track: Development

Speaker(s): Randy Knight

Title: Visual Studio 2010 Database Projects

Description:

Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.

SessionID: 674

3rd Normal Form: That's crazy talk!!!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Design - Track: Development

Speaker(s): Thomas LeBlanc

Title: 3rd Normal Form: That's crazy talk!!!

Description:

How did the development world conclude that an integer is the best primary key? What is 4th and 5th normal form? What has been added to SQL Server in 2005 and 2008 to help change the way database design has evolved over the years? Can we still use a VarChar(xx) for a primary key? What is the difference between a lookup and Parent/Child relationship? What is an example of a Many-To-Many relationship? This session will go through the history of 21 years of experience with various database designs – normalized and denormalized. The discussion will include the benefits and forward looking that should be required for using various design techniques. The flow will be a discussion with much attendee particaption to share sucess and pains in database development, leading to standards for all of us to take advantage of while designing databases.

SessionID: 677

SQL Azure 201 - Cloud Database Deep-Dive

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Azure\Cloud - Track: Development

Speaker(s): Scott Klein

Title: SQL Azure 201 - Cloud Database Deep-Dive

Description:

Going beyond a SQL Azure introduction, this session will show how SQL Azure can be used in real-world situations, providing real solutions for today's cloud initiatives. This session will discuss sharding and caching to enhance the cloud experience and performance. We will also look at the OData protocol as a way to consume SQL Azure data in your applications including Windows Phone 7. If time permits we will also look at the new SQL Azure reporting capabilities.

SessionID: 681

Zero To OLAP Cubes in 60 Minutes

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Business Intelligence

Speaker(s): Adam Jorgensen

Title: Zero To OLAP Cubes in 60 Minutes

Description:

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time. Let’s dive in together and learn about how SSAS and OLAP can make deliver actionable intelligence to your end users in a fraction of the time and effort of traditional reporting techniques. This all demo session will get you started and answer many questions you have about what SSAS is and what it can do for you.

SessionID: 679

SQL Server Parallel Data Warehouse - Under the Hood

Back to calendar

Event Date: 11-05-2011 00:00 - Category: New Technology - Track: Business Intelligence

Speaker(s): Brian Mitchell

Title: SQL Server Parallel Data Warehouse - Under the Hood

Description:

Parallel Data Warehouse is a complex product that is often misunderstood. This session will go deeper into PDW architecture than in previous sessions. Primarily through the use of demo's the attendee's will be exposed to the PDW service and how it interacts with multiple compute nodes to provide superior performance. The sessions reliance on demo's will allow the attendees to understand PDW in concrete terms what is usually described in abstract terms. We will spend a good deal of our time examining the tools in PDW available to the DBA to manage this complex appliance.

SessionID: 678

Azure Solutions - Using SQL Azure and Azure Storage Solutions

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Azure\Cloud - Track: Development

Speaker(s): Scott Klein

Title: Azure Solutions - Using SQL Azure and Azure Storage Solutions

Description:

This session will discuss how to use SQL Azure and the Windows Azure Storage functionality to solve today's many storage problems. We will first provide brief introductory looks at SQL Azure and Windows Azure Storage, then provide different examples of how the two can be used together to provide solutions to today's BLOB storage problems.

SessionID: 722

Top 10 SQL Server Defaults to Evaluate and Modify

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: DBA

Speaker(s): Jason Wong

Title: Top 10 SQL Server Defaults to Evaluate and Modify

Description:

In fact, SQL Server is so easy to use that in many enterprises, individual departments have installed SQL Server without involving the DBA management team. Often the DBA team is not even aware of the departmental SQL Server installation until a problem occurs that requires expertise beyond what the department can provide. --- Hilary Cotter. Working with SQL Server for many years, I have rescued a number of organizations from degrading database performance back to outstanding production database. In this session, I will discuss top 10 SQL server default settings that DBAs need to evaluate the best settings for their environment. I will elaborate how these values will impact your database operations. 1. Recovery model (default full) 2. Min - Max memory (default 0 to maximum) 3. Initial size, auto-growth ( 2MB data, 1 MB log, auto-grow: true) 4. Default Isolation Level (default Read Committed) 5. FillFactor (Index) (default 0/100) 6. Primary Key Clustered Index (PK default to Clustered Index) 7. Uniqueidentifier 8. Collation 9. Data type - nvarchar(255), the "N" 10. Allow Nulls What you can expect to take away from this session: 1. Learn the dos and don’ts in SQL Server 2. Understand the default server configuration and its impacts 3. Draw best practice principles based on real world scenarios 4. Learn the consequences if defaults are not understood, not modified 5. Best design to utilize the SQL Server new features

SessionID: 767

Unified Data Access in SharePoint 2010

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Design - Track: Development

Speaker(s): Cory Loriot

Title: Unified Data Access in SharePoint 2010

Description:

In MOSS 2007, hybrid data system access (such as combining SharePoint Lists, DBMS and web services) for web parts and application pages was complicated, to say the least. In this session, we will discuss how Business Connectivity Services, External Content Types, External Lists, and LINQ to SharePoint make SharePoint 2010 a much simpler platform for integrating internal and external data systems. We will develop a solution that integrates data from SharePoint, SQL Server and other external data systems during the demonstration.

SessionID: 766

Growing Pains - A Cautionary Tale

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Design - Track: Development

Speaker(s): Brett Tomson

Title: Growing Pains - A Cautionary Tale

Description:

It happens to everyone. One day your database is humming along quietly serving up choice nuggets of information quickly and efficiently while growing at a slow steady rate. The next day, your database has quadrupled in size and performance has ground to a halt as the system strains under the load. Management is screaming for answers and you're coworkers are running in circles screaming for their lives. In this session, we will examine how bad decisions and database design worst practices yielded an unwieldy monster that had the bravest of DBAs and database developers running for the hills. As we travel through this tale we will see how, with a little cunning and trickery, a schema change or two, the beast was tamed and the database was brought back to life. This session uses a real-world reporting system (names changed to protect the innocent) as the basis for its examples. Your mileage may vary.

SessionID: 765

Database Structures for Programmers

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Louis Davidson

Title: Database Structures for Programmers

Description:

All too often a person will complain that SQL Server isn’t up to the task of enterprise databases, and usually there are two things wrong with this statement. First, the person has a set of data that is hardly up to what SQL Server can deal with at “enterprise” level. Second they have no knowledge of how data is stored or how to manipulate the physical structures to their benefit. In this session, I will, at a reasonably high level cover most of the physical aspects of the SQL Server architecture page structures, table and index structures, files, and more, including some tips on how you can use these aspects to your advantage rather than struggling against the fundamentals of the SQL Server storage architecture.

SessionID: 768

Variables, Expressions, and XML Configs, Oh My!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSIS - Track: Business Intelligence

Speaker(s): Brandie Tarvin

Title: Variables, Expressions, and XML Configs, Oh My!

Description:

Using variables, expressions, and XML config files in SSIS shouldn't be a grand Hollywood production. In fact, it's easier than most people realize. The issue comes down to knowing the syntax and understanding how SSIS looks at these elements. Brandie will walk through the use of all three elements, demonstrating how variables can be used to control the direction of your package, how expressions can be used to reconfigure values or file names, and how XML config files can bring these elements together for a no-fuss, no-muss, multi-server environment. Bring your laptop (not required), with the Adventure Works database installed, and follow along with the fun. By the time this sessions is over, you'll be able to use all three elements with confidence, no matter what the situation.

SessionID: 771

What's New In SSRS 2008 (With Added R2 Flair)

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Brett Tomson

Title: What's New In SSRS 2008 (With Added R2 Flair)

Description:

Charts, sparklines, shared datasets, oh my! Don your hardhat and take a tour through the new and improved Reporting Services as available in SQL Server 2008 and 2008 R2. In this session, we will navigate the bounty of new features in SSRS ranging from new report controls and report parts to the treasures that await us with data visualization through mapping. From Lookup functions to rendering and distribution changes we'll try to cover it all. If time permits, a fine SSRS-based rendition of T-SQL Hangman awaits us. Be warned though, too many incorrect choices will leave our DBA hanging in the wind!

SessionID: 770

Maximizing Parallelism Performance

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Victor Isakov

Title: Maximizing Parallelism Performance

Description:

Servers with multiple processors are now the de-facto standard. SQL Server 2008 R2 supports up to 256 processors. As a DBA you need to get a handle on how parallelism works in SQL Server so as to be able to troubleshoot any performance problems and maximize your parallelism performance. In this session Victor Isakov (MCT, MCM, MCA) will cover how parallelism works in SQL Server and how to best configure your SQL Server instance(s). He will then show how you can determine whether parallelism is "hurting" your query performance and what corrective action you can take. Finally Victor will go through a number of use cases of the different types of parallelism problems that you may see in the field.

SessionID: 769

Deploying Data Tier Applications to the Cloud

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Azure\Cloud - Track: Development

Speaker(s): Joseph D'Antoni

Title: Deploying Data Tier Applications to the Cloud

Description:

Interested in quickly rolling out new applications to your local environment or to SQL Azure? This session will cover the Data Tier Application functionality that is built into SQL Server 2008 R2 and Visual Studio 2010. The session will start out with an overview of the technology, how it works and how it functions in a typical development organization. We will then go under the hood in SQL Server and take a brief look at the internals that drive both the deployment and upgrade process. Lastly, we will walk through a demonstation of building a new application in Visual Studio and deploying it to SQL Server Azure, extracting a Data Tier application from SQL, and lastly the process of an application upgrade using the technology.

SessionID: 760

Business Intelligence with SharePoint 2010 and PowerPivot

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Jen Underwood

Title: Business Intelligence with SharePoint 2010 and PowerPivot

Description:

This presentation covers SharePoint 2010 Business Intelligence technologies and new features including: - New Chart Web Part - Business Intelligence Center and PerformancePoint Dashboards - Simple KPIs and Status Lists - Visio Services Visualizations - Reporting Services and Report Builder - PowerPivot and the Management Dashboard - Business Connectivity Services (former BDC) A wide variety of live demonstrations on where to configure the features in SharePoint and how to use them will be shown. In addition, lessons learned and installation tips will also be shared.

SessionID: 759

Bend SQL to your will

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Jana Sattainathan

Title: Bend SQL to your will

Description:

Users are mostly set in their ways when it comes to querying especially if they have been doing so for a very long time. The newer querying features of SQL Server are more powerful and suprisingly simpler to get the same results. The performance of these new constructs are also superior. Specifically, the analytical functions (CTE's) Row Number, Rank, Dense Rank, Cube, NTile, Compute, With Rollup & OVER clause will be discussed with examples. The windowing functions will demoed with practical usage scenarios. In addition, other "not commonly used" aspects like recursive querying, MERGE, "Grouping Sets" of GROUP BY and other SQL features will be covered.

SessionID: 758

Partitioning in SQL Server 2005/2008

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Indexing & Partitioning - Track: DBA

Speaker(s): Jana Sattainathan

Title: Partitioning in SQL Server 2005/2008

Description:

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

SessionID: 761

The Enterprise SQL DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s): Scott Shaw

Title: The Enterprise SQL DBA

Description:

Ever wondered what it takes as a DBA to successfully navigate the political and technical world of a large database environment? What do you do your first day on the job with more than 300 SQL servers and thousands of databases to manage? This sessions tries to answer these questions and shows how to manage very large database environments (+200 SQL Servers). We'll discuss management shortcuts, maintaining complex environments, and tightening security. We'll also discuss personal development and challenges like handling customers and vendors, project management, standardization, and job advancement. Who knows, you may even find out whether or not becoming a DBA in a large corporation is a career path you want to choose.

SessionID: 764

Characteristics of a Great Relational Database

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Louis Davidson

Title: Characteristics of a Great Relational Database

Description:

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

SessionID: 763

The Modern Resume - Building Your Brand

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Professional Development

Speaker(s): Steve Jones

Title: The Modern Resume - Building Your Brand

Description:

Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.

SessionID: 762

Optimizing a Business Intelligence Solution

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: Business Intelligence

Speaker(s): Jen Underwood

Title: Optimizing a Business Intelligence Solution

Description:

This presentation covers optimizing a Microsoft business intelligence solution and the end-to-end components: SQL Server data warehouse, SSIS (Integration Services), SSRS (Reporting Services) and SSAS (Analysis Services). We will begin with running and discussing Best Practices Analyzer results. Then we will review some practical approaches for prioritizing performance issues followed by demonstrations of tuning tools for the database, ETL packages, reports and OLAP cubes. This presentation will be supplemented with downloadable scripts and resources for further review.

SessionID: 784

How to Do an Index Review

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Indexing & Partitioning - Track: DBA

Speaker(s): Michael DeFehr

Title: How to Do an Index Review

Description:

Is your server slow? What does this mean? If you haven't taken a look at the indexes in your system and whether/how they are being used, that could be part of your problem. This is an essential DBA skill and should be done periodically on all systems for which performance is a factor. This session will review the way tables and indexes are structured in SQL server, then dive into the DMVs that expose what you need to pay attention to in your system and show you some of the actions you can take to (often dramatically) improve your system's performance.

SessionID: 783

Administrator's Idol: Secure Database

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Security - Track: DBA

Speaker(s): Erdal Ozkaya

Title: Administrator's Idol: Secure Database

Description:

This session will provide you with the ability to run a network intrusion vulnerability analysis through penetration testing and then create the best possible prevention plan available. With cyber crime and attacks rising, this is the more necessary to be aware and its everyones goal to have a secure database. If you care about security than this session is right for you

SessionID: 782

The Fast Track Data Warehouse

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Data Warehousing - Track: Business Intelligence

Speaker(s): Randy Dyess

Title: The Fast Track Data Warehouse

Description:

In this session you will learn about the Microsoft Fast Track solution and what it may mean to you. Attendees will gain a better understanding of what a Fast Track solution offers and how to begin their own Fast Track installation and avoid some of the misunderstandings when it comes to Fast Track installations.

SessionID: 785

Leadership without Permission

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Hector Hernandez

Title: Leadership without Permission

Description:

Leadership is a dialectical, pro-active process wherein an individual persuades others to do something they would not otherwise do. We need to learn how to empower our skills, enhance our competence and energize our "serving leadership" power. Most people think only executives, managers, and project leads possess any leadership skills but the facts reveal another truth - the ability to lead others is held by those who know they can lead from any position. This session will ask provocative questions and provide you with a view of various leadership styles that can help you activate the leader in you. No one owns leadership,just start to lead from where you stand. Agenda: - Lead-er-ship Styles and Truths…. - Understanding how Lead-er-ship Influences Outcomes…. - Becoming a more Effective Lead-er…. - Management & Lead-er-ship…what is the difference - Lead-er-Ship Opportunities are Everywhere and No Really Owns it…. - A Formula to Consider….if you are in the Lead-er-Ship Business - Creating the Future through effective Lead-er-Ship - 10 Things Authentic Lead-ers should consider - Leading People You Can’t See - Contingency Theories of Leadership - Becoming a Trusted Advisor

SessionID: 789

Reporting Services Boot Camp

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Brian McDonald

Title: Reporting Services Boot Camp

Description:

Do you need to report your business data to users across your enterprise? Have you heard of Reporting Services, but are not sure what it has to offer? Do you have reporting services installed in your environment, but are unsure how to make use of it? All of these questions and many more will be answered in this one hour Reporting Services Boot Camp! Jammed with walked thoughs and demonstrations, this dynamite session is a SQL Saturday favorite and should not be missed. SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which provides a robust and centralized reporting platform for organizations. Using a familiar development environment we can create exciting reports that can be delivered in a variety of ways. In this level 200-300 session, I will: • Introduce and Provide an Architectural Overview of Reporting Services 2008R2 • Provide examples loaded with the awesome new features included in SSRS 2008R2 • Demonstrate how easy it is to deliver the full lifecycle of report development • Show how to deliver reports on the web, through applications and exciting other ways

SessionID: 788

The Art of Indexing

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Ken Simmons

Title: The Art of Indexing

Description:

Creating indexes can be one of the most useful performance gains you can add to your database. However, having too many indexes can hurt performance as well as require additional space and maintenance time. The introduction of Dynamic Management Views has made indexing easier; however, there are still many tactics you need to be aware of when applying indexes. This session will cover strategies such as discovering and applying missing indexes, finding and removing overlapping indexes, and identifying rarely used indexes that are expensive to maintain.

SessionID: 787

Automating Routine Maintenance

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Ken Simmons

Title: Automating Routine Maintenance

Description:

You have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.

SessionID: 774

Dashing Dashboarding

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Sandeep Khandelwal

Title: Dashing Dashboarding

Description:

SQL Server 2008 data warehousing tools are great. Complement your data warehouse by giving it a perfect partner, a presentation layer that will be loved and adopted by people at all levels. In this session you will learn on how to create interactive and live dashboards using Scorecards, Charts, KPIs, Reports and other BI tools available in SharePoint 2010. The session is geared towards Developers and Architects looking to leverage Performance Point (remember proclarity), Reporting Services, Excel Services and Visio to provide rich interactive charts and build that platform which adds value to your data warehouse.

SessionID: 773

The Dirty Dozen: 12 ways to write poorly performing MDX queries

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSAS/MDX - Track: Business Intelligence

Speaker(s): Steve Simon

Title: The Dirty Dozen: 12 ways to write poorly performing MDX queries

Description:

OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in the tough and turbulent economic times. This is certainly true within the realm of the financial and portfolio management world, which has been under the microscope for the past 18 months. This beginner’s to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and poorly performing MDX queries and how many of the queries may be optimized to ensure that they are both efficient and effective. Through a series of Before’s and After’s, the attendee will see how we have managed to improve the performance our queries and learn of some of the ‘Gotcha’s that we encountered along the way. Optimally efficient and effective MDX queries help our end users obtain the information necessary for corporate decision making. This in turn helps them ‘work smartly’ and helps the enterprise achieve its corporate goals and mission statement.

SessionID: 772

Interviewing Tips for Desperate DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Brandie Tarvin

Title: Interviewing Tips for Desperate DBA

Description:

Everyone dreads the interview. What do you say? How do you make sure you're perfect? What can you do to make yourself more memorable than the last guy, or the next girl? This session is designed to be an open discussion, giving tips and answering questions, for those out on the job hunt. Bring your fears and your concerns. You'll be shocked at how much of this you already know, but talked yourself out of remembering. Brandie offers a dash of common sense along with a few tips and tricks for surviving the phone interview, getting the face-to-face meeting, and securing the job offer. If there's time, we'll also discuss the myths of database certification, including whether certification is right for you.

SessionID: 776

SQL Server Data Mining… Making $mart financial decision$ in weak financial markets

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Mining - Track: Business Intelligence

Speaker(s): Steve Simon

Title: SQL Server Data Mining… Making $mart financial decision$ in weak financial markets

Description:

Over the past few months many financial houses have been severely ‘hit’ by the current slump in the sub prime mortgage market. This has lead to severe losses and considerable client liability. Many firms are now starting to take a ‘serious look’ at the potential utilization of data mining techniques as part of their ongoing efforts to control their risk exposure. This beginner to intermediate level hands-on presentation is aimed at showing the attendee some of the ‘data mining’ prototypes solutions that we are currently developing with SQL Server 2005 / 2008, as a part of our ongoing efforts to manage our risk.

SessionID: 781

Deadlocks: What to do about the dreaded 1205

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): Michael DeFehr

Title: Deadlocks: What to do about the dreaded 1205

Description:

Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We will start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.

SessionID: 780

Social Engineering, the art of Deception!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Security - Track: DBA

Speaker(s): Erdal Ozkaya

Title: Social Engineering, the art of Deception!

Description:

We all do like to stay out of trouble, we all like to have a secure and protected networks. We do all use tools to protect our networks, but is there any tool to protect as from the art of Deception ? We do patch our operating systems, we do upgrade our hardware’s firmware but do we got any patch for Human stupidity? This session is designed to introduce you to dangers that may come your way through Social Engineering! Just after 75 minutes you will not be the same you before the session. Yes, its good idea to protect your systems with ForeFront products but also a good idea to be aware of non-computing attacks which might affect your networks.

SessionID: 777

The BI DBA

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Administration - Track: Business Intelligence

Speaker(s): Randy Dyess

Title: The BI DBA

Description:

In this session, you will learn the difference between administering a data warehouse database or a reporting database versus a database meant for OLTP operations. This session will cover the basic administration tasks and how they can be different for DBAs working with data warehouse/reporting databases.

SessionID: 757

Create an Interactive Dashboard with SSRS

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Patrick LeBlanc

Title: Create an Interactive Dashboard with SSRS

Description:

In this session presented by Patrick LeBlanc and Chris Albrektson they will show you how to take your SSRS Dashboard to the next level. They will start off with some of the best design practices when it comes to creating dashboards. Then, we’ll show you some advanced techniques like using actions, data bars, and indicators and lastly show you how to make your Dashboard interactive. By the end of the session everyone will be able to take these newly learned tips with them in how to make your dashboard standout among the rest.

SessionID: 734

Business Intelligence: Decaffeinated Please!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Data Warehousing - Track: Business Intelligence

Speaker(s): Jose Chinchilla

Title: Business Intelligence: Decaffeinated Please!

Description:

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure. In this session attendees will learn some of the basic concepts that are key in understanding BI and DW. I will go over the need for Business Intelligence and Data Warehousing, its maturity stages, the Microsoft toolset for BI/DW and my 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started in the right direction. I will also go over some of the common challenges, pitfalls and roadblocks and how to avoid them.

SessionID: 733

Help Desk to DBA in 60-ish minutes

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s): Meredith Ryan-Smith

Title: Help Desk to DBA in 60-ish minutes

Description:

Most ‘accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.

SessionID: 732

New Reporting Features of SQL Server 2011

Back to calendar

Event Date: 11-05-2011 00:00 - Category: New Technology - Track: Business Intelligence

Speaker(s): Mike Davis

Title: New Reporting Features of SQL Server 2011

Description:

Learn the new features of Reporting Services planned for SQL Server 2011 Denali

SessionID: 735

Get Cert! Get Cred!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Jose Chinchilla

Title: Get Cert! Get Cred!

Description:

Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills. This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals. But, why and how certify? Join me to find out the opportunities you may be missing on!

SessionID: 738

Avoid Common Mistakes in T-SQL Programming

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Fundamentals - Track: Development

Speaker(s): Alex Kuznetsov

Title: Avoid Common Mistakes in T-SQL Programming

Description:

We shall consider several typical real life examples of poorly written T-SQL, see how and why it breaks, and fix them. We shall discuss some common misconceptions about SQL Server, see how our T-SQL can break because of them, and learn better alternatives.

SessionID: 737

Policy Based Management

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PBM - Track: DBA

Speaker(s): Peter Trast

Title: Policy Based Management

Description:

Maybe you were a system admin that got sucked into the exotic land of database administration because there was no one else to do it. Maybe you are a DBA on purpose. It might even be possible that one day you were writing web applications in your remote and intentionally isolated cube at the far end of the “trailer park” and faster than you can say DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS you found yourself in charge of an unwieldy, quickly expanding and barely governed SQL Server environment. In any case, you may have wondered, if there were some way to control the environment of SQL Server proactively and to have an automated way to enforce all of those naming convention standards and object settings that you TALKED about, documented and trained on. Have I got news for you! In SQL Server 2008, a new feature called Policy Based Management (PBM) was introduced. The idea is that if you have a setting or convention that you wish to check for and/or ENFORCE (get your control freak on), you just create a policy that defines the object (maybe a database), a facet (the property that can be checked for or enforced, like the recovery model of a database), and a condition (the value of the property, like Full for the recovery model). Systems Administrators recognize this concept (Group Policy in Active Directory) but the application and verification of the policy is done quite differently. See what it is and how it’s done!

SessionID: 736

Windows PowerShell Best Practices for SQL DBA's

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Ed Wilson

Title: Windows PowerShell Best Practices for SQL DBA's

Description:

Windows PowerShell Best Practices for SQL DBA’s Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.

SessionID: 725

SQL Server Service Broker – An Overview

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Misc - Track: Development

Speaker(s): Janis Griffin

Title: SQL Server Service Broker – An Overview

Description:

Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related applications and their data structures.

SessionID: 724

Database Performance Management – 2008 MDW

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Janis Griffin

Title: Database Performance Management – 2008 MDW

Description:

Management Data Warehouse (MDW) was introduced in SQL Server 2008 and can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up and use MDW. It will review the underlying schema and show examples of both canned and custom reports. It will, also, point out some of its shortcomings in comparison with other performance tools.

SessionID: 723

Writing faster queries

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Tim Chapman

Title: Writing faster queries

Description:

Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this all-demo session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 727

On Demand Subscriptions – no crystal ball required

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Pam Shaw

Title: On Demand Subscriptions – no crystal ball required

Description:

Do you have the need to email reports from SSRS – but not sure exactly when you want them to be emailed? What’s more, you don’t have an Enterprise license. No worries, we can do that. It just takes a little planning. We will explore subscriptions which are part of the scheduled delivery process defined within Reporting Services including what is required to create subscriptions. We will hten explore what options are available and how we can manipulate these for use on demand. We will review some practical applications that On Demand Subscriptions can resolve.

SessionID: 731

Using Script Task and Components in SQL Server Integration Services (SSIS)

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Advanced SSIS - Track: Business Intelligence

Speaker(s): Mike Davis

Title: Using Script Task and Components in SQL Server Integration Services (SSIS)

Description:

Mike shows you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them.

SessionID: 729

Practical Powershell for SQL Server Professional - Success Cases

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Laerte Junior

Title: Practical Powershell for SQL Server Professional - Success Cases

Description:

I will give to you 3 scenarios : • You need to Gathering Performance counters in 20 SQL Server servers with heterogeneous environments (SQL Server 2005, 2008, 2008 R2 – Windows 2003, 2008, 2008 R2) • You need to merge and filter several with SQL Server Profiler Traces with different events and columns to solve a specific problem. • You need to provide an elegant and automated solution to create a T-SQL Code Review and take off the rework in a SDLC (Software Development Life Cycle) in Team Build 2010 This session will show practical solutions applied to problems of everyday life (specifically those scenarios) that were solved using Powershell. We'll see real demos , the problem , the resolution and the code used.

SessionID: 728

Tips & Tricks for dynamic Reporting Services Reports

Back to calendar

Event Date: 11-05-2011 00:00 - Category: SSRS - Track: Business Intelligence

Speaker(s): Pam Shaw

Title: Tips & Tricks for dynamic Reporting Services Reports

Description:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

SessionID: 751

Creating and Using Pivot Tables/Cubes Using 3 Microsoft Tools

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Sharepoint/PowerPivot - Track: Business Intelligence

Speaker(s): Michael Antonovich

Title: Creating and Using Pivot Tables/Cubes Using 3 Microsoft Tools

Description:

This session begins with a simple SQL database consisting of several related tables. It begins with a simple example of using the TSQL PIVOT command using both a static and a dynamic example. It then uses the same tables with Excel together with PowerPivot to create a Pivot Table and Pivot Chart. Finally, as a third method to create Pivot Tables that users can manipulate to see different slices of data, I will demonstrate how easily you can work with those same tables to create a simple cube in Analysis Services. Finally, if time permits, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to view and use the pivot table.

SessionID: 750

Policy-Based Management in a Nutshell

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PBM - Track: DBA

Speaker(s): Jorge Segarra

Title: Policy-Based Management in a Nutshell

Description:

In this session we will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment (yes, even your non-2008 servers!). This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Servers today!

SessionID: 749

Death By UDF

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Kevin Boles

Title: Death By UDF

Description:

User Defined Functions provide several benefits that developers strive for: code encapsulation and code reuse. But they come with the likelyhood of many huge downsides: severe performance impact, concurrency issues and even incorrect results. The "cursor-under-the-covers" that improperly coded scalar UDFs can cause also don't get represented in query plans and statistics IO output either, so even developers that might use those tools will be misled. We will review the various types of badness that can come from common UDF designs, including how to properly see what is going on. Then we will cover some refactors and a few tricks that can help mitigate the issues.

SessionID: 752

So You've Inherited the "DB From Heck" (v2.0)

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Tips & Tricks - Track: Development

Speaker(s): Troy Ketsdever

Title: So You've Inherited the "DB From Heck" (v2.0)

Description:

It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations. To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system. In this updated session, we'll start with a quick look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending. After that, we'll explore some query-based methods for detecting design and implementation anomalies, and some things to consider when undertaking a project to correct such deficiencies.

SessionID: 756

Presentation WOW!

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Edwin M Sarmiento

Title: Presentation WOW!

Description:

So you open up PowerPoint, create your slides and get ready to present. Sure, you know exactly how to do this - you've done it a lot of times in the past - but there’s more. Leveraging on the experiences learned from presenting at worldwide conferences such as SQL PASS Community Summit, TechEd, DevTeach and the likes, this session will look at what needs to be considered when creating powerful presentations that shine.

SessionID: 755

DBA Disaster Recovery Techniques To Keep Handy

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Edwin M Sarmiento

Title: DBA Disaster Recovery Techniques To Keep Handy

Description:

Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery

SessionID: 753

Zero to "MERGE" in 60 minutes

Back to calendar

Event Date: 11-05-2011 00:00 - Category: TSQL Advanced - Track: Development

Speaker(s): Troy Ketsdever

Title: Zero to "MERGE" in 60 minutes

Description:

SQL Server 2008 saw the introduction of the new MERGE DML statement. In this session, we'll take a look at the basic syntax and capabilities of the command, with a focus on how it can be leveraged in your OLTP environment. Once we have reviewed some simple examples, we'll dive into some of the more advanced uses (abuses?) of the command, reinforcing our understanding by looking at more complex examples.

SessionID: 741

Peer-to-Peer Replication: Real Life Implementations and Best Practices

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: DBA

Speaker(s): Meir Dudai

Title: Peer-to-Peer Replication: Real Life Implementations and Best Practices

Description:

Many organizations require challenging scalability and high availability solutions for their database implementations. Peer-to-Peer Replication is one of the most powerful tools in SQL Server. It is a robust technology allowing High Availability and scalability that every DBA and system architect should be aware of. In the session, we will learn how to leverage Peer-to-Peer replication in real-life scenarios in which replication can provide an optimal solution for the business’s requirements. We will go through best practices and see some tips & tricks for easy implementation and maintenance of Peer-to-Peer replication.

SessionID: 740

Adopt, Discover and Improve – How to take ownership of a system and survive on a new job

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Responsibilities - Track: DBA

Speaker(s): Dmitri Korotkevitch

Title: Adopt, Discover and Improve – How to take ownership of a system and survive on a new job

Description:

The current job market is extremely competitive. Employers receive dozens or even hundreds of resumes for every job opening. Unfortunately, getting the job offer is not enough – employers often do not want to give new employees enough time to get familiar with their systems and expect them to start producing ROI almost immediately. It becomes critical for newly hired Database Administrators and Developers to take ownership of the system as soon as possible if they want to keep the position they won. Taking ownership of the system is an iteration-based process. As a first step, initial system state needs to be analyzed and bottlenecks identified. Next, the source of bottlenecks needs to be determined. There are few common reasons why bottlenecks occur: systems outgrow the hardware, servers are misconfigured or, most commonly, the database and/or application code are poorly designed. In any case, the problematic places need to be detected and fixed. This session will focus on the entire process. It will show how to analyze the system state using wait statistics, data management objects and system performance counters. It will demonstrate how specific resource bottlenecks relate to database design, concurrency and code issues. It will show how to pinpoint the most problematic queries and code patterns as the first candidates for refactoring. It will also demonstrate how to detect anti-patterns and design issues such as heap tables, inefficient clustered and non-clustered indexes, incorrect data type usage and many others using catalog views, data management objects and SQL server traces.

SessionID: 739

Baselining, trend analysis and system monitoring with Management Data Warehouse

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Monitoring/Auditing - Track: DBA

Speaker(s): Dmitri Korotkevitch

Title: Baselining, trend analysis and system monitoring with Management Data Warehouse

Description:

Every year more and more businesses use Microsoft SQL Server as the backend database server in their mission-critical systems. High availability of these systems has become a standard requirement. It is not uncommon to have a Service Level Agreement that does not allow more than a few minutes of downtime per calendar year. That forces DBAs to implement proactive monitoring solutions. One of the key components of a proactive system monitoring strategy is baselining. Comparison of the current system state to a baseline helps understand changes in system load and behavior. Monitoring of these changes helps predict and avoid bottlenecks. Historically, system monitoring has been done based on system performance counters, DMO and SQL server traces. One of the challenges with this approach is the heterogeneous nature of the data collected. This requires additional processing and unification of the data before analysis can be performed. Another challenge is the correlation of different data streams. The standard SQL Server installation does not provide all the necessary tools to solve these problems out of the box. Management Data Warehouse, introduced in SQL Server 2008, simplifies system troubleshooting tasks. The data provided by Data Collectors are unified and stored in a relational database. A set of standard reports allows drilling down to the various aspects of system load and behavior during performance troubleshooting. Unfortunately, the standard configuration for MDW is not optimal for the trend analysis aspects of system monitoring. The standard Data Collectors do not capture enough information to create a comprehensive baseline. As a result, there are no standard reports which can be used to analyze trends and predict possible bottlenecks. This session will focus on customizations and enhancements to MDW and Data Collectors that will help with system baselining, monitoring and trend analysis. Specifically, it will demonstrate how to enhance existing and create new Data Collectors in order to obtain a comprehensive system baseline. It will give an overview of MDW database schema and object dependencies. And finally, it will show how to query the collected data for analysis, reporting and monitoring purposes.

SessionID: 742

How to become a SQL Server community celebrity?

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Regular session - Track: Professional Development

Speaker(s): Meir Dudai

Title: How to become a SQL Server community celebrity?

Description:

How do people become SQL Server Gurus? Is it a special gift or can it be achieved by anyone? If you want to become a “SQL Server celebrity”, you’ll get the recipe in this session. We will analyze the way you can make it to the top and become one of the leading SQL Server professionals. From organizing user groups to publishing books, we will go through all the steps needed for you to become a well known expert in your field.

SessionID: 745

Clustering for Mere Mortals

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: DBA

Speaker(s): Geoff Hiten

Title: Clustering for Mere Mortals

Description:

Learn about clustering in current SQL Server and Windows Server releases. Failover Clustering is a fundamental step for any High Availability SQL implementation. Learn how Clustering works, what are the new requirements for Failover Clustering, and how you can make the most of this feature.

SessionID: 744

Bad SQL

Back to calendar

Event Date: 11-05-2011 00:00 - Category: Summit Spotlight - Track: Development

Speaker(s): Geoff Hiten

Title: Bad SQL

Description:

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

SessionID: 743

Real World Administration with SQL Server PowerShell Extensions (SQLPSX)

Back to calendar

Event Date: 11-05-2011 00:00 - Category: PowerShell - Track: DBA

Speaker(s): Chad Miller

Title: Real World Administration with SQL Server PowerShell Extensions (SQLPSX)

Description:

See how the CodeProject SQLPSX, an extensive PowerShell-based open source project representing over 3,000 hours of development, is used for real world PowerShell automation tasks. We'll cover retrieving SQL Server information, SSIS administration, Policy-Based Management, replication and SQLIse a WPF-based query tool. Along the way we'll also discuss why would use PowerShell over other solutions and highlight where non-PowerShell based solutions is more appropriate.