| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 03-11-2014 08:30 | Paul Randal | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Performance Troubleshooting Using Waits and Latches |
| 03-11-2014 08:30 | Adam Jorgensen, John Welch | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Big Data: Deploy, Design, and Manage Like a Pro |
| 03-11-2014 08:30 | Robert Cain, Bradley Ball, Jason Strate | Pre-Conference Session (full day) | Application & Database Development | Zero to Hero with PowerShell and SQL Server |
| 03-11-2014 08:30 | Kalen Delaney | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | In-Memory OLTP Internals: How is a 30x Performance Boost Possible? |
| 03-11-2014 08:30 | Itzik Ben-Gan | Pre-Conference Session (full day) | Application & Database Development | Mastering T-SQL Querying Fundamentals |
| 03-11-2014 08:30 | Chris Shaw, John Morehouse | Pre-Conference Session (full day) | Application & Database Development | Real World End-to-End Performance Solutions |
| 03-11-2014 08:30 | Marco Russo | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Data Modeling in SSAS Tabular |
| 03-11-2014 08:30 | Carlos Bossy | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Predictive Analytics in the Enterprise |
| 04-11-2014 08:30 | Allan Hirt | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | The A to Z of Availability Groups |
| 04-11-2014 08:30 | Adam Machanic | Pre-Conference Session (full day) | Application & Database Development | Better Performance through Parallelism |
| 04-11-2014 08:30 | Alberto Ferrari | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | From 0 to DAX |
| 04-11-2014 08:30 | Tim Chapman, Denzil Ribeiro | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Troubleshoot Customer Performance Problems Like a Microsoft Engineer |
| 04-11-2014 08:30 | Grant Fritchey | Pre-Conference Session (full day) | Application & Database Development | Query Performance Tuning in SQL Server 2014 |
| 04-11-2014 08:30 | Devin Knight, Brian Knight | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | SSIS: Problem, Design, Solution |
| 04-11-2014 08:30 | Peter Myers | Pre-Conference Session (full day) | BI Information Delivery | Superhero Power BI |
| 04-11-2014 08:30 | Davide Mauri | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Agile Data Warehousing: Start to Finish |
| 04-11-2014 08:30 | Jonathan Kehayias, Erin Stellato | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Everything You Never Wanted to Know about Extended Events |
| 05-11-2014 08:15 | James Phillips, T.K. Ranga Rengarajan, Joseph Sirosh | Keynote (90 minutes) | Cloud Application Development & Deployment | Keynote: Evolving Microsoft’s Data Platform–The Journey to Cloud Continues |
| 05-11-2014 10:15 | Nicolle Whitman | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Analytics Platform System Overview (APS) |
| 05-11-2014 10:15 | Joseph D'Antoni | General Session (75 minutes) | Enterprise Database Administration & Deployment | Building Perfect SQL Servers, Every Time |
| 05-11-2014 10:15 | Reza Rad | General Session (75 minutes) | BI Information Delivery | Deeper Data Insight and Prediction with Data Mining |
| 05-11-2014 10:15 | Pinal Dave | General Session (75 minutes) | Application & Database Development | Secrets of SQL Server: Database Worst Practices |
| 05-11-2014 10:15 | Kevin Farlee | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014: In-Memory Overview |
| 05-11-2014 10:15 | Miguel Llopis, Faisal Mohamood | General Session (75 minutes) | BI Information Delivery | What's New in Microsoft Power Query for Excel |
| 05-11-2014 10:15 | Ryan Adams | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server AlwaysOn Quickstart |
| 05-11-2014 10:15 | Tom Stringer | General Session (75 minutes) | Enterprise Database Administration & Deployment | Troubleshooting SQL Server with Extended Events |
| 05-11-2014 10:45 | Aaron Bertrand | General Session (75 minutes) | Application & Database Development | Five Ways to Write More Effective Triggers |
| 05-11-2014 10:45 | Stephen Baron | General Session (75 minutes) | Application & Database Development | Life in the fast lane with Azure DocumentDB |
| 05-11-2014 10:45 | Gareth Swanepoel | General Session (75 minutes) | Enterprise Database Administration & Deployment | A Practical Guide to Microsoft Azure SQL Databases for the DBA |
| 05-11-2014 10:45 | Andy Leonard, Kevin Hazzard | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Scripting with SSIS |
| 05-11-2014 10:45 | Stuart Ainsworth | General Session (75 minutes) | BI Platform Architecture, Development & Administration | The Elephant in the Room: A DBA's Guide to Hadoop and Big Data |
| 05-11-2014 10:45 | Robert Cain | General Session (75 minutes) | Application & Database Development | Make SQL Server Pop with PowerShell |
| 05-11-2014 10:45 | Kevin Kline | General Session (75 minutes) | Professional Development | Community Session: Intro to PASS Summit |
| 05-11-2014 10:45 | Rod Colledge | General Session (75 minutes) | BI Information Delivery | Building Hybrid BI Solutions with Power BI |
| 05-11-2014 10:45 | Steve Simon | General Session (75 minutes) | BI Platform Architecture, Development & Administration | A Dive into Data Quality Services |
| 05-11-2014 13:30 | Kendra Little | General Session (75 minutes) | Application & Database Development | World's Worst Performance Tuning Techniques |
| 05-11-2014 13:30 | Scott Shaw | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Under the Covers of Hadoop on Windows |
| 05-11-2014 13:30 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 and Azure Integration |
| 05-11-2014 13:30 | Hope Foley | General Session (75 minutes) | Application & Database Development | Spatial Data: Looking Outside the Map |
| 05-11-2014 13:30 | Edwin M Sarmiento | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Configuring SharePoint 2013 as a Business Intelligence Platform |
| 05-11-2014 13:30 | Bradley Ball | General Session (75 minutes) | Enterprise Database Administration & Deployment | Using PowerShell to Manage Cloud Integrated Data Platforms |
| 05-11-2014 13:30 | Juergen Thomas | General Session (75 minutes) | Application & Database Development | Azure CAT: Line of Business Application on Azure Virtual Machine Services |
| 05-11-2014 13:30 | Kevin Farlee | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 AlwaysOn (High Availability and Disaster Recovery) |
| 05-11-2014 13:30 | Jen Stirrup | Half-Day Session (3 hours) | BI Information Delivery | Business Intelligence Toolkit Overview: Microsoft Power BI & R (Part 1) |
| 05-11-2014 13:30 | Kevin Kline | General Session (75 minutes) | Professional Development | Top 10 Mistakes of New IT Leaders |
| 05-11-2014 13:30 | Wendy Pastrick | General Session (75 minutes) | Professional Development | Community Session: Checklist for Making the Most of PASS and Summit |
| 05-11-2014 13:30 | David Klee | General Session (75 minutes) | Enterprise Database Administration & Deployment | Right-Sizing Your SQL Server Virtual Machine |
| 05-11-2014 13:30 | Warner Chaves | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Use Cases for In-Memory OLTP |
| 05-11-2014 13:30 | Dan Bulos | General Session (75 minutes) | BI Information Delivery | Are You Getting Your Message Across? How to Display Data! |
| 05-11-2014 13:30 | Mine Tokus, Abbas Ali Aloc | General Session (75 minutes) | Application & Database Development | Microsoft Azure SQL Database – Resource Management |
| 05-11-2014 13:30 | John Martin | General Session (75 minutes) | Enterprise Database Administration & Deployment | Upgrading and Migrating SQL Server |
| 05-11-2014 13:30 | Buck Woody | General Session (75 minutes) | Enterprise Database Administration & Deployment | Match the Database to the Data – From on Prem to the Cloud |
| 05-11-2014 15:00 | Carlos Bossy | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Get to Know HDInsight and Start Mining Big Data |
| 05-11-2014 15:00 | Klaus Aschenbrenner | General Session (75 minutes) | Enterprise Database Administration & Deployment | Latches, Spinlocks, and Lock Free Data Structures |
| 05-11-2014 15:00 | General Session (75 minutes) | Enterprise Database Administration & Deployment | Integration Services (SSIS) for the DBA | |
| 05-11-2014 15:00 | Conor Cunningham | General Session (75 minutes) | Enterprise Database Administration & Deployment | Query Store - A New SQL Query Tuning Feature |
| 05-11-2014 15:00 | Tim Radney, Brent Ozar, Craig Purnell, Luke Jian, Steve Wake, Mark Vaillancourt | Lightning Talk (10 minutes) | Professional Development | Lightning Talks 101 |
| 05-11-2014 15:00 | Peter Myers | General Session (75 minutes) | BI Platform Architecture, Development & Administration | End-to-End SQL Server 2012 Master Data Services |
| 05-11-2014 15:00 | Ben DeBow | General Session (75 minutes) | Enterprise Database Administration & Deployment | Congratulations, You're Now a DBA . . . |
| 05-11-2014 15:00 | Karen Lopez, Lara Rubbelke | General Session (75 minutes) | Application & Database Development | 7 Databases in 70 Minutes: A Primer for NoSQL in Azure |
| 05-11-2014 15:00 | Sean McCown | General Session (75 minutes) | Enterprise Database Administration & Deployment | Performance Tuning Your Backups |
| 05-11-2014 15:00 | Jen Stirrup | Half-Day Session (3 hours) | BI Information Delivery | Business Intelligence Toolkit Overview: Microsoft Power BI & R (Part 2) |
| 05-11-2014 15:00 | Selcin Turkarslan | General Session (75 minutes) | Enterprise Database Administration & Deployment | Migration and Deployment Principles for SQL Server in Azure VMs |
| 05-11-2014 15:00 | Will Thompson | General Session (75 minutes) | BI Information Delivery | Interactive Data Visualization with Power View |
| 05-11-2014 15:00 | Niko Neugebauer | General Session (75 minutes) | BI Platform Architecture, Development & Administration | ETL Patterns with Clustered Columnstore Indexes |
| 05-11-2014 15:00 | Kalen Delaney | General Session (75 minutes) | Application & Database Development | Are You Optimistic About Concurrency? |
| 05-11-2014 15:00 | Brian Knight | General Session (75 minutes) | Professional Development | Real World Lessons about Starting a Consulting Company |
| 05-11-2014 15:00 | Joseph D'Antoni | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | SQL Server DR in Microsoft Azure: Building Your Second Data Center (Part 1) |
| 05-11-2014 15:00 | Amy Lewis, Melissa Coates, Lance Harra | General Session (75 minutes) | Professional Development | Community Session: PASS Program Abstract Workshop |
| 05-11-2014 16:30 | Kun Cheng, Silvano Coriani, Rama Ramani | General Session (75 minutes) | Application & Database Development | Azure CAT: Data Platform: The Right Storage Solution for the Right Problem |
| 05-11-2014 16:30 | Mladen Prajdić | General Session (75 minutes) | Application & Database Development | SQL Server and Application Security for Developers |
| 05-11-2014 16:30 | Kimberly Tripp | General Session (75 minutes) | Enterprise Database Administration & Deployment | Dealing with Multipurpose Procs and PSP the RIGHT Way! |
| 05-11-2014 16:30 | Marco Russo | General Session (75 minutes) | BI Information Delivery | DAX Patterns |
| 05-11-2014 16:30 | Joseph D'Antoni | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | SQL Server DR in Microsoft Azure: Building Your Second Data Center (Part 2) |
| 05-11-2014 16:30 | Joe Webb | General Session (75 minutes) | Professional Development | Hiring the Right People: Interviewing and Selecting the Right Team |
| 05-11-2014 16:30 | Sunil Agarwal | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014: ColumnStore Index |
| 05-11-2014 16:30 | Glenn Berry | General Session (75 minutes) | Enterprise Database Administration & Deployment | Analyzing I/O Subsystem Performance |
| 05-11-2014 16:30 | Bill Gibson, Vinod Jagannathan | General Session (75 minutes) | Application & Database Development | Azure SQL Database Overview |
| 05-11-2014 16:30 | Robert Davis | General Session (75 minutes) | Application & Database Development | Boosting Performance with Indexing |
| 05-11-2014 16:30 | Bob Pusateri | General Session (75 minutes) | Enterprise Database Administration & Deployment | VLDBs: Lessons Learned |
| 05-11-2014 16:30 | Sebastian Meine | General Session (75 minutes) | Enterprise Database Administration & Deployment | Permission Management:12 Pitfalls and Misconceptions |
| 05-11-2014 16:30 | Devin Knight | General Session (75 minutes) | BI Information Delivery | Creating an End-to-End Power View Reporting Solution |
| 05-11-2014 16:30 | John Welch | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Continuous Delivery for Data Warehouses and Marts |
| 05-11-2014 16:30 | Sanjay Soni, Kasper de Jonge | General Session (75 minutes) | BI Information Delivery | End-to-End Demos with Power BI |
| 05-11-2014 16:30 | Stacia Varga | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Understanding BI Security Best Practices |
| 05-11-2014 16:45 | Denny Cherry | General Session (75 minutes) | Professional Development | Community Session: Speaker Idol - Round 1 |
| 06-11-2014 06:45 | Denny Cherry, Geoff Hiten, Joseph D'Antoni, Rob Volk | General Session (75 minutes) | Professional Development | Sponsor Breakfast: PASS The Bacon: Breakfast Panel |
| 06-11-2014 07:00 | Lou Hernandez | General Session (75 minutes) | Professional Development | Sponsor Breakfast: Supercharging SQL with Actifio Copy Data Virtualization |
| 06-11-2014 08:15 | Rimma Nehme | Keynote (90 minutes) | Cloud Application Development & Deployment | Keynote: Cloud Databases 101 |
| 06-11-2014 10:15 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | Optimizing SQL Server Performance in a Virtual Environment |
| 06-11-2014 10:15 | Reza Rad | General Session (75 minutes) | BI Information Delivery | Top Five Power Query M Functions that You Don't Know |
| 06-11-2014 10:15 | Silvano Coriani, Olivia Klose | General Session (75 minutes) | Enterprise Database Administration & Deployment | Jumpstarting Big Data Projects – Stories from the Field |
| 06-11-2014 10:15 | Sanjay Soni, Miguel Martinez, Anand Subbaraj | General Session (75 minutes) | BI Information Delivery | Analyzing Tweets with HDInsight, Excel and Power BI |
| 06-11-2014 10:15 | Matt Winkler | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deploying Hadoop in a Hybrid Environment |
| 06-11-2014 10:15 | Tim Chapman, Thomas LaRock, Tim Chapman | General Session (75 minutes) | Application & Database Development | Writing Faster Queries Using SQL Server 2014 |
| 06-11-2014 10:15 | Adam Belebczuk | General Session (75 minutes) | Enterprise Database Administration & Deployment | Introduction to AlwaysOn Availability Groups |
| 06-11-2014 10:15 | Adam Machanic | General Session (75 minutes) | Application & Database Development | Query Tuning Mastery: Manhandling Parallelism, 2014 Edition |
| 06-11-2014 10:45 | Mark Broadbent, Buck Woody | General Session (75 minutes) | Professional Development | Community Session: Being Buck Woody |
| 06-11-2014 10:45 | Artin Avanes | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Polybase in the Modern Data Warehouse |
| 06-11-2014 10:45 | John Sterrett, Brian Moran | General Session (75 minutes) | Professional Development | Is Independent Consulting for Me? |
| 06-11-2014 10:45 | Chris Shaw | General Session (75 minutes) | Enterprise Database Administration & Deployment | Schema/Data Modifications: Something's Changed? We'll Find it |
| 06-11-2014 10:45 | Kasper de Jonge | General Session (75 minutes) | BI Information Delivery | Power View with Analysis Services Multidimensional Models |
| 06-11-2014 10:45 | Dan Bulos | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Modeling in the Age of Big Data and Self-Service BI |
| 06-11-2014 10:45 | Ayad Shammout, Mike Weiner, Jack Freeman, Stan Orlowski, Huili Shao | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014: In-Memory Customer Deployments and Lessons Learned |
| 06-11-2014 10:45 | Mickey Stuewe | General Session (75 minutes) | BI Information Delivery | Techniques for Dynamic SSRS Reports |
| 06-11-2014 10:45 | Oliver Engels, Tillmann Eitelberg | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SSIS and HDInsight |
| 06-11-2014 11:45 | General Session (75 minutes) | Professional Development | WIT Luncheon: Kimberly Bryant | |
| 06-11-2014 13:30 | Jose Chinchilla, Andreas Wolter, Markus Ehrenmueller-Jensen, Josh Fennessy, Regis Baccaro, Meagan Longoria | Lightning Talk (10 minutes) | Professional Development | Lightning Talks 102 |
| 06-11-2014 13:30 | Jes Schultz, Kendal Van Dyke | General Session (75 minutes) | Professional Development | Community Session: Running a User Group: Go From "Where do I start?" to "I've got this!" |
| 06-11-2014 13:30 | Jonathan Kehayias | General Session (75 minutes) | Enterprise Database Administration & Deployment | Solving Complex Problems with Extended Events |
| 06-11-2014 13:30 | J May | General Session (75 minutes) | Enterprise Database Administration & Deployment | To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT |
| 06-11-2014 13:30 | Luming Han, Mini Nair | General Session (75 minutes) | BI Information Delivery | Power BI Hybrid Data Access via Data Management Gateway |
| 06-11-2014 13:30 | Scott Klein | General Session (75 minutes) | Enterprise Database Administration & Deployment | Leveraging SQL Server in Azure Virtual Machines Best Practices |
| 06-11-2014 13:30 | Paul Randal | General Session (75 minutes) | Enterprise Database Administration & Deployment | Advanced Data Recovery Techniques |
| 06-11-2014 13:30 | MIKE DONNELLY | General Session (75 minutes) | Application & Database Development | Twice in a Lifetime: T-SQL Refactoring 101 |
| 06-11-2014 13:30 | Kevin Kline, Aaron Bertrand | General Session (75 minutes) | Application & Database Development | Top Free Tools for Tuning SQL Statements |
| 06-11-2014 13:30 | Julie Koesmarno | General Session (75 minutes) | BI Information Delivery | "I Want It NOW!" Data Visualization with Power View |
| 06-11-2014 13:30 | Patrick O'Keeffe | General Session (75 minutes) | Enterprise Database Administration & Deployment | Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance |
| 06-11-2014 13:30 | Tim Mitchell | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building Bullet-Resistant SSIS Packages |
| 06-11-2014 13:30 | Peter Myers | General Session (75 minutes) | BI Information Delivery | Preparing a Power BI Workbook for Publication |
| 06-11-2014 13:30 | Bob Pusateri, Adam Machanic, Sean McCown, Michelle Ufford, Jennifer McCown | General Session (75 minutes) | Professional Development | How to Interview a DBA: A Panel Debate |
| 06-11-2014 13:30 | Davide Mauri | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Agile BI: Unit Testing and Continuos Integration |
| 06-11-2014 13:30 | Jan Engelsberg, Torsten Grabs | General Session (75 minutes) | Application & Database Development | Azure SQL Database Performance and Scale Out Deep Dive |
| 06-11-2014 13:30 | Karan Gulati, Nishant Thacker | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building a Big Data Predictive Application |
| 06-11-2014 15:00 | George Li | General Session (75 minutes) | Enterprise Database Administration & Deployment | In-Memory OLTP in SQL Server 2014: End-to-End Migration |
| 06-11-2014 15:00 | Steve Jones | General Session (75 minutes) | Enterprise Database Administration & Deployment | Maintaining High Performance When Using Encryption |
| 06-11-2014 15:00 | Jos de Bruijn | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 In-Memory OLTP Query Processing |
| 06-11-2014 15:00 | Alberto Ferrari | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Advanced Modeling with Analysis Services Tabular |
| 06-11-2014 15:00 | Karen Lopez, Joseph D'Antoni | General Session (75 minutes) | Professional Development | You Wouldn't Let HR Manage Your DBs, So Don't Let Them Manage Your Career |
| 06-11-2014 15:00 | Matt Masson, Matthew Roche | General Session (75 minutes) | BI Information Delivery | BI Power Hour |
| 06-11-2014 15:00 | Craig Purnell | General Session (75 minutes) | Professional Development | The Professional Networking Toolbox |
| 06-11-2014 15:00 | Argenis Fernandez | General Session (75 minutes) | Enterprise Database Administration & Deployment | Secure Your SQL Server Instance without Changing Any Code |
| 06-11-2014 15:00 | Bob Ward | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Inside SQL Server I/O (Part 1) |
| 06-11-2014 15:00 | Lindsey Allen, Rama Ramani | General Session (75 minutes) | Application & Database Development | Azure CAT: Deep Dive of Real World Complex Azure Data Solutions |
| 06-11-2014 15:00 | Kendra Little | General Session (75 minutes) | Application & Database Development | Why Does SQL Server Keep Asking for this Index? |
| 06-11-2014 15:00 | Pat Sinthusan | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014: The Cure for Cloud Phobia |
| 06-11-2014 15:00 | Amy Lewis, Melissa Coates, Lance Harra | General Session (75 minutes) | Professional Development | Community Session: PASS Program Office Hours |
| 06-11-2014 15:00 | Maurice De Vidts | General Session (75 minutes) | Enterprise Database Administration & Deployment | Scaling and Deploying SQL Server 2014 on High Core Servers and Flash Arrays |
| 06-11-2014 15:00 | Kathi Kellenberger | Half-Day Session (3 hours) | Application & Database Development | T-SQL Window Function Deep Dive (Part 1) |
| 06-11-2014 15:00 | Jason Strate | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building Next Generation ETL Solutions with PDW |
| 06-11-2014 15:00 | Rafael Salas | General Session (75 minutes) | BI Information Delivery | Power Query: Business Users and ETL Developers Hug Day |
| 06-11-2014 16:45 | Kathi Kellenberger | Half-Day Session (3 hours) | Application & Database Development | T-SQL Window Function Deep Dive (Part 2) |
| 06-11-2014 16:45 | Bob Ward | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Inside SQL Server I/O (Part 2) |
| 06-11-2014 16:45 | Paul Dyke | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Analytics Platform System Deep Dive (APS) |
| 06-11-2014 16:45 | Raymond Laghaeian | General Session (75 minutes) | Application & Database Development | Introducing Azure Machine Learning |
| 06-11-2014 16:45 | Conor Cunningham | General Session (75 minutes) | Enterprise Database Administration & Deployment | Managing 1 Million+ DBs-How Big Data is Used to Run SQL Azure |
| 06-11-2014 16:45 | Xin Jin, Evgeny Krivosheev | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Hybrid Features End-to-End |
| 06-11-2014 16:45 | Matt Smith, Michael Wilmot | General Session (75 minutes) | BI Information Delivery | Real World Healthcare BI Transformations in the Cloud |
| 06-11-2014 16:45 | Brian Larson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Tuples, Sets, and Members: Understanding the Basics of MDX |
| 06-11-2014 16:45 | Colleen Morrow | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Audit: from Introduction to Automation |
| 06-11-2014 16:45 | Scott Stauffer | General Session (75 minutes) | Application & Database Development | Build a Social Analytics Platform to Manage Your Social Presence |
| 06-11-2014 16:45 | Jonathan Kehayias | General Session (75 minutes) | Enterprise Database Administration & Deployment | Deadlocking for Mere Mortals |
| 06-11-2014 16:45 | André Kamman | General Session (75 minutes) | Enterprise Database Administration & Deployment | How to Write Professional PowerShell Scripts |
| 06-11-2014 16:45 | Jason Thomas | General Session (75 minutes) | BI Information Delivery | DataViz You Thought You Could NOT Do with SSRS |
| 06-11-2014 16:45 | Scott Currie | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Autogenerate a Dimensional Data Warehouse from Metadata |
| 06-11-2014 16:45 | Brent Ozar | General Session (75 minutes) | Enterprise Database Administration & Deployment | Developers: Who Needs a DBA? |
| 06-11-2014 16:45 | Erin Stellato | General Session (75 minutes) | Application & Database Development | Five Execution Plan Patterns to Watch for |
| 06-11-2014 17:00 | Denny Cherry | General Session (75 minutes) | Professional Development | Community Session: Speaker Idol - Round 2 |
| 07-11-2014 08:15 | Buck Woody | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server in Azure VM Roadmap |
| 07-11-2014 08:15 | Josh Fennessy | General Session (75 minutes) | BI Information Delivery | Visual Analytics with HDInsight and Power View |
| 07-11-2014 08:15 | Sanjay Soni, Justin Martinson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Connecting SAP ERP and Microsoft BI Platform |
| 07-11-2014 08:15 | Doug Lane | General Session (75 minutes) | BI Information Delivery | From Minutes to Milliseconds: High-Performance SSRS Tuning |
| 07-11-2014 08:15 | Anand Subbaraj | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Introducing Microsoft Azure Data Factory |
| 07-11-2014 08:15 | John Sterrett | General Session (75 minutes) | Enterprise Database Administration & Deployment | Table Partitioning: the Secret Weapon for Your Big Data Problems |
| 07-11-2014 08:15 | Neil Hambly | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Performance Troubleshooting Using DMVs (Part 1) |
| 07-11-2014 08:15 | Ryan Adams | General Session (75 minutes) | Professional Development | Community Session: Navigating PASS |
| 07-11-2014 08:15 | Trayce Jordan | General Session (75 minutes) | Enterprise Database Administration & Deployment | Troubleshooting AlwaysOn Availability Groups in SQL 2014 |
| 07-11-2014 08:15 | Jos de Bruijn | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 In-Memory OLTP Transaction Processing |
| 07-11-2014 08:15 | Benjamin Nevarez | General Session (75 minutes) | Application & Database Development | Query Processing in In-Memory OLTP |
| 07-11-2014 08:15 | Gerhard Brueckl | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deep Dive into Analysis Services Security |
| 07-11-2014 08:15 | Jeremiah Peschka | General Session (75 minutes) | Application & Database Development | Dynamic SQL: Build Fast, Flexible Queries |
| 07-11-2014 08:15 | Ajay Jagannathan, Ravinder Vuppula | General Session (75 minutes) | Enterprise Database Administration & Deployment | Improve Availability using Online Operations in SQL Server 2014 |
| 07-11-2014 08:15 | Adam Saxton | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Top Power BI Issues |
| 07-11-2014 08:15 | Dejan Sarka | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Identity Mapping and De-Duplicating |
| 07-11-2014 08:15 | Allan Hirt | General Session (75 minutes) | Enterprise Database Administration & Deployment | Did You Vote Today? A DBA's Guide to Cluster Quorum |
| 07-11-2014 09:45 | Stacia Varga | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building a BI Solution in the Cloud |
| 07-11-2014 09:45 | Neil Hambly | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Performance Troubleshooting Using DMVs (Part 2) |
| 07-11-2014 09:45 | Lonny Bastien, Steven Green | General Session (75 minutes) | Application & Database Development | Application Lifecycle Management for SQL Server Database Development |
| 07-11-2014 09:45 | Julie Strauss, Matthew Roche | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Information Management with the Data Catalog In Power BI… and Beyond |
| 07-11-2014 09:45 | Chris Webb | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deep Dive into MDX Scoped Assignments |
| 07-11-2014 09:45 | Ola Hallengren | General Session (75 minutes) | Enterprise Database Administration & Deployment | Inside Ola Hallengren's Maintenance Solution |
| 07-11-2014 09:45 | Jonathan Kehayias | General Session (75 minutes) | Application & Database Development | Going Asynchronous with Service Broker |
| 07-11-2014 09:45 | Paul Rizza | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Shortcuts to SSIS via C#.Net - EzAPI |
| 07-11-2014 10:15 | Denny Cherry | General Session (75 minutes) | Professional Development | Community Session: Speaker Idol - Round 3 |
| 07-11-2014 10:15 | Vern Rabe | General Session (75 minutes) | Application & Database Development | The Significance of Choosing the Right Data Types |
| 07-11-2014 10:15 | Jes Schultz | General Session (75 minutes) | Application & Database Development | Are Your Indexes Hurting You or Helping You? |
| 07-11-2014 10:15 | Argenis Fernandez | General Session (75 minutes) | Enterprise Database Administration & Deployment | Making DBCC CHECKDB Go Faster |
| 07-11-2014 10:15 | Scott Klein | General Session (75 minutes) | Application & Database Development | Data-tier Considerations of Cloud-based Modern Application Design |
| 07-11-2014 10:15 | Thomas LeBlanc | General Session (75 minutes) | BI Information Delivery | Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube |
| 07-11-2014 10:15 | David Darden | General Session (75 minutes) | Professional Development | Agile BI: A Primer |
| 07-11-2014 10:15 | Luke Jian | General Session (75 minutes) | Enterprise Database Administration & Deployment | A Tale of Two Joins: Merge vs. Hash |
| 07-11-2014 10:15 | Kevin Hazzard | General Session (75 minutes) | Enterprise Database Administration & Deployment | Using the Resource Governor for Scalability |
| 07-11-2014 13:00 | Randy Knight, Kevin Boles, Julie Smith, Stuart Ainsworth, Argenis Fernandez, Rick Heiges | Lightning Talk (10 minutes) | Professional Development | Lightning Talks 103 |
| 07-11-2014 13:00 | Pablo Castro | General Session (75 minutes) | Application & Database Development | Azure Search Deep Dive |
| 07-11-2014 13:00 | Dejan Sarka | General Session (75 minutes) | Application & Database Development | Temporal Data in SQL Server |
| 07-11-2014 13:00 | Angel Abundez | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Managing Self-Service BI in SharePoint 2013 (Part 1) |
| 07-11-2014 13:00 | Eddie Wuerch | General Session (75 minutes) | Professional Development | Join Us! Getting Started as a Technical Speaker |
| 07-11-2014 13:00 | Brian Larson | General Session (75 minutes) | BI Information Delivery | Effective Reporting through SSRS Advanced Authoring Features |
| 07-11-2014 13:00 | Jose L. Rivera | General Session (75 minutes) | Professional Development | Community Session: Conociendo y creciendo con la comunidad PASS |
| 07-11-2014 13:00 | Adam Jorgensen, Denise McInerney, Thomas LaRock | General Session (75 minutes) | Professional Development | PASS Board Q&A [Board Q&A] |
| 07-11-2014 13:00 | Maxim Lukiyanov | General Session (75 minutes) | Application & Database Development | HBase: Building Real-Time Big Data Apps in the Cloud |
| 07-11-2014 13:00 | Bradley Ball | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Locking Internals Deep Dive (Part 1) |
| 07-11-2014 13:00 | Oliver Engels, Tillmann Eitelberg | General Session (75 minutes) | BI Information Delivery | Alarm for Data Governance! Self-Service BI is coming! |
| 07-11-2014 13:00 | Mark Broadbent | General Session (75 minutes) | Enterprise Database Administration & Deployment | Enter the Dragon: Running SQL 2014 on Windows Server Core |
| 07-11-2014 13:00 | Kun Cheng, Sanjay Mishra, Silvano Coriani | General Session (75 minutes) | Application & Database Development | Azure CAT: Azure SQL DB Performance Tuning & Troubleshooting |
| 07-11-2014 13:00 | Mark Vaillancourt | General Session (75 minutes) | BI Information Delivery | Power Query: Data Chemistry for The Masses |
| 07-11-2014 13:00 | Gail Shaw | General Session (75 minutes) | Enterprise Database Administration & Deployment | Guessing Games: Statistics, Heuristics, and Row Estimations |
| 07-11-2014 13:00 | Ike Ellis | General Session (75 minutes) | Application & Database Development | SQL Server Development Best Practices |
| 07-11-2014 13:00 | Sunil Agarwal, Jamie Reding | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 in-Memory OLTP - Monitoring and Troubleshooting |
| 07-11-2014 13:00 | Matt Winkler | General Session (75 minutes) | Enterprise Database Administration & Deployment | Introduction to Azure HDInsight and Visual Studio Customizations |
| 07-11-2014 14:30 | Meagan Longoria | General Session (75 minutes) | BI Information Delivery | Choose Your Mapping Adventure: Visualizing Your Geospatial Data |
| 07-11-2014 14:30 | Karen Lopez | General Session (75 minutes) | Application & Database Development | Stuff Your Database Says about Me . . . and How to Fix it |
| 07-11-2014 14:30 | Jose Chinchilla | General Session (75 minutes) | Enterprise Database Administration & Deployment | Rock Your Data Warehouse with SQL Server 2014 Columnstore Indexes |
| 07-11-2014 14:30 | Shep Sheppard, Ajay Jagannathan | General Session (75 minutes) | Enterprise Database Administration & Deployment | Azure CAT: SQL Server 2014 Gems |
| 07-11-2014 14:30 | Alexander (Sasha) Nosov, Nadav Helfman | General Session (75 minutes) | Application & Database Development | Azure SQL Database Business Continuity and Auditing Deep Dive |
| 07-11-2014 14:30 | Grant Fritchey | General Session (75 minutes) | Application & Database Development | Getting Started Reading Execution Plans |
| 07-11-2014 14:30 | Santosh Balasubramanian, Judy Myer | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Introducing Microsoft Azure Stream Analytics |
| 07-11-2014 14:30 | Chris Webb | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Top Analysis Services Multidimensional Design Mistake |
| 07-11-2014 14:30 | Kendal Van Dyke | General Session (75 minutes) | Application & Database Development | How to Build a SQL Server Virtual Lab On Your Own Machine |
| 07-11-2014 14:30 | Matt Masson, Theresa Palmer-Boroski | General Session (75 minutes) | BI Information Delivery | Deep Dive into Power Query Formula Language |
| 07-11-2014 14:30 | Angel Abundez | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Managing Self-Service BI in SharePoint 2013 (Part 2) |
| 07-11-2014 14:30 | Bradley Ball | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Locking Internals Deep Dive (Part 2) |
| 07-11-2014 14:30 | Bob Duffy | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Load Testing Analysis Services |
| 07-11-2014 14:30 | Allen White | General Session (75 minutes) | Enterprise Database Administration & Deployment | Manage Both On-Prem and Azure Databases with PowerShell |
| 07-11-2014 14:30 | Parmita Mehta | General Session (75 minutes) | Application & Database Development | Making the Most of Azure Machine Learning End-to-End |
| 07-11-2014 14:30 | John Welch | General Session (75 minutes) | BI Platform Architecture, Development & Administration | ETL Recovery and Rollback |
| 07-11-2014 14:45 | Denny Cherry | General Session (75 minutes) | Professional Development | Community Session: Speaker Idol - Final |
| 07-11-2014 16:00 | Jason Horner | General Session (75 minutes) | BI Information Delivery | Advanced Spatial Analysis: Beyond Bubble Charts |
| 07-11-2014 16:00 | Guy Glantser | General Session (75 minutes) | Enterprise Database Administration & Deployment | Working with Very Large Tables Like a Pro in SQL Server 2014 |
| 07-11-2014 16:00 | Melissa Coates | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Administering and Managing the Power BI Environment |
| 07-11-2014 16:00 | Hugo Kornelis | General Session (75 minutes) | Application & Database Development | T-SQL User-Defined Functions, or: Bad Performance Made Easy |
| 07-11-2014 16:00 | Pam Lahoud | General Session (75 minutes) | Application & Database Development | Built for Speed: Database Application Design for Performance |
| 07-11-2014 16:00 | Julie Smith, Scott Currie | General Session (75 minutes) | BI Platform Architecture, Development & Administration | A New Approach to Unit Testing and Integration Testing in SSIS |
| 07-11-2014 16:00 | Martin Cairney | General Session (75 minutes) | Enterprise Database Administration & Deployment | Thinking Out of the Box: Manage SQL Server Using Built-in Tools |
| 07-11-2014 16:00 | Michael Frandsen | General Session (75 minutes) | Enterprise Database Administration & Deployment | High Performance Infrastructure for SQL Server 2014 |
| 07-11-2014 16:00 | John Stuchly | General Session (75 minutes) | BI Information Delivery | Poor Man's Dashboard: Modular Dashboard Design in SSRS |
| 07-11-2014 16:00 | Timothy McAliley, Michael Ray | General Session (75 minutes) | Enterprise Database Administration & Deployment | Who Dunnit? A Walk Around the SQL Server 2014 Audit Feature |
| 07-11-2014 16:00 | Amit R S Bansal | General Session (75 minutes) | Enterprise Database Administration & Deployment | Mind Your IO: Resource Governor Shows You How |
| 07-11-2014 16:00 | David Klee | General Session (75 minutes) | Enterprise Database Administration & Deployment | Achieving Peak Performance from your Virtualized SQL Servers |
| 07-11-2014 16:00 | Kevin Kline | General Session (75 minutes) | Professional Development | Irreplaceable: Techniques to Fireproof Your IT Career |
| 07-11-2014 16:00 | Dmitri Korotkevitch | General Session (75 minutes) | Application & Database Development | Windows Azure: An Unexpected Journey |
| 07-11-2014 16:00 | Janet Yeilding, Dipanjan Banik | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deep Dive into Azure Stream Analytics |
| 07-11-2014 16:00 | Binh Cao, Tomas Polanco | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Just in Time Data Analytics with SQL Server 2014 |
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In this full-day pre-conference session, you'll learn how to investigate and interpret wait and latch statistics and learn practical techniques you can take home and start using immediately. You'll also learn what a myriad of wait and latch types actually mean and how you can investigate lightly-documented types to gain insight into what causes them.
Don't waste time when it comes to performance troubleshooting; wait statistics are the fastest route to understanding your problems and this workshop will help you get there faster.
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
We will do this through a series of labs that the audience can follow along with. These labs and demos will showcase how to make big data real for the enterprise. That means something for the architects with on-demand compute and analysis, something for operations with real time operational streaming and analytics, predictive analytics for the analysts and development, and BI integration for the data developers.
Each student will build a new environment setting up these scenarios so they can take the examples back to their own firm and use them the next day. This is a real development and architecture coaching and training session that will leave attendees excited about all that these technologies can do to modernize their data architecture.
We will also provide coverage of new innovation areas such as Stinger, Spark, and other new technologies that make this ecosystem more valuable to the modern data professional.
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
The day will start with an introduction to PowerShell, basic useage, and cmdlets. Next, we'll dive into programming scripts in PowerShell, starting with the basics of loops, conditional logic, and functions, and moving right along to creating your own reusable modules. The real meat of the day comes when we learn how to interact with SQL Server from PowerShell.
Both the SQL Provider and SMO (SQL Management Objects) DLL library will be covered in full. Most importantly, you'll learn how to read the online SMO library documentation and how to convert the examples into PowerShell syntax.
The day will culminate by building a reusable module for working with many SQL Server common tasks, such as T-SQL code generation, or performing health checks on your servers. Don't be left behind! Learn how to leverage the power of PowerShell in your SQL Server environment.
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In this full-day seminar, Kalen Delaney (a SQL Server MVP for over 20 years) will show you how SQL Server 2012 manages concurrent operations to understand where there is room for improvement. We’ll look at the completely new data structures for In-Memory OLTP to see how SQL Server 2014 can provide lock-free and latch-free data processing.
This session we’ll discuss what gets written to disk during checkpoints, as well as what gets logged. Kalen will explain how the recovery process recreates your memory-optimized tables. Finally, she’ll go into detail on just what it is that makes In-Memory OLTP so much FASTER!
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This full-day seminar is dedicated to correct understanding of T-SQL querying fundamentals. You will learn about the principal elements in the foundations of the language. You will learn about logical query processing—what I find to be the most critical aspect of T-SQL that any T-SQL practitioner should master. Then the seminar covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators. If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions.
Know your T-SQL querying fundamentals well, and then tackling advanced problems will be so much easier.
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
In this powerful yet entertaining full-day pre-conference session, we will start with two different database professionals with two different skill sets. The speakers both have very different ways of approaching a project (and are both set in their ways!), but both have the same measurable goal. Whose process runs faster? Join this session and see the results.
In other words . . . “Let’s get ready to Rumble!”
What may appear as the end of the session is really only the beginning as variables and limitations are added and various questions are answered: What happens to our project when we are forced to use GUIDs (Globally Unique Identifiers), or when we push our solution to the cloud? Does the introduction of new hardware improve the overall outcome of our test? Do we see faster performance with SQL Server 2014 over SQL Server 2012? Join us and find out!
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
This full-day pre-conference session is dedicated to Tabular Modeling in Analysis Services 2012 and is the best way to learn this new technology directly from two SSAS Maestros who have used the product since the early beta releases, and who have written a book and many articles on this topic. No knowledge of previous versions of Analysis Services and UDM (Unified Dimensional Model) is required, because Tabular is based on different concepts and on the new DAX language. As an attendee, you will learn the best practices of creating Tabular data models by using the right techniques to design entities and relationships of the business model, optimizing the memory consumption, as well as the performance.
This full-day session will also cover features that affect presentation (hierarchies, table and column properties, formatting) and topics related to deployment, security, and partitioning.
Event Date: 03-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
In this session, we’ll cover the predictive analytics process from beginning to end, and by the end of the day you’ll have a practical understanding of how to develop predictive models for your data.
The session includes an overview of predictive modeling concepts and terminology, followed by the opportunity for you to complete actual predictive modeling exercises throughout the day using Excel and Visual Studio. You’ll see how to fine-tune and compare results using various algorithms, and how to make the best use of the models within your enterprise.
The session also provides brief coverage of popular data mining alternatives to understand what Microsoft provides in comparison with tools such as R, Python, and Weka.
Session Outline
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
• The real difference between FCIs and AGs – one of the sources of confusion since they both use an underlying Windows Server failover cluster (WSFC) • Planning a WSFC for an AG deployment, including things like networking and hybrid scenarios that involve the cloud • WSFC quorum for AGs • Failure scenarios and how to recover from them • Tips, tricks, and best practices for deploying AGs and their administration
This session will include hands-on lab exercises. Please bring your own internet enabled device. Further information on specific device/connection requirements will be sent 30 days prior to the session.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This full-day pre-conference session starts with an overview of CPU scheduler internals from the perspective of both Windows and the SQL Server Operating System (SQLOS). Next, you will learn about intra-query parallelism, the method that SQL Server uses to break up large tasks into many smaller pieces, so that each piece can be processed simultaneously. You will come to understand how to read parallel query plans and how to interpret parallel wait statistics, as well as best practices for the various parallelism settings within SQL Server. Finally, you will be introduced to techniques for exploiting parallelism at the query level: patterns that can help the optimizer do a better job of parallelizing your query.
After attending this pre-conference session, you will be in full control of your CPUs and be able to compel your server to use every clock tick to your end users' advantage.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
During this one-day workshop, the authors of the best seller books Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model and Building Data Models with Power Pivot will guide you in the process of learning the DAX language, through many examples and scenarios that will help you understand the important concepts of DAX and how to leverage them in the everyday work. The workshop is useful to many profiles: Information Workers interested in exploiting the many interesting features of PowerPivot for Excel 2013 and BI developers who want to learn the DAX language.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In this full-day session join two SQL Server Microsoft Certified Masters, Principal PFE Denzil Ribeiro and Senior PFE Tim Chapman, as they tackle various challenging customer scenarios they've encountered. The class will start with developing a general performance troubleshooting methodology, which will include topics such as wait statistics, extended events, perfmon, DMVs, pssdiag, SQL Nexus. The rest of the day will cover hands-on troubleshooting of real performance problems. Customer problems will be reproduced and you will be involved in solving them , so expect an interactive class! Scenarios will relate to SQL Server 2008 - 2012 including how some of these are alleviated in SQL 2014.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This full-day session takes you through everything you need in order to tune your queries. We’ll start with establishing an understanding of how the optimizer works, move through methods for capturing query performance metrics, and then step through methods of fixing common problems. We’ll take advantage of the tools offered by Microsoft, such as Dynamic Management Objects, Query Execution Plans, and Extended Events.
We'll also spend some time understanding the new performance tuning capabilities introduced with SQL Server 2014 including enhancements to cardinality, native compiled procedures, and in-memory data tables.
You’ll leave this session with a better understanding of how to identify and fix poorly performing queries that you can apply immediately on your own systems.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
The session will start out with one of the most common challenges in ETL: data warehouses. We will show you a variety of competing patterns to load your dimensions and facts more efficiently and discuss the pros and cons of each. You’ll learn how to use SQL Server Change Data Capture integration into SSIS (CDC) and incremental loads to effectively load your data warehouse in the fastest way possible.
One of the most common design patterns needed is how to deal with duplicate data. The speakers will show an end-to-end solution to scrub duplicate data and give rows a scoring system to sift out the best records. You'll also see a number of advanced patterns for lesser-used tasks in SSIS like Term Extraction and Data Mining Transform.
These are just a few of the patterns that we will be demonstrating. With all of the solutions shown, you will be given an end-to-end project with all the packages and data. You'll come out of the session with a lot of options on how to do your ETL job.
Remember to bring your laptop since you’ll be able to work with the speakers on many of the patterns.
Also, please note that you will want to have at least beginner SSIS experience for this session.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
The aim of this session is to excite you with the potential of Microsoft's new self-service suite of BI products and collaboration platform, called Power BI. You will learn about four “Power” authoring products available in Excel and how they function to discover, acquire, transform, relate, and enrich data for analysis and reporting. Topics include Power Query, PowerPivot, Power View, and Power Map.
You will also learn how to effectively share and collaborate on Power BI solutions in the cloud with Office 365. Topics include data refresh to on-premise data, the data catalog to search for data queries, natural language query (Q&A) to intuitively query data, and a mobile application for Power BI.
This session has been designed to provide perspective across the Power BI story. Theory and an end-to-end series of real-world demonstrations will allow you to appreciate how the Power BI products span on-premise and cloud environments and how they attain super-strength as they work together.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
The only way to do this is to have a clear idea of its architecture, understanding the concepts of measures and dimensions, and a proven engineered way to build it so that quality and stability can go hand-in-hand with cost reduction and scalability. This will allow you to start your BI project in the best way possible avoiding errors, making implementation effective and efficient, building the groundwork for a winning Agile approach, and helping you to define the way in which your team should work so that your BI solution will stand the test of time.
Event Date: 04-11-2014 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In order to be ready to fully use Extended Events when you walk back into the office after PASS Summit, we'll provide a full day of training where you will learn what Extended Events are, how they work, and how to create XE sessions that capture the data you need while minimizing the impact on system performance.
In addition, we'll step through complex issues using advanced troubleshooting so you can see how XE will help you solve problems that you couldn't with Trace. This is your opportunity to learn exactly what you need to start using Extended Events in your SQL Server 2012 and 2014 environments.
Event Date: 05-11-2014 08:15 - Category: Keynote (90 minutes) - Track: Cloud Application Development & Deployment
In this session you will hear from the Microsoft Data Platform engineering leadership team about recent innovations and the journey ahead for Microsoft’s data platform. Learn first-hand how customers are accelerating their business through the many innovations included in SQL Server 2014 from ground breaking in-memory technologies to new highly efficient hybrid cloud scenarios. See how customers are revolutionizing their business with new insights using Power BI and Azure Machine Learning and Azure HDInsight services. Learn about the investments were are making Microsoft Azure across IAAS and PAAS to make it the best cloud hosting service for your database applications.
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers.
You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Scenarios such as Market Basket Analysis and predictive analysis will be covered with live demos. You will also learn how to validate models against test data set with accuracy charts. Lastly, you will learn how to use DMX queries in .NET applications and bring data mining features into your custom application.
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately after the session.
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe you have been tasked with finding out about the cloud. Join me in exploring the cloud where I will show you how SQL Server works in the Microsoft Azure SQL Database world. We will run through the simple process of configuring a Microsoft Azure SQL database, and then we’ll discuss the similarities and differences between on-premises SQL Server and Microsoft Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Microsoft Azure.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session, delivered by an SSIS architect and a .Net architect, presents a lifecycle for developing .Net scripted solutions within SSIS and custom tasks with .Net.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and "big data.” Although we'll talk about basic techniques for querying data, the focus is on basic understanding how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster.
You won't walk out of this session a Hadoop administrator, but you'll understand what questions to ask and where to start looking for answers.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: Application & Database Development
You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to make your SQL Server Pop with PowerShell.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
We will explore the following questions: What is Power BI? What do you need to run Power BI? How does Power BI differ to traditional BI? Where does Power BI fit in a broader enterprise BI strategy? And, finally, how can on-premises data sources be used in cloud-based Power BI solutions?
In addition to answering these questions, we will build a Power BI solution from scratch using both on-premises and cloud-based data sources. We will use Power Query, Power Pivot, Power View and Power Map, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q & A, the new natural language query technology.
Event Date: 05-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Learn why you shouldn't obsess over defragmenting indexes or updating statistics, see a demo of troubleshooting parameter sniffing, and discover why query hints aren't the best problem solvers.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this talk, we will dive into the details of Hadoop on Windows by exploring each of the components and their functions within an Enterprise Hadoop distribution. We will also discuss some of the common use cases, applications, and data types that are being enabled with this new capability.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
After reviewing the available features, we’ll take a look at how to configure these features and how to build these features out in the real world in order to reduce your data center footprint quickly and easily.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will learn what it takes to successfully architect and design SharePoint 2013 as a BI platform. We will cover multiple configuration scenarios and the different technologies necessary to build the infrastructure. At the end of the session, you can walk away feeling confident to run Power Pivot, Power View and Reporting Services in your SharePoint 2013 farm.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 13:30 - Category: Half-Day Session (3 hours) - Track: BI Information Delivery
We will look at the following technologies in an end-to-end environment: R Power Pivot Power Query Power View Power Map Excel The end result is that we will look at creating dashboards in Power BI tools and Excel.
To summarize, this session aims to deliver a breadth of data visualization knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualization, and translated into Microsoft Power BI functionality.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly “right-size” the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Demos will cover PAGELATCH contention (and lack thereof), use of non-persistent in-memory tables for ETL and in-memory tables as “shock absorbers” for high throughput environments.
For each case we will do a comparison of "Classic" vs. in-memory, what gains the audience can expect, and what patterns will yield the biggest benefits.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will answer these questions by taking a case study approach. Different data sets will be studied and we will see how different charts bring out different aspects of the data. Perhaps more importantly, we will take a look at which charts don’t really show anything interesting at all. Time will also be spent looking at the differences between using charts in reports and dashboards as opposed to visual analytics.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, we will go over the architecture and internals of Azure SQL Database and then focus on resource management techniques incluload balancing, engine throttling, using resource governor to isolate load on physical machines. We will go over resource limitations on Azure SQL Database like memory usage, database size, transaction duration and Temp DB usage. We will conclude with best practices for seamless user experience on Azure SQL Database.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will discuss and demonstrate some of the ways in which you can make this process easier and more of a day to day task than it has historically been. Looking at what tools and processes we can use to strengthen our case for an upgrade or just how to make sure that we have sized a system appropriately.
I will cover how I have upgraded and migrated to the latest versions of SQL Server all the way from SQL 2000 up to SQL 2012, what the gotchas are and how to avoid getting bitten so that you can be confident that you will have a successful migration or upgrade too.
Join me as we work through upgrading a number of SQL Servers, avoiding the pitfalls along the way.
Event Date: 05-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this introductory session, you will learn the fundamentals of HDInsight and Hadoop, you'll see how to provision your own cluster in minutes, and you'll know how to put the cluster to work by the end of the session. Practical examples that show clustering techniques and text analysis of unstructured and semi-structured data will be shown allowing attendees to implement their own cluster with minimal administration overhead.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn about best practices in how to analyze and resolve latch and spinlock contention for your performance critical workload. We will also discuss lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn what SSIS is and which components it consists of. You will also learn how to use the SSIS catalog, which is new in SQL Server 2012, to track the execution of the package, as well as how to troubleshoot packages when they fail or cause problems.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 15:00 - Category: Lightning Talk (10 minutes) - Track: Professional Development
Lightning Talks 101 focuses on the DBA track, featuring:
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) will be covered, in addition to T-SQL scripting opportunities to automate processes.
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 Master Data Services can achieve.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will provide you with a road map for succeeding as a DBA. We will cover all of the basics that the typical DBA needs to know and focus on day one and year one. By the end of this session, you will know what is important and should be on your daily task list and what you can ignore. With data is growing exponentially and you have lucked out if you truly like being a DBA because the sky is the limit.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Learn more about the new data platform categories like document, key/value, columnar, and graph. We'll discuss where ACID is king, and when BASE rules, and how the CAP theorem is applied with more common NoSQL implementations like HBase, MongoDB, Cassandra and Hadoop.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will discuss some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. You'll learn about the backup "execution plan" and how to access it. Understanding how to tune the individual portions of your backup process will allow you to knock 80% and even more off of your backup and restore time. Sean McCown won’t be holding anything back in this session. This is a method he’s used for 15 years to tune his backups and has had great success.
Event Date: 05-11-2014 15:00 - Category: Half-Day Session (3 hours) - Track: BI Information Delivery
We will look at the following technologies in an end-to-end environment:
R Power Pivot Power Query Power View Power Map Excel
The end result is that we will look at creating dashboards in Power BI tools and Excel.
To summarize, this session aims to deliver a breadth of data visualization knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualization, and translated into Microsoft Power BI functionality.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Also, learn about the architecture of Power View and related components, and about the different flavors of Power View (Power BI in Office 365 vs. on-premise, Excel desktop vs. Excel Web App vs. Power View Web App) and their differences. If you’re eager to gain a deeper understanding of Power View, don’t miss this session!
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Using different hardware might lead you to different conclusions, and the size of the workload is always the central aspect of your performance.
Loading data first and then creating a Clustered Columnstore, or creating Clustered Columnstore and then loading? Join me to find the answers!
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Professional Development
Learn how to create a culture in your organization or team that will help you retain employees and help your team stand out. Learn from some of the mistakes that most leaders make when starting a company. Finally, learn how to turn your idea into reality and grab your first customers.
Event Date: 05-11-2014 15:00 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
This half-day session will showcase all of SQL Server’s DR features in this hybrid model, as well as environments built only in Microsoft Azure. You will learn about off-site direct to Azure backups from your local SQL Server, and you will gain an understanding of the networking model within Azure. We will also look at demos of log shipping, replication, mirroring, and Availability Groups in a hybrid model.
You will walk away with a solid understanding of AlwaysOn functionality within Microsoft Azure VMs, the costs, benefits and limitations of building a DR solution using Azure, and how Azure based backup and recovery works.
Event Date: 05-11-2014 15:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come to this session to learn when recompilation is warranted. And, more importantly, how to choose to do it selectively and only for the combinations of parameters that really need it. Create the right balance of CPU / recompilation with a programming strategy that also simplifies the overall number of procedures needed. If you create stored procedures and want better performance, this is the place to be!
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
You can save development time by adapting an existing DAX pattern to your specific scenario. This session will present a set of fundamental patterns you have to know in DAX, because they are used very often in many business scenarios and are already tested and optimized. This knowledge will save you from the effort of choosing between different possible optimizations.
Event Date: 05-11-2014 16:30 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
This half-day session will showcase all of SQL Server’s DR features in this hybrid model, as well as environments built only in Microsoft Azure. You will learn about off-site direct to Azure backups from your local SQL Server, and you will gain an understanding of the networking model within Azure. We will also look at demos of log shipping, replication, mirroring, and Availability Groups in a hybrid model.
You will walk away with a solid understanding of AlwaysOn functionality within Microsoft Azure VMs, the costs, benefits and limitations of building a DR solution using Azure, and how Azure based backup and recovery works.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Professional Development
Hiring is one of the most important things a leader does. A good fit strengthens your team; a hiring mistake is costly to everyone. In this session, we’ll explore proven techniques for interviewing and identifying the best person to join your team.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Application & Database Development
For the incredibly low price of absolutely free, you will learn multiple techniques for applying Indexing to your ailing queries. Return your queries to the youthful vim and vigor they had when there was only a little data in the database.
You too can amaze and astound your friends and coworkers by applying Indexing. Become the office hero. I'll show you how. I'll teach you three easy methods for indexing:
Don't wait! Act now!
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience will select topics that we’ll cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: if you are not aware of them, you might GRANT or DENY more permissions than you intended.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will give you a beginning to end view of what is needed to create Power View reports from organizing a Power Pivot source to preparing the actual Power View report.
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 05-11-2014 16:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you'll also learn about the relationship across the security settings in the BI tools, backend databases, and the Windows operating system. Building on this foundation, you'll learn what steps are necessary to apply security best practices in each component of the Microsoft BI stack.
Event Date: 05-11-2014 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 06-11-2014 06:45 - Category: General Session (75 minutes) - Track: Professional Development
For more information, visit: http://discover.us.sios.com/event-reg-pass-summit-2014-sios-sandisk-breakfast-session-pass-the-bacon.html?LeadSource=lp-pass-passbkfst-1114
Event Date: 06-11-2014 07:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 06-11-2014 08:15 - Category: Keynote (90 minutes) - Track: Cloud Application Development & Deployment
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We will discuss how to look for CPU performance issues at the host level. We will also be looking at the Memory Balloon drivers and what they actually do, as well as how you should be configuring them and why.
We will then talk about some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server, and we’ll finish up the session with some storage configuration options.
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, you will learn more about the top functionality of M that does not exist in the GUI, but is very helpful in ETL implementation. Features such as error handling, working with generators, and custom functions will all be discussed.
You will also see lots of real-world live demos, one of which will be sample a date dimension with fiscal calendar attributes and public holidays fetched live.
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Join Microsoft SQL Server Certified Masters, Tim Chapman and Thomas LaRock, to learn how to spot common query performance killers and what you can do to make queries execute as fast as possible.
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
The 2012 edition of this talk--one of the most popular sessions at PASS Summit--discussed problems with parallel costing, intricacies of plan selection and execution, and the extremely effective Parallel CROSS APPLY pattern. But these things were just the beginning. Two more years of research have yielded new insights, new techniques, and new performance gains.
In this session, you'll get a quick review of the 2012 content before diving into brand-new costing hacks, tricks for leveraging parallel scans, and a set of SQLCLR functions that will give you more control over intraquery parallelism than you ever thought possible. Get ready: it's time to Manhandle Parallelism all over again.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: Professional Development
Session Takeaways:
Learn top techniques, tips and tricks to maximize your PASS Summit learning experience.
Understand how (and what) you can do within the SQL Community to further your professional career.
Plot your future career moves.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: Professional Development
In this session, you will get lessons learned from the presenter's transition from corporate America to independent consulting. You will get a checklist that helps you do an assessment to determine if independent consulting is for you. We will debunk some common myths about independent consulting. Finally, we will cover some resources, tips and tricks that could help you get a successful start in independent consulting.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
A baseline is often determined to be complete after a number of Performance Monitor data collections, but that’s only the beginning. When the only information available to you are performance counters, how can you determine if there have been changes to the code, or changes to the hardware and configuration? When you alter the way you watch your systems, you increase your ability to solve problems quicker and you also increase the resiliency.
In this session, we’ll look at the tools Microsoft has built a solid baseline for SQL Server 2008 to SQL Server 2014.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will examine these questions and the array of new technologies and tools being used. We will look at specific reporting and analytics scenarios to see what approach to data modeling is best for each scenario. Particular attention will be paid to the role of dimensional modeling with when and how best to use in each scenario. Also, alternative data modeling approaches will be examined.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we’ll talk about providing dynamic report layouts, filtering data based on the user’s credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero.
Event Date: 06-11-2014 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
With the SQL Server Integration Services (SSIS) - since included in SQL Server 2005 - and known as high-performance ETL platform, Microsoft also provides at first glance the ideal platform for this. But is that really the case? How does SSIS metadata and unstructured data get together? In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
Event Date: 06-11-2014 11:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 06-11-2014 13:30 - Category: Lightning Talk (10 minutes) - Track: Professional Development
Lightning Talks 102 focuses on the BIA track, featuring:
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Introduced in SQL Server 2008, Extended Events provides a refreshingly new method of looking at what occurs inside of SQL Server. The expansion of the number of events in SQL Server 2012 made Extended Events a viable replacement for SQL Trace with minimal performance impacts on even the busiest systems. At some point everyone will need to understand how to leverage Extended Events, and this session will get you started on the path to success.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This demo-heavy session will show you never-seen-before methods the speaker has used extensively in the last year to salvage data for real-life clients after catastrophic corruption. You won't believe what it's possible to do!
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can’t be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
How to benchmark performance for specific server configurations using the free tool, HammerDB.
A little-known technique to create a tiny version of large production databases, yet deliver query execution behaviors as you would see in production.
Sneaky DBCC commands which help you replicate a full production server on your simple workstation, as well as how to turn on and off specific query engine optimizations.
Best practices in reading execution plans using the free tool, Plan Explorer.
A variety of T-SQL techniques, including the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, and some weird situations where SQL Server doesn’t use cached plans when it should.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won't be only be about how to fix that problem query, but we'll also talk about how to improve overall performance for all your users.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Topics will include defining an intuitive Power Pivot data model with friendly names, synonyms, comments and data formats; enabling images; defining "automatic" calculated fields (measures) to provide end-user flexibility to aggregate data; and how to appropriately configure the data model reporting properties. Numerous demonstrations will show the before-and-after effects in Power View and Power Q&A when applying configurations to the data model.
In addition, supported native Excel reporting capabilities that will function in Excel Online (via a web browser) will be described, together with an explanation of how to appropriately configure the Browser View Options.
This session is relevant for Power Pivot data model developers and information workers interacting with Power View reports.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Professional Development
What’s the best way to conduct a phone screen? Is it possible to tell a knowledgeable candidate from one who is full of it? Do practical tests prove anything? What are the resume red flags? The panel will cover many aspects of these questions and more in this lively session.
Come for the debate, and stick around to put in your opinions and questions in the final Q&A.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Test-driven development and Continuous Integration are two extremely interesting processes that are used in software development, and they can be also applied to BI solutions in order to bring Agility into the BI field. In this session, we'll see which tools can be used to unit test your solution, how data can be unit tested, and how we can automatically start and test the ETL phase, or a cube process, each time someone checks in a change made to the solution.
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 06-11-2014 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Professional Development
Do you know that you may have left tens of thousands of dollars on the table during your last negotiation? Do you know that you can ask for more than money when negotiating salary? Are you taking vacation just to be here at the PASS Summit?
In this session we will share our experiences working in a range of organizations from very formal giant corporate HR departments, government agencies and small tech startups. You will learn about how your HR organization works, what salary levels and midpoints are, negotiation strategies, when to say "no" and how to say "yes".
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Professional Development
Additionally, we will go over some tips for small talk and conversation; protocol for following up with contacts and staying in touch with your network; tips on how to correctly handle an introduction; and how to build bridges to different networks and the value therein. Attend this session and get the edge on leveraging networking to further your career.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn about Transparent Data Encryption, IPSec, Database Firewalls, Contained Databases and many other technologies that help you lock down your systems and close attack vectors.
This talk puts great emphasis on the biggest threat to your database: SQL injection, offering many remediation techniques to prevent such attacks. During the demos, you will learn techniques to deal with vendors who require SA accounts to run their applications. Protect your SQL Servers without having to wait for your Developers or Vendors to make changes!
Event Date: 06-11-2014 15:00 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
The approach of this talk is to look at the “basic lifecycle” of I/O for database in SQL Server from creating a database, reading database pages, writing to the transaction log, and writing database pages to disk. Behind this approach I will weave in how SQLOS is involved in I/O, Windows APIs, background processes (Ex. checkpoint), monitoring tools, diagnostics tools, error conditions, troubleshooting, trace flags, and more.
In addition the following topics will be covered as they relate to I/O:
• Building Indexes • Altering Databases • Backup/Restore Basics • DBCC • Reading the transaction log • Tempdb • Resource Governor • Shutting down • Cloud Hybrid I/O Scenarios • Hekaton
Come ready to learn and have your brain melted in this fast-paced, fact-filled, and very deep session. This is a 500+ level session and is not for everyone. As with all my “Inside” talks, I will use the Windows Debugger and other tools, have lots of demos, and often talk about Windows APIs. However, even though this is a deep session for folks who love internals, I do present practical information that can help you make informed decisions about the configuration, deployment, maintenance, and operations for your SQL Server with respect to I/O. Even though much of the information I present can apply to older versions of SQL Server, all materials will be presented will be based on the internals of SQL Server 2012 and SQL Server 2014.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Application & Database Development
You'll learn to predict how a new index will change read patterns on the table, whether you need to add the exact index SQL Server is requesting, and how to measure performance improvements from your index changes.
If you're comfortable querying SQL Server's missing index DMVs and looking at an execution plan here and there, this session is for you.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn how to build an agile storage infrastructure that balances private and cloud resources to optimize SQL Server 2014.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 15:00 - Category: Half-Day Session (3 hours) - Track: Application & Database Development
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to avoid cursor solutions and create simpler code by using the windowing functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
You will also learn what you need to know to take full advantage of these features to get great performance. We’ll also discuss which features perform worse or better than older techniques, what to watch out for in the execution plan, and more.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we'll look at common performance issues with large ETL processes and discuss how these process brought to the next generation on PDW. We'll also discuss the techniques and capabilities of PDW in regards to ETL solutions and demonstrate the potential for removing 10s of hours of ETL data processing.
Event Date: 06-11-2014 15:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will help address those concerns. You will learn how Power Query can be easily used to empower business users when discovering, combining, refining and publishing data while allowing IT to leverage self-service tools that fit in their overall architecture portfolio. We will use Power Query to show how business users can solve complex data integration challenges that traditionally rely on IT driven technologies in a way that is intuitive and effective. As a bonus, you may get a free hug from a developer or an end user.
Event Date: 06-11-2014 16:45 - Category: Half-Day Session (3 hours) - Track: Application & Database Development
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to avoid cursor solutions and create simpler code by using the windowing functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
You will also learn what you need to know to take full advantage of these features to get great performance. We’ll also discuss which features perform worse or better than older techniques, what to watch out for in the execution plan, and more.
Event Date: 06-11-2014 16:45 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
The approach of this talk is to look at the “basic lifecycle” of I/O for database in SQL Server from creating a database, reading database pages, writing to the transaction log, and writing database pages to disk. Behind this approach I will weave in how SQLOS is involved in I/O, Windows APIs, background processes (Ex. checkpoint), monitoring tools, diagnostics tools, error conditions, troubleshooting, trace flags, and more.
In addition the following topics will be covered as they relate to I/O:
• Building Indexes • Altering Databases • Backup/Restore Basics • DBCC • Reading the transaction log • Tempdb • Resource Governor • Shutting down • Cloud Hybrid I/O Scenarios • Hekaton
Come ready to learn and have your brain melted in this fast-paced, fact-filled, and very deep session. This is a 500+ level session and is not for everyone. As with all my “Inside” talks, I will use the Windows Debugger and other tools, have lots of demos, and often talk about Windows APIs. However, even though this is a deep session for folks who love internals, I do present practical information that can help you make informed decisions about the configuration, deployment, maintenance, and operations for your SQL Server with respect to I/O. Even though much of the information I present can apply to older versions of SQL Server, all materials will be presented will be based on the internals of SQL Server 2012 and SQL Server 2014.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will provide a solid understanding of what makes up an MDX query and will give you the tools and confidence you need to create your own custom queries.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In SQL Server 2008, Microsoft finally gave us a true auditing tool. But, how does it work, what exactly can it track, and how will you handle its output?
In this session, we'll cover SQL Audit from the ground up. We’ll go from the basics of creating a database or server audit, all the way to using PowerShell to manage it at the enterprise level.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, we’ll take a look at how to leverage multiple features of SQL Server, such as Semantic Relevancy; Full Text Search; Blobs; and Spatial Data Types to build the foundations of our Social Analytics Platform.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This is a demo-rich session and all demos will be covering practical SQL Server related solutions.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we will show how to instead use a metadata database to store the requirements information, and then use this metadata to automatically generate EVERYTHING you need for your data warehouse project: documentation, schemas, SSIS packages, deployment scripts, etc. The code for the solution, which is presently in use in production data warehouses in major international companies, will be provided for all attendees to freely use.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In just one session, you'll learn the basics of performance troubleshooting, backup, index tuning, and security. Brent Ozar, recovering developer, will teach you the basic care and feeding of a Microsoft SQL Server 2005, 2008, 2012, or 2014 instance and give you scripts to keep you out of trouble.
Event Date: 06-11-2014 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, Erin Stellato will show you how to focus on particular patterns you can apply that take the guessing out of plan-based tuning. There are good things to look for, as well as bad, and these patterns will help you develop a methodology to accelerate both your confidence with reading plans and the performance of your queries.
Event Date: 06-11-2014 17:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will help to dispel some of the big data confusion, and we will focus on HD Insight, Microsoft's Hadoop based implementation. Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on. This is one of the keys to successfully selling management on the needs for a big data solution. It's not just another database, it's a tool to enhance existing analytic structures.
During this session, we'll start with a brief overview of Hadoop and HDFS. Next, we'll take a look at HD Insight, and explore some of the features therein.
Finally, integration with SSAS and Power View (using Excel 2013) will be shown, which will close the loop on big data visualizations.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, you'll learn how design and configuration choices put pressure on your report server and techniques to relieve that pressure. You’ll see how to configure your Reporting Services databases for speed, streamline your subscription schedules, and use caching for high-demand reports. You'll also learn some design strategies to lighten your report processing load. If you want to maximize the speed of your Reporting Services environment and minimize the pain of performance tuning, this session is for you.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. You learn how to implement new features added in SQL Server 2014 to improve table partitioning. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
Event Date: 07-11-2014 08:15 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Different approaches will be examined by their impact on caching, connection time, and maintenance. By the end of the session, you will understand why it can sometimes make sense to have 2000+ dynamic roles in your SSAS cube!
A major part of the session will be dedicated to dynamic security using SSAS assemblies, which is often the last hope for complex requirements. This session will guide you through the most common and uncommon pitfalls that you will encounter and show how to work around them.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. In this session, we’ll be dispelling these misconceptions and demonstrating how dynamic SQL can become a part of every DBA’s tool kit.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we are going to check how different algorithms for comparing strings included in SQL Server 2012 and SQL Server 2014 work. We are going to use Soundex Transact-SQL function, four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services.
Finally, we are going to introduce how SQL Server 2012 Data Quality Services (DQS) help us here. We are also going to tackle the performance problems with string matching merging.
Event Date: 07-11-2014 08:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will cover multiple versions of Windows on how to approach, configure, and manage quorum, including how to force quorum if necessary.
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
Event Date: 07-11-2014 09:45 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available.
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this interactive session, the Data Catalog team will review the capabilities of the catalog today, and will present the plans for evolving the Data Catalog moving forward. These plans include integrating data publishing and discovery into additional application experiences, with the catalog providing a platform for EIM services.
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: Application & Database Development
This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required. Even in SQL Server 2014, Service Broker lacks a UI integration, which is sometimes a road block for implementations. Not to worry, this session will show you how to configure Service Broker correctly the first time so you can develop easy, foolproof deployments to solve complicated problems.
Event Date: 07-11-2014 09:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This course will show how someone with basic programming skills can leverage EzAPI to develop those same packages programmatically in minutes with fewer than 50 lines of code.
Demos scripts will cover creating 300+ packages in under 5 minutes or dynamically building out the load packages to populate a Type 2 Slowly Changing Dimension in hours instead of weeks.
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and sparklines focus attention on what is important to the viewed data set.
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Professional Development
This session will cover an introduction to Agile methodologies (with a focus on Scrum), what you will need to do to make it work for Business Intelligence projects, and common challenges that you will need to consider. This “from the trenches” presentation will also cover real world examples of projects where this approach was extremely successful, and a few that weren't.
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session seeks to fill in some of the gaps that might exist by looking in-depth at the three types of join operations. We’ll visualize how the join operations’ algorithms work so you can understand how query plans are computed, and then we’ll look at why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. You’ll see through demonstrations that empirical cost calculations are similar to what the query optimizer actually returns.
Event Date: 07-11-2014 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this highly-interactive, demo-focused session, the presenter will guide you through several real-world examples that show how the Resource Governor should be used and a couple of examples that show the opposite. Please join us for a fun- and fact-filled whirlwind tour of the resource management tools built right into SQL Server.
Event Date: 07-11-2014 13:00 - Category: Lightning Talk (10 minutes) - Track: Professional Development
Lightning Talks 103 focuses on the AppDev and Professional Development tracks, featuring:
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Application & Database Development
After discussing temporal problems, we are going to develop interval CLR data type that supports validity time. Then we are going to talk about what kind of constraints pertain to temporal data, and how we can implement those constraints. We are going to use T-SQL to develop two very useful temporal operators: PACK and UNPACK. In addition, we are going to introduce the proposed sixth normal form that deals with temporal data, and show how you can implement it correctly.
Event Date: 07-11-2014 13:00 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Come learn about how to plan, implement, and track your Self-Service BI environment in SharePoint 2013 that’s most intuitive for your user base. Also come to understand how each reporting tool’s deployment model works so you can manage Dev and UAT environments effectively. We’ll review how to analyze adoption with the Power Pivot Management Dashboard and provide tips on additional SharePoint features that will assist any organization in making the transition; from Personal BI to Team BI, to Corporate BI and back again.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Professional Development
This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design, build, and prep the presentation, and * Pitch your topic to a conference or user group and get scheduled.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Professional Development
Thomas LaRock – President Adam Jorgensen – Executive Vice President Denise McInerney – VP, Marketing Bill Graziano - Immediate Past President Amy Lewis - Director, PASS Programs James Rowland-Jones - Director, PASS Global Growth Jen Stirrup - Director, PASS Virtual Chapters Sri Sridharan - Director, PASS Volunteers Tim Ford - Director, PASS SQLSaturday Wendy Pastrick - Director, PASS Global Chapters Sanjay Mishra, Board of Directors, Founding Partner Jennifer Moser, Board of Directors, Founding Partner
Meet Board members and hear the latest on everything from PASS events, initiatives, and member benefits to processes, governance, and more. Don't miss this chance to make your voice heard.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Application & Database Development
This session will provide introduction to Apache HBase and describe capabilities of HBase clusters available in Azure HDInsight service. It will focus on how this technology can be used to build real-time big data apps. The techniques will be demonstrated on the real-time social sentiment analysis app. The app will be decomposed, it’s architecture, key elements and decision points explained.
Event Date: 07-11-2014 13:00 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
After this session you’ll know the answers to all of these questions! Plus learn how in the HECKaton SQL Server 2014 affects what you’ve just learned!
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, we will show data governance best practices and what capabilities for data governance Power BI has in place. In addition, we’ll discuss how you can enhance your self-service BI landscape with Master Data and Data Quality Services for improved governance.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this exciting session, we will discuss administration, configuration, and installation of both SQL 2014 and ServerCore in both standalone and advanced AlwaysOn configurations. But will the lack of GUI support send Server Core in the same direction as the Dragon32, or spell a bright new beginning for Server based computing and SQL Server? Join this session to find out, and, this time, listen to the Dragon roar!
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will show how Power Query can be easily used to take advantage of data's properties to drive the change we need to support our goals.
We will discuss/demonstrate: -- The simple process of accessing a wide variety of data sources -- The ease with which simple transformations can be achieved using the Power Query Ribbon -- Power Query's fantastic ability to travel through time to see every step taken with the data -- The foundations of the Power Query Formula Language, informally know as "M" -- Using "M" to take Power Query WAY beyond what the Ribbon has to offer.
Come learn about what may well be the most exciting member of the Power BI family.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we’ll look at the methods which the query optimizer uses to generate accurate, and sometimes not so accurate, row counts for operators in a query plan. We’ll take a look at some of the common causes of row estimation errors and what can be done about them.
We’ll finish up by looking at the changes introduced in this area with SQL Server 2014.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Application & Database Development
We’ll also discuss deployment practices with SQL Server Data Tools, how to write tests with tSQLt, and test the things that are traditionally very difficult to test, like ever-changing data. In additions, we’ll take a look at how to mock databases for stored procedures. And finally, we’ll talk about the various ways where we can put a database into a continuous integration environment.
If you don't understand the importance of these practices, we'll be explaining them in the first 30 minutes, followed by demonstrations on how to include the database in these practices for the rest of the time.
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 13:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
But, how do you know which tool will best serve your purpose, or what factors are even important in making this decision? In this session, we’ll identify factors to consider when deciding which tool to use to visualize your data in maps such as system/software requirements, internet connectivity requirements, availability and type of location data, required level of technical understanding, and more.
We’ll also explore the requirements and features of maps in Power Map, Power View, Reporting Services, and the Bing Maps add-in for Excel. You’ll leave this session knowing your options for creating maps and confident in your ability to choose the best path/tool within Excel and SQL Server.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this presentation, Karen Lopez shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions by using real-life evidence of her own data in your systems. There may be snark and humour involved.
She will leave you with 10 tips for avoiding embarrassing, public-facing data #FAILs in your database designs.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
What’s worse, you have also increased the number of indexes, index storage, and turned your data warehouse into a maintenance nightmare in the process.
In this session, learn how updateable column store indexes in SQL Server 2014 improve query performance, as much as 10x faster, while reducing the number of indexes, lowering index storage and maintenance overhead in your data warehouse.
Jose Chinchilla will demonstrate how to configure and maintain updateable column-store indexes along with best practices and tips to improve query performance in large fact tables with over 1 billion rows.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Application & Database Development
This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans.
The information presented will be immediately applicable on the queries you have running back in the office.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual lab on your own machine.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2014 14:30 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Come learn about how to plan, implement, and track your Self-Service BI environment in SharePoint 2013 that’s most intuitive for your user base. Also come to understand how each reporting tool’s deployment model works so you can manage Dev and UAT environments effectively. We’ll review how to analyze adoption with the Power Pivot Management Dashboard and provide tips on additional SharePoint features that will assist any organization in making the transition; from Personal BI to Team BI, to Corporate BI and back again.
Event Date: 07-11-2014 14:30 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
After this session you’ll know the answers to all of these questions! Plus learn how in the HECKaton SQL Server 2014 affects what you’ve just learned!
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. We will discuss a case study with some shocking results as to what you may have to do to configure and scale analysis services.
As bonus content, we also do the same case study on load testing the tabular model, and how to compare and optimize its concurrency and scalability.
Sample source code and configuration notes will be supplied to help you load test analysis services. We will be discussing both the MOLAP (Multidimensional Online Analytical Processing) and the Tabular models.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we'll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 14:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
During this session, we’ll discuss several methods for handling scenarios that require you to redo work in your data warehouse. We’ll cover both recovering from failed loads and rolling back changes that completely successfully, but later need to be reverted. We’ll demonstrate how you can use SSIS in conjunction with SQL Server database engine features to build support for this into your ETL framework. We’ll also show the process for actually recovering in these scenarios.
Event Date: 07-11-2014 14:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
SQL Server 2014 offers several new features that can make all these challenges go away. In this session, we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation, and Delayed Durability, and we will apply them on our challenging table and see what happens.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources and how those OData feeds affect Enterprise Data Search functionality.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic. All code will be shared with attendees for free and unrestricted use within their own projects.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Policy Management, Data Collector and Extended Events, all included in both Enterprise and Standard Editions, provide a framework to keep your configurations consistent and give you some insights into the performance of your SQL Server instances. In this session, we will see how to make use of these components to formalize your configuration and track some performance attributes.
After this session you’ll be able to build out an effective management and monitoring toolkit using only “out-of-the-box” features.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will discuss the new storage features in Windows Server 2012 and R2 and how they relate to SQL Server 2012 and how SQL Server 2014 expands on this.
In working with the Core Windows Server team in Redmond during the development of Windows 8/2012 and 8.1/R2, the presenter did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about InfiniBand, SMB, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more.
Having worked on the development of SQL Server 2014 and Win8.1, the speaker will share completely new concepts of integration between SQL Server and modern hardware.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
The concept was designed and delivered as an operational dashboard to an executive team, and displayed both on desktop monitors and 50' screens for continual business monitoring. We will show the creation of a dashboarding template, or canvas, which is the framework for delivery. We will then create multiple data sources, spanning relational, multidimensional, and SharePoint lists, which will be used to populate our widgets.
We’ll create a drill report to provide interactivity to the dashboard, and dataset scheduling and autorefresh options will be covered as well. We will bring it all together and present an effective dashboard and have a modular process for creating additional dashboards and shared widgets.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, you will learn to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: Application & Database Development
The session shares real-life experiences of converting an on-premises OLTP system that handles about 10,000 TPS to the Microsoft Azure PaaS platform. We will discuss various architectural challenges encountered during conversion and approaches to address them. The following topics will be covered:
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2014 16:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration