| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 24-10-2016 08:30 | Jason Horner | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Dimensional Modeling: From Zero to Hero |
| 24-10-2016 08:30 | Jason Hall, John Martin, David Benoit, Lori Edwards, Scott Fallen, Greg Gonzalez, Mike Wood | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | SentryOne Performance Boot Camp |
| 24-10-2016 08:30 | Brian Larson | Pre-Conference Session (full day) | BI Information Delivery | Effective Data Visualization with SQL 2016 - Data Near and Far |
| 24-10-2016 08:30 | Glenn Berry | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Dr. DMV: How to Use DMVs to Diagnose Performance Problems |
| 24-10-2016 08:30 | Itzik Ben-Gan | Pre-Conference Session (full day) | Application | High Performance T-SQL for the Experienced Database Practitioner |
| 24-10-2016 08:30 | Stacia Varga | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | What's New for BI in SQL Server 2016? |
| 24-10-2016 08:30 | Allan Hirt | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | AlmostOn: Troubleshooting Clustered Implementations of SQL Server |
| 25-10-2016 08:30 | Kendra Little | Pre-Conference Session (full day) | Application | SQL Server Index Formulas: Problems and Solutions |
| 25-10-2016 08:30 | David Klee | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | The Complete Primer to SQL Server Virtualization |
| 25-10-2016 08:30 | Marco Russo | Pre-Conference Session (full day) | BI Information Delivery | Create a Power BI Solution in One Day |
| 25-10-2016 08:30 | Patrick LeBlanc, Adam Saxton | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Microsoft BI in a Day |
| 25-10-2016 08:30 | Thomas LeBlanc, Vicky Harp, Randy Jacops, Stan Geiger, Scott Stone, Bullett Manale, Mark Slavens | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Boost SQL Server Performance to the Next Level with IDERA |
| 25-10-2016 08:30 | Kalen Delaney | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Locking, Blocking, Versions: Concurrency for Maximum Performance |
| 26-10-2016 10:15 | Ryan Adams | General Session (75 minutes) | Enterprise Database Administration & Deployment | Managing MSDB |
| 26-10-2016 10:15 | Andy Yun | General Session (75 minutes) | Application | Why Your Data Type Choices Matter |
| 26-10-2016 10:15 | Mike Hillwig | General Session (75 minutes) | Professional Development | Lighten Up: Soft Skills for Hardcore Techies |
| 26-10-2016 10:15 | Maurice De Vidts, Kannan Mani | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Architecting SQL Server for Mission Critical and High Performance |
| 26-10-2016 10:15 | Michael Fal | General Session (75 minutes) | Enterprise Database Administration & Deployment | Powershell Jumpstart for SQL Server DBAs |
| 26-10-2016 10:15 | Dean Furness | General Session (75 minutes) | BI Information Delivery | Enabling Business-Driven Self-Service BI within Enterprise IT |
| 26-10-2016 10:15 | Bill Gibson | General Session (75 minutes) | Application | Design Patterns for SaaS Applications with Azure SQL Database |
| 26-10-2016 10:15 | George Su | Partner Session (75 minutes) | BI Platform Architecture, Development & Administration | Advanced SSRS Tricks and SSRS Web Reporting |
| 26-10-2016 10:15 | Kamal Hathi, Amir Netz, Justyna Lucznik, Patrick Baumgartner | General Session (75 minutes) | BI Information Delivery | Microsoft BI - an Integrated Modern Solution |
| 26-10-2016 10:15 | Jeff Renz | General Session (75 minutes) | Application | Introduction To Azure DocumentDB |
| 26-10-2016 10:15 | Rafael Salas | General Session (75 minutes) | BI Information Delivery | Enabling Advanced Data Preparation Capabilities for Your Business |
| 26-10-2016 10:15 | Peter Myers, Matt Masson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | What's New in SQL Server 2016 Master Data Services |
| 26-10-2016 10:45 | Glenn Berry | General Session (75 minutes) | Enterprise Database Administration & Deployment | Hardware 301: Diving Deeper into Database Hardware |
| 26-10-2016 10:45 | Brent Ozar | General Session (75 minutes) | Application | Intro to Internals: How to Think Like the SQL Server Engine |
| 26-10-2016 10:45 | Lindsey Allen, Rob A'Court, Stuart Moore | General Session (75 minutes) | Application | What's New in Azure SQL Database |
| 26-10-2016 10:45 | Reza Rad | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Preparation is the Keystone |
| 26-10-2016 10:45 | Denzil Ribeiro, Arvind Shyamsundar | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT : Accelerate SQL Server 2016 to the Max: Lessons Learned from Early Customer Engagements |
| 26-10-2016 12:30 | Kevin Kline | Marketing Community Session (45 minutes) | Professional Development | Introduction to PASS Summit 2016 |
| 26-10-2016 13:30 | Bob Ward | Half-Day MS CSS Session (3 hours) | Enterprise Database Administration & Deployment | Inside SQL Server In-Memory OLTP |
| 26-10-2016 13:30 | Ed Leighton-Dick | General Session (75 minutes) | Application | Extending Applications Securely Using Service Broker |
| 26-10-2016 13:30 | Joseph D'Antoni | General Session (75 minutes) | Application | Using SQL Server 2016 to Accelerate Your Business |
| 26-10-2016 13:30 | Anat Dror, Jason Hall | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Query Store Unplugged |
| 26-10-2016 13:30 | Richard Bolesta | General Session (75 minutes) | Professional Development | Safe-Guard Your Career – How to Work Better as a Team and Between Departments |
| 26-10-2016 13:30 | Stacia Varga | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Building an SSRS Monitoring System |
| 26-10-2016 13:30 | Dejan Sarka | General Session (75 minutes) | BI Information Delivery | Introducing R |
| 26-10-2016 13:30 | Edwin M Sarmiento | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Architecting SQL Server Environments with Containers for Superior HA & Cost Savings |
| 26-10-2016 13:30 | Murshed Zaman, John Hoang, Alex Laskos, Henry Been, Bence Faludi | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SQLCAT: Azure SQL Data Warehouse Customer Stories from Early Adopters |
| 26-10-2016 13:30 | Victor Isakov, Murilo Miranda, Luan Moreno Medeiros Maciel, Maxwell Myrick, Shawn Meyers, Edward Pollack | Lightning Talk (75 minutes) | Enterprise Database Administration & Deployment | Lightning Talks 103 |
| 26-10-2016 13:30 | Matan Yungman | Half-Day Session (2.5 hours) | Application | MongoDB for the SQL Server Professional |
| 26-10-2016 13:30 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | Database Security in SQL Server 2016 and beyond |
| 26-10-2016 13:30 | Brian Larson | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Calculate, Aggregate & Filter: Truly Understanding DAX |
| 26-10-2016 13:30 | Riccardo Muti, Chris Finlan | General Session (75 minutes) | BI Information Delivery | SQL Server Reporting Services: What’s New and What’s Next |
| 26-10-2016 13:30 | Jen Stirrup | General Session (75 minutes) | BI Information Delivery | Mobile BI and Dataviz with SQL Server 2016, R, and PowerBI |
| 26-10-2016 13:30 | Eduardo Castro | General Session (75 minutes) | BI Platform Architecture, Development & Administration | R Language for the SQL Server DBA |
| 26-10-2016 15:15 | Jason Horner | General Session (75 minutes) | BI Information Delivery | Advanced Spatial Analysis Beyond Bubble Charts |
| 26-10-2016 15:15 | Thomas LeBlanc | General Session (75 minutes) | BI Information Delivery | Excel Tips & Tricks for Displaying an Analysis Service Database |
| 26-10-2016 15:15 | Rick Heiges, Bill Ramos | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Playing Well with Other Data Platforms and Clouds |
| 26-10-2016 15:15 | Brian Mitchell | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Architecting Robust Big Data Solutions |
| 26-10-2016 15:15 | Gail Shaw | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Many Latencies of TempDB |
| 26-10-2016 15:15 | Jason Hall, Scott Fallen | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | SentryOne Tools for Productivity and Performance |
| 26-10-2016 15:15 | Joe Webb | General Session (75 minutes) | Professional Development | Get the Right People on the Bus |
| 26-10-2016 15:15 | Oliver Engels, Tillmann Eitelberg | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Apply the Power of Azure Data Lake Analytics to Your BI Landscape |
| 26-10-2016 15:15 | Kevin Farlee | General Session (75 minutes) | Enterprise Database Administration & Deployment | Operational Analytics in SQL Server 2016 and Azure SQL Database |
| 26-10-2016 15:15 | Grant Fritchey | General Session (75 minutes) | Application | The Query Store and Query Tuning in SQL Server |
| 26-10-2016 15:15 | Vlad Vlasceanu | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Highly Available and Scalable SQL Server in the Amazon Web Services (AWS) Cloud |
| 26-10-2016 15:15 | Ginger Grant | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Combining SQL Server 2016 and Hadoop with Polybase |
| 26-10-2016 15:15 | Karen Lopez, Karen Lopez, Thomas LaRock | General Session (75 minutes) | Application | Ticking Timebombs in Your Databases |
| 26-10-2016 15:15 | Luis Vargas | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server in Azure VM: Best Practices, Latest Features, and Roadmap |
| 26-10-2016 15:15 | Thomas Grohser | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Optimizing SQL Server and Databases for Large Fact Tables |
| 26-10-2016 16:45 | Peter Sprague | Partner Session (75 minutes) | BI Platform Architecture, Development & Administration | Conquer the Content Mess – Managing BI Content Lifecycle |
| 26-10-2016 16:45 | Tim Mitchell, Stuart Ainsworth | General Session (75 minutes) | Professional Development | Making the Business Case for Training |
| 26-10-2016 16:45 | David Klee | General Session (75 minutes) | Enterprise Database Administration & Deployment | Virtual SQL Servers. Actual Performance. |
| 26-10-2016 16:45 | Matt Usher | General Session (75 minutes) | Enterprise Database Administration & Deployment | Design for Big Data with Microsoft Azure SQL Data Warehouse |
| 26-10-2016 16:45 | Peter Myers | General Session (75 minutes) | BI Information Delivery | Reports on the Run: Mobile Reporting with SQL Server 2016 |
| 26-10-2016 16:45 | Kevin Kline | General Session (75 minutes) | Application | Four Ways We Kill the SQL Server Plan Cache |
| 26-10-2016 16:45 | Bill Fellows | General Session (75 minutes) | BI Platform Architecture, Development & Administration | An Architect's Strategy for Consistent SSIS with SQL Server 2016 |
| 26-10-2016 16:45 | Saveen Reddy | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Going Under the Hood with Azure Data Lake |
| 26-10-2016 16:45 | Jakub Szymaszek, Rebecca Zhang | General Session (75 minutes) | Application | Protecting Sensitive Data with Always Encrypted |
| 26-10-2016 16:45 | David Stein, Paco Gonzalez, Markus Ehrenmueller-Jensen, Josh Fennessy, Dean Furness, Leila Etaati | Lightning Talk (75 minutes) | BI Information Delivery | Lightning Talks 102 |
| 26-10-2016 16:45 | Buck Woody | General Session (75 minutes) | Enterprise Database Administration & Deployment | Data Science: Every Business is Now a Technology Business |
| 26-10-2016 16:45 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol: Round 1 |
| 26-10-2016 16:45 | Christian Wade, Bret Grinslade | General Session (75 minutes) | BI Information Delivery | Analysis Services on Azure |
| 26-10-2016 16:45 | Cathrine Wilhelmsen | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Biml for Beginners: Speed Up Your SSIS Development |
| 26-10-2016 16:45 | Brian Walters | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Learn How SQL Server 2016 Performs with Storage Spaces Direct |
| 26-10-2016 16:45 | Itzik Ben-Gan | General Session (75 minutes) | Application | This Batch-Mode Window Aggregate Operator Will Change Your Life! |
| 26-10-2016 16:45 | Andrew Kelly | General Session (75 minutes) | Enterprise Database Administration & Deployment | Query Store – What is it all about? |
| 27-10-2016 10:15 | Vern Rabe | General Session (75 minutes) | Enterprise Database Administration & Deployment | It’s Time for a Change: Temporal Table Support in SQL Server 2016 |
| 27-10-2016 10:15 | Bob Ward | MS CSS Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2016: It Just Runs Faster |
| 27-10-2016 10:15 | Umachandar Jayachandran, Nellie Gustafsson, Jarupat Jisarojito | General Session (75 minutes) | Application | SQL Server 2016 R Services - How Can You Make Your Apps Intelligent Today? |
| 27-10-2016 10:15 | Steve Wake | General Session (75 minutes) | BI Information Delivery | Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting |
| 27-10-2016 10:15 | Cecilia Aragon | General Session (75 minutes) | Application | Why People Should Care About Data Science; or The Hearts and Minds of Data Science |
| 27-10-2016 10:15 | Michelle Ufford | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data-Driven @ Netflix |
| 27-10-2016 10:15 | Konstantin Melamud | General Session (75 minutes) | Application | In-Memory OLTP for Developers: What You Need to Know |
| 27-10-2016 10:15 | Tobias Ternstrom, Slava Oks, Travis Wright | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server on Linux, Come Learn What is Happening! |
| 27-10-2016 10:15 | Debra Dove | General Session (75 minutes) | Application | Azure Data Services: Spotlight on Azure SQL Database |
| 27-10-2016 10:15 | Pinal Dave, Andy McDermid | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Backup and Restore SQL Server Databases in Microsoft Azure |
| 27-10-2016 10:15 | Tillmann Eitelberg, Frank Geisler | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Programming Reporting Services 2016 |
| 27-10-2016 10:15 | Guy Glantser | General Session (75 minutes) | BI Information Delivery | Introduction to Azure Machine Learning |
| 27-10-2016 10:45 | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Introducing U-SQL: A Language that Simplifies Big Data Processing | |
| 27-10-2016 10:45 | Kendra Little | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Great Performance Robbery: Locking Problems and Solutions |
| 27-10-2016 10:45 | James Rowland-Jones, Kevin Ngo | General Session (75 minutes) | Application | Sizing Azure SQL Data Warehouse for Customer Proposals |
| 27-10-2016 10:45 | Kevin Kline | General Session (75 minutes) | Professional Development | Fundamentals of Tech Team Leadership |
| 27-10-2016 13:30 | Mike Lawell | General Session (75 minutes) | Application | Execution Plans for Mere Mortals |
| 27-10-2016 13:30 | Murshed Zaman, John Hoang, Rangarajan Srirangam | General Session (75 minutes) | BI Platform Architecture, Development & Administration | SQLCAT: Azure SQL Data Warehouse Best Practices |
| 27-10-2016 13:30 | Bruno Aziza | Partner Session (75 minutes) | BI Platform Architecture, Development & Administration | Best Practices Session: Business Intelligence for Big Data aka [BIG BI] |
| 27-10-2016 13:30 | Paul Ou Yang | General Session (75 minutes) | BI Information Delivery | Untangling the Spaghetti Graph |
| 27-10-2016 13:30 | Kalen Delaney | General Session (75 minutes) | Enterprise Database Administration & Deployment | Recovery Models Made SIMPLE |
| 27-10-2016 13:30 | Anand Subbaraj, Gaurav Malhotra | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Cortana Intelligence Suite: Patterns & Practices for Data Integration at Scale |
| 27-10-2016 13:30 | Jovan Popovic | General Session (75 minutes) | Application | Exploring New Features in Azure SQL Database that Enable Developers to do More |
| 27-10-2016 13:30 | Argenis Fernandez | General Session (75 minutes) | Enterprise Database Administration & Deployment | Hacking SQL Server for Fun and Profit |
| 27-10-2016 13:30 | Markus Ehrenmueller-Jensen | General Session (75 minutes) | BI Information Delivery | My Favorite Pie (Chart): Simple Rules for Clear Visualizations |
| 27-10-2016 13:30 | Denny Cherry | General Session (75 minutes) | Enterprise Database Administration & Deployment | How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Scalability |
| 27-10-2016 13:30 | Jordan Goldmeier | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Disasters: Data Visualization in the Organization |
| 27-10-2016 13:30 | boB Taylor | General Session (75 minutes) | Application | Azure SQL Database: No CDC, No Problem! |
| 27-10-2016 13:30 | Lara Rubbelke, James Rowland-Jones | General Session (75 minutes) | Professional Development | How to be a Technology All-Star: Things You Need to Know to Navigate Change and Stay Ahead |
| 27-10-2016 13:30 | Wayne Sheffield, Rob Volk, Jeff Renz, Hugo Kornelis, Russ Thomas | Lightning Talk (75 minutes) | Application | Lightning Talks 101 |
| 27-10-2016 13:30 | Denny Lee, Andrew Liu | General Session (75 minutes) | Application | Blazing Fast, Planet-Scale Customer Scenarios with Azure DocumentDB |
| 27-10-2016 13:30 | Paul Turley | General Session (75 minutes) | BI Information Delivery | Reporting Services 2016: The Force Awakens |
| 27-10-2016 13:30 | Amit Banerjee, Ajay Jagannathan | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Enhancements that Keep Your Environment Always On |
| 27-10-2016 15:15 | Tim Mitchell | Half-Day Session (2.5 hours) | BI Platform Architecture, Development & Administration | A Crash-Course in Biml |
| 27-10-2016 15:15 | Joe Sack, Arvind Shyamsundar, Justin Silver, Clifford Lipscomb | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT : Early Customer Experiences with SQL Server R Services |
| 27-10-2016 15:15 | Jason Horner | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Dimensional Modeling Design Patterns: Beyond the Basics |
| 27-10-2016 15:15 | William Durkin | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Replication - What, How and Why |
| 27-10-2016 15:15 | Gopi Kumar, Jacob Spoelstra, Hang Zhang | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Productive Data Science with Team Data Science Process |
| 27-10-2016 15:15 | Sivakumar Harinath, Sirui Sun | General Session (75 minutes) | BI Information Delivery | Power BI for the Enterprise |
| 27-10-2016 15:15 | Dr. Subramani Paramasivam | General Session (75 minutes) | Enterprise Database Administration & Deployment | Tired of Connecting On-Prem and Cloud Data? Take a DB Stretch |
| 27-10-2016 15:15 | Brian Knight | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Real-Time Analytics with Cortana Analytics |
| 27-10-2016 15:15 | Tara Shankar Jana, Kirill Gavrylyuk | General Session (75 minutes) | Application | Intelligent Data-Driven Apps that Learn and Adapt |
| 27-10-2016 15:15 | General Session (75 minutes) | Application | Tuning and Optimizing U-SQL Queries for Maximum Performance | |
| 27-10-2016 15:15 | Cathrine Wilhelmsen | General Session (75 minutes) | Professional Development | Advance Your Career by Becoming a Volunteer |
| 27-10-2016 15:15 | David Bermingham | General Session (75 minutes) | Enterprise Database Administration & Deployment | Azure Resource Manager: High Availability and High Performance |
| 27-10-2016 15:15 | Lukasz Pawlowski, Saptarshi Mukherjee, Michael Stahle | General Session (75 minutes) | BI Information Delivery | Embed Stunning Visual Analytics in Customer Facing Applications using Microsoft Power BI Embedded |
| 27-10-2016 15:15 | Thomas LeBlanc, Bill Anton | Half-Day Session (2.5 hours) | BI Platform Architecture, Development & Administration | Troubleshooting Analysis Services Performance Issues |
| 27-10-2016 15:15 | Grant Fritchey | Partner Session (75 minutes) | Application | Faster Provisioning with SQL Clone |
| 27-10-2016 15:15 | Niko Neugebauer | General Session (75 minutes) | Application | Columnstore Technology Improvements in SQL Server 2016 |
| 27-10-2016 15:15 | Allen White, Mindy Curnutt, Lance Harra, Angela Henry | Marketing Community Session (45 minutes) | Professional Development | PASS Program Strategy Team Meeting |
| 27-10-2016 16:45 | Geoff Hiten | General Session (75 minutes) | Professional Development | Smart Rats Leave First |
| 27-10-2016 16:45 | Scott Klein, Lindsey Allen, Rohan Kumar | General Session (75 minutes) | Application | UNPLUGGED: SQL Server 2016 |
| 27-10-2016 16:45 | Mladen Prajdić | General Session (75 minutes) | Application | Optimizing Database Access And Diving Into .Net SqlClient |
| 27-10-2016 16:45 | Sanjay Mishra, Antti Nivala, Sathyan Narasingh | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Lessons Learned from Customers Adopting Azure SQL Database Elastic Pool |
| 27-10-2016 16:45 | Marco Russo | General Session (75 minutes) | BI Platform Architecture, Development & Administration | DirectQuery in Analysis Services 2016: Best Practices & Use Cases |
| 27-10-2016 16:45 | Mark Broadbent | General Session (75 minutes) | Enterprise Database Administration & Deployment | Lockless in Seattle: Using In-Memory OLTP Transaction Processing |
| 27-10-2016 16:45 | Mickey Stuewe | General Session (75 minutes) | Application | Changing Your Habits to Improve the Performance of Your T-SQL |
| 27-10-2016 16:45 | John Sterrett | General Session (75 minutes) | Enterprise Database Administration & Deployment | Synthetic vs Real-World Workloads: Benchmark Throwdown! |
| 27-10-2016 16:45 | Ben DeBow | General Session (75 minutes) | Professional Development | The Road to Consulting |
| 27-10-2016 16:45 | Dejan Sarka | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Anomaly Detection |
| 27-10-2016 16:45 | Leila Etaati | General Session (75 minutes) | BI Information Delivery | R; One Ring to Rule Them All |
| 27-10-2016 16:45 | Colleen Morrow | General Session (75 minutes) | Application | Inside the Black Box: Making Sense of Service Broker |
| 27-10-2016 16:45 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol: Round 2 |
| 27-10-2016 16:45 | Scott Shaw, Bill Preachuk | Partner Session (75 minutes) | Application | Hadoop Stored Procedures, Procedural Language, Visualization, Oh My! |
| 27-10-2016 16:45 | Stacia Varga | General Session (75 minutes) | BI Information Delivery | Getting Your Story Straight with Data Visualizations |
| 28-10-2016 08:00 | Shawn Meyers | General Session (75 minutes) | Enterprise Database Administration & Deployment | Monitoring and Alerting of Availability Groups |
| 28-10-2016 08:00 | Meagan Longoria | General Session (75 minutes) | BI Information Delivery | Overcoming Chartaphobia with Power BI |
| 28-10-2016 08:00 | Miguel Llopis, Kim Manis | General Session (75 minutes) | BI Information Delivery | Effective Report Authoring Using Power BI Desktop |
| 28-10-2016 08:00 | Dmitri Korotkevitch | General Session (75 minutes) | Application | Data Partitioning for Database Architects and Mere Mortals |
| 28-10-2016 08:00 | J May | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Columnstore Indexes in SQL Server: Flipping the DW Faster Bit |
| 28-10-2016 08:00 | Ajay Jagannathan, Suresh Kandoth | MS CSS Session (75 minutes) | Enterprise Database Administration & Deployment | Tune Your SQL Server Engine to Turbocharge its Performance |
| 28-10-2016 08:00 | Andy Galbraith | General Session (75 minutes) | Enterprise Database Administration & Deployment | Does it Hurt When I Do This? Performing a SQL Server Health Check |
| 28-10-2016 08:00 | Brent Ozar | Half-Day Session (2.5 hours) | Professional Development | 500-Level Guide to Career Internals |
| 28-10-2016 08:00 | Kathi Kellenberger | General Session (75 minutes) | Application | Indexing for Beginners |
| 28-10-2016 08:00 | Debra Dove | General Session (75 minutes) | Enterprise Database Administration & Deployment | Managing SaaS Application Databases with Elastic Jobs: SQL Agent and More for Azure SQL Database |
| 28-10-2016 08:00 | Marco Russo | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Optimizing Multi-Billion Row Tables in Tabular |
| 28-10-2016 08:00 | James Rowland-Jones, Matt Usher, Jamie Reding, John Macintyre, Torsten Grabs, Ron Ortloff, Casey Karst, Kevin Ngo, Sada K | Microsoft Chalk Talk (75 minutes) | Application | Chalk Talk with Data Warehouse & Fast Track Team |
| 28-10-2016 08:00 | Juergen Thomas, Cameron Gardiner | General Session (75 minutes) | Enterprise Database Administration & Deployment | AzureCAT: SAP Workload on SQL Server in Azure |
| 28-10-2016 08:00 | Kun Cheng, Denzil Ribeiro | General Session (75 minutes) | Application | SQLCAT: Azure SQL Database Best Practices in Performance Tuning and Resiliency Design |
| 28-10-2016 08:00 | Lukasz Pawlowski, Saptarshi Mukherjee | General Session (75 minutes) | BI Information Delivery | Integrate Your LoB Applications and SharePoint Portal with Microsoft Power BI |
| 28-10-2016 08:00 | Eduardo Castro | General Session (75 minutes) | BI Information Delivery | Microsoft Data Science Toolset |
| 28-10-2016 09:30 | Devin Knight | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Advanced Power BI: Solving the Hard Problems |
| 28-10-2016 09:30 | Brandon Leach | General Session (75 minutes) | Enterprise Database Administration & Deployment | Data Pages, Allocation Units, IAM chains... Oh My! |
| 28-10-2016 09:30 | Maxim Lukiyanov | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Leverage R & Spark in Azure HDInsight for scalable Machine Learning |
| 28-10-2016 09:30 | Stuart Ainsworth, Rick Heiges, Maxwell Myrick, Cathrine Wilhelmsen, Amy Herold | Lightning Talk (75 minutes) | Professional Development | Lightning Talks 104 |
| 28-10-2016 09:30 | Wayne Sheffield | General Session (75 minutes) | Application | Table Vars and Temp Tables – What you NEED to Know! |
| 28-10-2016 09:30 | Jamey Johnston | General Session (75 minutes) | BI Information Delivery | Code Like a Pirate ... Intro to R and Data Science Tools in MS |
| 28-10-2016 09:30 | Kay Unkroth | General Session (75 minutes) | BI Information Delivery | Accelerate Tabular Data Modeling with TMSL and TOM in Analysis Services |
| 28-10-2016 09:30 | Lindsey Allen, Tomas Talius | Microsoft Chalk Talk (75 minutes) | Application | Chalk Talk with Azure SQL Database PM Team |
| 28-10-2016 09:30 | Allan Hirt | Half-Day Session (2.5 hours) | Enterprise Database Administration & Deployment | New HA Feature Deep Dive - SQL Server 2016 and Windows Server 2016 |
| 28-10-2016 09:30 | Sanjay Nagamangalam, Ken Van Hyning | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Management Tools on Windows and Other Platforms |
| 28-10-2016 09:30 | Raj Pochiraju, Shamik Ghosh, Eddie Wuerch | General Session (75 minutes) | Enterprise Database Administration & Deployment | Migrate to Modern SQL Server Platform from Oracle , MYSQL , SQL using SSMA, DMA and DEA |
| 28-10-2016 09:30 | Hamish Watson | General Session (75 minutes) | Application | Overcoming a Culture of FearOps by Adopting DevOps |
| 28-10-2016 09:30 | Tim Mitchell | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deep Dive into the SSIS Catalog |
| 28-10-2016 09:30 | Mike Weiner, Wolfgang Kutschera, Greg Bray | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Firsthand Customer Experiences Running SQL Server 2016 for their Most Business Critical Solutions |
| 28-10-2016 09:30 | Jamie Reding | General Session (75 minutes) | Enterprise Database Administration & Deployment | Explore SQL Server FastTrack Data Warehouse (FTDW) |
| 28-10-2016 09:30 | Argenis Fernandez, David Klee, Lou Lydiksen | Partner Session (75 minutes) | Enterprise Database Administration & Deployment | Storage Testing for Database Professionals |
| 28-10-2016 11:00 | Leila Etaati | General Session (75 minutes) | BI Information Delivery | Cortana Analytics : Transform Data into Intelligence |
| 28-10-2016 11:00 | Sunil Agarwal, Lindsey Allen, Kevin Farlee, Joe Sack, Jovan Popovic, Jakub Szymaszek, Tomas Talius | Microsoft Chalk Talk (75 minutes) | Enterprise Database Administration & Deployment | Chalk Talk with the SQL Server Team |
| 28-10-2016 11:00 | Steve Fox, Sudarshan Gopaladesikan | General Session (75 minutes) | BI Information Delivery | AzureCAT: Using Microsoft's Analytics Stack to Improve Team and Player Performance in Professional Sports |
| 28-10-2016 11:00 | Patricio Cofre | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Using Azure Machine Learning to Predict Consumer Price Index |
| 28-10-2016 11:00 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol: Round 3 |
| 28-10-2016 11:00 | Bala Shankar | MS CSS Session (75 minutes) | Enterprise Database Administration & Deployment | Deploying SQL Server with Microsoft Azure Virtual Machine |
| 28-10-2016 11:00 | Edwin M Sarmiento | General Session (75 minutes) | Professional Development | What SQL Server Professionals Can Learn From Writing and Blogging |
| 28-10-2016 11:00 | Scott Currie | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Biml Recipes: Automatically Create T-SQL Scripts for Common Tasks |
| 28-10-2016 11:00 | David Maxwell | General Session (75 minutes) | Enterprise Database Administration & Deployment | Turbo Charged Transaction Logs - Internals and Performance |
| 28-10-2016 11:00 | Sean McCown | General Session (75 minutes) | Enterprise Database Administration & Deployment | Monster Text Manipulation: Regular Expressions for the DBA |
| 28-10-2016 11:00 | Guy Glantser | General Session (75 minutes) | Application | From XML to JSON |
| 28-10-2016 11:15 | Umachandar Jayachandran, Nellie Gustafsson, Jasraj Dange | General Session (75 minutes) | Application | Inside SQL Server 2016 R Services - Architecture, Security, Performance, and Troubleshooting |
| 28-10-2016 11:15 | André Kamman | General Session (75 minutes) | Enterprise Database Administration & Deployment | How to move databases around in Azure |
| 28-10-2016 11:15 | Hugo Kornelis | General Session (75 minutes) | Application | Now Where Did THAT Estimate Come From? |
| 28-10-2016 11:15 | Jimmy Wong | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Running SQL Server Integration Services within a SQL Server Virtual Machine to do More with Less Money |
| 28-10-2016 13:00 | Kevin Kline | Marketing Community Session (45 minutes) | Professional Development | Staying Involved with PASS |
| 28-10-2016 14:00 | Bob Pusateri | General Session (75 minutes) | Enterprise Database Administration & Deployment | Supercharging Backups and Restores For Fun and Profit |
| 28-10-2016 14:00 | Kay Unkroth, Miguel Llopis, Riccardo Muti, Josh Caplan, Theresa Palmer-Boroski, Chris Finlan, Youssef Shoukry | Microsoft Chalk Talk (75 minutes) | Application | Chalk Talk with the Power BI & SQL BI Teams |
| 28-10-2016 14:00 | Jason Thomas | General Session (75 minutes) | BI Information Delivery | Data Storytelling Using Power BI |
| 28-10-2016 14:00 | Joseph D'Antoni | General Session (75 minutes) | Application | Building Secure Applications in Azure SQL Database |
| 28-10-2016 14:00 | Chris Hyde | General Session (75 minutes) | BI Information Delivery | Introduction to SQL Server R Services in SQL 2016 |
| 28-10-2016 14:00 | Gail Shaw | General Session (75 minutes) | Enterprise Database Administration & Deployment | Go, Go, QueryStore! |
| 28-10-2016 14:00 | Rob Farley | General Session (75 minutes) | Enterprise Database Administration & Deployment | The Synergy of In-Memory Operational Analytics |
| 28-10-2016 14:00 | Pinal Dave | General Session (75 minutes) | Application | Kick Start! SQL Server 2014 / 2016 Performance Tips and Tricks |
| 28-10-2016 14:00 | Jimmy Wong | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Deep Dive of SQL Server 2016 Integration Services |
| 28-10-2016 14:00 | Karen Lopez, Josh Fennessy | General Session (75 minutes) | Professional Development | How to Get Fired as a DBA |
| 28-10-2016 14:00 | Carlos Bossy | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Operationalizing Data Science |
| 28-10-2016 14:00 | Michael J Swart | General Session (75 minutes) | Application | Developing Highly Concurrent Databases |
| 28-10-2016 14:00 | Meet Bhagdev, Andrea Lam, Saloni Sonpal | General Session (75 minutes) | Application | Developing Apps for SQL Server from Popular OSS Languages and Frameworks |
| 28-10-2016 14:00 | Eric Kang, Abbie Petchtes | General Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Data Tools: Enable Continuous Integration and Deployment for Your Databases in Less than 10 Minutes |
| 28-10-2016 14:00 | Dimah Zaidalkilani | General Session (75 minutes) | Enterprise Database Administration & Deployment | Keeping Your On-Prem Data up to Date with the On-Premises Data Gateway |
| 28-10-2016 15:30 | Reza Rad | General Session (75 minutes) | BI Information Delivery | 10 Amazing Things About Power BI You Don't Know |
| 28-10-2016 15:30 | Lance Tidwell | General Session (75 minutes) | Enterprise Database Administration & Deployment | Parameter Sniffing the Good, the Bad, and the Ugly |
| 28-10-2016 15:30 | John Welch | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Advanced Scripting Using SSIS Script Tasks and Components |
| 28-10-2016 15:30 | David Stein | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Azure Data Factory and SSIS Automation With Biml |
| 28-10-2016 15:30 | Buck Woody | General Session (75 minutes) | BI Platform Architecture, Development & Administration | Microsoft R for the Architect |
| 28-10-2016 15:30 | Andrew Liu, Dharma Shukla | General Session (75 minutes) | Application | Azure DocumentDB: A Deep Dive into Advanced Features |
| 28-10-2016 15:30 | Victor Isakov | General Session (75 minutes) | Enterprise Database Administration & Deployment | Mitigating a SQL Server Upgrade Disaster |
| 28-10-2016 15:30 | Saverio Lorenzini | General Session (75 minutes) | Application | Improving SQL Query Performance by Analyzing the Cached Plans |
| 28-10-2016 15:30 | Elad Ziklik, Mike Flasko, Lance Olson, Ofer Ashkenazi, Matt Winkler, Nino Bice, Jennifer Stevens, Neeraj Khanchandani | Microsoft Chalk Talk (75 minutes) | BI Platform Architecture, Development & Administration | Chalk Talk with the Cortana Intelligence Program Management Team |
| 28-10-2016 15:30 | Tara Shankar Jana | General Session (75 minutes) | Application | Build Smarter and Scalable Applications Using Azure Database Services |
| 28-10-2016 15:30 | Mohammad Ali | General Session (75 minutes) | BI Information Delivery | End to End Business Analytics - Real World Scenario Demos and Solution Templates |
| 28-10-2016 15:30 | Denny Cherry | General Session (75 minutes) | Professional Development | Speaker Idol: Final Round |
| 28-10-2016 15:30 | Mladen Prajdić | General Session (75 minutes) | Enterprise Database Administration & Deployment | Algorithms For Searching Through Encrypted Data |
| 28-10-2016 15:30 | Steve Stedman | General Session (75 minutes) | Enterprise Database Administration & Deployment | When Database Corruption Strikes |
| 28-10-2016 15:30 | Jon Boulineau | General Session (75 minutes) | Application | Agile Development Fundamentals: Continuous Integration with SSDT |
| 28-10-2016 15:30 | Edward Pollack | General Session (75 minutes) | Application | All About SQL Injection |
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
In this session, we will first understand the basics of dimensional modeling. Then we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Attend this full day pre-con to gain in depth knowledge of SentryOne products and services. Whether you are already a customer or considering adopting our platform, you will learn how to make the most of it directly from our product and sales engineering teams. CEO Greg Gonzalez will discuss the direction and future of SentryOne. This year we are offering 2 afternoon tracks to accommodate different experience levels.
Basic Track session topics include: SentryOne Configuration, Azure SQL DB & Cloud.SentryOne.com features, and Get Your Server in Shape.
Advanced Track session topics include: SentryOne in the Real World (case studies), SentryOne Advanced Alerting, and Problem Solving.
You will also have the opportunity to interact with the sales and product teams during breaks and lunch as well as a dedicated Q&A session at the end of the day to get your own questions answered. This day of deep dive technical training will provide you with the knowledge and tools to make your own environment run as efficiently as possible.
Morning Sessions
Keynote (60 Minutes) - 200 Greg Gonzalez, CEO
Plan Explorer Index Analysis (30 minutes) – 200 Jason Hall & Greg Gonzalez
Retro Features (105 minutes) – 200 Scott Fallen & John Martin
Basic Track
SentryOne Configuration (90 Minutes) - 300 Lori Edwards
Azure SQL DB & Cloud.SentryOne.com (45 Minutes) - 300 Mike Wood
Get Your SQL Server in Shape (60 Minutes) - 300 David Benoit
Advanced Track
SentryOne in the Real World – Customer Case Studies (90 minutes) – 400 Jason Hall & Guests
SentryOne Advanced Alerting (45 minutes) - 400 John Martin
Using the New Top SQL (60 minutes) - 400 Greg Gonzalez & Jason Hall
Operation Debrief (60 minutes) - 300 SQL Sentry Team
Please visit the <a href="//www.sqlsentry.com/bootcamp" target="_blank"> SQL Sentry Boot Camp page</a> for more information!
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
The session will include tips and tricks for creating simple, easily maintainable visualizations of complex datasets. Along the way, we will look at innovative ways to utilize features such as scope, dynamic report properties, images, and SQL Server spatial data types to push our visualizations to the limits.
As we examine each data visualization tool, we will discuss its strengths, weaknesses, and ways in which it can best be utilized. The session will also cover methods for secure, efficient delivery of visualizations both inside and outside of the organization. We may even play a SQL Server visualization-based game or two!
Participants will leave with a knowledge of the range of tools available in SQL Server 2016 and a solid understanding of the ways to leverage each tool for effective data visualization.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch Brian’s 24Hop Summit Preview Edition session!
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level.
This session will show you how to properly analyze and interpret the results of every single query in the set, along with lots of information on how to properly configure your instance and databases.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch Glenn’s 24Hop Summit Preview Edition session!
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Application
The seminar covers the APPLY operator, its optimization considerations and practical use cases. For example, you will learn about querying tasks where you need to control whether the optimizer will use a seek-based or a scan-based strategy depending on the density of the data, and how APPLY can help you to address this need.
The seminar covers window functions, their optimization considerations and practical uses. You will learn about aggregate, ranking and offset window functions, and how such functions introduce a whole new way of solving T-SQL problems in general.
You will learn about pivoting and unpivoting techniques, including specialized cases and dynamic pivoting. You will also learn about the OFFSET-FETCH filter and how to tune queries using it.
The seminar also covers SQL Server 2016 additions related to temporal data including system-versioned temporal tables and the AT TIME ZONE function. If time permits, the seminar will cover additional T-SQL querying and programming topics such as dynamic search conditions, sequences and how access methods are affected by isolation levels.
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
We start by introducing changes to Integration Services that expand your connectivity, development, and deployment options. We also review the improvements to Analysis Services models that provide you with even more flexibility in the design process, support more complex modeling scenarios, and improve performance. Then we tour the Reporting Services modernization for development, new web access, and mobile reporting.
Throughout this workshop, we also review options for integrating JSON, R, and PolyBase into BI processes. Whether you are a BI architect or developer, this workshop provides you with the information you need to prepare for SQL Server 2016.
Event Date: 24-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In addition, FCIs and AGs are tightly coupled solutions utilizing a Windows Server Failover Cluster (WSFC), networking, Active Directory, DNS, and more. Without understanding these things, troubleshooting becomes nearly impossible.
This full-day pre-con will teach you approaches for dealing with real-world problems related to the different clustered configurations of SQL Server whether they are FCIs or AGs. You’ll learn about the tools and utilities you can use for diagnosis, common failure scenarios, and solutions, avoiding problems by being proactive, and more. Each student will also gain hands on experience via one or more lab scenarios using their own laptop connected to Web-based virtual machines where learning translates into action to bring a broken HA environment online.
If you are responsible for supporting FCIs or AGs, this session is one which will make you the hero when everyone needs one.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch Allan’s 24Hop Summit Preview Edition session!
Sorry! This Pre-Conference Session is sold out!
# #### SessionID: 47583 # SQL Server Index Formulas: Problems and Solutions #### [Back to calendar](#id-583) Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Application ## Speaker(s): Kendra Little ## Title: SQL Server Index Formulas: Problems and Solutions ## Description: ### Every SQL Server developer must know the essentials of clustered and non-clustered index design to build fast and reliable applications. You need scripts to show when a new non-clustered index, filtered index, or indexed view will improve performance on a live SQL Server workload, and the skills to design the best index.In this example-packed full-day session, you will work through a series of problems and solutions to learn how to create and tune indexes. You will learn how to select and order key columns, when included columns help, when to use special indexes, and when to drop indexes. You will see how SQL Server 2016’s new Query Store feature offers you new tools for improving your indexes, and how Query Store compares to index dynamic management views.
You'll leave with all the scripts for the problems and solutions covered in the course, plus a set of additional exercises to keep building your index skills.
Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
This all-day interactive and hypervisor-agnostic session is designed to help data professionals learn more about virtualization and infrastructure, and discover how this new layer can be used to improve the management, availability, and performance of their databases. You will be exposed to all layers of virtualization underneath the SQL Server, from the storage to the hypervisor, and will discover many useful tips and tricks to tuning the database layer to boost performance and availability. The following topics will be addressed during the session: • virtualization and infrastructure fundamentals • the SQL Server Virtual Machine • networking, support, and licensing • High Availability and Disaster Recovery • performance investigation and tuning of the entire stack.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch David’s 24Hop Summit Preview Edition session!
Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
At the end of the day, you will be ready to start using the entire Power BI stack in your company, choosing the right feature for each requirement and applying the best practices in each step. The additional benefit is to understand how to include cloud services as a part of your data warehouse infrastructure.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch Marco’s 24Hop Summit Preview Edition session!
Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
In this session we will explain and demonstrate how to build out an efficient and effective Data Platform that will scale across your entire organization. We will present on-premises, hybrid, and cloud-based options. You will leave with the tools needed to develop, deploy, and manage the entire solution. Here is a look at what will be covered.
Preparing your organization for a Business Intelligence Solution
We will cover what this looks like for your organization. From on-premises, to cloud and hybrid approaches. We will take a look at some sample topologies as well as look at how Office 365 fits into the picture. If you go the Office 365 approach, you will also need to know how authentication will be effected.
Building a Data Warehouse
Data warehouses still have their place. You also have options in how you approach it. We will look at some of the different technology available to you and why you should consider having a data warehouse.
Loading a Data Warehouse
So, you’ve decided to have a data warehouse! How do you get data into it? We will look at how SQL Server Integration Services fits in your organization and how it can help you to get data where it needs to be. We will also briefly talk about Azure Data Factory.
Building a Semantic Model
A semantic model really helps to describe your data and allows for further analytics on your data. You have options here as well! We will look at self-service options, such as Power Pivot and Power BI Desktop, as well as enterprise options with tabular and multidimensional in Analysis Services.
Sharing and Visualizing your Data
After you have your data and your semantic model, you can start to have fun! We will look at the Microsoft offerings for reporting. This will include the new Reporting Services 2016, Power BI and Excel.
Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Sessions include:
• IDERA Overview with Randy Jacops, CEO • IDERA Roadmap • IDERA Free Tools • Customer Case Studies • SQL Diagnostic Manager Architectural Internals • SQL Diagnostic Manager PowerShell Scripting • SQL Security Suite • SQL BI Manager • SQL Workload Analysis
For more information, click <a href="http://www.idera.com/lp/pass-2016-pre-conference" target="_blank">here</a>!
Event Date: 25-10-2016 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
SQL Server offers two methods for an application to provide data consistency: Pessimistic and Optimistic Concurrency Control. In this seminar we’ll discuss what consistency might mean to your applications, and describe the details of how each of the concurrency models works internally. We’ll examine the costs and trade-offs between the two concurrency models that SQL Server 2014 supports through different transaction isolation levels. Finally, we’ll examine the tools available for analyzing and troubleshooting blocking problems, including metadata views and Extended Events. You will learn:
• why concurrency management is a crucial part of database and application tuning • how each of the transaction isolation levels impacts concurrency • the details of how SQL Server implements pessimistic concurrency through locking, and when locking causes blocking • how the snapshot-based isolation levels implement optimistic concurrency, and the problems to be aware of • how In-Memory OLTP allows maximum concurrency with no locking • how to use the metadata views and Extended Events to troubleshoot concurrency problems and monitor the resources used to manage concurrency.
Want to preview this Pre Conference session before you purchase it? Click HERE to watch Kalen’s 24Hop Summit Preview Edition session!
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
Attend this session to learn how database records are stored within SQL Server and why all data types are not created equal. Armed with that knowledge, we will explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Professional Development
As technology professionals, our tech skills need to be at their peak. However, we often lack the communication skills to describe technical concepts to others, including business users, executives, or even other technology professionals. In this session, veteran IT professional and Microsoft Data Platform MVP, Mike Hillwig, will show you a handful of skills that are essential in communicating with people outside of the database world.
You will learn Mike's keys to good storytelling, making analogies, listening, writing, and putting technology concepts into things that give you a common language with business users. You'll leave this session with the ability to influence technology decisions based on your skills explaining why the DBA is usually right.
Event Date: 26-10-2016 10:15 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will cover the Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, take the mystery out of the code, and help you get started writing your own PowerShell scripts. Attendees will not only acquire an understanding of Powershell, but see practical examples of how it can be used with SQL Server, along with a set of resources they can use to learn more about the language.
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will present an approach that brings the LOB and IT together in a partnership that embraces self-service BI while maintaining a level of rigor and oversight – combining typical project processes with a task-driven agile approach. As a result, BI solutions can be brought to market quicker, supporting the LOB and keeping IT relevant.
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 10:15 - Category: Partner Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
• Modifying SSRS Reports on the fly • Extending SSRS, Owner Draw Gradient Background • Adding Barcode, QRCode • Database Fields in page header and page footer • Review of some known SSRS Issues
Second, we will show how anyone can quickly create SSRS Reports from the web. It is the only solution that will enable users to create SSRS Reports from mobile devices such as an iPad or smart phone. Reports are created in minutes, with little or no SSRS report writing training, that include such features as: • Groups and summaries, including percentage summaries. • Charting, Bar, Pie, Column, Line, and Area. • Databar • Indicator • Running Total • Field Highlighting • QR Code and Barcode
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure DocumentDB.
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Self-Service BI technologies have evolved to include data preparation capabilities and in that space Power BI comes with a rich set of features that often goes unnoticed or underused.
In this session we will explore how Power BI can be used to respond to more advanced data preparation scenarios while requiring no or minimal coding, making it an ideal tool for users such as data and business analysts. We will show how Power BI can be used to reduce time and cost of preparing the data used in analysis and reports, while keeping in check considerations and concerns that we, as IT stakeholders, have when adopting this type of technologies in our organizations.
Event Date: 26-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Topics will include: Security improvements, entity history management, business rule extensions, merge conflict resolution, approval workflows with change sets, many-to-many hierarchies, Entity Sync, and managing deleted data.
This session will be of interest to data professionals already familiar with SQL Server Master Data Services, or the discipline of Master Data Management.
Event Date: 26-10-2016 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory. You will also learn how to evaluate and compare different types of storage subsystems for various database workload types. Gain the knowledge you need to get the best performance and scalability possible from your hardware budget!
Event Date: 26-10-2016 10:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 10:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We will use customer case studies to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.
Event Date: 26-10-2016 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 12:30 - Category: Marketing Community Session (45 minutes) - Track: Professional Development
Event Date: 26-10-2016 13:30 - Category: Half-Day MS CSS Session (3 hours) - Track: Enterprise Database Administration & Deployment
We will cover “everything Hekaton”, including how it is integrated with the SQL Server Engine Architecture. We will explore how data is stored in memory and on disk, how I/O works, how native complied procedures are built and executed. We will also look at how Hekaton integrates with the rest of the engine, including Backup, Restore, Recovery, High-Availability, Transaction Logging, and Troubleshooting.
Demos are a must for a half-day session like this and what would an inside session be if we didn’t bring out the Windows Debugger. As with previous “Inside…” talks I’ve presented at PASS, this session is level 500 and not for the faint of heart. So read through the docs on In-Memory OLTP and bring some extra pain reliever as we move fast and go deep.
This session will appear as two sessions in the program guide but is not a Part I and II. It is one complete session with a small break so you should plan to attend it all to get the maximum benefit.
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 13:30 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you learn how to find the answers to these questions and more. You learn where to find key information about performance by reviewing logs and performance counters. In addition, you learn how to persist this information so that you can monitor trends over time to determine whether changes to the environment are helping or hurting performance.
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 26-10-2016 13:30 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You’ll also hear from Tim Baker, Director of Data Platform Services for Manulife Financial. He’ll discuss how a containerized architecture allows his Global 500 company to sustain rapid growth without the rampant sprawl and management nightmares of the past—all while achieving unparalleled agility and availability.
Don’t miss your chance to gather valuable insights from the experiences of these two industry leaders.
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 13:30 - Category: Lightning Talk (75 minutes) - Track: Enterprise Database Administration & Deployment
Lightning Talks 103 focuses on the DBA track, featuring:
Victor Isakov - "Important Trace Flags to Use in Production Environments"
Murilo Miranda and Luan Medeiros Maciel - "SQL Server on Azure VMs - Lessons from the Field"
Maxwell Myrick - "What Every DBA Should Know About Updates in Under 10 Minutes"
Edward Pollack- "The Good, Bad, and Ugly of Filtered Indexes"
Shawn Myers - "SQL Server and vNUMA: Learn What You Need Quickly"
Event Date: 26-10-2016 13:30 - Category: Half-Day Session (2.5 hours) - Track: Application
MongoDB is the leading NoSQL database today. It provides a rich set of features and supports many programming languages. Many organizations move from SQL Server to MongoDB, and many DBAs and database developers are required to know it in addition to SQL Server.
In this session, we will talk about:
MongoDB is here. It's time to know how, when, and why to work with it.
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, we will have an overview of these tools and learn "what to use, when" so that you have a blueprint for your mobile, cloud, hybrid and on-premise Business Intelligence strategy, using SQL Server 2016 as the supporting technology.
Takeaways: SQL Server Reporting Services (SSRS) has been given the love it deserves; learn about Datazen and how if fits with SSRS and Power BI; see the new capabilities for SQL Server Analysis Services; see Microsoft R Server in SQL Server, explained; mobile business intelligence for everyone!
Join this session to get the inside scoop on SQL Server 2016 from the Business Intelligence perspective.
Event Date: 26-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We will start by using R Studio and Scripts samples and will migrate these scripts to Microsoft R Server and Microsoft SQL Server 2016. Next, we will show how to integrate these scripts inside the data warehouse cycle and within PowerBI in the architecture.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and spark-lines focus attention on what is important to the viewed data set.
Event Date: 26-10-2016 15:15 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session provides a survey of the latest trends and how you can extend your SQL Server knowledge to take advantage of these technologies. You will see how database technologies such as SQL Server, Oracle, DB2 work on the Azure, AWS and Google cloud platforms. We will also look at NoSQL and Data Warehouse technologies on the same platforms. You will also see how different BI tools like Microsoft Power BI, Tableau and QlikView helps you play well between the database technologies. Finally, if you are looking to modernize older versions of SQL Server, you’ll learn about how DB Best Technologies approach upgrade projects.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we'll look at some common causes of TempDB contention, both query-based and configuration-based. We’ll look at guidelines for configuring TempDB and when and why you'd make various changes, and we’ll cover more ways to monitor TempDB than you can shake a stick at.
Now, about those weekend plans…
Event Date: 26-10-2016 15:15 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Hiring is one of the most important things a leader does. A good fit strengthens your team; a hiring mistake is costly to everyone. In this session, we’ll explore proven techniques for interviewing and identifying the best person to join your team.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session you will learn how to integrate relational databases (SQL Azure DB, Azure DWH, or SQL Server) by federation with ADLA, how to trigger jobs from on-prem systems like SSIS, and how to orchestrate the service via Azure Data Factory. Through live demos you will see that this service gives you great computing power for your BI landscape and integration is not that difficult.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Application
This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.
Event Date: 26-10-2016 15:15 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
The demos in this session include a review of SQL Server Polybase settings, query formats for accessing Polybase data, and examples of query performance for different types of queries. Attendees will find out limitations of Polybase queries, performance information, and what kind of data works best for SQL and Hadoop.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Application
We will examine how workarounds, technical debt and clever designs can cause you grief when you least expect it. We will show you features that can haunt you later. Are your primary keys going to fail you? Are your faux NULLs going to bite you? Is there now a better way to do the right thing in SQL Server 2016?
In this demo-focused session we will show you how these timebombs happen and give you the tools and knowledge to identify the ones that will cause the most pain. We'll show you how to find the timebombs in SQL Server and how to know when a problem is about to happen.
Join us: you'll keep your job, have happier users and get more rest.
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We will also explore the Mary Go Round query feature and find ways to bulk load data faster and how to load data from an OLTP system with zero impact to it.
Event Date: 26-10-2016 16:45 - Category: Partner Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Professional Development
This session will attempt to answer that question by providing you with a framework to build a persuasive argument. The presenters will provide insights from their combined 37 years of experience as employees, managers, educators, and community leaders. We'll cover how to determine your boss's receptiveness to training, discover currently available resources for education, and building a persuasive argument based on business objectives. We will also review the differences in quality of training resources, both free and paid, to help those controlling the purse strings understand why training is a solid investment.
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.
This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
This session will answer questions like:
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 16:45 - Category: Lightning Talk (75 minutes) - Track: BI Information Delivery
Lightning Talks 102 focuses on the BIA and BID tracks, featuring:
Dean Furness - "Creating Cool Custom Bullet Charts with SSRS"
David Stein - "Three Things You Won't Believe I Do With BIML”. "
Leila Etaati - "Be Confident: Choose the Right Algorithm in Azure ML"
Josh Fennessy - "Interested in Hadoop? Here's What you Need to Know..."
Markus Ehrenmueller-Jensen - "Burst Your Sun (Glasses) - Improve Your Datavizualisation"
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Event Date: 26-10-2016 16:45 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 26-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.
Event Date: 27-10-2016 10:15 - Category: MS CSS Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
In this session, we are going to take a look at in-memory tables, their best use cases as well as development best practices. We will also look at the changes to the indexing design for inMemory-based objects and how it differs from existing disk-based table indexing. Finally, we are going to cover how to build fast, scalable applications which utilize inMemory objects, as well as choosing the appropriate indexes for your inMemory objects to give you the performance boost that you have been expecting.
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 10:15 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
On the basis of an existing application on CodePlex (https://reportgeneratortask.codeplex.com/) we will look at more detail into the web service.
After this introduction we will take a look into the new programming interface for SSRS 2016. We try to match main functions on the new API and show differences and stumbling blocks. In addition, we detail what new functionalities DataZen and power BI have brought into the API, and what the API provides for these types of reports.
Event Date: 27-10-2016 10:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Azure offers a fully managed Machine Learning cloud service that enables you to easily build, deploy, and share predictive analytics solutions. In this session we will learn what machine learning is and why we should use it, how it can be used to analyze historical data and predict future behavior, what some of the business use cases for machine learning are, and how it all works in Azure. The session includes some examples that will demonstrate the power of Machine Learning.
Event Date: 27-10-2016 10:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 10:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 10:45 - Category: General Session (75 minutes) - Track: Application
The objective of this session is to demystify the DWU and help you provide better estimates to your customers.
Areas covered will include both technical and non-technical requirements:
Event Date: 27-10-2016 10:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 13:30 - Category: Partner Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session full of demos, former Microsoft BI executive, Bruno Aziza (now at AtScale), takes you through the Do’s and Don’ts of BI on Big Data.
We will cover: • Why moving data is evil when all you’re trying to do is provide employees with live, fast and unencumbered access to relevant data. • Why SQL, DAX and MDX don’t matter in the end. All you need is the right semantic layer practices to rule them all • How you can make ANY BI tool (not just PowerBI and Excel) perform on all Big Data sources? • Why your SQL Analysis expertise can be leveraged TODAY for all data - Small and Big, Hadoop and Non-Hadoop.
WARNING: This session is not for the shy and faint-hearted. We want you to bring your questions. We want you to be ready to take some of ours (brave participants will be rewarded with awesome gifts).
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
Come and see demos that will help illustrate new scenarios and usage patterns that Azure SQL Database provides to developers.
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
You will leave this session with five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations. Every rule will be applied through live demos in Excel, Reporting Services, and Power BI Desktop, where you will learn how to avoid pitfalls from the defaults in those tools.
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 27-10-2016 13:30 - Category: Lightning Talk (75 minutes) - Track: Application
Lightning Talks 101 focuses on the AppDev track, featuring:
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Application
To help address these realities, data practitioners from a diverse set of backgrounds are increasingly relying on schema-free, distributed, scalable, and high-performance data storage (also known as NoSQL databases). In this session, we will showcase a wide variety of customer scenarios, business goals, and technical challenges faced by real-world customers. More importantly, how adding Azure DocumentDB into a data practitioner's arsenal within the Microsoft/Azure data ecosystem will allow you to easily solve these complex design patterns at massive scale.
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 27-10-2016 13:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 15:15 - Category: Half-Day Session (2.5 hours) - Track: BI Platform Architecture, Development & Administration
In this half-day session, we will fully explore how Biml can help you with your SSIS development. We will review what Biml is, walking through the language basics and showing how it fits into your existing SSIS development environment. Once we've covered those basics, we will work through several increasingly complex examples to show how Biml can be used to generate, in a matter of minutes, packages that would have otherwise taken days if not weeks.
There are two types of SSIS developers: Those using Biml, and those who will soon be. This session will help you to get started with Biml, and put you ahead of your peers in this revolutionary technology.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. You will leave the session with an understanding of how you can leverage this feature to achieve solutions that are not possible using other High Availability features.
The content will be valid for all versions of SQL Server from 2005 onward.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Stretch Database is the new concept, which allows you to stretch your data from on-premises to cloud without a need of any SSIS packages or any other automation. In this session you will understand, enabling/disabling data stretch, reading data from stretched database, setup remote data archiving and backup and restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow and Deep backups.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Professional Development
Whether you are a junior developer, a senior database administrator or a chief architect, you can always advance your career further. By becoming a volunteer, you will get invaluable experience while developing your soft skills, building your personal brand and expanding your network. Maybe you will even find your dream job along the way?
In this session we will explore volunteer opportunities and how they can help advance your career. There is something for everyone! From helping others through social media, to sharing your knowledge by blogging or speaking, to organizing small or large events. Volunteer to do something you already love or volunteer to develop a specific soft skill. Either way, you are guaranteed to learn, grow and better position yourself for the next step in your career.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire lifecycle of SQL Server in Azure.
Attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Clusters Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated. High-performance optimization will be discussed and demonstrated with the goal of achieving performance goals without overprovisioning cloud resources.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 27-10-2016 15:15 - Category: Half-Day Session (2.5 hours) - Track: BI Platform Architecture, Development & Administration
In this mini-workshop you'll learn how to identify the most common bottlenecks and performance issues and walk away with practical techniques (and scripts!) you can take home and start using immediately. Your journey will start with learning how to think like the SSAS engine by seeing how a query is broken down into chunks and processed by the various subsystems. Along the way, you'll learn how to use (and automate) the collection of performance counters and extended events. By the end of the session, you'll not only know how to identify performance bottlenecks, but also how to narrow down the list of potential solutions. Stop guessing what's causing your Analysis Services performance problems!
Event Date: 27-10-2016 15:15 - Category: Partner Session (75 minutes) - Track: Application
But copying databases for development and test is a job that gets 'delegated up'; DBAs, IT Managers, those with the keys to Production find themselves performing the task, and the development team is often blocked while it takes place.
The same people are often responsible for ensuring the copy is appropriate for the environment (permissions, configuration data, sensitive data), so have to perform semi-manual tasks and maintain brittle scripts to do so.
In this session Redgate’s Grant Fritchey shows how new tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline or snapshotting of changes.
Event Date: 27-10-2016 15:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 15:15 - Category: Marketing Community Session (45 minutes) - Track: Professional Development
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will learn what are the new features of DirectQuery, how to implement best practices in order to obtain the best results, and what are typical use cases where DirectQuery should be considered as an alternative to the in-memory engine embedded in Analysis Services.
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data cleaning, visualization, and prediction will be presented. Subsequently, an introduction to use R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML with R will be shown.
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Application
Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order.
In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 27-10-2016 16:45 - Category: Partner Session (75 minutes) - Track: Application
This session will walk you through the new HPL/SQL for Hive, which is ideal for transferring complex stored procedures to Hadoop. We will also take a look at using PowerBI with Hive LLAP to visualize your data. In end you'll see how something strange can seem so familiar.
Event Date: 27-10-2016 16:45 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will teach you how to implement proper monitoring and alerting. We will also show you what metrics and reports you should be reviewing regularly to ensure there are no surprises, such as pauses replication or unacceptable delays. For example, we will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts. We will show what to monitor in your AG, and how to setup alerting so you know when to take action.
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Application
This session demonstrates the data partitioning techniques available in the various editions of SQL Server. It discusses benefits, downsides and the best use-cases for partition tables, local and distributed partitioned views and stretch databases. The session will also demonstrate how data partitioning helps boost performance of systems handling a mixed workload, improves cardinality estimations with large tables, and reduces the system’s storage cost.
Finally, the session provides a set of guidelines on how to split the data between relational and non-relational storages in OLTP and IoT systems hosted in the Cloud.
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session includes an overview of SQL Server 2012 and a deep dive into SQL Server 2014 and 2016 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, and big wins. Learn whether columnstore can change your users' world and why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit and why columnstore manifests my motto, “Change the world or go home!”
Event Date: 28-10-2016 08:00 - Category: MS CSS Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In the last couple of years, SQL Server Escalation Team and Product Group have worked closely with many customers running Tier-1 mission critical workloads to scale their SQL Server with several configuration parameters and application patterns.
In this session you will hear directly from experienced members of the Microsoft SQL Server product group and escalation team, about these specific learnings, configurations, and approaches for scaling SQL Server on the largest hardware systems available on the planet. You will be amazed to find out how you can extract more performance from SQL Server without changing your application code or design!
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB, as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Event Date: 28-10-2016 08:00 - Category: Half-Day Session (2.5 hours) - Track: Professional Development
Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore.
It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session we will show you how Tabular performs when you are querying a model with many billions of rows, conduct a complete analysis of the model, searching for optimization ideas, and implement them on the fly, so to look at the effect of using the best practices on large models. This will also give you a realistic idea of what Tabular can do for you when you need to work on large models.
Event Date: 28-10-2016 08:00 - Category: Microsoft Chalk Talk (75 minutes) - Track: Application
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 08:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
The main objectives of the session are to show how to create Architectures that include Data Science analysis using Microsoft Machine Learning, and revealing the results in a PowerBI Dashboard. Attendees will also learn how to integrate R code in solutions, starting with R Studio and then migrating the code to SQL Server 2016, and integrating with the PowerBI dashboard.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real world problems with Power BI.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You'll hear how these concepts tie in to your work as a DBA or developer. You’ll get to see the concepts in action through demos and learn how you can use this knowledge to design better solutions. In addition you'll see some neat tools to help you dig in and learn further.
After this session you will understand: • the three basic types of storage in SQL Server • the physical structure of a row and how it affects performance • differences in how SQL Server works with heaps and clustered indexes • how pages are allocated and tracked • how to use various tools to continue your learning.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 09:30 - Category: Lightning Talk (75 minutes) - Track: Professional Development
Lightning Talks 104 focuses on the Professional Development track, featuring:
Stuart Ainsworth - "Oh, the Places You'll Go! A Seussian Guide to the Data Platform"
Maxwell Myrick - "Insider Secrets to Securing the Budget You Need"
Catherine Wilhelmsen - "5 Ways to Advance Your Career by Becoming a Volunteer"
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Application
In this code-filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Come to this session to get an introduction to the R language including:
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 09:30 - Category: Microsoft Chalk Talk (75 minutes) - Track: Application
Event Date: 28-10-2016 09:30 - Category: Half-Day Session (2.5 hours) - Track: Enterprise Database Administration & Deployment
This half-day session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of.
With this extended session, most of what will be discussed will be shown so you can see how they work. If you want to get up to speed quickly with what’s new for availability in the new versions of SQL Server and Windows, this is the one session you should attend.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Application
During this session we will demonstrate how DevOps allows you to respond faster to competitive pressures by replacing error-prone (human) processes with automation for improved traceability, reliable, and repeatable deployments.
DevOps methodologies allow you to develop and use automation techniques for fast, efficient, and reliable software delivery. DevOps is about a cultural shift as much as a process and technological one. This session will illustrate how when you overcome the technical challenges of implementing DevOps you expose the cultural benefits.
With improved traceability, reliable, and repeatable deployments, this session will help you remove FearOps from your organisation.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 09:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 09:30 - Category: Partner Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 11:00 - Category: Microsoft Chalk Talk (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Through leveraging Azure+PowerBI resources for data scraping, analytics, and visualization, it is possible to obtain:
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2016 11:00 - Category: MS CSS Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will look at some of the common issues I have seen, on the support side, through various customer deployments. We will cover items that range from setup and configuration of the VMs, to licensing and looking at how you can work with AlwaysOn, along with other recommendations.
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This will be a scenario-driven session where we discuss many real-world examples of manual tasks that can be automated with Biml snippets and the free BIDS Helper AddIn to BIDS/SSDT. You will receive all code for your own use.
Scenarios include:
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Here you’ll learn: • the most useful regular expression commands • the appropriate times to use regular expressions • how to use regular expressions to write code for you • how to incorporate regular expressions into large tasks and combine them with other methods.
Event Date: 28-10-2016 11:00 - Category: General Session (75 minutes) - Track: Application
In this session we will learn how to work efficiently with these two markup languages in SQL Server. We will discuss use cases for using either XML or JSON. We will compare a few methods and talk about the performance impact of each. If you’re a developer and you need to manipulate XML or JSON files in SQL Server, then this session is for you.
Event Date: 28-10-2016 11:15 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 11:15 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we will look at the various ways to archive and move databases around within the Azure (hybrid) cloud. Learn how to move data between SQL Server and Azure SQL Database, move data between your datacenter and Azure, create backups for long term storage to comply with your corporate data retention policy, and create (automated) database copies for your developers.
We will discuss the various options and their respective pros and cons.
This session will restore (pun intended) your confidence in your backup/restore skills.
Event Date: 28-10-2016 11:15 - Category: General Session (75 minutes) - Track: Application
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries."
Event Date: 28-10-2016 11:15 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 13:00 - Category: Marketing Community Session (45 minutes) - Track: Professional Development
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 14:00 - Category: Microsoft Chalk Talk (75 minutes) - Track: Application
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Join me as I take you through on how to utilize Power BI effectively to tell data stories and engage your audience. Watch and learn some of the top techniques and hacks on making aesthetic as well as relevant Power BI reports for effective storytelling. Also, watch out for some engaging examples of storytelling using Power BI (which also includes the winning report of the Microsoft Power BI Best Report contest!)
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Application
Azure provides extremely robust security protection at the physical, logical, and data layers of its services and applications, making Azure datacenters among the most secure facilities of their kind in the world. Likewise, Azure SQL Database includes multiple layers of security, with role-based logical data protection and auditing to monitor the security of your data.
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Application
Here is the glimpse of the features we will cover in this session. • live plans for long-running queries • transaction durability and its impact on queries • new cardinality estimate for optimal performance • In-memory OLTP optimization of superior query performance • columnstore indexes and performance tuning • Query Store • Temporal Tables.
This 75 minutes will be the most productive time for any DBA and Developer who wants to quickly jumpstart with SQL Server 2014 and its new features.
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Professional Development
In this session, we will share with you the types of behaviors we've seen in real life that will likely get you fired if you try them. Then for each, we'll discuss how to recover from them. We'll also give you some real-world stories of how some people made their situation even worse. It won't be all serious; we have some great #FAIL stories of our own and we managed to survive.
Finally, we'll leave you with 10 tips for recovering from fails without getting fired.
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Application
Concurrency problems can restrict the throughput you get from SQL Server. So your goal is to develop an application that can avoid these bottlenecks and make use of all the hardware it's given.
In this session we'll cover several enemies of concurrency, excessive blocking, how to detect and fix deadlocks, correct tempdb configuration and others. We'll also talk about when it's appropriate to use SQL Server's In-Memory OLTP features or the Read Committed Snapshot Isolation Level.
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 14:00 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
During this session, we will demonstrate several scripts in SSIS (including the ones mentioned above) that show how to take full advantage of the capabilities of SSIS. This session is intended for people who have worked with and understand SSIS, and have a basic understanding of .NET development.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session you will learn the dvantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.
All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 15:30 - Category: Microsoft Chalk Talk (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Application
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: BI Information Delivery
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Professional Development
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session we'll take a look at a few algorithms that enable you to search through the encrypted text data on the server without decrypting anything and returning only the search results to the client with performance in mind. Just the way a search should be performed.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We will walk through three corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Application
This demo-heavy session walks through the beginning-to-end processes of implementing Continuous Integration and inspires developers to become passionate practitioners of agile practices.
Event Date: 28-10-2016 15:30 - Category: General Session (75 minutes) - Track: Application
Proactive solutions are key to preventing SQL injection and ensuring that hackers don't see your application as an easy target. We will demonstrate common mistakes that lead to SQL injection and a variety of ways which can safeguard our data against attacks.
While illustrating the ways in which hackers probe and attack our systems, we will show that SQL injection is not only the result of bad TSQL, but also bad code. By securing our data from the application and database tiers, we can greatly decrease their attractiveness to hackers and prevent attacks that could cripple a business permanently.