| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 14-10-2013 08:30 | Paul Randal | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Practical Disaster Recovery Techniques |
| 14-10-2013 08:30 | Glenn Berry | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Scaling SQL Server 2012 |
| 14-10-2013 08:30 | Shon Hauck, Curt Mathews | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Enterprise High Availability with AlwaysOn Availability Groups |
| 14-10-2013 08:30 | Stacia Varga | Pre-Conference Session (full day) | BI Information Delivery | From Reporting Services Rookie to Rockstar |
| 14-10-2013 08:30 | Paul White | Pre-Conference Session (full day) | Application & Database Development | Understanding the Optimizer and Interpreting Execution Plans |
| 14-10-2013 08:30 | Itzik Ben-Gan | Pre-Conference Session (full day) | Application & Database Development | Practical T-SQL – Efficient Solutions |
| 14-10-2013 08:30 | Devin Knight, Brian Knight | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Growing Up with SSAS: From PowerPivot to MOLAP Cubes |
| 15-10-2013 08:30 | Denny Cherry | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Storage and Virtualization for DBAs |
| 15-10-2013 08:30 | Michael Thomassy, Silvano Coriani, Conor Cunningham | Pre-Conference Session (full day) | Cloud Application Development & Deployment | SQLCAT: Windows Azure Data Platform Technical Immersion Day |
| 15-10-2013 08:30 | Allan Hirt | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Plan and Deploy Successful Clustered Solutions for SQL Server |
| 15-10-2013 08:30 | Louis Davidson | Pre-Conference Session (full day) | Application & Database Development | How to Design a Relational Database |
| 15-10-2013 08:30 | Kendra Little, Jes Schultz, Brent Ozar | Pre-Conference Session (full day) | Application & Database Development | Make SQL Server Apps Go Faster |
| 15-10-2013 08:30 | Grant Fritchey | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Thriving as a DBA in the World of Cloud and On-Premise Data |
| 15-10-2013 08:30 | Jen Stirrup, Allan Mitchell | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Big Data for the Business Intelligence Professional |
| 16-10-2013 08:15 | Keynote (90 minutes) | Keynote | SQL Server 2014 and the Hybrid Cloud | |
| 16-10-2013 10:15 | Jason Thomas | Regular Session (75 minutes) | BI Information Delivery | Visualizing John Snow's Cholera Map Using Microsoft BI |
| 16-10-2013 10:15 | Michael Antonovich | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Putting Quality Back in Your Data Analysis |
| 16-10-2013 10:15 | Nabeel Derhem | Regular Session (75 minutes) | Cloud Application Development & Deployment | Moving Your Database to the Cloud – What You Need to Know |
| 16-10-2013 10:15 | Erin Stellato | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Making the Leap from Profiler to Extended Events |
| 16-10-2013 10:15 | Mark Russinovich | Spotlight Session (90 minutes) | Cloud Application Development & Deployment | Windows Azure Deep Dive |
| 16-10-2013 10:15 | Tim Chapman, Thomas LaRock, Tim Chapman | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Query Performance Tuning: A 12-Step Method |
| 16-10-2013 10:15 | Erin Welker | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | BI Best Practices: The Good, the Bad, and the Ugly |
| 16-10-2013 10:15 | Kevin Kline | Regular Session (75 minutes) | Professional Development | Convince Me – Persuasion Techniques That Get Things Done |
| 16-10-2013 10:45 | Kay Unkroth | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Deploying Microsoft BI in SharePoint 2013, Part 1: PowerPivot |
| 16-10-2013 10:45 | Faisal Mohamood | Regular Session (75 minutes) | BI Information Delivery | Microsoft Power Query for Excel: Discover and Refine Your Data |
| 16-10-2013 10:45 | Mindy Curnutt | Regular Session (75 minutes) | Application & Database Development | Exposing a Chatty Cathy: What a Drag! |
| 16-10-2013 10:45 | Denny Cherry | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Optimizing SQL Server Performance in a Virtual Environment |
| 16-10-2013 10:45 | Riccardo Muti, Amy Forstrom | Regular Session (75 minutes) | BI Information Delivery | Visual Analytics with Power View in Excel 2013 & SharePoint 2013 |
| 16-10-2013 10:45 | Luis Vargas | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | AlwaysOn in SQL Server 2014 |
| 16-10-2013 10:45 | Christina Leo | Regular Session (75 minutes) | Application & Database Development | Building Your T-SQL Tool Kit: Window Function Fundamentals |
| 16-10-2013 13:30 | Devin Knight | Regular Session (75 minutes) | BI Information Delivery | Creating an End-to-End Power View Reporting Solution |
| 16-10-2013 13:30 | Randy Knight | Regular Session (75 minutes) | Application & Database Development | Understanding Transaction Isolation Levels |
| 16-10-2013 13:30 | Scott Klein | Regular Session (75 minutes) | Cloud Application Development & Deployment | Windows Azure SQL Database for the DBA |
| 16-10-2013 13:30 | Mark S. Rasmussen | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Understanding Data Files at the Byte Level |
| 16-10-2013 13:30 | Tim Mitchell | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Cleansing in SSIS |
| 16-10-2013 13:30 | Glenn Berry | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Professor DMV: How to Use DMVs to Diagnose Performance Issues |
| 16-10-2013 13:30 | Stuart Ainsworth | Regular Session (75 minutes) | Application & Database Development | SQL Server XML 101 |
| 16-10-2013 13:30 | Adam Jorgensen, Lara Rubbelke | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Enriching Big Data for Analysis |
| 16-10-2013 13:30 | Gail Shaw | Half-Day Session (3 hours) | Application & Database Development | Indexes: Everything You Need to Know |
| 16-10-2013 13:30 | Carlos Bossy | Regular Session (75 minutes) | BI Information Delivery | Predictive Analytics: Letting the Data Decide |
| 16-10-2013 13:30 | Ajay Jagannathan | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Extended Events in SQL Server 2012 |
| 16-10-2013 13:30 | Susan O'Connell | Regular Session (75 minutes) | BI Information Delivery | PowerPivot Data Modeling Techniques |
| 16-10-2013 13:30 | Lori Woehler | Regular Session (75 minutes) | Cloud Application Development & Deployment | Busting Myths: Windows Azure Security and Compliance |
| 16-10-2013 13:30 | Bob Ward | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | Inside SQL Server 2012 Memory: The Sequel |
| 16-10-2013 13:30 | Ben DeBow | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Congratulations, You're Now a DBA... |
| 16-10-2013 15:00 | Edwin M Sarmiento | Lightning Talks (10 minutes) | Enterprise Database Administration & Deployment | The Role of Active Directory and DNS in SQL Server HA/DR |
| 16-10-2013 15:00 | Matt Masson, Wee Hyong Tok | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | SQL Server Integration Services Roadmap |
| 16-10-2013 15:00 | Rob Volk, Ed Watson | Lightning Talks (10 minutes) | Enterprise Database Administration & Deployment | DBAs in Toyland: Here's Another Fine Mess You've Gotten Me Into! |
| 16-10-2013 15:00 | Hope Foley | Regular Session (75 minutes) | Application & Database Development | Spatial Data: Cooler Than You'd Think! |
| 16-10-2013 15:00 | Michael Wells | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Using PowerShell to Quickly Deploy New SQL Server Instances |
| 16-10-2013 15:00 | Craig Purnell | Lightning Talks (10 minutes) | Professional Development | Are You Certified or Certifiable? |
| 16-10-2013 15:00 | Stacia Varga | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | Reduce, Reuse, Recycle: Automating Your BI Framework |
| 16-10-2013 15:00 | Ari Schorr, Dandy Weyn | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 and Sharks with Freakin’ Lasers |
| 16-10-2013 15:00 | Tim Radney | Lightning Talks (10 minutes) | Application & Database Development | The Ultimate Tail Log Backup and Restore |
| 16-10-2013 15:00 | Brian Knight | Spotlight Session (90 minutes) | BI Information Delivery | Ninja Data Moves in Office 2013 |
| 16-10-2013 15:00 | Peter Myers | Regular Session (75 minutes) | BI Information Delivery | SQL Server 2012 Data Mining: Taking App Design to the Next Level |
| 16-10-2013 15:00 | Darmadi Komo | Regular Session (75 minutes) | Cloud Application Development & Deployment | Private and Hybrid Cloud: Better Together |
| 16-10-2013 15:00 | Chuck Heinzelman, Riccardo Muti | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Deploying Microsoft BI in SharePoint 2013, Part 2: SSRS & Power View |
| 16-10-2013 15:00 | Steve Wake | Lightning Talks (10 minutes) | BI Platform Architecture, Development & Administration | Master the Date Dimension Like a Time Lord |
| 16-10-2013 15:00 | Dan Evans | Lightning Talks (10 minutes) | BI Information Delivery | BI on the Fly |
| 16-10-2013 15:00 | Nicholas Cain | Regular Session (75 minutes) | Professional Development | Hirable and Desirable: How to Make Companies Want You |
| 16-10-2013 15:00 | Joseph D'Antoni | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Accelerate Database Performance Through Data Compression |
| 16-10-2013 15:00 | Dan Evans, Edwin M Sarmiento, Tim Radney, Craig Purnell, Rob Volk, Steve Wake, Ed Watson | Regular Session (75 minutes) | Professional Development | Lightning Talks 101 |
| 16-10-2013 15:00 | Aaron Bertrand | Spotlight Session (90 minutes) | Application & Database Development | T-SQL: Bad Habits and Best Practices |
| 16-10-2013 16:45 | Dejan Sarka | Regular Session (75 minutes) | BI Information Delivery | Fraud Detection: Notes from the Field |
| 16-10-2013 16:45 | Michael Tejedor, Dandy Weyn | Regular Session (75 minutes) | BI Information Delivery | Introduction to Power BI for Office 365 |
| 16-10-2013 16:45 | Melissa Coates | Regular Session (75 minutes) | BI Information Delivery | So You Want to Be a Rockstar Report Developer? |
| 16-10-2013 16:45 | Tim Ford | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Periodic Table of DMVs: Part 2012 - The SQL |
| 16-10-2013 16:45 | Ryan Adams | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | How Active Directory Affects SQL Server |
| 16-10-2013 16:45 | Allan Hirt | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Troubleshooting Clusters |
| 16-10-2013 16:45 | Arie Jones | Regular Session (75 minutes) | Application & Database Development | Keeping an Eye on Your Data with Change Data Capture |
| 16-10-2013 16:45 | Adam Mahood | Regular Session (75 minutes) | Cloud Application Development & Deployment | What’s New in Database Development with SQL Server Data Tools and Visual Studio? |
| 16-10-2013 16:45 | Louis Davidson | Spotlight Session (90 minutes) | Application & Database Development | How to Model and Implement a Hierarchy in SQL Server |
| 16-10-2013 16:45 | Grant Fritchey | Spotlight Session (90 minutes) | Cloud Application Development & Deployment | Query Performance Tuning for Azure SQL Database |
| 16-10-2013 16:45 | Rohit Bakhshi, Brian Swan | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Under the Covers of Hadoop on Windows |
| 16-10-2013 16:45 | Allen White | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | Automate Your ETL Infrastructure with SSIS and PowerShell |
| 16-10-2013 16:45 | Chuck Heinzelman, Sanjay Mishra, Luis Vargas, Piyush Ranjan, Evgeny Krivosheev, Khalid Mouss | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Windows Azure Virtual Machines and SQL Server Unplugged |
| 16-10-2013 16:45 | Kasper de Jonge | Regular Session (75 minutes) | BI Information Delivery | Enriching Your BI Semantic Tabular Models with DAX |
| 16-10-2013 16:45 | Robert Cain | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Installing and Configuring SQL Server 2012 Reporting Services |
| 17-10-2013 08:15 | David DeWitt | Keynote (90 minutes) | Keynote | Hekaton: Why, What, and How |
| 17-10-2013 10:15 | John Welch | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Unit and Integration Testing for SSIS Packages |
| 17-10-2013 10:15 | Devin Knight, Dustin Ryan | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Choosing the Right Analysis Services: MOLAP vs. Tabular |
| 17-10-2013 10:15 | Jose Chinchilla | Regular Session (75 minutes) | BI Information Delivery | PowerPivot + Power View = Self-Service BI Revolution |
| 17-10-2013 10:15 | Kimberly Tripp | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad |
| 17-10-2013 10:15 | Lord Richard Douglas, Patrick O'Keeffe | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Best Practices for Optimizing SQL Server with Solid State Disk |
| 17-10-2013 10:15 | John Sterrett | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Table Partitioning: Secret Weapon for Big Data Problems |
| 17-10-2013 10:15 | Mark Vaillancourt | Regular Session (75 minutes) | Professional Development | DANGER! The Art and Science of Presenting |
| 17-10-2013 10:15 | Jorge Segarra | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | What Is a BI DBA? |
| 17-10-2013 10:45 | Gregory Leake | Regular Session (75 minutes) | Cloud Application Development & Deployment | Lap Around Windows Azure SQL Database Premium Service |
| 17-10-2013 10:45 | Lara Rubbelke, Rafael Fernandez | Regular Session (75 minutes) | Application & Database Development | Compliance in Azure: The Big Data Conversation |
| 17-10-2013 10:45 | Christopher Price | Regular Session (75 minutes) | Cloud Application Development & Deployment | Running with Elephants: Predictive Analytics with HDInsight |
| 17-10-2013 10:45 | Kendal Van Dyke | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Discover, Document, and Diagnose Your Servers on Your Coffee Break |
| 17-10-2013 10:45 | Matt Masson, Kasper de Jonge, Matthew Roche, Riccardo Muti, Faisal Mohamood | Regular Session (75 minutes) | BI Information Delivery | Power BI – This Is How We Do It |
| 17-10-2013 10:45 | J May | Regular Session (75 minutes) | Application & Database Development | Columnstore Indexes Today & v.Next: Flipping the DW /faster Bit |
| 17-10-2013 10:45 | Nabeel Derhem | Regular Session (75 minutes) | Application & Database Development | NoSQL: An Introduction |
| 17-10-2013 13:30 | Frank Cicalese | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Reference Architectures on Cisco Unified Compute System |
| 17-10-2013 13:30 | Luke Jian | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Anatomy of a Join |
| 17-10-2013 13:30 | Amy Forstrom, Adam Wilson | Regular Session (75 minutes) | BI Information Delivery | Power BI: Modern Device and Data Search Experiences |
| 17-10-2013 13:30 | Karen Lopez | Regular Session (75 minutes) | Cloud Application Development & Deployment | Windows Azure SQL Database Design: Silver Lining and Dark Side |
| 17-10-2013 13:30 | Sanil Mhatre | Regular Session (75 minutes) | Application & Database Development | Unit Testing Made Easy for Database Development |
| 17-10-2013 13:30 | Audrey Hammonds | Regular Session (75 minutes) | Application & Database Development | Design Matters! The Performance Impact of Database Design |
| 17-10-2013 13:30 | Doug Lane | Regular Session (75 minutes) | BI Information Delivery | From Minutes to Milliseconds: High-Performance SSRS Tuning |
| 17-10-2013 13:30 | Erin Welker | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | A Systematic Approach to ETL Performance Tuning |
| 17-10-2013 13:30 | Jason Thomas | Regular Session (75 minutes) | BI Information Delivery | Geospatial Analytics Using Microsoft BI |
| 17-10-2013 13:30 | John Hoang, Binh Cao, Tomas Polanco | Regular Session (75 minutes) | Application & Database Development | CAT: Architecting Near Real-Time Data Warehouses on PDW |
| 17-10-2013 13:30 | Jen Stirrup, Allan Mitchell | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Demystifying Big Data for BI Professionals: The Essentials |
| 17-10-2013 13:30 | Thomas LeBlanc | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Slicing and Dicing: Attributes and Hierarchies in SSAS 2012 |
| 17-10-2013 13:30 | Matt Masson, Wee Hyong Tok | Regular Session (75 minutes) | BI Information Delivery | Power BI and the Data Management Gateway |
| 17-10-2013 13:30 | Kevin Liu | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2014 In-Memory OLTP: DBA Deep Dive |
| 17-10-2013 13:30 | Kevin Farlee, Evgeny Krivosheev | Regular Session (75 minutes) | Application & Database Development | SQL Server 2014 and the Hybrid Cloud |
| 17-10-2013 15:00 | Sanjay Mishra | Regular Session (75 minutes) | Application & Database Development | CAT: Business Continuity with SQL Server – Real-Life War Stories |
| 17-10-2013 15:00 | Brian Walker, Murshed Zaman | Regular Session (75 minutes) | Application & Database Development | CAT: PDW Architecture Gets Real - Customer Implementations |
| 17-10-2013 15:00 | Niko Neugebauer | Lightning Talks (10 minutes) | BI Information Delivery | NodeXL in 10 Minutes |
| 17-10-2013 15:00 | Rob Farley | Spotlight Session (90 minutes) | Application & Database Development | These Aren't the Joins You're Looking for... |
| 17-10-2013 15:00 | Andrew Kelly | Spotlight Session (90 minutes) | Application & Database Development | Maximizing Plan Reuse |
| 17-10-2013 15:00 | Jose Chinchilla | Lightning Talks (10 minutes) | BI Platform Architecture, Development & Administration | Conformed Stored Procedures |
| 17-10-2013 15:00 | Ryan Adams | Lightning Talks (10 minutes) | Enterprise Database Administration & Deployment | How to Monitor Policy-Based Management |
| 17-10-2013 15:00 | Lord Richard Douglas | Lightning Talks (10 minutes) | Application & Database Development | Teaching Nerds T-SQL with “Star Wars” |
| 17-10-2013 15:00 | Jonathan Kehayias | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | SQL Server Archaeology: Dig into the Past with system_health |
| 17-10-2013 15:00 | Yuri Michael Diomin | Lightning Talks (10 minutes) | Application & Database Development | From Postal Addresses to Spatial Data: A Simple Geocoding UDF |
| 17-10-2013 15:00 | Rafael Salas | Regular Session (75 minutes) | BI Information Delivery | Self-Service ETL and Power Query: Are We There Yet? |
| 17-10-2013 15:00 | Aaron Nelson, Michael Wells | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | DBA Task Automation: Unleash the PowerShell Hero in You! |
| 17-10-2013 15:00 | Andy Leonard | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Designing an SSIS Framework |
| 17-10-2013 15:00 | Lara Rubbelke, Ari Schorr | Regular Session (75 minutes) | BI Information Delivery | Power BI 3D Visualization and Storytelling with Power Map |
| 17-10-2013 15:00 | Jose Chinchilla, Ryan Adams, Niko Neugebauer, Jeff Renz, Lord Richard Douglas, Yuri Michael Diomin | Regular Session (75 minutes) | Professional Development | Lightning Talks 102 |
| 17-10-2013 15:00 | Colin Stasiuk | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Doing More with Less: SQL Server Policy-Based Management |
| 17-10-2013 15:00 | Grant Fritchey, Dandy Weyn | Regular Session (75 minutes) | Cloud Application Development & Deployment | Being the DBA of the Future: A World of On-Premise and Cloud |
| 17-10-2013 15:00 | Jeff Renz, Leslie Weed | Lightning Talks (10 minutes) | Application & Database Development | Introduction to Data Vault Data Warehouse Architecture |
| 17-10-2013 15:00 | Greg Galloway, John Sirmon | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | CAT: Performance Tuning Tabular Models in SSAS 2012 |
| 17-10-2013 17:00 | Kun Cheng | Regular Session (75 minutes) | Application & Database Development | CAT: Architecture Patterns & Lessons Learned from Azure Projects |
| 17-10-2013 17:00 | Patrick LeBlanc, Matt Masson, Kasper de Jonge, Matthew Roche, Riccardo Muti, Adam Wilson | Spotlight Session (90 minutes) | BI Information Delivery | BI Power Hour |
| 17-10-2013 17:00 | Sanjay Mishra, Silvano Coriani | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | CAT: SQL Server on Azure VM – Performance and Best Practices |
| 17-10-2013 17:00 | Josh Fennessy | Regular Session (75 minutes) | BI Information Delivery | PerformancePoint: Not a Lost Treasure, An Analytic Gem |
| 17-10-2013 17:00 | Robert Cain | Regular Session (75 minutes) | Application & Database Development | SQL Server Database Projects in SQL Server 2012 Data Tools |
| 17-10-2013 17:00 | Kevin Kline, Aaron Bertrand | Spotlight Session (90 minutes) | Application & Database Development | 10 Query Tuning Techniques Every SQL Programmer Should Know |
| 17-10-2013 17:00 | Matt Velic | Regular Session (75 minutes) | Cloud Application Development & Deployment | Automating in the Cloud |
| 17-10-2013 17:00 | Dmitri Korotkevitch | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | From S to 3XL: Implementing Data Partitioning and Tiered Storage |
| 17-10-2013 17:00 | Gail Shaw | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Dos and Don’ts of Database Corruption |
| 17-10-2013 17:00 | Conor Cunningham | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | OLTP Sharding Techniques for Massive Scale |
| 17-10-2013 17:00 | Jes Schultz | Regular Session (75 minutes) | Application & Database Development | Index Methods You're Not Using |
| 17-10-2013 17:00 | Brian Mitchell | Regular Session (75 minutes) | Application & Database Development | Polybase Deep Dive |
| 17-10-2013 17:00 | Bill Fellows | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Type More, Click Less: Programmatically Build SSIS Packages |
| 17-10-2013 17:00 | Paul Randal | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Waits, Latches, and Spinlocks: Internals and Analysis |
| 17-10-2013 17:00 | Stacia Varga | Regular Session (75 minutes) | BI Information Delivery | Planning Your Report Design |
| 18-10-2013 08:00 | Christian Wade | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Get Your MDX/DAX Tips and Tricks: Currency Conversion |
| 18-10-2013 08:00 | Kendra Little | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | How to Tell When Storage Is a Problem |
| 18-10-2013 08:00 | Brent Ozar | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Why Is SQL Server Slow Right Now? |
| 18-10-2013 08:00 | Rob Farley | Spotlight Session (90 minutes) | Application & Database Development | Table Expressions: So Much More than CTEs |
| 18-10-2013 08:00 | Neil Hambly | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Load Testing with SQL Server Tools |
| 18-10-2013 08:00 | Dandy Weyn | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Upgrading SQL Server – Done Right |
| 18-10-2013 08:00 | Dejan Sarka | Regular Session (75 minutes) | BI Information Delivery | Advanced Analytics in Excel 2013 |
| 18-10-2013 08:00 | Marc Reguera | Regular Session (75 minutes) | BI Information Delivery | From Data to Insight: Views from Microsoft Finance |
| 18-10-2013 08:00 | Michael Thomassy, Silvano Coriani | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | CAT: How Do I Troubleshoot My Database in the Cloud? |
| 18-10-2013 08:00 | Thomas LeBlanc | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Transitioning from T-SQL to MDX |
| 18-10-2013 08:00 | Patrick LeBlanc | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Securing SSAS Tabular Models |
| 18-10-2013 08:00 | Dan Bulos | Regular Session (75 minutes) | BI Information Delivery | Dashboard Design Best Practices |
| 18-10-2013 08:00 | Tim Chapman | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Index Internals: A Deep Dive |
| 18-10-2013 08:00 | Peter Myers | Regular Session (75 minutes) | BI Information Delivery | Mastering the CUBE Functions in Excel |
| 18-10-2013 08:00 | Karen Lopez, Steve Jones, Erin Stellato, Kevin Kline, Grant Fritchey, Andy Leonard, Thomas LaRock, Aaron Bertrand | Regular Session (75 minutes) | Professional Development | How to Avoid Living at Work: Lessons from Working at Home |
| 18-10-2013 09:45 | Richard Bolesta | Regular Session (75 minutes) | Professional Development | Leadership: Transcending Management |
| 18-10-2013 09:45 | Ryan Adams | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Policy-Based Management and Central Management Server |
| 18-10-2013 09:45 | Colin Stasiuk | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQL Server Showdown |
| 18-10-2013 09:45 | Sanjay Mishra, Luis Vargas | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQL Server High Availability & Disaster Recovery in Windows Azure |
| 18-10-2013 09:45 | Glenn Berry | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Storage Subsystem Basics for the DBA |
| 18-10-2013 09:45 | Mike Walsh | Spotlight Session (90 minutes) | Professional Development | Never Have to Say "Mayday!!!" Again |
| 18-10-2013 09:45 | Bradley Ball | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Data Internals Deep Dive |
| 18-10-2013 09:45 | Leonard Lobel | Regular Session (75 minutes) | Application & Database Development | Geospatial Data Types in SQL Server 2012 |
| 18-10-2013 10:15 | Kevin Farlee | Regular Session (75 minutes) | Application & Database Development | SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive |
| 18-10-2013 10:15 | Cindy Gross | Regular Session (75 minutes) | Application & Database Development | Zero to 60 with HDInsight |
| 18-10-2013 10:15 | Jen Stirrup | Regular Session (75 minutes) | BI Information Delivery | Visualize Your Big Data with HDInsight, Power View, and Excel |
| 18-10-2013 10:15 | Josef Richberg | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Unseen Minions: Improving Parallel Processing in SSIS |
| 18-10-2013 10:15 | Adam Saxton | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Death by a Thousand Cuts: A Look at Power View Performance |
| 18-10-2013 10:15 | Matthew Roche, Ofer Ashkenazi | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Power BI Self-Service Information Management and Data Stewardship |
| 18-10-2013 10:15 | Silvano Coriani, Jason Roth | Regular Session (75 minutes) | Application & Database Development | Using Batching to Optimize SQL Database Apps on Windows Azure |
| 18-10-2013 13:00 | Cindy Gross, Dipti Sangani | Regular Session (75 minutes) | Application & Database Development | CAT: From Question to Insight with HDInsight and BI |
| 18-10-2013 13:00 | Michael Antonovich | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Introducing Cube World to Users from Flat Table Land |
| 18-10-2013 13:00 | Andreas Wolter | Regular Session (75 minutes) | Application & Database Development | From Locks to No Locks – Concurrency in SQL Server |
| 18-10-2013 13:00 | Daniel Sol | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQL Server Performance and Monitoring in Windows Azure at Scale |
| 18-10-2013 13:00 | Bob Pusateri | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Whatcha Doin'? Passive Security for Hostile Environments |
| 18-10-2013 13:00 | Joe Webb | Spotlight Session (90 minutes) | Professional Development | Building a Better Team Through Feedback |
| 18-10-2013 13:00 | Mark S. Rasmussen | Regular Session (75 minutes) | Application & Database Development | Top Tricks and Best Practices for .NET SQL Server Developers |
| 18-10-2013 13:00 | Regular Session (75 minutes) | BI Information Delivery | The New Hotness: SQL Server 2012 and SharePoint 2013 | |
| 18-10-2013 13:00 | John Welch | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Moving Big Data: SSIS, Pig, and Sqoop |
| 18-10-2013 13:00 | Brian Knight | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | Data Mining in SQL Server Analysis Services |
| 18-10-2013 13:00 | David Klee | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Squeezing Top Performance from Your Virtualized SQL Server |
| 18-10-2013 13:00 | Brian Mitchell | Regular Session (75 minutes) | Application & Database Development | Clustered Updatable Columnstore Indexes |
| 18-10-2013 13:00 | Michael Steineke, Mike Weiner, Emanuel Rivera Aleman | Regular Session (75 minutes) | Application & Database Development | CAT: SQL Server 2014 In-Memory OLTP – Customer Migration |
| 18-10-2013 13:00 | Tim Chapman, Denzil Ribeiro | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Transaction Log Internals |
| 18-10-2013 13:00 | James Serra | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Building an Effective Data Warehouse Architecture |
| 18-10-2013 13:15 | Adam Jorgensen, Sri Sridharan, Denise McInerney, Thomas LaRock, Rob Farley, Rushabh Mehta, Jennifer Moser, Olivier Matrat, Wendy Pastrick, Neil Buchwalter, Bill Graziano, Douglas McDowell, James Rowland-Jones, Richard Bolesta | Regular Session (75 minutes) | Professional Development | PASS Board Q&A |
| 18-10-2013 14:45 | Julie Koesmarno | Regular Session (75 minutes) | BI Information Delivery | From Impaired to Insightful: Analysis with Geospatial Data |
| 18-10-2013 14:45 | Mladen Prajdić | Regular Session (75 minutes) | Application & Database Development | Custom Replication with Service Broker and CDC/CT |
| 18-10-2013 14:45 | David Darden | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Building a Supportable ETL Framework |
| 18-10-2013 14:45 | Faisal Mohamood, Theresa Palmer-Boroski, Clemens Szyperski | Regular Session (75 minutes) | BI Information Delivery | Deep Dive into the Power Query Formula Language |
| 18-10-2013 14:45 | Joseph D'Antoni | Regular Session (75 minutes) | Cloud Application Development & Deployment | Into the Blue: Extending AlwaysOn Availability Groups |
| 18-10-2013 14:45 | Kathi Kellenberger | Regular Session (75 minutes) | Application & Database Development | Writing Better Queries with Window Functions |
| 18-10-2013 14:45 | Michael Fal | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Monitoring Methodologies: The Hierarchy of Database Needs |
| 18-10-2013 14:45 | Jose Chinchilla | Half-Day Session (3 hours) | BI Platform Architecture, Development & Administration | Fast Performing SSAS Hierarchies: Tips and Tricks |
| 18-10-2013 14:45 | Kasper de Jonge, Riccardo Muti | Regular Session (75 minutes) | BI Information Delivery | Power View with Analysis Services Multidimensional Models |
| 18-10-2013 14:45 | Paul Randal | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Index Fragmentation: Internals, Analysis, and Solutions |
| 18-10-2013 14:45 | Kendal Van Dyke | Half-Day Session (3 hours) | Enterprise Database Administration & Deployment | SQL Server Disaster Recovery and High Availability Overview |
| 18-10-2013 14:45 | Brian Moran | Regular Session (75 minutes) | Professional Development | Workplace Coaching: Simple Skills that Change Everything |
| 18-10-2013 14:45 | Tim Mitchell | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Make Your SSIS Packages Run Faster: 10 Quick Tips |
| 18-10-2013 14:45 | Ayad Shammout, Thomas Grohser, Michael Steineke, Sanjay Mishra, David Smith | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices |
| 18-10-2013 14:45 | Steve Howard | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | CAT: High Performance, High Volume Data Movement in Azure |
| 18-10-2013 16:15 | Benjamin Nevarez | Regular Session (75 minutes) | Application & Database Development | Defeating the Limitations of the Query Optimizer |
| 18-10-2013 16:15 | Lindsey Allen, Rafael Fernandez | Regular Session (75 minutes) | Application & Database Development | CAT: Event-Driven System-Health Monitoring at Microsoft Commerce |
| 18-10-2013 16:15 | Chuck Heinzelman | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Running BI Workloads on Windows Azure Virtual Machines |
| 18-10-2013 16:15 | Ajay Jagannathan, Ajay Jagannathan | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Online Operations in SQL Server 2014 |
| 18-10-2013 16:15 | Christina Leo | Regular Session (75 minutes) | Application & Database Development | T-SQL Fundamentals: Logical Processing Order |
| 18-10-2013 16:15 | Reza Rad | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | SSIS Package Failed in Production? Here’s How to Troubleshoot |
| 18-10-2013 16:15 | Oliver Engels, Julian Breunung | Regular Session (75 minutes) | BI Information Delivery | "R" vs "M": Languages for Data Exploration |
| 18-10-2013 16:15 | Paul Turley | Regular Session (75 minutes) | BI Information Delivery | NY, London, Paris, Munich… Everybody's talkin’ ‘bout Mobile BI |
| 18-10-2013 16:15 | Jennifer McCown, Sean McCown | Regular Session (75 minutes) | Professional Development | Mouth Wide Shut: Interviews from the Other Side of the Table |
| 18-10-2013 16:15 | Aaron Nelson | Regular Session (75 minutes) | Application & Database Development | Database Development with SSDT for Visual Studio 2012 |
| 18-10-2013 16:15 | Jes Schultz | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | The Not-So-Secret SQL Server Agent |
| 18-10-2013 16:15 | Josh Fennessy | Regular Session (75 minutes) | BI Information Delivery | Delivering Analytics with Excel 2013: 10 Secrets for Success |
| 18-10-2013 16:15 | Paul White | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Parallel Query Execution |
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
We'll cover backup and restore strategies, how to architect a database to allow faster recovery, dealing with log and data corruption, and more. In this demo-heavy pre-conference session, you'll learn a ton of practical tips, tricks, and techniques learned from 15 years of experience helping customers plan for and recover from disasters, including less frequently seen problems and more advanced techniques.
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
This comprehensive full-day session will give you concrete, practical advice about how to scale SQL Server. Starting with your current workload, configuration, and hardware, we’ll explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we’ll cover how you can decide whether you should scale up or scale out your data tier. For scale-up solutions, you’ll learn how to scale up properly with nearly zero down time. And for scale-out implementations, you’ll learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data-dependent routing. We’ll also cover how to use middle-tier caching and other application techniques to increase your overall scalability.
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Attend this full-day session to gain a comprehensive understanding of the AlwaysOn technology and how it compares with other SQL Server high availability offerings so that you can make the right decision for your enterprise needs. We’ll cover common deployment considerations and scenarios, including details for both SQL Server and Windows cluster. The session will also cover common issues that arise during deployment, as well as the top support issues that Microsoft customers experience and how avoid them when implementing AlwaysOn in your production environment. Through it all, we’ll get hands-on with demonstrations and examples illustrating key scenarios.
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
In a jam-packed day of discussions and demonstrations focused on SQL Server 2008 Reporting Services and later, you’ll learn: • How to approach the report development process • How to manage key components of a report project: data sources, datasets, report items, and data regions • How to use a tablix effectively to design the layout of data with creative groupings • How to use expressions to display data or change the appearance and behavior of a report in practical ways • How to use report parameters with and without query parameters • How to use data visualization features to enhance the communication of information • How to add interactivity to reports • How to work with pagination and rendering features to manage page layout • And more!
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
The first part of this full-day session will cover the SQL Server query optimizer in-depth. Starting with a clear overview of the basics, the session will progress rapidly to look at the detailed and often subtle behaviors that have real impact on almost every query you write. At the end of the optimizer section, you will understand how it works, its strengths and weaknesses, and how to design databases and write queries to get the best from it.
The second part of the session will begin with an introduction to the Execution Engine framework, query plan operators, and the main things to check in execution plans. We’ll then move on to developing the expert practical skills you’ll need to start interpreting execution plans instead of just reading them, including accurate plan assessment, selecting targets for improvement, and confidently making effective changes.
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
We’ll cover topics such as temporal data, with efficient handling of temporal intervals; new solutions to gaps and islands problems; statistical calculations such as median; aggregates against partitioned tables; complexities of generating surrogate keys; and copying data with dependencies. We’ll also look at suggestions for improvements in SQL Server.
Event Date: 14-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
You’ll follow the scenario over time as this single report needs to be viewed by dozens in the department and must be upsized to SharePoint. Then as months pass and the CEO wants to secure the report and scale it better, you'll learn how to scale the isolated reports into SSAS's tabular model, which offers better security and flexibility. Over time, the cube becomes so important that the CIO wants to merge it with the data warehouse and scale it even better. In this last part of the session, you'll learn how to create a traditional cube using SSAS's MOLAP model to increase scalability and processing power.
Bring your laptop to this session so you can work through each of the examples, and you’ll have a complete set of solutions by the end of the day.
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
The first half of this pre-conference session will focus on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives and digging into LUNs, HBAs, the fabric, and the storage configuration.
In the second half of the day, we'll cover the pros and cons of moving SQL Servers into a virtual server environment. We’ll look at when it’s a good idea and when it’s probably not. As with most things in the database world, there are no hard-set, one-size-fits-all answers about virtualization. But there are times when virtualizing a SQL Server is a good idea – and can save you money.
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Cloud Application Development & Deployment
We’ll also show you how to analyze where a cloud platform can really make a difference. We’ll look at such considerations as architecting for costs, increasing deployment and upgrade flexibility, and reducing operating complexity. These experiences and lessons learned have been acquired through working with the most complex customer projects to date. And we’ll share best practices that you can immediately apply in designing and implementing Azure Data Platform solutions of every scale. Throughout the seminar, we’ll explore all the solution angles, such as achieving scalability at every application layer, addressing reliability and resiliency requirements, and operating, monitoring, and troubleshooting cloud solutions at scale. You’ll also learn the pros and cons of different options for storing data in cloud solutions.
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
This full-day pre-conference session will cover how to plan, deploy, and administer clustered SQL Server solutions. The session will feature live examples and demos and cover topics such as quorum, disk configuration, networking (local and between sites), patching of both SQL Server and Windows, and configuring test clusters in virtual machines. The session will also highlight differences between versions of SQL Server or Windows that may affect your deployment and will touch on using the cloud, known as Infrastructure as a Service (IaaS).
Take advantage of this opportunity to learn what you need to know about this important configuration aspect that affects most DBAs, whether your SQL Server deployments are physical or virtual.
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
To design a database correctly, there are several things you need to understand, including the basics of relational theory, how to gather and apply requirements, normalization, etc. While having a good foundation in the fundamentals is more than many database designers have, it is only the start.
In this full-day pre-conference session, we’ll cover relational database design in three sections. First, we’ll begin with a discussion and demonstration of database design principles; second, we’ll move into a classroom database design section, where we’ll take a scenario and produce a database; and third, we’ll break up into teams and design databases that we’ll then discuss as a class.
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
This pre-conference session will cover the following topics and more: • How wait stats tell you where to focus your tuning • How the plan cache shows you which queries are the worst • How to make fast improvements by picking the right indexes • How to identify and fix the most common query anti-patterns
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
This full-day session will highlight SQL Server and Windows Azure SQL Database as the data platforms and architectures of choice for current and future database projects. You’ll take away practical knowledge, scripts, and a clear understanding that will enable you to leverage all the tools available in the cloud and on-premise.
At the end of the day, you’ll: • See that the knowledge you have about your on-premise servers and databases migrates easily to the cloud • Understand the additional HA/DR functionality offered to on-premise systems by the Microsoft cloud offering • Know about the new tools offered by the Azure Portal and how they work with SQL Server Management Studio and PowerShell to help you manage your systems
Event Date: 15-10-2013 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
Microsoft has partnered with HortonWorks to bring Big Data into the hands of business users via their favorite BI tools: Power View, PowerPivot, and Excel. This session will cover both on-premise and Azure-based technologies, examining the Microsoft distribution of Hadoop through a range of technologies such as HDInsight, Hive, and Azure through to Excel, PowerPivot, and Power View.
The first half of the session will be dedicated to the “what” and “how” of Hadoop, using HDInsight. With Hadoop comes a whole ecosystem of tools, and we’ll look at how to use them in a BI context to support users’ Big Data needs. We’ll also look in detail at MapReduce to parallelize complex Big Data queries across many servers.
After you have Big Data, how are you going to serve it to business users to derive value for the enterprise? The second half of the session will be dedicated to the “why” of Big Data. We’ll visualize Big Data in our favorite BI tools: Excel, PowerPivot, and Power View.
Event Date: 16-10-2013 08:15 - Category: Keynote (90 minutes) - Track: Keynote
Windows Azure Infrastructure Services can provide you with geo-replicated, highly available, and nearly "bottomless" storage solutions. And SQL Server 2014 introduces several new features that make taking advantage of these Windows Azure solutions even easier by including database storage directly on Windows Azure storage, smart backup to Windows Azure Storage, and hybrid HA/DR configurations. Come to this session to learn more about these new features and how to apply them to your applications.
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you’ll learn the basics of what DQS is and how you can use it to clean your data. You’ll see how to build a domain, both manually and from an existing data table. You’ll then see how to use these domains to validate tables in SQL Server and Excel, preparing them for use in SQL Server Analysis Services and PowerPivot. After this session, you’ll understand how by putting quality back into your data, you can be your organization's BI hero.
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
The session will begin by comparing the different options for hosting your database in the cloud – Azure vs. Amazon and Azure VM vs. Azure SQL Database – and then focus on Azure SQL Database, discussing planning, performance, and high availability considerations. You’ll also learn the techniques and tools you can use to move your schema and data to the cloud, including SSMS, DAC, BACPAC, SSIS, BCP, SSDT, and more.
Event Date: 16-10-2013 10:15 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
It’s OK. Really. In this session, we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real-world examples using Extended Events to do what you’re used to doing with Trace, and more. This session is applicable whether you're running SQL Server 2008 or 2012, and you'll walk out with a set of scripts to get you started. If you’ve been putting off learning Extended Events because you just don’t think you have the time (even if you’ve never used Profiler), this is the session for you. You CAN find the time…today.
Event Date: 16-10-2013 10:15 - Category: Spotlight Session (90 minutes) - Track: Cloud Application Development & Deployment
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will focus on high-level approaches to the various components of architecting and developing a BI solution, including where to start, tips on gathering business requirements, working with business users, project management, dimensional design, and more!
Event Date: 16-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Professional Development
You’ll learn: • The fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority • The eight techniques of influencing IT professionals, when to apply them, and how to best use them • The communication and procedural techniques that ensure your ideas get a hearing by managers and peers and how to win support for them
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will demonstrate the following: • How to cast a net to catch a "Chatty Cathy" application in action • How to expose and aggregate every round trip to SQL Server from the application process being reviewed (without bringing the server to its knees) • How to identify when indexes, purging, more hardware, and other SQL Server-side "improvements" will not solve a performance bottleneck • The importance the application's approach to SQL Server plays when it comes to load, latency, and user experience
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
All are good reasons to attend this all-demo session, which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations.
When you leave, you’ll have the fundamentals you need to fully develop your mastery of window functions.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Whether you’re a developer who needs to understand how isolation works and why NOLOCK is usually not an appropriate hint or you’re a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We’ll look at each isolation level and how it impacts the engine, and then examine appropriate (and inappropriate) use cases for each.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we'll discuss and demonstrate design patterns for addressing various types of dirty data using SQL Server Integration Services. We’ll review the various cleansing tools accessible from within SSIS, including native Integration Services components, T-SQL, SSIS scripting, and Data Quality Services components.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Attendees should have some basic exposure to XML (including the use of XML in SQL Server) to get the most from this session as we learn how to "run queries within a query" and how to extract XML data into a tabular format. We’ll cover the five basic XML methods (.exist(), .value(), .query(), .nodes(), and .modify()) and FLWOR (for, let, where, order by, and return). Use cases will include a quick overview of extended events and the use of XQuery to pull out relevant information for DBAs.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 13:30 - Category: Half-Day Session (3 hours) - Track: Application & Database Development
In this half-day session, we’ll dive deep into indexes, looking at their architecture and internal structure and how that affects the way indexes are used in query execution. We’ll look at why clustered indexes are recommended on almost all tables and how their architecture affects the choice of columns. Then, we’ll examine nonclustered indexes, their architecture, and how query design affects which indexes you should create for a workload. We’ll end up with a discussion on index maintenance, rebuilding, reorganizing, and the challenging aspects of removing unused indexes.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
The session will include a brief overview of data mining, followed by a demonstration of an actual predictive modeling exercise. You’ll see how to fine-tune and compare the results using various algorithms and how to make the best use of the models in your enterprise. With predictive analytics having achieved the “Plateau of Productivity” in Gartner’s Hype Cycle for Emerging Technologies, now is the time to learn what these powerful tools can do for you.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 16-10-2013 13:30 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
Want demos? There will be plenty – and the Windows Debugger will definitely make an appearance. You’ll walk away from this session armed with deep technical details and practical knowledge that can help you better deploy, manage, and maintain your SQL Server environment.
Event Date: 16-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will give you a road map for succeeding as a DBA. We’ll cover all of the basics that a typical DBA needs to know and focus on Day 1 and Year 1. By the end of the session, you’ll know what is important, what should be on your daily task list, and what you can ignore. With data growing exponentially, you’ve lucked out if you truly like being a DBA because the sky is the limit.
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we’ll explore a process that was created to truly automate not just the SQL Server install, but all the configurations and the deployment of your organization’s standard objects – all using a free, open-source set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours and ensures a SQL Server instance that meets your company’s standards.
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Professional Development
Event Date: 16-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.
Event Date: 16-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Application & Database Development
Event Date: 16-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come learn how, why, and when compression is the solution to your database performance problems. This session will discuss the basics of how compression and deduplication reduce your data volume. We’ll review the three different types of compression in SQL Server 2012, including the overhead and benefits of each and the situations for which each is appropriate, and examine the special type of compression used for ColumnStore indexes to help your data warehouse queries fly. As with turbo, data compression also has drawbacks, which we’ll cover as well.
Event Date: 16-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development
In this session:
Event Date: 16-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Audience participation and sharing of experiences is encouraged as we cover choices you have for data sets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session will focus primarily on SSRS 2012, although some concepts may apply to other BI tools as well. Join this session, and take your reporting skills to the next level.
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You’ll see how to baseline performance, identify activity, plan SQL Server migrations and consolidations, and performance-tune your instances using an assortment of DMOs and SQL Server system views. You'll walk out of the session with a clear understanding of how the DMOs are organized and how you can use them to make your life easier... at least as it pertains to SQL Server.
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 16:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 16-10-2013 16:45 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
In this session, we’ll discuss how to represent a hierarchy in your data model, and then walk through several different implementations of hierarchies that you can use to optimize your hierarchy implementations and put into practice immediately, with ready-made T-SQL examples.
Event Date: 16-10-2013 16:45 - Category: Spotlight Session (90 minutes) - Track: Cloud Application Development & Deployment
This session will introduce you to the tools available for identifying poor performing queries, including dynamic management objects, query I/O, and others. You'll learn how to understand why a query is running slow using the Azure Database Portal. With this understanding, you’ll be able to fix your poorly performing queries. All in the cloud.
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 16:45 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 16-10-2013 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will cover scale-out deployments, encryption keys, and service accounts. We’ll also take a deep dive into Report Manager. You'll see how security affects the management of reports, how to schedule reports to run automatically, and how to use data-driven subscriptions to effectively meet the needs of multiple users without the overhead of multiple reports. Finally, you'll see how to use both report snapshots and the report cache to minimize the impact on your data servers, return reports faster, and create an audit trail when needed.
Event Date: 17-10-2013 08:15 - Category: Keynote (90 minutes) - Track: Keynote
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We’ll cover in-depth how to set up your development environment to support test-driven development and what techniques you can use to make it practical for SSIS. We’ll also see how to automate the testing of SSIS packages, using the open-source ssisUnit framework. The session will cover several common questions about automated unit testing, including how to handle test data, how to set up the environment for multiple developers, how to make tests flexible, and how to ensure that the tests remain valuable over time.
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012. And this session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012.
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 17-10-2013 10:15 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
In many cases, no! These are "sledgehammer" approaches, and while they might solve some problems (usually parameter sniffing problems), they don’t solve the actual problem. In this session, you'll learn a generalized yet tailored-to-the-table way to solve query plan quality problems for very large tables (VLTs). Topics will include creating, using, and updating filtered statistics; using forced parameterization and templatized plan guides; and understanding stored procedures and how they can leverage filtered statistics.
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.
Event Date: 17-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Professional Development
The past decade, we’ve learned a lot about the chemistry of the brain and why humans react the way we do to events in our environment. The idea of Emotional Intelligence – EQ – is a compelling concept that applies this knowledge in a set of learnable, improvable skills for leading others. Although EQ is often applied to corporate leadership, this session will explain the basics of EQ and demonstrate how you can use it to make your presentations better in the following areas: • Crafting better slide decks • Preparing yourself for presenting • Delivering your content • Dealing with the unexpected
Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room – including you.
Event Date: 17-10-2013 10:15 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
This action-packed session will present an end-to-end, real-world solution for implementing a recommendation engine. We’ll cover Sqoop, HDFS, MapReduce Mongo, and HBase as we build, process, and test on top of the built-in Mahout algorithms.
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You need to work smarter, not harder, and automate your documentation. In this session, you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches – all while on your coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session, and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office.
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
This session is an end-to-end demo through Power BI, guided by the members of the SQL Server engineering team who built the tools and features. We’ll demonstrate the capabilities of Power BI, look at services and features and how they fit together, and show you how to get started and how to bring all those capabilities to your organization. You’ll be well prepared for deep-dive Power BI sessions throughout the week – don’t miss it!
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will present an overview of SQL Server 2012 and 2014 columnstore indexes, including columnstore futures. We’ll review the architecture and explore the challenges, workarounds, travails, and big wins at customer sites and inside Microsoft IT. Learn whether columnstore can change your users' world, why columnstore may be a compelling reason to upgrade, and how columnstore indexes flip the DW /faster bit. And see why columnstore manifests my motto: “Change the world, or go home!”
Event Date: 17-10-2013 10:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We’ll visualize how the join operations’ algorithms work so you can understand how query plans are computed, and then we’ll look at why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. You’ll see through demonstrations that empirical cost calculations are similar to what the query optimizer actually returns.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. The session will feature a demonstration of a complete life cycle roundtrip – data model to database and back to data model – and tips and tricks for creating and maintaining WASD database designs. We’ll finish up with 10 tips for designing databases for both WASD and SQL Server.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Unit testing presents a unique challenge in database development because of the need to provide a consistent test environment. In this session, we’ll not only cover the basis of unit testing concepts and terminology, but also discuss how unit testing helps ensure and document the quality and accuracy of database deliverables. We’ll walk through a demo of creating and running database unit tests using VSTS 2012 and of upgrading from VSTS2010 database and unit test projects.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this session, you'll learn how design and configuration choices put pressure on your report server and techniques to relieve that pressure. You’ll see how to configure your Reporting Services databases for speed, houseclean your subscription schedules, and use caching for high-demand reports. You'll also learn some design strategies to lighten your report processing load. If you want to maximize the speed of your Reporting Services environment and minimize the pain of performance tuning, this session is for you.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we’ll look at the high-level system as a whole and discuss possible areas contributing to a lag in performance. We’ll also talk about implementing instrumentation components to monitor all aspects of the ETL solution. We’ll use this monitoring data and an example case study to walk through the process of tuning the ETL system to make sure the data warehouse is consistently available at the required time.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
This session will start by explaining why geospatial analytics is important in today's world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will feature practical demos for each of these tools, during which we’ll work on some of the publicly available data sets to uncover some interesting facts.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
We’ll provide best practices in building SSAS tabular and SSAS UDM cubes against PDW large data sets. We’ll look at appropriate scenarios for using PDW columnstore index (updatable), DirectQuery in tabular, and ROLAP queries against UDM cubes. We’ll examine the actual implementations and contrast the different approaches between building a tabular-cube-based reporting architecture vs. a UDM-cube-based solution. And we’ll see how to handle incremental loading of data, processing of changed partitions, and automated cube partition creation. Finally, we’ll demonstrate the hub-and-spoke architecture by using the PDW enterprise tabular model as a hub and pushing data out into the data mart SMP databases.
Event Date: 17-10-2013 13:30 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
We’ll examine the Microsoft distribution of Hadoop, covering HDInsight, Hive, and Azure through to Excel, PowerPivot, and Power View. We’ll begin by reviewing the “what” and “how” of Hadoop, using HDInsight. We’ll also demonstrate the Hadoop ecosystem of tools in a BI context to show how to provide insights into Big Data. Then, we’ll visualize Big Data in our favorite BI tools – Excel, PowerPivot, and Power View – to show how you can serve Big Data to business users to derive value for the enterprise.
Event Date: 17-10-2013 13:30 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Attributes and attribute hierarchies have many properties that can be confusing at times. What is the difference between Visible and Not Enabled? Should I make the attribute not visible if it is in a hierarchy? Where can I group related attributes together so it is not confusing to the end user? What if there are too many distinct values for an attribute – can I group some values? How can I improve the performance of a cube? What about Slowly Changing Dimension data? Where is a many-to-many configured?
This demo-rich session will cover 80% to 90% of the available properties, with practical examples to take back to the office.
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Windows Azure Infrastructure Services can provide you with geo-replicated, highly available, and nearly "bottomless" storage solutions. And SQL Server 2014 introduces several new features that make taking advantage of these Windows Azure solutions even easier by including database storage directly on Windows Azure storage, smart backup to Windows Azure Storage, and hybrid HA/DR configurations. Come to this session to learn more about these new features and how to apply them to your applications.
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: BI Information Delivery
Event Date: 17-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
We’ll walk through clear examples of how to properly issue calls to SQL Server to ensure plan reuse. We’ll also see how to identify existing plans that are not being reused and, more importantly, how to reverse that behavior. We’ll finish up by exploring several options for dealing with situations in which you may not have complete control over how calls are made to the database, such as with third-party applications.
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this session, you’ll learn how Power Query for Excel can be used to discover, combine, and refine data. We’ll also look at some advanced functionality and the language used under the covers – M. After attending this presentation, you’ll be better prepared to support business users, understand how Power Query may fit into your organization’s BI landscape, and address potential risks of misguided implementations.
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
This session will explain where Power Map fits in the Self-Service BI stack in Excel 2013 and Power BI for Office 365. We’ll also see it in action through use cases, such as how Microsoft TSPs in Dallas are using Power Map to identify insights in neighborhood utilities data and how Bing Ads is working with customers to develop well-timed back-to-school marketing campaigns.
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development
In this session:
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come learn about the architecture behind PBM and dive into demos that illustrate its power and usefulness. You’ll also see how to set up an easy (and free) solution available on CodePlex that uses a Central Management Server, PBM, PowerShell, and SQL Server Reporting Services to give you a dashboard look into your SQL Server environment.
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 17-10-2013 15:00 - Category: Lightning Talks (10 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 17:00 - Category: Spotlight Session (90 minutes) - Track: BI Information Delivery
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
PerformancePoint Services is the reporting environment of choice when dashboards and analysis are in the requirements list. Attend this session to get an overview of PerformancePoint's architecture and learn what you need to do to ensure the services are enabled and configured correctly in SharePoint. Then see how to build a dashboard from the ground up, complete with KPIs, a scorecard, and analytic reports. In addition to learning how to create these objects, you'll learn how to connect them together to maximize interactivity and user adoption – all in 75 minutes. Come learn about PerformancePoint and redefine what you think is possible.
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 17:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
In this session, we'll review the basic cloud architecture and then dive into the specific components of the solution to see the power in combining different kinds of automation. No prior knowledge of PowerShell or cloud services is required.
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We’ll cover the following topics: • How data partitioning helps with database manageability and performance and can help reduce hardware costs • Pros, cons, and the best use cases of the different data partitioning techniques: partitioned tables, partitioned views, and a combination of both • Implementation of tiered storage, focusing on moving data between filegroups and/or disk arrays and keeping systems online in the various versions and editions of SQL Server (including non-Enterprise editions) • Creation of dynamic files and filegroups and compatibility with high availability technologies • Potential issues to be aware of when implementing data partitioning
Event Date: 17-10-2013 17:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we’ll look at:
• Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption • Best practices for handling a database that you suspect may be corrupted • Actions that can make the problem worse • Appropriate steps to take and methods of recovery
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 17-10-2013 17:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 17-10-2013 17:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
These tips and tricks can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal. The demo content also covers BISM Normalizer, which is a free tool developed by the SQL community for the SQL community.
Event Date: 18-10-2013 08:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
When you get back to the office, you'll have: • An easy-to-use script to find bottlenecks fast • Instructions on how to let anybody run it without being SA • Fewer Help desk tickets and phone calls pestering you
Event Date: 18-10-2013 08:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this session, Finance professionals from Microsoft will showcase how they use Microsoft BI tools to get powerful insights into key business drivers. You'll see how to build an effective sales dashboard in a matter of minutes and learn how to rapidly extract insights out of millions of records with powerful self-service visualizations.
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we'll present the entire spectrum of what we’ve learned working on customer projects around the world and instrumenting and analyzing these applications based on Windows Azure SQL Database.
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Because they aren’t static, how dashboards interact and how they fit into a larger reporting environment offer a particular design challenge. Designing the navigation across the content on each dashboard page is critical to communicating the desired message. Join this session to review best-practices techniques for displaying a set of data in a dashboard for maximum impact and explore a framework for constructing dashboards from the various content types.
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 08:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Achieving a decent balance between work and home life can be difficult. Even more difficult is making sure that your peers back in the office understand that you are still a contributing member of the team. You only need to look at the recent actions of Yahoo! recalling all their remote workers to understand just how much trust can be lost between employer and employees.
Join this panel discussion to gain valuable tips about how to be a successful remote worker in IT today. Panelists will share lessons they’ve learned in their careers that can help you understand how to make working from home work for you and your team. Bring your questions!
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
PBM lets you administer and control your SQL Server environment in a way that was very difficult or even impossible before. Simply put, PBM lets you define rules or policies to govern your SQL Server enterprise. You can enforce naming conventions, prevent certain object creations, get notifications if a rule you defined is broken, and much more. CMS lets you organize and manage your instances using predefined groups from a single common point. Have you ever wanted to run a code block against multiple instances at the same time? CMS lets you easily do this and more. See how these two features can add a whole new level of manageability to your environment and reduce the time you spend achieving your management goals.
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
We'll begin with a review of the three SQL Server platform offerings: • Traditional "out of box" SQL Server • Windows Azure SQL Database • Windows Azure VM-hosted SQL Server
We’ll compare the platforms against each other, going over the pros and cons of each, and then work through some use cases and demos on how each offering can help you meet the needs of your business. We’ll see that the cloud platforms need not be seen as replacing traditional “out of box” SQL Server deployments but rather as additional weapons in your arsenal.
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You’ll learn about the different types of storage available and how to decide which to use for different workload types. You’ll also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll then cover methods to effectively measure and monitor your storage performance so that you’ll have valuable information and evidence available the next time you have to discuss I/O performance with your storage administrator.
Event Date: 18-10-2013 09:45 - Category: Spotlight Session (90 minutes) - Track: Professional Development
In this session, we'll look at case studies of real-life aviation disasters and production database downtime incidents. We'll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.
Event Date: 18-10-2013 09:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Today is your lucky day! In this session, we will start at the bottom and build our way up. We'll cover byte swapping and bitmaps and dive a little into decoding Hex and binary, working to give you a full understanding of database internals and how you use them every day!
Event Date: 18-10-2013 09:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
We’ll explore the planar and geodetic spatial models and spatial markup languages such as WKT and GML, and then put these concepts to use building several spatial desktop and web applications. Demos will show how to integrate with Bing Maps and how to use the geospatial methods to easily calculate area, length, and distance and project new shapes based on intersection and overlap. We’ll also cover the latest geospatial enhancements in SQL Server 2012. Attend this session, and embrace spatial programming today!
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Come learn how to: • Mash up unstructured data from Hadoop with structured data from more traditional relational and multi-dimensional sources • Visualize your Big Data using familiar BI tools such as Excel and Power View • Use Microsoft's Big Data technologies to gain new business insights and overcome data silos within your organization, while also making use of external data sources
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We’ll cover in detail alternative methods of managing large workloads by using traditional programming methods, including named pipes, queues, and producers/consumer architecture – all from within SSIS itself. We'll then cover methods of dividing workloads and preventing bottlenecks, as well as techniques to improve the resource efficiency of SSIS.
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, we’ll look at various batching techniques and the impact they can have for SQL Database applications. We’ll also examine the different impact that batching has in applications that cross the Windows Azure datacenter boundary. Finally, we'll review specific coding techniques in ADO.NET, including table-valued parameters, SqlBulkCopy, and buffering. This session is aimed at developers looking for guidance on improving the performance and scalability of their SQL Database applications.
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will focus on reading data (while being blocked). We’ll consider table design and query hints, why we should rarely if ever use NOLOCK, and what alternatives we have. Be prepared for a demo-intensive, code-heavy session – not “GUI-action.”
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Attend this session to learn about the SQL Server features that allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, you’ll see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments, these techniques can come in handy. The best security is often that which cannot be seen.
Event Date: 18-10-2013 13:00 - Category: Spotlight Session (90 minutes) - Track: Professional Development
In this session, you’ll learn how to provide effective feedback to your peers and direct reports. You’ll learn how to deliver feedback that encourages the behavior that you’d like to see repeated and provides recommended changes for behavior that is not acceptable or is subpar. You’ll also learn how to customize your feedback based on different personality types.
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 13:00 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 13:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
This session will cover valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. You’ll learn tips for configuring your SQL Server installations for maximum performance when virtualized and for monitoring and capacity management so that you know when you need to add more hardware to keep your database servers running at peak performance.
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Join this session for the answers to all these questions. You’ll leave with information that will impress your boss and lead to a big raise – or at least lead you down the correct path to adding business value to your organization.
Event Date: 18-10-2013 13:15 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
You’ll learn the basics of geographical data, including GIS, longitude-latitude coordinates, and free-form text. Using these different data types, we’ll discuss SQL Server Reporting Services 2012, Power View, and Excel 2013 tools that can leverage this insightful analysis. Finally, and most importantly, this session will get you started in the essential techniques for delivering geospatial reports that tell meaningful and engaging stories for business users.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
With Service Broker offering guaranteed async-ordered message delivery and CDC providing us with the changes in our tables, we can build a flexible publishing framework between various databases and machines. Of course, it's not all unicorns and rainbows, so we'll also look at the downsides of such a solution.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
The Hierarchy of Database Needs fills this gap by providing a clear plan for building enterprise database monitoring. Based on Maslow’s Hierarchy of Needs, the methodology outlines six levels of database monitoring areas to address. Each level builds on the level below it, covering specific database concerns, such as backups, service availability, strategic solutions, tool selection, and service level agreements. You’ll walk away with a clear plan for building an overall monitoring strategy for your own database environment.
Event Date: 18-10-2013 14:45 - Category: Half-Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
This half-day session will walk you through how to implement SSAS hierarchies the right way and show you some tips and tricks to make them perform faster. You’ll also learn how to query and navigate SSAS hierarchies using common MDX functions.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.
Event Date: 18-10-2013 14:45 - Category: Half-Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Professional Development
Who should attend? This session is for data pros who want to grow, lead, and help others around them grow and lead. Coaching skills are a huge benefit for anyone with a job or their own business – whether you’re a boss, geek, or both. Coaching can make relationships with friends, family, co-workers, and business partners richer and more rewarding. Thinking about a career in consulting? Want to be a world-class leader one day? Acquiring coaching skills may be key to your success.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we’ll focus on SSIS package performance, quickly reviewing 10 of the most common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, we’ll show how we moved from a database-centric approach to a heterogeneous, event-driven architecture that is helping the Commerce Platform understand what is happening, what happened, and in the near future, what should happen. We’ll discuss how, in addition to using SQL Databases, our use of the Reactive Framework and the HDInsight Service helps fulfill the various requirements of the overall system-insight solution.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This all-demo session will explain the logical processing hierarchy, giving you the foundational knowledge you need to build well-structured queries that keep the optimizer happy. You’ll learn how the FROM clause is processed, why a calculated column’s alias can’t be addressed in the JOIN, why WHERE isn’t the only filter, and why NULL confuses everything. When you leave, you’ll think very differently about how you build your queries, and the query optimizer will love you for learning to speak its language.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session reveals some methods for troubleshooting failed SSIS packages in a production environment without SSDT, including using extensive logging, error handling in packages, data taps, and more. We will also explore some extensions for SSIS, such as an extension for execution order of packages that helps control execution in production and helps you find the root cause of the error in production.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
What possibilities do these languages offer, where can you best use them, and how good is their integration with the Microsoft stack? We’ll answer these questions and more. Join us for this demo-driven session and get a good start on how to work with these two languages.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Practically every reporting and dashboard product has a mobile capability, and some new tools have been designed specifically for tablet devices. Use Power View, SSRS reports, and Excel visuals on your iPad and Surface RT. Build and use compelling visual dashboards and analytic exploration on almost any device. Most importantly, learn to design the semantic model layer and security to make all the magic happen for your business.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Professional Development
In this interactive session, we’ll show you the most effective ways to find out what the candidate really knows. You’ll learn about effective tech screening, drawing answers out of nervous candidates, and how to use probing questions to really determine the applicant’s true expertise.
Join this session to learn: • How to pick up on resume “inaccuracies” • How to truly vet a candidate’s skills • Why keeping your mouth shut is a vital interviewing skill • The one thing that interviewers never do (and should)
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Among the many insider tips, we’ll see how Pivot Tables – known and loved by many – have been enhanced with visual tools to enable rich reporting capabilities and additional reporting functionality to allow for augmented design possibilities. Behind the scenes, Pivot Tables have been improved to also allow for easier data exploration and more accessible self-service capabilities.
In addition, expert analysts will be keen to learn about new Excel functions that allow for direct querying of Analysis Services databases, allowing for custom reporting options previously unheard of in tools like Excel.
Event Date: 18-10-2013 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You’ll see intra-query parallel deadlocks and a parallel query that executes faster using fewer resources than the equivalent single-threaded plan. You’ll also discover the true meaning of the misunderstood CXPACKET wait type and learn how to force parallel execution for that large, complex query you have that refuses to “go parallel” on its own.