| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 26-10-2015 08:30 | Argenis Fernandez, J May, David Klee | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | The Complete Primer to SQL Server Virtualization |
| 26-10-2015 08:30 | Tim Mitchell | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Building Better SSIS Packages |
| 26-10-2015 08:30 | Paul Turley, Richard Waymire, Jim Miller, Ron Talmage, Tim Chapman | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Upgrade, Migration and Bacon Planning for SQL Server 2014 and 2016 |
| 26-10-2015 08:30 | Pinal Dave | Pre-Conference Session (full day) | Application & Database Development | 42 Tips to Performance Tuning, Optimization, and Everything |
| 26-10-2015 08:30 | Stacia Varga | Pre-Conference Session (full day) | BI Information Delivery | Visualizing Data: the Good, the Bad, and the Ugly |
| 26-10-2015 08:30 | Allan Hirt | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Advanced SQL Server Availability Architectures and Deployments |
| 26-10-2015 08:30 | Joseph D'Antoni | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Finding Your Balance: BI in the Cloud, On Premises, or Both |
| 26-10-2015 08:30 | Kalen Delaney | Pre-Conference Session (full day) | Application & Database Development | Index Internals: RowStore, ColumnStore, and NoStore! |
| 26-10-2015 08:30 | Paul Randal | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Performance Troubleshooting Using Waits and Latches |
| 27-10-2015 08:30 | Kimberly Tripp | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Queries Gone Wrong: Statistics, Cardinality, Solutions |
| 27-10-2015 08:30 | Devin Knight, Brian Knight | Pre-Conference Session (full day) | BI Information Delivery | Power BI for Every Industry |
| 27-10-2015 08:30 | Sean McCown, Jennifer McCown | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | The Enterprise Scripting Workshop |
| 27-10-2015 08:30 | Aaron Bertrand | Pre-Conference Session (full day) | Application & Database Development | 50 Things All SQL Server Developers Need to Know |
| 27-10-2015 08:30 | Bradley Ball, Josh Luedeman | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Optimize “All Data” with a Modern Data Warehouse Solution |
| 27-10-2015 08:30 | Dmitri Korotkevitch | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | SQL Server Internals: The Practical Angle |
| 27-10-2015 08:30 | Kendra Little | Pre-Conference Session (full day) | Application & Database Development | SQL Server Index Therapy Session |
| 27-10-2015 08:30 | Jason Hall, David Benoit, Lori Edwards, Scott Fallen, Rick Pittser, Melissa Connors, Greg Gonzalez, Stephen Dykes | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | SQL Sentry Performance Boot Camp - Vendor Session |
| 27-10-2015 08:30 | Amit Banerjee, Sourabh Agarwal | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | How to be a Ninja: Troubleshooting SQL performance on Azure Virtual Machines |
| 27-10-2015 08:30 | Bill Preachuk | Pre-Conference Session (full day) | Application & Database Development | Hadoop Essentials for the SQL Server Professional |
| 28-10-2015 10:15 | Kamal Hathi, James Phillips | General Session (75 minutes) | BI Information Delivery | Foundation Session: Microsoft Business Intelligence |
| 28-10-2015 10:15 | Ryan Adams | General Session (75 minutes) | Enterprise Database Administration & Deployment | Install an AlwaysOn Failover Cluster and Availability Group |
| 28-10-2015 10:15 | Dmitri Korotkevitch | General Session (75 minutes) | Application & Database Development | Thinking Outside the In-Memory Box |
| 28-10-2015 10:15 | Mickey Stuewe | General Session (75 minutes) | BI Information Delivery | Sophisticated Techniques to Use in SSRS |
| 28-10-2015 10:15 | Brian Walters | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SQL Server 2016 on Flash: Fast Track DW, SOFS, Columnstore, & AlwaysOn |
| 28-10-2015 10:15 | Ike Ellis | General Session (75 minutes) | Application & Database Development | Survey of the Microsoft Azure Data Landscape |
| 28-10-2015 10:15 | Sunil Agarwal | General Session (75 minutes) | Enterprise Database Administration & Deployment | Overview of ColumnStore Index in SQL Server 2016 and Azure SQL Database |
| 28-10-2015 10:15 | Erin Stellato | General Session (75 minutes) | Enterprise Database Administration & Deployment | Kicking and Screaming: Replacing Profiler with Extended Events |
| 28-10-2015 10:15 | Pinal Dave | General Session (75 minutes) | Application & Database Development | Secrets of SQL Server: Database Worst Practices |
| 28-10-2015 10:15 | Kimberly Tripp | General Session (75 minutes) | Application & Database Development | SQL Server Indexing for Performance |
| 28-10-2015 10:45 | Wolfgang Strasser | General Session (75 minutes) | BI Platform Architecture, Development & Administration | A Programmatic Journey through SSIS Catalog |
| 28-10-2015 10:45 | Alex Whittles | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Beginners Guide to MDX |
| 28-10-2015 10:45 | Brandon Leach | General Session (75 minutes) | Enterprise Database Administration & Deployment | Bringing Balance to the SQL Server Force with Resource Governor |
| 28-10-2015 10:45 | Stuart Ainsworth | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Eating the Elephant: A DBA's Guide to Hadoop |
| 28-10-2015 10:45 | Jason Horner | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Dimensional Modeling Design Patterns: Beyond the Basics |
| 28-10-2015 10:45 | Bob Pusateri | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Security Basics |
| 28-10-2015 10:45 | Kathi Kellenberger | General Session (75 minutes) | Professional Development | Writing Technical Books |
| 28-10-2015 12:30 | Kevin Kline | General Session (75 minutes) | Professional Development | Community Session: Intro to PASS Summit |
| 28-10-2015 13:30 | Mark Vaillancourt | General Session (75 minutes) | BI Information Delivery | A Bigger Boat: Data Visualization Lessons from the Movie Theater |
| 28-10-2015 13:30 | Klaus Aschenbrenner | Half-Day Session (3 hours) | Application & Database Development | Windowing Functions: THE Killer Feature in SQL Server! |
| 28-10-2015 13:30 | Mladen Prajdić | General Session (75 minutes) | BI Information Delivery | Visualizing Streaming Data in Real Time |
| 28-10-2015 13:30 | Jeff Renz | General Session (75 minutes) | Application & Database Development | Introduction to Microsoft Azure DocumentDB |
| 28-10-2015 13:30 | Paul Randal | General Session (75 minutes) | Enterprise Database Administration & Deployment | DBA Mythbusters |
| 28-10-2015 13:30 | Russ Thomas | General Session (75 minutes) | Professional Development | Stress Inoculation: Maintaining Performance Under Pressure |
| 28-10-2015 13:30 | Robert Cain | General Session (75 minutes) | Enterprise Database Administration & Deployment | Zero to Hero with PowerShell and SQL Server in 1 Session |
| 28-10-2015 13:30 | Konstantin Melamud | General Session (75 minutes) | Enterprise Database Administration & Deployment | Turbo Boost Performance: In-Memory Tables and Index Optimizations |
| 28-10-2015 13:30 | Ayad Shammout, Thomas Grohser, Michael Steineke, Sanjay Mishra, David Smith, Wolfgang Kutschera | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: SQL Server HA DR Customer Panel -- 7 Habits of people who build highly available systems |
| 28-10-2015 13:30 | Edwin M Sarmiento | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Integrating SQL Server Analysis Services with Hadoop |
| 28-10-2015 13:30 | Luis Cabrera-Cordon, Gopi Kumar, Jason Wilcox | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Foundation Session: Advanced Analytics |
| 28-10-2015 13:30 | Colleen Morrow | General Session (75 minutes) | Enterprise Database Administration & Deployment | Enterprise Auditing with SQL Server Audit |
| 28-10-2015 13:30 | Rafael Salas | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Solving the Data Integration Problem with Power Query |
| 28-10-2015 13:30 | Scott Currie | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Create and Load a Staging Environment from Scratch in an Hour |
| 28-10-2015 13:30 | Peter Myers | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Big Data Fundamentals with Azure HDInsight |
| 28-10-2015 13:30 | Torsten Grabs | General Session (75 minutes) | Application & Database Development | Building Elastic SaaS Applications with Azure SQL Database |
| 28-10-2015 15:15 | Jen Underwood, Michael Tejedor | General Session (75 minutes) | BI Information Delivery | Power BI Overview |
| 28-10-2015 15:15 | Frank Weigel | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Business Intelligence Updates in SQL Server 2016 |
| 28-10-2015 15:15 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol Round 1 |
| 28-10-2015 15:15 | Rob Farley | General Session (75 minutes) | Application & Database Development | A Few Of My Favourite Plan Operators |
| 28-10-2015 15:15 | Erin Stellato | General Session (75 minutes) | Enterprise Database Administration & Deployment | Statistics and Query Plans |
| 28-10-2015 15:15 | Saveen Reddy, Sukvinder Singh Gill | General Session (75 minutes) | Enterprise Database Administration & Deployment | Foundation Session: Big Data and Data Warehousing |
| 28-10-2015 15:15 | Mike Hillwig | General Session (75 minutes) | Professional Development | Leadership Without Borders: Working with Global Teams |
| 28-10-2015 15:15 | Marco Russo | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Toolkit for DAX Optimization |
| 28-10-2015 15:15 | Bradley Ball | General Session (75 minutes) | Application & Database Development | Indexing Internals for Developers and DBAs |
| 28-10-2015 15:15 | Kenneth Fisher | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Security for Everyone |
| 28-10-2015 15:15 | Pedro Lopes, Lonny Bastien | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Upgrade and Migration |
| 28-10-2015 15:15 | Karen Lopez, Thomas LaRock | General Session (75 minutes) | Application & Database Development | Database Design Throwdown |
| 28-10-2015 15:15 | Luis Vargas | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server on Azure Virtual Machines: Features, Best Practices & Roadmap |
| 28-10-2015 15:15 | Ola Hallengren | General Session (75 minutes) | Enterprise Database Administration & Deployment | Building a Performance Monitoring System Using Extended Events and DMVs |
| 28-10-2015 15:15 | Argenis Fernandez | General Session (75 minutes) | Application & Database Development | Stored Procedures vs. Ad Hoc SQL: Performance Showdown! |
| 28-10-2015 15:15 | Robert Davis | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | DBA's Guide to Administering BI Systems |
| 28-10-2015 16:45 | Miguel Llopis, Ariel Netz, Lance Delano | General Session (75 minutes) | BI Information Delivery | Power BI Desktop Overview |
| 28-10-2015 16:45 | Kevin Farlee | General Session (75 minutes) | Enterprise Database Administration & Deployment | AlwaysOn in SQL Server 2016 |
| 28-10-2015 16:45 | Oliver Engels, Gabi Münster, Gabi Münster | General Session (75 minutes) | BI Information Delivery | A Concept for Clean Reporting: Information Design Rules for SSRS and R |
| 28-10-2015 16:45 | Sean McCown | General Session (75 minutes) | Enterprise Database Administration & Deployment | Monster Text Manipulation: Regular Expressions for the DBA |
| 28-10-2015 16:45 | Aaron Bertrand, Scott Fallen | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Sentry's Tools for Tuning |
| 28-10-2015 16:45 | J May | General Session (75 minutes) | Application & Database Development | Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit |
| 28-10-2015 16:45 | Devin Knight, Bradley Schacht | General Session (75 minutes) | Enterprise Database Administration & Deployment | Migrating your SQL Servers VMs to Azure with PowerShell |
| 28-10-2015 16:45 | Peter Myers | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Introduction to Time Series Forecasting |
| 28-10-2015 16:45 | Matt Usher | General Session (75 minutes) | Application & Database Development | Overview of Azure SQL Data Warehouse and Architecture |
| 28-10-2015 16:45 | Carlos Bossy | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Use Hive and Hadoop for High-Performance Data Warehousing |
| 28-10-2015 16:45 | Luke Jian | General Session (75 minutes) | Enterprise Database Administration & Deployment | Anatomy of an Optimizer |
| 28-10-2015 16:45 | Brian Knight | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SQL Server Integration Services (SSIS) Performance Internals |
| 28-10-2015 16:45 | Asad Khan, John Macintyre, Pablo Castro, Tony Petrossian, Shawn Bice | General Session (75 minutes) | Enterprise Database Administration & Deployment | Foundation Session: Developing Modern Applications on Azure |
| 28-10-2015 16:45 | Doug Lane | General Session (75 minutes) | Application & Database Development | Living and Dying by Dynamic SQL |
| 28-10-2015 16:45 | Matt Usher, Rajesh Dadhia | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Cortana Analytics Deep Dive: Big Data Stores |
| 28-10-2015 16:45 | Brian Davis, Adam Belebczuk, Russ Thomas, Rick Heiges, Cathrine Wilhelmsen | Lightning Talk (75 minutes) | Professional Development | Lightning Talks 104 |
| 29-10-2015 10:15 | Andrew Hoh, Aravind Krishna R. | General Session (75 minutes) | Application & Database Development | Azure DocumentDB - Common Use Cases and Success Stories |
| 29-10-2015 10:15 | Wayne Sheffield, Jeff Renz, Lance Tidwell, Aaron Buma, Paul Wehland | Lightning Talk (75 minutes) | Application & Database Development | Lightning Talks 102 |
| 29-10-2015 10:15 | Itzik Ben-Gan | General Session (75 minutes) | Application & Database Development | Run, Total, Run! |
| 29-10-2015 10:15 | Guy Hunkin, Eli Schwartz | General Session (75 minutes) | BI Information Delivery | What’s New for Business Analytics in Excel 2016 |
| 29-10-2015 10:15 | Edward Pollack | General Session (75 minutes) | Enterprise Database Administration & Deployment | My Favorite DMVs |
| 29-10-2015 10:15 | Rod Colledge | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building Hybrid BI Solutions with Power BI |
| 29-10-2015 10:15 | Ben DeBow, Denis McDowell | General Session (75 minutes) | Application & Database Development | DevOps Is Coming to an Enterprise near You |
| 29-10-2015 10:15 | Jason Strate | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Plan Cache Whisperer: Performance Tuning SQL Server |
| 29-10-2015 10:15 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | Optimizing SQL Server Performance in a Virtual Environment |
| 29-10-2015 10:15 | Grant Fritchey | General Session (75 minutes) | Enterprise Database Administration & Deployment | Statistics for the New Data Pro |
| 29-10-2015 10:45 | Allen White | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Automate Your ETL Infrastructure with SSIS and PowerShell |
| 29-10-2015 10:45 | Sanjay Soni, Anand Subbaraj, Kristian Kimbro Rickard | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Real Time Business Analytics Using Power BI for a Customer Scenario |
| 29-10-2015 10:45 | Joachim Hammer, Jamey Johnston, Tomer Weisberg | General Session (75 minutes) | Enterprise Database Administration & Deployment | Overview of Security Investments in SQL Server 2016 and Azure SQL Database |
| 29-10-2015 10:45 | Chris Webb | General Session (75 minutes) | BI Information Delivery | Analyzing Audience Reaction to the PASS Summit Keynote |
| 29-10-2015 10:45 | Rolf Tesmer | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Using Azure Machine Learning to Predict Seattle House Prices |
| 29-10-2015 10:45 | Jen Stirrup | General Session (75 minutes) | BI Information Delivery | Data Storytelling with R, Azure Machine Learning, and Power BI |
| 29-10-2015 10:45 | Richard Waymire, Jim Hautala | General Session (75 minutes) | Enterprise Database Administration & Deployment | Analyzing Performance and Scalability for OLTP and Data Warehousing Solutions |
| 29-10-2015 12:30 | Ryan Adams | General Session (75 minutes) | Professional Development | Community Session: Navigating PASS |
| 29-10-2015 13:30 | Thomas LeBlanc | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Learning Analysis Services 2014 Tabular in 3 Hours |
| 29-10-2015 13:30 | Michael Rys | General Session (75 minutes) | BI Platform Architecture, Development & Administration | U-SQL: ‘THE’ Language for Big Data |
| 29-10-2015 13:30 | Steve Jones | General Session (75 minutes) | Application & Database Development | Using Automated Tests to Raise Code Quality |
| 29-10-2015 13:30 | Neil Hambly | General Session (75 minutes) | Application & Database Development | Effective Indexing with Partitioning and Compression |
| 29-10-2015 13:30 | Jos de Bruijn | General Session (75 minutes) | Enterprise Database Administration & Deployment | In-Memory OLTP Investments in SQL Server 2016 and Azure SQL Database |
| 29-10-2015 13:30 | Glenn Berry | General Session (75 minutes) | Enterprise Database Administration & Deployment | High Availability/Disaster Recovery 101 |
| 29-10-2015 13:30 | Riccardo Muti | General Session (75 minutes) | BI Platform Architecture, Development & Administration | What's New in SQL Server 2016 Reporting Services |
| 29-10-2015 13:30 | Scott Shaw | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Hadoop for Large Scale Interactive Workloads in Azure |
| 29-10-2015 13:30 | Drew DiPalma | General Session (75 minutes) | Application & Database Development | Migrating the Enterprise Data Warehouse with Azure SQL Data Warehouse |
| 29-10-2015 13:30 | Denzil Ribeiro | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: SQL Server 2016 Columnstore Customer Scenarios and Best Practices |
| 29-10-2015 13:30 | Wee Hyong Tok, SpeakerName, Sonia Carlson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Cortana Analytics Deep Dive: Information Management |
| 29-10-2015 13:30 | Adam Saxton | General Session (75 minutes) | Enterprise Database Administration & Deployment | Kerberos - I'm not dead yet! |
| 29-10-2015 13:30 | Cindy Gross | General Session (75 minutes) | BI Platform Architecture, Development & Administration | BI on Big Data: Bridging the Gap |
| 29-10-2015 13:30 | Sunil Agarwal | General Session (75 minutes) | Enterprise Database Administration & Deployment | Real-Time Operational Analytics in SQL Server 2016 and Azure SQL Database |
| 29-10-2015 13:30 | Joe Webb | General Session (75 minutes) | Professional Development | Hiring the Right People: How to Select and Hire the Right Team |
| 29-10-2015 13:30 | Reza Rad | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SSIS vs. Azure Data Factory |
| 29-10-2015 15:15 | Rob Farley | General Session (75 minutes) | Application & Database Development | The Power Of Composite Indexes |
| 29-10-2015 15:15 | Michael Fal | General Session (75 minutes) | Enterprise Database Administration & Deployment | PowerShell and the Art of SQL Server Deployment |
| 29-10-2015 15:15 | Stacia Varga | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Reducing the Impact of BI Workloads on Your Database Engine |
| 29-10-2015 15:15 | Kevin Kline | General Session (75 minutes) | Professional Development | Top 10 Mistakes of New IT Leaders |
| 29-10-2015 15:15 | Bob Ward | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Inside Wait Types, Latches, and Spinlocks |
| 29-10-2015 15:15 | Karen Lopez, Allan Hirt, Jennifer McCown | General Session (75 minutes) | Professional Development | Panel: Will the DBA Job of the Future Still Involve DBAs? |
| 29-10-2015 15:15 | Santosh Balasubramanian | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Real Time Insights on your IoT with Stream Analytics and Machine Learning |
| 29-10-2015 15:15 | Guy Glantser | General Session (75 minutes) | Application & Database Development | How to Use Parameters like a Pro and Boost Performance |
| 29-10-2015 15:15 | Lord Richard Douglas | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Day After Tomorrow: Why You Need to Baseline |
| 29-10-2015 15:15 | Doug Lane | General Session (75 minutes) | BI Information Delivery | SQL Server Mystery: Dead Reports Don't Talk |
| 29-10-2015 15:15 | General Session (75 minutes) | BI Platform Architecture, Development & Administration | APS and SSAS for Real-Time Analysis | |
| 29-10-2015 15:15 | Andy Leonard | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Use Biml to Automate SSIS Design Patterns |
| 29-10-2015 15:15 | Saveen Reddy, Alan Tan, Matthew Hicks | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building Applications on Azure Data Lake |
| 29-10-2015 15:15 | Nishant Thacker | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Understanding Real World Big Data Scenarios |
| 29-10-2015 15:15 | Kalen Delaney | General Session (75 minutes) | Enterprise Database Administration & Deployment | How Minimal Is Minimal Logging? |
| 29-10-2015 15:15 | Tobias Ternstrom, Umachandar Jayachandran, Dotan Elharrar | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Advanced Analytics with R in SQL Server 2016 |
| 29-10-2015 16:45 | Jen Stirrup, Jens Vestergaard, Paco Gonzalez, Markus Ehrenmueller-Jensen, Steve Wake, Dan Galavan | Lightning Talk (75 minutes) | BI Information Delivery | Lightning Talks 103 |
| 29-10-2015 16:45 | Tony Petrossian | General Session (75 minutes) | Application & Database Development | Application Patterns for Azure SQL Database |
| 29-10-2015 16:45 | Patrick O'Keeffe | General Session (75 minutes) | Application & Database Development | Lessons learned from building scalable applications on the Microsoft Azure SQL Database |
| 29-10-2015 16:45 | Alberto Ferrari | General Session (75 minutes) | BI Information Delivery | Budgeting with Power Pivot |
| 29-10-2015 16:45 | Niko Neugebauer | General Session (75 minutes) | Application & Database Development | Understanding and Solving Common Columnstore Problems |
| 29-10-2015 16:45 | Matt Masson, Jimmy Wong, Janine Zhang, Helen Li | General Session (75 minutes) | BI Platform Architecture, Development & Administration | What´s New for SQL Server 2016 Integration and Master Data Services |
| 29-10-2015 16:45 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol Round 2 |
| 29-10-2015 16:45 | Miguel Llopis, Lance Delano, Robert Bruckner | General Session (75 minutes) | BI Information Delivery | Deep Dive into Data Preparation, Modeling & Analytics using Power BI Desktop |
| 29-10-2015 16:45 | Victor Isakov | General Session (75 minutes) | Enterprise Database Administration & Deployment | Administering and Optimizing Availability Groups Correctly |
| 29-10-2015 16:45 | Mike Walsh | General Session (75 minutes) | Enterprise Database Administration & Deployment | 10 SQL Server Review Findings I Want to Stop Finding! |
| 29-10-2015 16:45 | Borko Novakovic | General Session (75 minutes) | Enterprise Database Administration & Deployment | Temporal and JSON in SQL Server 2016 and Azure SQL Database |
| 29-10-2015 16:45 | Pieter Vanhove | General Session (75 minutes) | Enterprise Database Administration & Deployment | Run Your DBA Morning Checklist with Policy-Based Management |
| 29-10-2015 16:45 | Sahaj Saini, Miro Flasza | General Session (75 minutes) | Application & Database Development | PolyBase in SQL Server 2016 and Azure SQL DW |
| 29-10-2015 16:45 | Benjamin Nevarez | General Session (75 minutes) | Application & Database Development | Dive into the Query Optimizer: Undocumented Insight |
| 29-10-2015 16:45 | Devin Knight | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Securing Your BI Solutions |
| 29-10-2015 16:45 | Richie Rump | General Session (75 minutes) | Application & Database Development | Who's Afraid of Entity Framework? |
| 30-10-2015 08:00 | John Morehouse | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Databaseology: A Deep Dive Into Database Internals |
| 30-10-2015 08:00 | Ed Triou | General Session (75 minutes) | BI Platform Architecture, Development & Administration | U-SQL Query Execution and Performance Tuning |
| 30-10-2015 08:00 | Asad Khan | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Spark SQL - Exploratory analytics with Big Data |
| 30-10-2015 08:00 | J May, Brian Walters | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server on Flash: Re-Thinking Best Practices |
| 30-10-2015 08:00 | Wayne Sheffield | General Session (75 minutes) | Application & Database Development | SSMS Tips and Tricks: Using What You've Already Got |
| 30-10-2015 08:00 | Kun Cheng, Luis Ventura, Changgyu Oh, Komron Nouri, Duke Yetter | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Azure SQL Database Customer Experiences and Lessons Learned |
| 30-10-2015 08:00 | Drew DiPalma | General Session (75 minutes) | Application & Database Development | Analytics Platform System Best Practices |
| 30-10-2015 08:00 | Matt Masson, Matthew Roche | General Session (75 minutes) | BI Information Delivery | BI Power Hour |
| 30-10-2015 08:00 | Mark Broadbent | General Session (75 minutes) | Enterprise Database Administration & Deployment | Lock, Block, and Two Smoking Barrels |
| 30-10-2015 08:00 | Mindy Curnutt | General Session (75 minutes) | Enterprise Database Administration & Deployment | 3 Methods to End the Madness: Application Slowness Diagnosis |
| 30-10-2015 08:00 | Allen White | General Session (75 minutes) | Application & Database Development | Scalable Application Design with Service Broker |
| 30-10-2015 08:00 | Steve Stedman | General Session (75 minutes) | Application & Database Development | Advanced Common Table Expressions and Recursive Query Technique |
| 30-10-2015 08:00 | Trayce Jordan | General Session (75 minutes) | Enterprise Database Administration & Deployment | Finding root cause for unexplained Availability Group failover |
| 30-10-2015 08:00 | Sandy Rivas | General Session (75 minutes) | BI Information Delivery | Leveraging Power BI to Gain Insights & Increase Profit |
| 30-10-2015 08:00 | Chris Shaw | General Session (75 minutes) | Application & Database Development | Achieve Index Feng Shui in SQL Server |
| 30-10-2015 08:00 | Vlad Vlasceanu | General Session (75 minutes) | Application & Database Development | RDBMS in the Cloud: Deploying SQL Server on AWS |
| 30-10-2015 09:30 | Wee Hyong Tok, Sachin Chouksey | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Using the Cortana Analytics Process for Smart Transportation |
| 30-10-2015 09:30 | Mini Nair | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Making Power BI Content Refreshable for Hybrid Scenario |
| 30-10-2015 09:30 | Matt Winkler | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Big Data Made Easy for SQL Developers with Azure Data Lake Analytics |
| 30-10-2015 09:30 | Tony Petrossian | General Session (75 minutes) | Application & Database Development | Azure SQL Database Investments and Roadmap |
| 30-10-2015 09:30 | Leonard Lobel | General Session (75 minutes) | Application & Database Development | Programming T-SQL Enhancements: Windowing and More |
| 30-10-2015 09:30 | Glenn Berry | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Dr. DMV's Troubleshooting Toolkit |
| 30-10-2015 09:30 | Jason Thomas | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Memoirs of Building a 150 GB (and Growing) SSAS Tabular Model |
| 30-10-2015 09:30 | Andy Leonard | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Hacking the SSIS Catalog |
| 30-10-2015 09:30 | Allan Mitchell | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Building a Scalable Analytical Solution Using IaaS and Elasticsearch |
| 30-10-2015 09:30 | John Sterrett, Brian Moran, Ben DeBow, David Klee | General Session (75 minutes) | Professional Development | Is Independent Consulting for Me? |
| 30-10-2015 09:30 | Kendal Van Dyke | General Session (75 minutes) | Enterprise Database Administration & Deployment | Tuning and Troubleshooting Transactional Replication |
| 30-10-2015 09:30 | Hope Foley | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Don't Rely on Magic: Tabular Performance Troubleshooting |
| 30-10-2015 09:30 | Chris Webb | General Session (75 minutes) | BI Information Delivery | Using Power Query to Build a Reporting Solution in Excel |
| 30-10-2015 09:30 | Ayad Shammout, Mike Weiner, Wolfgang Kutschera, Jack Freeman | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: SQL Server 2016 Early Adopter Experiences |
| 30-10-2015 09:30 | Oliver Engels, Tillmann Eitelberg | General Session (75 minutes) | BI Platform Architecture, Development & Administration | The Reporting Machine! |
| 30-10-2015 09:30 | Paul Turley | Half-Day Session (3 hours) | BI Information Delivery | Power BI Hands-On Mini Workshop |
| 30-10-2015 09:30 | Steve Wake | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Date Dimension: Past and Future in One Script |
| 30-10-2015 11:00 | Adam Belebczuk | General Session (75 minutes) | Application & Database Development | XML Without Xanax: How to Handle XML in SQL Server |
| 30-10-2015 11:00 | Davide Mauri | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Real-Time Data Integration (in the Cloud or Not) |
| 30-10-2015 11:00 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Database Administration for the Non-DBA |
| 30-10-2015 11:00 | Miguel Llopis, Guy Hunkin | General Session (75 minutes) | BI Information Delivery | Get Data & Transformations in Excel 2016 |
| 30-10-2015 11:00 | Matan Yungman | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Data-Loading Performance Presentation |
| 30-10-2015 11:00 | Bill Anton | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Analysis Services: Show Me Where It Hurts |
| 30-10-2015 11:00 | Mark Broadbent, Tim Radney, Andreas Wolter, Rob Volk, Murilo Miranda | Lightning Talk (75 minutes) | Enterprise Database Administration & Deployment | Lightning Talks 101 |
| 30-10-2015 11:15 | Marc Reguera, Will Thompson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Visualizations & Storytelling Best Practices using Power BI Desktop |
| 30-10-2015 11:15 | Jes Schultz | General Session (75 minutes) | Enterprise Database Administration & Deployment | Minimize Data Loss with Advanced Restore Methods |
| 30-10-2015 11:15 | Victor Isakov | General Session (75 minutes) | Application & Database Development | Designing a Database Solution to Store Large Volumes of Documents |
| 30-10-2015 11:15 | Kasper de Jonge | General Session (75 minutes) | BI Information Delivery | The Analysis Services Evolution |
| 30-10-2015 11:15 | André Kamman | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Analyzing your ETL Solution with PowerShell |
| 30-10-2015 11:15 | Murshed Zaman, John Hoang, Ron Ortloff | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Azure SQL Data Warehouse Lessons Learned and Customer Stories |
| 30-10-2015 11:15 | Joe Yong | General Session (75 minutes) | Enterprise Database Administration & Deployment | Stretch Database: Leverage Azure for SQL Server on Your Terms |
| 30-10-2015 13:15 | Kendal Van Dyke | General Session (75 minutes) | Professional Development | Community Session: Staying Involved with PASS |
| 30-10-2015 14:00 | Theresa Palmer-Boroski | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building Content Packs for Power BI |
| 30-10-2015 14:00 | Giampaolo Battaglia | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Cortana Analytics Deep Dive: Preconfigured Solutions |
| 30-10-2015 14:00 | Jason Brimhall | General Session (75 minutes) | Enterprise Database Administration & Deployment | Working with Object Compression in SQL Server |
| 30-10-2015 14:00 | sudhir rawat | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Improving Performance of Big Data Solution |
| 30-10-2015 14:00 | Dan Bulos | General Session (75 minutes) | BI Information Delivery | Dashboard Design for Maximum Impact |
| 30-10-2015 14:00 | Uwe Ricken | General Session (75 minutes) | Enterprise Database Administration & Deployment | Change Data Capture Case Study and Checklist |
| 30-10-2015 14:00 | Sanjay Mishra, Purvesh Patel, Robert Parker, Monish Darda | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Azure SQL VM Design Patterns and Customer Stories |
| 30-10-2015 14:00 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol Round 3 |
| 30-10-2015 14:00 | Jack Corbett | General Session (75 minutes) | Application & Database Development | Tired of the CRUD? Automate It! |
| 30-10-2015 14:00 | Dejan Sarka | General Session (75 minutes) | Enterprise Database Administration & Deployment | High-Performance Statistical Queries |
| 30-10-2015 14:00 | Jason Strate | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Accelerating Business Intelligence Solutions With Microsoft Azure |
| 30-10-2015 14:00 | Edwin M Sarmiento | General Session (75 minutes) | Professional Development | From Technician to CEO: A Roadmap for Advancing Your Career |
| 30-10-2015 14:00 | Argenis Fernandez | General Session (75 minutes) | Enterprise Database Administration & Deployment | Zero-Downtime Upgrades: Rockstar DBA |
| 30-10-2015 14:00 | Tim Mitchell | General Session (75 minutes) | Application & Database Development | Testing SSIS Packages |
| 30-10-2015 14:00 | Drew DiPalma | General Session (75 minutes) | Application & Database Development | Azure SQL Data Warehouse: Integration with Azure Ecosystem |
| 30-10-2015 14:00 | Hugo Kornelis | General Session (75 minutes) | Application & Database Development | Advanced Indexing |
| 30-10-2015 14:00 | Mike Diehl | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Agile Analytics: Making Progress Visible |
| 30-10-2015 15:30 | Reeves Smith | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Integration with MDS |
| 30-10-2015 15:30 | Josh Caplan, Jon Gallant | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Integrating with Power BI Using Developer APIs |
| 30-10-2015 15:30 | Warner Chaves | General Session (75 minutes) | Enterprise Database Administration & Deployment | Time to Stretch: Scaling out and in with Azure DB Elastic Scale |
| 30-10-2015 15:30 | Ed Leighton-Dick, David Klee | General Session (75 minutes) | Enterprise Database Administration & Deployment | How to Build a Virtual Test Lab for SQL Server |
| 30-10-2015 15:30 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol Final |
| 30-10-2015 15:30 | Margarita Naumova | General Session (75 minutes) | Application & Database Development | The Top 8 Reasons for Your Transaction Performance Problems |
| 30-10-2015 15:30 | Paul Turley, Chris Finlan | General Session (75 minutes) | BI Information Delivery | Datazen Technical Deep Dive |
| 30-10-2015 15:30 | Melody Zacharias | General Session (75 minutes) | Application & Database Development | Distributed Replay: Testing with Your Data, Your Way! |
| 30-10-2015 15:30 | Mike Lawell | General Session (75 minutes) | Application & Database Development | Execution Plans for Mere Mortals |
| 30-10-2015 15:30 | Borko Novakovic | General Session (75 minutes) | Enterprise Database Administration & Deployment | Query optimization and Query Store in SQL Server 2016 and Azure SQL Database |
| 30-10-2015 15:30 | Brian Larson | General Session (75 minutes) | BI Information Delivery | Visualizing Geographic and Geometric Data |
| 30-10-2015 15:30 | Pam Shaw | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Taking the Scare out of Monster Reports |
| 30-10-2015 15:30 | Brian Davis | General Session (75 minutes) | Enterprise Database Administration & Deployment | Goodbye Next Next Next, Hello Automated Installs |
| 30-10-2015 15:30 | Bill Fellows | General Session (75 minutes) | BI Platform Architecture, Development & Administration | 2014 SSIS Project Deployment Model: Deployment and Maintenance |
| 30-10-2015 15:30 | Chris Bell | General Session (75 minutes) | Enterprise Database Administration & Deployment | Hacking Exposé Too: Just How Transparent is TDE? |
| 30-10-2015 15:30 | David Bermingham | General Session (75 minutes) | Enterprise Database Administration & Deployment | Understanding Windows Azure High Availability Options for SQL Server |
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Your SQL Servers are mostly virtualized at this point, but have you lost the control you used to have over the infrastructure when they were physical servers? Do your SQL Servers “feel” slower now that they are virtualized? When architected and managed with SQL Server in mind, this added layer can help to improve the SQL Server’s availability and ability to change with the business, but only when executed properly.
This all-day, interactive, and hypervisor-agnostic pre-conference session is designed to help data professionals learn more about virtualization and infrastructure. Discover how this new layer can be used to improve the management, availability, and performance of your databases. You will be exposed to all layers of virtualization underneath the SQL Server, from storage to hypervisor. Discover many useful tips and tricks to tuning the database layer to boost performance and availability. This session addresses these topics:
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
Building packages in SQL Server Integration Services is easy. Building good packages takes a bit more effort.
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be: • Reliable • Resilient • Reusable • Maintainable • Well performing There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages. In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day: • Checking for problems even when the package executes successfully • Building effective tests for your packages • Error handling and prevention • Being kind to your fellow developers by building clear and easy-to-maintain packages • Leave a trail of evidence: package logging done properly • Avoiding performance bottlenecks: tips for making packages run faster • Using the right tool for the job by integrating non-SSIS tools when appropriate
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
An upgrade and/or migration is far more than just a case of moving a database or installing a new version of SQL Server. This session will guide you through the process, looking at not only the technology but the methodology, processes and tools that we have at our disposal to make a successful move to more current versions on premises, in the cloud, or both with SQL Server in an Azure VM or Azure SQL Database. We will dive deep into workload-specific upgrade needs for OLTP, HA, SSAS/SSRS, and SSIS environments.
For those impacted by the end of extended support for SQL Server 2005 on 04/12/2016, we will discuss enhancements to the SQL Server platform and examples of how to take advantage of the latest features.
Bacon will be served at 8:00 am sharp so don’t be late.
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This demo-oriented, full-day pre-conference session answers the questions that database administrators (DBAs) and developers often have about performance tuning and query optimization. Some problems have straightforward answers, but others are often invisible or need attention without even a problem statement. This session is divided into these three major components:
We discuss 42 tips, tricks, and scripts in this session. Every attendee will have those scripts handy upon completion of the session.
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
The Microsoft BI stack provides an assortment of data visualization tools, but do you know how to use these tools effectively to communicate information clearly?
In this full-day pre-conference workshop, you start by building a foundation of visualization principles and learning about the history and current state of visualization theory. In addition, this session introduces the vocabulary of visualization as you explore four main categories of visualizations: comparison, composition, relationship, and distribution.
Next, you examine how visualizations can distort your data and how to correct bad or ugly visualizations by correctly selecting the right tool and applying the appropriate design. We examine many examples of data visualizations, identify the problems with those visualizations, learn the principles of good design, and apply those principles to transform the bad and the ugly into good visualizations.
Last, we survey the visualization landscape within the Microsoft BI toolset. We compare and contrast the options available among these tools. We take a close look at the advantages and disadvantages of each tool so that you have a better understanding of the available options so you can decide which of these tools best support your own visualization requirements.
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Most people are familiar with simple availability solutions that protect their instances or databases by using SQL Server failover clustering instances (FCIs) and availability groups (AGs). However, deploying advanced architectures and solutions that span multiple subnets, datacenters, and even the cloud requires a lot of knowledge and planning that is not easily revealed through a simple web search. Understanding the building blocks for advanced networking, storage, and Windows concepts and how SQL Server fits into them all is the only way to be successful.
Covered topics, which apply to multiple versions of SQL Server and Windows, include:
Attendees get hands-on experience via labs, using their own laptops to reinforce advanced concepts such as forcing quorum and bringing an AG online after failing an AG over to a non-preferred replica. Laptop requirements will be sent a few weeks before the session.
This advanced session is not for beginners. The basics of SQL Server availability are covered, but prior knowledge of clustering, FCIs, and AGs is assumed.
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
Have you heard about Power BI and Microsoft Azure? These services can take many forms, such as cloud virtual machines (VMs), database as a service (DBaaS), Power BI in the cloud, and a myriad of other services. In this full-day pre-conference session, you learn about building business intelligence (BI) solutions using Microsoft Azure, Power BI, and the Microsoft BI stack (on premises, in the cloud, or both). This session gives you a foundation for determining when incorporating cloud components into your BI solution makes sense and how to get started.
In this full-day workshop, you learn: • How to use Azure components to build a BI infrastructure completely or partially in the cloud • Which changes to your solution architecture are necessary when you move components to the cloud • Best practices for configuring and networking Azure resources • How to integrate your cloud-based solution with your on-premises Active Directory • How to securely connect Power BI to your Azure and on-premises data sources • How to configure supported data sources for scheduled refresh • Best practices for administering Power BI components in Office 365
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
Indexes allow SQL Server to access your data in the most efficient manner. Indexes are the only tuning technique that can improve query performance by orders of magnitude. Understanding exactly how your indexes are structured can enable you to choose the best indexes for your queries. SQL Server 2014 provides three very different kinds of index structures: traditional B-tree clustered and nonclustered indexes, ColumnStore clustered and nonclustered indexes, and in-memory indexes that are used for memory-optimized tables.
In this session, we look at how each of these three types of indexes is stored and used. For B-tree indexes, we look at the difference between clustered and nonclustered indexes, and we explore fragmentation and defragmentation. For ColumnStore indexes, we see how they are stored differently than B-tree row-based indexes, and we compare SQL Server 2012 nonclustered indexes with SQL Server 2014 clustered ColumnStores. For in-memory online transaction processing (OLTP) indexes, we see yet another way of managing indexes. Because indexes for memory-optimized tables are not stored on disk (hence the NoStore reference), we talk about how they can be persisted across SQL Server restarts. For each type, we also cover some best practice recommendations.
Knowing how indexes are useful and how each type is stored and managed can enable you to compare them and to decide which index type is the best choice for your needs.
Event Date: 26-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
One of the first things to check when investigating performance issues are wait and latch statistics, which can often point you in the right direction for further analysis. Unfortunately, many people misinterpret what SQL Server tells them and jump to conclusions about how to solve a problem: what we often call "knee-jerk performance tuning". In this full-day pre-conference workshop, you learn how to investigate and interpret wait and latch statistics; you get practical techniques you can take home and start using immediately. You also learn what a myriad of wait and latch types actually mean and how to 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: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Most of the time, SQL Server returns data quickly. But sometimes, performance is slow, and what SQL Server did to access your data just doesn’t make sense. Transact-SQL (T-SQL) is a declarative language that details what data you need, but without information about how SQL Server should get it. Join order, predicate analysis--how does SQL Server decide the order or when to evaluate a predicate? There are numerous reasons why query performance can suffer.
This full-day pre-conference session covers a number of critical areas. For each area, the session shows you behavior, execution plan, troubleshooting technique, and most importantly, possible solutions.
This workshop is about solving your query-performance problems. You’ll walk away with a plethora of strategies to troubleshoot and tackle even the most difficult query problems. Stop using "sledgehammer" approaches (updating statistics, rebuilding indexes, clearing cache) and learn more finessed ways to solve query plan quality problems.
Topics include understanding and maintaining statistics, managing very large tables (VLTs), skewed data, and distribution problems; troubleshooting common and advanced scenarios; and using the cardinality estimation models (and trace flags) available in SQL Server 2008 through 2014.
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
Learn how to use Microsoft’s newest business intelligence (BI) suite, Power BI, across your vertical as we take a tour around four major industries with real-world examples: healthcare, retail, manufacturing, and finance. Bring your laptops for this interactive, hands-on pre-conference session. We’re sure you’ll walk away with actionable practices to take back to work. This session shows you how to:
You’ll walk away from this session with all the solutions and code to implement these solutions in your organization. Bring your business users and analysts so that they can achieve these goals by themselves, too!
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
The database administrator (DBA) life can be frustrating: You rarely have time to innovate because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You need to put big items on hold to manage special requests. As careful as you are, mistakes creep in the busier you get.
In this pre-conference workshop, learn how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts can reduce task time from hours or days to just a few minutes, and eliminate mistakes from your environment. • Enterprise philosophy: Tackle simple tasks with the whole environment in mind. • Single data store: Define the benefits and uses of a single central database for common-use data and metadata. • Choice of tools: Choose the best tool (e.g., PowerShell, T-SQL, SSIS) for the job. • Environment ground work: Prepare your environment for enterprise scripting. • Real-world scripts: Work through dozens of enterprise scripting issues (e.g., alerting, error handling, multiple SQL versions) as you develop a real enterprise script in class
This session is for DBAs with a basic understanding of PowerShell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
What problematic patterns and anti-patterns are most likely to trip up SQL Server developers on a daily basis? What sort of Transact-SQL (T-SQL) challenges does every SQL Server developer encounter? This full-day pre-conference session takes a tour of the most common and challenging issues that database developers face; learn how to conquer them in the lab today so that they do not take you by surprise in the future.
Loaded with live demos and useful techniques, this session teaches you how to take your SQL Server queries from mundane to masterful. You'll learn:
With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and I/O while being easier to maintain and offering faster performance.
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
Most of the world’s data exists in a combination of on-premise, cloud, and non-relational forms. This session teaches you the options, best practices, and patterns to acquire, store, process, and analyze all forms of data in a modern solution. This solution combines your on-premise systems, cloud solutions, and analytics platforms in a next-generation approach to managing the data life cycle.
This pre-conference session includes hands-on labs and demos, great take-home content, and up-to-the-minute, “from the field” guidance on how to approach challenges by combining new features and technologies with your expertise as a data pro. We use SQL Server, Apache Hadoop, Microsoft Azure, Azure Machine Learning, and Azure Data Factory--and some other things we can’t discuss yet!
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
A deep understanding of SQL Server internals makes it much easier to design and maintain efficient SQL Server solutions. Unfortunately, database professionals who lack this knowledge often make design and implementation decisions that adversely affect their systems.
This pre-conference session helps to address these issues and shows you how SQL Server components work under the hood, work together and communicate with one another, and most importantly, affect your systems.
The session is for database administrators (DBAs) and developers who want to design, develop, and maintain systems to get the most from SQL Server. The session can also help database pros who prefer to understand and fix the root cause of a problem rather than simply applying a bandage. The session is based on the book “Pro SQL Server Internals” (http://www.amazon.com/dp/1430259620), includes numerous demos, and discusses answers to the following questions:
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
You want to design indexes to improve SQL Server's performance, but you're concerned that you might create too many, not enough, or just plain "wrong" indexes. In this session, you will learn how to design effective clustered and nonclustered indexes to speed up your queries. You will tackle index design challenges to learn how to choose the right key and included columns and how to consolidate duplicate indexes. You will get practical tips to recognize when to use filtered indexes and indexed views and how to avoid the gotchas and pitfalls that make indexes slow down your queries. If you have two years of experience writing queries for SQL Server, this session will put you in control of your next index-design project.
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Enlist in the first ever SQL Sentry Bootcamp! Attend this full day pre-con to gain in depth knowledge of SQL Sentry products and services. Whether you are already a customer or considering adopting our platform, you will learn how to make the most of it directly from our product and sales engineering teams.
CEO Greg Gonzalez will discuss the direction and future of SQL Sentry. Session topics include: SQL Sentry configuration and optimization, setting up the best alerting environment, applying SQL Sentry software to solve real world issues, mining performance data from your repository, how to make use of our cloud services, and what's new in Plan Explorer 3.0.
Interact with the sales and product teams during breaks and lunch as well as a dedicated Q&A session at the end of the day to get your own questions answered. This day of deep dive technical training will provide you with the knowledge and tools to make your own environment run as efficiently as possible.
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Troubleshooting is an art but the tricks of the trade changed with the advent of Azure Virtual Machines. Performance troubleshooting is different and at the same time very similar to what you have been used to for SQL Server. SQL Server performance on Azure VMs can be a sore point for many as the host troubleshooting entry points are limited and the knowledge of the internal workings scarce.
We will show you how to troubleshoot performance for SQL Server instances running on Azure Virtual Machines like a NINJA! What's more, we will detail how to automate deployments from scratch, implement best practices automatically and analyze performance issues magically!
Event Date: 27-10-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This session provides a rich technical overview of Apache Hadoop 2.3 (both Hortonworks Data Platform [HDP] and Microsoft HDInsight), specifically focused for the needs of SQL Server developers and DBAs.
We will lead off with an overview of several relevant projects of the Hadoop ecosystem covering HDFS, MapReduce, Tez, Hive, Pig, HCatalog, Sqoop, Flume, Kafka/Storm, and Spark at a minimum. We then dig deep into a series of data-processing demos, highlighting what is most valuable to SQL Server pros and focusing on Hive (the Hadoop SQL variant). We examine core Hive concepts such as partitioning, bucketing, ORC file format, compression, and vectorization, to equip you to expand your existing T-SQL and data skills into HiveQL/Hadoop. To wrap up, we discuss real-world knowledge gleaned from successful Hadoop implementations and show you how to implement common use cases in Hadoop.
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
This session discusses several of these use-cases:
Finally, this session shows several techniques that help address in-memory OLTP limitations by utilizing horizontal and vertical partitioning and combining the data from on-disk and memory-optimized tables.
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
This session focuses on nonclustered indexes. The session starts with query plan analysis techniques to help you better understand what SQL Server is doing, then dives into a walkthrough on how to use the tools to help decide which indexes are best. We'll talk about the "green hint" that shows up in showplan (the good and the bad) as well as using Database Tuning Advisor (DTA). If you want a jump start on creating the right indexes for better performance, this is the place to be!
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session shows the different aspects of programmability in the context of SSISDB. Beginning with a short overview of the underlying database objects, a deeper look at SSISDB's stored procedures follows. A side-step from T-SQL to C# and the available SSIS SDK illustrates a different view of SSISDB access. In conclusion, the analysis and reporting aspects of SSISDB programmability are shown with some exemplified SQL Server Reporting Services (SSRS) reports. The different examples are based on industry-based project experiences.
After this session, you will have a deeper knowledge about SSISDB's content and programming interfaces, and you will know how to start SSIS packages using T-SQL and C#. The pros and cons of these programming techniques will also be discussed.
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
MDX can seem daunting, but when broken down into the basics, it's easier than you think. We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!
The session walks through the difference between a member, measure, tuple, set, and dimension. We describe how to decipher a [] from a {} or a (), and we look at some of the awesome power that MDX can provide to your reporting.
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Resource Governor is one the most underused features available to enterprise edition users of SQL Server. In this session, we delve into the basics of the Resource Governor feature in SQL Server and when, why, and how you should use it. We look at the types of issues this feature can help resolve. We delve into various components of the feature, such as a classifier function, workload groups, and resource pools and how those components change the behavior of SQL Server. We bring all this together with a sample implementation. Along the way, we look at best practices and questions to answer to ensure a successful implementation.
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session covers 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 talk about basic techniques for querying data, the focus is on a basic understanding of how Hadoop works, how to plan for growth, and how to start maintaining a Hadoop cluster. Additional discussion covers the complementary nature of Hadoop and SQL Server.
Examples and demos highlight basic query tools, including transferring data to and from SQL Server.
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session dives deeper into the art of dimensional modeling. We look at how and when to create different types of fact and dimension tables, including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After this session, you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to this interactive and engaging session.
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 10:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2015 12:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 13:30 - Category: Half-Day Session (3 hours) - Track: Application & Database Development
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and could see it all happening live on a central monitoring website?
In this session, we'll take a detailed look at this scenario and build a system for such monitoring. We'll use the Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website, and the D3 JavaScript library for actual real-time visualizations on any device.
After seeing all this in action, you'll definitely get a few ideas on where you can use this approach in your company.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
This session demonstrates how to create a DocumentDB instance in Azure, work with JSON documents, create ad hoc queries with familiar SQL syntax, and create application logic as stored procedures, triggers, and user defined functions (UDFs), using standard JavaScript.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Professional Development
This course presents a variety of simple yet highly actionable techniques borrowed from some of the most stressful fields on earth. In this course, you learn to apply the same methods that doctors, military, law enforcement, and paramedics learn to cope and perform under high-stress situations. Discover how easily these techniques translate to almost any career or endeavor.
Whether you regularly support a multi-million dollar data center on a 24-hour on-call rotation or are asked to restore production while three levels of management look over your shoulder, counting the dollars lost per minute, everyone is susceptible to stress. Some people just have a higher immunity. Attend this inoculation session and get caught up on your boosters.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We begin with a super-fast-paced introduction to PowerShell, starting with a quick overview of the two environments in which you can use it: command windows and the Integrated Scripting Environment (IS). Next, learn about cmdlets, variables, functions, and logic flow. But wait, there's more! Learn how to interact with SQL Server by using the SQL Provider. For the last dance we limbo, going low level with the SQL Management Object library, (SMO).
Don't be left behind. Learn how to leverage the power of PowerShell in your SQL Server environment.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options.
Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, learn how businesses and IT can use Power Query--a free data integration tool and part of Power BI--to transform, combine, and share data from heterogeneous data sources, reducing the time and cost to prepare the data that is used to produce analysis and reports. We also discuss how Power Query fits in the larger BI landscape and the considerations and concerns that IT stakeholders have when adopting this type of self-service technology.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Using a live-typing approach, we start from scratch and by the end of the session, we create a full-blown staging environment. This includes the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment simply by changing the connection strings, or you can make small changes to implement your own data load patterns.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session describes the fundamentals of Big Data and Hadoop, leading to the introduction of Microsoft’s cloud-based Big Data service, Azure HDInsight. The session includes numerous demonstrations to show how files can be stored in the Azure Blob Store and efficiently processed with a cluster of servers. The demos will introduce Pig and Hive, designed to ensure that Big Data remains approachable to the developer, and the integration of Big Data into conventional business intelligence (BI) solutions.
This session will be of interest to those new to the concept of Big Data and interested in understanding the challenges that it is designed to solve.
Event Date: 28-10-2015 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Whether your people are in Boston, Berlin, Bangalore, or Beijing, they all need to work together. We look at the challenges of having a globally diverse team, including collaboration, feedback, work assignments, and performance evaluations. We also look at outsourcing, offshoring, and a combination of the two. And we look at one of the greatest benefits: follow-the-sun support.
In this session, we demonstrate how a language barrier isn't usually the biggest challenge and how cultural differences make the most impact.
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, datatypes, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them.
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
We look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. This session reminds you that the little things matter a lot when it comes to performance. Don't miss it!
Event Date: 28-10-2015 15:15 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
We will start with the best practices for managing SSAS, SSRS, and other BI systems, and then we will take deep dive into the scripting languages XMLA and MDX for administrative tasks and troubleshooting with Analysis Services' version of DMVs, schema rowsets. We will finish up by looking at how to create automated maintenance jobs for SSAS.
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
• The most useful regular expression commands • The appropriate times to use regular expressions • How to use regular expressions to write code for you • How to incorporate regular expressions into large tasks and combine them with other methods
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
SQL Server Analysis Services includes the Microsoft Time Series algorithm to provide an approach to intuitive and accurate time series forecasting. The algorithm can be used in scenarios when you have an historic series of data, and when you need to predict a future series of values that is based on more than just your gut instinct.
This session will describe how to prepare data, create and query time series data mining models, and interpret query results. A number of demonstration time series models will be created by using the data mining add-ins available in Excel, Visual Studio, and DMX script.
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We demonstrate how to use documented trace flags to look at the transformation rules that the optimizer has available.
With each SQL Server version, new transformation rules are introduced, changing the way the query optimization process works and sometimes dramatically improving performance. We look in depth at some of the most important transformation rules introduced in the SQL Server 2014 optimizer, explain their importance, and demonstrate how they work while comparing the results with older versions of SQL Server. We explain why query optimization complexity increases exponentially with the number of tables included in the plan, and how to diagnose and remedy issues that relate to bad query plans.
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
To spark discussion and keep the audience riveted, this session is styled as a technical presentation weaved into an interactive murder mystery, complete with suspects, interrogations, and clues. Attendees form small groups to observe, discuss, and ultimately solve the mystery of the deadly dynamic SQL.
Developers and DBAs: if you want to become wise in the ways of dynamic SQL, this session is for you. Be sure to bring your sleuthing skills!
Event Date: 28-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2015 16:45 - Category: Lightning Talk (75 minutes) - Track: Professional Development
Lightning Talks 104 focuses on the Professional Development track, featuring:
Adam Belebczuk - "STEM Education for Kids: A Call to Action"
Russ Thomas - "10 Minute Stress Inoculation: Performing Under Pressure"
Cathrine Wilhelmsen - "Help! I'm Supposed to Present Now but My Computer Is Dead!"
Brian Davis - "Treat Your Presentations like You Treat Your Data"
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 10:15 - Category: Lightning Talk (75 minutes) - Track: Application & Database Development
Lightning Talks 102 focuses on the AppDev track, featuring:
Aaron Burma - "Subqueries 2.0: Correlated Subqueries and Subquery Extensions"
Wayne Sheffield - "How Referential Integrity Helps SQL Server Optimize Queries"
Paul Wehland - "5 Absolute Rules of Minimally Logged Bulk Insert"
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Dynamic management views (DMVs) are a direct peek into the internal working of your database server. With them, mysteries can quickly be unraveled when trouble brews or even be prevented, through monitoring solutions that keep an eye on these views all the time.
Using queries that have been personally run and deployed in production environments, we explore what these views are used for, how to effectively use them, and the many problems that can be solved with them.
With these tools at your disposal, the slow-running query has nowhere to hide, missing indexes become plain as day, and resource pressure is easy to monitor and respond to. Now you can focus on all the other important things vying for your attention on a daily basis!
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, take a look at building non-traditional BI solutions by taking a hybrid approach with Power BI.
Discover how you can empower business users with self-service tools, in a way that doesn't compromise data security or governance. See how you can combine on-premise and Internet data sources with cloud-based BI services. Look at the Corporate Data Catalog to enable secure data discovery. And explore the Microsoft Data Management Gateway, which enables secure data-refresh scenarios for cloud-based BI solutions.
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, you'll see how a variety of Microsoft tools can be used to analyze this activity:
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
The session further explores the use of Azure ML regression algorithms and other statistical techniques to build an Azure ML experiment. Use this experiment to discover which features influence prices and then build an Azure ML predictive Web Service based on those features.
In the process of learning about Azure ML regression, and with a bit of luck, you might even get a model that works!
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
There are no prerequisites, but attendees are welcome to follow along with the demo if they have an Azure ML and Power BI account and R installed. Files will be released before the session.
Event Date: 29-10-2015 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 12:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 29-10-2015 13:30 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
This session will step you through building a Tabular Model from start to finish with a bonus Dashboard built in Excel 2013 PowerView. Data will be imported from various sources. Relationships built between these sources manually and from existing foreign keys. Slicing and Dicing with attributes and hierarchies ranging from the Date Dimension continuing thru a slowly changing type 2 dimension. Tabular includes a query language, Data Analysis Expressions (DAX) that will be used to build computed columns in dimensions, measures for analysis and a many-to-many relationship. Additional features include partitioning for performance, roles for security and perspectives for ease of use. The end product, visualizations, will be demonstrated through PowerView in Excel 2013.
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this presentation you will learn the concepts behind the new language and see examples of how to use it to query unstructured, semi-structured and structured data. It will show the similarities to the SQL and database objects you know and call out some of the important differences.
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, use scripts to query dynamic management views (DMVs) to identify the right objects on which to implement strategy, measure performance gains, and identify the impact on memory and other resources. Devise a sliding-window, data-loading strategy by using partition switching. Track fragmentation at the partition level and minimize index maintenance windows. Discover partitioning improvements in SQL Server 2014. Take home an advanced script for tracking usage and details on fragmentation, memory caching, compression levels, and partitioned objects.
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
I want you to walk away with knowledge of how this works, how you can get into trouble and how to correct any issues with it.
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 13: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 explore proven techniques for interviewing and identifying the best person to join your team.
Event Date: 29-10-2015 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 29-10-2015 15:15 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
This session is not for the faint of heart. We will cover a lot of material in a short time-frame, enough to make your own head spin(lock). And we will also move at a fast pace. This is a 500 level session where we will go deep into the internals of SQL Server as you learn the how, what, and why of wait types, latches, and spinlocks. Having said that, you will come up away with practical advice, tools, and tips you can use right way to use in your SQL Server environment. This session will be based on SQL Server 2012 and 2014 but many of the concepts we talk about can apply to previous versions. As a bonus we will discuss any relevant changes for SQL Server 2016 and how Azure database applications are affected by these topics.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Our panel of SQL Server experts share their current experiences in the data profession. They share what they believe you should be working towards now and in the future.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Application & Database Development
In this session, you learn about plan caching and how the Query Optimizer handles parameters. We talk about the pros and cons of parameter sniffing, as well as simple versus forced parameterization. But most important, we learn how to identify performance problems caused by poor parameter handling and we learn many techniques for solving these problems and boosting your application performance.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session shows you how to get the most from them. We explain what a baseline is, why and when you need to take one, and how you can create one. You also learn about native Windows and SQL Server tools that enable you to do just that. Don’t wait for a disaster to fully realize the importance of baselining.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session is part interactive mystery, part technical presentation in which attendees work together in small groups to discuss suspect interviews and clues, attempting to solve a SQL Server crime. We will focus on SQL Server Reporting Services (SSRS) administration, including:
If you're a database administrator (DBA) or developer who wants to learn key SSRS administration concepts while exercising your mystery-solving skills, this session is for you!
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Learn APS best practices such as choosing the right distribution key for tables, laying out the data model for optimal data movement and taking advantage of APS features such as the clustered columnstore index to get the best possible performance from SSAS cubes. This functionality is not without its limitations. Come see how to work around those limitations and optimize SSAS models to work with APS.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will learn:
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session looks inside the transaction log to see exactly what is logged for minimally logged operations. First, we look at some background information regarding how the log is used and managed, and then we introduce a tool that can help you actually see your log records.
When you can query the log, you can determine how logging for operations such as index rebuilds and SELECT INTO differs depending on whether you are using the FULL or BULK_LOGGED recovery model. We also look at other factors in our SQL Server operations that can affect what is actually written to the log.
Event Date: 29-10-2015 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 16:45 - Category: Lightning Talk (75 minutes) - Track: BI Information Delivery
Lightning Talks 103 focuses on the BIA and BID tracks, featuring:
Jen Stirrup - "Worst Data Visualizations Ever! What Not to do to Your Data"
Steve Wake - "Power BI: From Nothing to Dashboard in 10 Minutes!"
Dan Galavan - "Master Data Services: How Far Can It Take Your Organization?"
Paco Gonzalez - "Tone Analysis with HDInsight and Azure Machine Learning"
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
When it comes to budgeting, each company is unique. In this session, you learn some common techniques to use when building a budget model with Power Pivot and Power Query. These techniques include previous year allocation, multiple-step budgeting with linked back tables, and managing budget on products that do not yet exist.
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we'll explore the ten most frequent findings I bump into and wish I never bumped into again. Let's talk about best practices, look at some scripts to get on track with best practices and talk about these crucial issues.
You'll leave with scripts, anger about the findings and hopefully will take the time to knock those findings out of existence in your environments in the first week back from the PASS Summit. You want to leave proving you got something out of the Summit? Come to this session and go tackle these ten environment killers. You'll be well ahead of most of the environments we encounter in the field.
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 29-10-2015 16:45 - Category: General Session (75 minutes) - Track: Application & Database Development
EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it's changed over time. We'll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we'll review EF-generated T-SQL and give some tips on how to improve performance. If you're a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. In SQL Server 2012 and 2014, even more mechanisms followed, but challenges and problems remain.
We take a long look into the world of SQL Server concurrency and investigate pessimistic and optimistic isolation, how they work, when you should use them, and when they can go very wrong. Don't find yourself staring down the wrong end of SQL Server's two smoking barrels--join us for this revealing and thought-provoking presentation.
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
For each of these approaches, we go over how to script both a classic server-side trace and a newer Extended Events session to capture the information you need for analysis. You learn how to use T-SQL to query and make sense of the captured data from both collection types. We look at the results from each method of capture, side by side. The session includes plenty of demos and great take-away scripts.
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
We start with an understanding of the different index types and review the common pitfalls of indexing. Then, we quickly move to showing how you can identify index usage to determine whether there are not enough, too many, or even duplicates in the databases you manage. Our balance is achieved when we look at SQL Server 2014 and the options provided.
Event Date: 30-10-2015 08:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 09:30 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
This session goes into exhaustive detail about how to interpret the results of each diagnostic query, including relevant background information about how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases to avoid many performance and scalability issues.
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
Kibana is a visualisation tool that works seamlessly with Elasticsearch. It allows you to create time-based comparisons over your data and gives the users power to derive insight from the data. It has many visualisations available, and this session shows you the right ones to use for the situation.
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: Professional Development
In this panel discussion, you hear about lessons learned, common mistakes, and challenges discovered during the panel’s transition from corporate America to independent consulting.
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this demo-based session, we give you a complete overview into a customer project during which we used SQL Server Integration Services (SSIS), SSRS, and Master Data Services (MDS) to do exactly that:
Event Date: 30-10-2015 09:30 - Category: Half-Day Session (3 hours) - Track: BI Information Delivery
Skills you will learn apply to both on-prem solutions using Excel Power* add-ins and cloud solutions using hosted Power BI. I recommend installing 64 bit software with at least 4 GB of RAM, 8 GB recommended.
Event Date: 30-10-2015 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: Application & Database Development
If you answered yes to any of these questions, then this session is for you! We'll start with why XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML. Finally, we'll confront the true source of our anxiety by parsing XML back into tabular data, using xQuery.
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Although this session doesn't teach you everything you need to know, it gives you some insights into the SQL Server database engine--and the ability to know what you're looking for.
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
For that, Microsoft has published a famous whitepaper called "The Data Loading Performance Guide". The problem is that it's long and full of details, and most of us are too busy (or too lazy) to read it.
In this session, we turn the whitepaper into a presentation and talk about the ways you can optimize your massive data-loading processes by applying the techniques therein. We also discuss other advanced techniques that have emerged since the whitepaper was published.
Among other topics, we talk about the #1 enemy of high-performance data loading, minimal logging, bulk load, indexing techniques, properly leveraging parallelism and partitioning, SQL Server 2014 delayed durability, and more.
Event Date: 30-10-2015 11:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Event Date: 30-10-2015 11:00 - Category: Lightning Talk (75 minutes) - Track: Enterprise Database Administration & Deployment
Lightning Talks 101 focuses on the DBA track, featuring:
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 11:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
What if you can stretch an existing SQL Server table to Azure little or no application changes? Data is moved securely and transparently. Standard TSQL queries continue to work as-is regardless of where the data is stored. Backup/restore just hot data while cold/archive data is automatically protected. Re-index only the few million rows of hot data though the table has billions of rows in total.
All this while DBAs retains full control from the on-prem SQL Server even if advanced security features such as row level security or encryption is employed. Come learn how you can with Stretch Database.
Event Date: 30-10-2015 13:15 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session shows you how to reach into the database and discover compression states at the page level. At the lower level, this session also shows how to determine compression settings of objects in the database. You can use both some undocumented and more commonly known commands to derive some interesting information from the database engine.
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
The first task is choosing a dashboard type and purpose. This session reviews a framework to determine the theme and content of a dashboard. We look at common graphical content and how to use tables in a dashboard. We also examine table-specific content such as microcharts, icons, and exception highlighting.
Dashboard layout and flow is not covered in the literature about dashboards but is important. Which content should be adjacent on the dashboard? How do you arrange content that should be scanned in a particular order? We review how to arrange dashboard content and set up appropriate navigation.
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 14:00 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.
In this session you will:
This is a demo-intensive session, so you can see rolling upgrades live and up close.
If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Application & Database Development
As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.
This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session demonstrates the architecture of a master data management (MDM) solution and the data integration required to implement it within the enterprise:
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
However, dynamically scaling the database tier can be difficult due to having to deal with distribution schemes, data movement, application routing and the actual increase or decrease of the database resources.
Azure SQL Database and the Elastic Scale .NET API combine to provide a solution to these challenges in an easy to use but powerful set of capabilities. In this session we will demo the main building blocks of the Elastic Scale API, how they combine with SQL Azure and how to bring database elasticity in your own application!
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Typical reasons for transaction delays include slow transaction logs, page splits, blocking, over-indexing, and even some configuration settings of your database or instance. Query-tuning tips are slightly different than those for transactions, and this session is about OLTP performance troubleshooting. See some typical scenarios of transaction delays and the reasons behind them. This session will help you in your performance troubleshooting efforts and improve your level of confidence.
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Application & Database Development
Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session discusses how to use SQL Server Reporting Services (SSRS) to bring it all together while avoiding pitfalls and mistakes. The demonstration shows you how to build a multipage, dashboard-style report to manage your report server, showing a multitude of grids and charts. Discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We'll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
The real question, though, is just how transparent is TDE?
In this second installment of the Hacking Exposé series, we assume the role of a hacker, dig into our database, and steal your backups and data files. Next, we try to restore the files, and even dig into the files themselves and see what might be exposed.
We then go through the steps to lock down your data using TDE. Once again, we assume the role of a hacker and try to dig through the database, steal backups and data files, and see what is available to us.
*Warning: Do not try these demos at work without proper permissions, as some actual hacking techniques are used.
Event Date: 30-10-2015 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
SQL Server AlwaysOn Availability Groups deployed in Azure have specific requirements that we discuss in detail and illustrate through live demonstrations. Demos include configuration via both PowerShell and the Azure Portal.
Hybrid cloud configurations are also introduced as a disaster recovery solution for SQL Server deployments. On premise-to-cloud, cloud-to-cloud, and intercloud options are demonstrated, and the benefits of each configuration are discussed in detail.