| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 30-10-2017 08:30 | Allan Hirt | Pre-Conference Session (Full Day) | Design | Advanced SQL Server Availability and Storage Solutions |
| 30-10-2017 08:30 | Ginger Grant | Pre-Conference Session (Full Day) | Analyze | Applied Data Science for the SQL Server Professional |
| 30-10-2017 08:30 | Jeremy Likness | Pre-Conference Session (Full Day) | Design | Modern Web API Design |
| 30-10-2017 08:30 | Erin Stellato | Pre-Conference Session (Full Day) | Perform | Solving Common Performance Problems Using Query Store |
| 30-10-2017 08:30 | Joseph D'Antoni | Pre-Conference Session (Full Day) | Design | Azure Infrastructure |
| 30-10-2017 08:30 | Marco Russo | Pre-Conference Session (Full Day) | Design | Data Modeling with Power BI |
| 30-10-2017 08:30 | Itzik Ben-Gan | Pre-Conference Session (Full Day) | Build | Mastering T-SQL Querying Fundamentals |
| 31-10-2017 08:30 | Paul Turley | Pre-Conference Session (Full Day) | Design | Modern Reporting with SQL Server 2016 and 2017 Reporting Services |
| 31-10-2017 08:30 | Chris Webb | Pre-Conference Session (Full Day) | Design | Loading and Transforming Data in Power BI and Power Query |
| 31-10-2017 08:30 | Melissa Coates, Lord Richard Douglas, John Martin, Lori Edwards, Scott Fallen, Greg Gonzalez, Fred Frost | Pre-Conference Session (Full Day) | Perform | SentryOne Performance Boot Camp |
| 31-10-2017 08:30 | Niko Neugebauer | Pre-Conference Session (Full Day) | Perform | Columnstore Indexes: Practical Solutions & Techniques |
| 31-10-2017 08:30 | Chrissy LeMaire, Rob Sewell, Constantine Kokkinos | Pre-Conference Session (Full Day) | Scale | Standing on the Shoulders of Giants: Community-proven PowerShell Solutions for Every Data Platform Pro |
| 31-10-2017 08:30 | Mico Yuk | Pre-Conference Session (Full Day) | Design | Visual Data Storytelling: How to Tell a Compelling Story that Matters to Your Users |
| 31-10-2017 08:30 | Brent Ozar, Erik Darling | Pre-Conference Session (Full Day) | Perform | Expert Performance Tuning for SQL Server 2016 & 2017 |
| 31-10-2017 08:30 | David Klee | Pre-Conference Session (Full Day) | Perform | Virtual SQL Servers: Right to Ludicrous Speed |
| 31-10-2017 16:45 | Bill Graziano, Cathrine Wilhelmsen | General Session (75 minutes) | Evolve | PASS Summit 2017 First-Timer Orientation & Speed Networking |
| 01-11-2017 06:55 | Deborah van Petegem | Sponsor Breakfast | Innovate | Breakfast and Backup: Dell EMC Transforms Data Protection for SQL Server |
| 01-11-2017 07:00 | Venu Aravamudan | Sponsor Breakfast | Innovate | Using Microsoft SQL Server on Amazon Web Services |
| 01-11-2017 08:15 | Rohan Kumar | Keynote (90 minutes) | Innovate | SQL Server 2017 and Azure Data Services – The Ultimate Hybrid Data Platform |
| 01-11-2017 10:15 | Sunil Agarwal | MS Tiger Session (75 minutes) | Build | Maximizing the Query Performance with Columnstore Indexes |
| 01-11-2017 10:15 | Aaron Nelson, Paul Turley | General Session (75 minutes) | Build | PowerShell for BI Professionals: Automating SSIS, SSRS & SSAS |
| 01-11-2017 10:15 | David Maxwell | General Session (75 minutes) | Support | Understanding and Handling Database Corruption |
| 01-11-2017 10:15 | Amit R S Bansal | General Session (75 minutes) | Perform | Benchmarking & Testing In-Memory OLTP Performance |
| 01-11-2017 10:15 | Jimmy May | General Session (75 minutes) | Perform | Intro to I/O Monitoring: The Counters That Count |
| 01-11-2017 10:15 | Dr. Jennifer Akullian | General Session (75 minutes) | Evolve | Mental Health in Tech |
| 01-11-2017 10:15 | Kellyn Pot'Vin-Gorman | General Session (75 minutes) | Support | DevOps Tool Combinations for Winning Agility |
| 01-11-2017 10:15 | Sanjay Mishra, Robert Venable | Microsoft Session (75 minutes) | Scale | How Microsoft Sales Evolved from a Monolithic On-Prem Solution to a Scaleout Solution in Azure |
| 01-11-2017 10:15 | Umachandar Jayachandran, Nellie Gustafsson | Microsoft Session (75 minutes) | Build | How to Leverage Machine Learning Services in SQL Server 2017 and Azure SQL Database |
| 01-11-2017 10:15 | Ted Neward | General Session (75 minutes) | Design | Busy .NET Developer's Guide to Multiparadigmatic Design in C# |
| 01-11-2017 10:15 | Ginger Grant | General Session (75 minutes) | Analyze | Speed Up R Solutions with Azure ML |
| 01-11-2017 10:45 | Kendra Little | General Session (75 minutes) | Build | Why Did My Clever Index Change Backfire? |
| 01-11-2017 10:45 | Kamal Hathi | Microsoft Session (75 minutes) | Analyze | Microsoft BI – An Integrated Modern Solution |
| 01-11-2017 10:45 | Douglas Barrett | Partner Session (75 minutes) | Design | Positioning IT for Success Through Automation |
| 01-11-2017 10:45 | Argenis Fernandez | General Session (75 minutes) | Support | Modern Security Attack Vectors Against SQL Server Environments |
| 01-11-2017 10:45 | Itzik Ben-Gan | General Session (75 minutes) | Perform | T-SQL Tips and Tricks |
| 01-11-2017 12:30 | Kevin Kline | Marketing Community Session (45 minutes) | Evolve | Introduction to PASS Summit 2017 |
| 01-11-2017 13:30 | Raj Pochiraju, Parikshit Savjani | MS Tiger Session (75 minutes) | Scale | Customer Successes Migrating On-Premise Workload to Azure SQL Database |
| 01-11-2017 13:30 | Julie Strauss, Bill Gibson | Microsoft Session (75 minutes) | Build | Building and Managing SaaS Applications on SQL Database |
| 01-11-2017 13:30 | Jen Stirrup | General Session (75 minutes) | Build | Cloud & Hybrid Data Storage Roadmap for Business Intelligence |
| 01-11-2017 13:30 | André Melancia | General Session (75 minutes) | Support | Hacking SQL Server |
| 01-11-2017 13:30 | Drew Furgiuele | General Session (75 minutes) | Build | SQL Server and PowerShell: Let's Get Serious |
| 01-11-2017 13:30 | Paul Andrew | General Session (75 minutes) | Design | Working with Azure Data Factory & Creating Custom Activities |
| 01-11-2017 13:30 | Gabriel Villa | General Session (75 minutes) | Design | Know Your Options: Databases on Amazon Web Services |
| 01-11-2017 13:30 | Joseph D'Antoni | General Session (75 minutes) | Design | Storage for the DBA |
| 01-11-2017 13:30 | Steve Jones | Partner Session (75 minutes) | Build | Adopting A DevOps Process for Your Database |
| 01-11-2017 13:30 | Ramkumar Krishnan, Naveen Vig | Microsoft Session (75 minutes) | Build | Technical Reference Implementation for Enterprise BI & Reporting in Azure |
| 01-11-2017 13:30 | Mindy Curnutt | General Session (75 minutes) | Evolve | Imposter Syndrome - Sometimes Feel Like a Fraud? Welcome to the Club! |
| 01-11-2017 13:30 | Rajnikant Tandel, Anup Gopinathan | Partner Session (75 minutes) | Perform | Optimize SQL Server: Become a Query Tuning Master |
| 01-11-2017 13:30 | David Maxwell | General Session (75 minutes) | Perform | Targeting Wait Statistics with Extended Events and DMVs |
| 01-11-2017 13:30 | Erin Stellato | General Session (75 minutes) | Perform | Query Store and Automatic Tuning in SQL Server |
| 01-11-2017 13:30 | Josh Caplan, Bret Grinslade | Microsoft Session (75 minutes) | Analyze | Deliver Enterprise BI on Big Data |
| 01-11-2017 13:30 | Patrick LeBlanc, Adam Saxton | General Session (75 minutes) | Analyze | Guy in a Cube Unplugged |
| 01-11-2017 15:15 | Gianluca Sartori | General Session (75 minutes) | Perform | Responding to Extended Events in Near Real-Time |
| 01-11-2017 15:15 | Bob Pusateri | General Session (75 minutes) | Perform | Locks, Blocks, and Snapshots: Maximizing Database Concurrency |
| 01-11-2017 15:15 | Matt Masson, Lukasz Pawlowski, Ali Hamud | Microsoft Session (75 minutes) | Build | Unlock the Power of your Data by Integrating Analytics into your Line-of-Business Apps |
| 01-11-2017 15:15 | Steve Jones, Grant Fritchey, Richard Macaskill | Partner Session (75 minutes) | Build | How DevOps for the Database Helps with Compliance |
| 01-11-2017 15:15 | Lindsey Allen, Jovan Popovic | Microsoft Session (75 minutes) | Build | Modernize Your On-premises Applications with SQL Database Managed Instances |
| 01-11-2017 15:15 | Thomas LaRock | General Session (75 minutes) | Build | SQL Server Audit |
| 01-11-2017 15:15 | Jeremy Likness | General Session (75 minutes) | Build | Build APIs Confidently with Swagger |
| 01-11-2017 15:15 | Kevin Kline | General Session (75 minutes) | Evolve | Pitch Perfect - Presenting Ideas That Win Executive Support |
| 01-11-2017 15:15 | Glenn Berry | Half-Day Session (2.5 hours) | Perform | Migrating to SQL Server 2017 |
| 01-11-2017 15:15 | Carlos Bossy | General Session (75 minutes) | Design | Implement a Complete Business Intelligence Solution in the Cloud |
| 01-11-2017 15:15 | Dejan Sarka | Half-Day Session (2.5 hours) | Analyze | Embrace R |
| 01-11-2017 15:15 | Bob Ward | MS Tiger Half-Day Session (2.5 hours) | Build | Inside SQL Server 2017 on Linux |
| 01-11-2017 15:15 | Joe Sack, Pedro Lopes | MS Tiger Session (75 minutes) | Support | SQL Server 2017: "Intelligence: Meet Database" |
| 01-11-2017 15:15 | Denny Lee | Microsoft Session (75 minutes) | Scale | Azure Cosmos DB: The Globally Distributed, Multi-model Database |
| 01-11-2017 15:15 | Eugene Meidinger | General Session (75 minutes) | Support | Execution Plans 101 |
| 01-11-2017 15:15 | Ike Ellis | General Session (75 minutes) | Build | Dive in to the Azure Data Lake |
| 01-11-2017 16:45 | Paul Turley, Chris Webb, Meagan Longoria, Ginger Grant, Mico Yuk | General Session (75 minutes) | Design | Data Visualization - A Panel Discussion |
| 01-11-2017 16:45 | Oliver Engels, Tillmann Eitelberg | General Session (75 minutes) | Design | Take P, R or U and Solve your Data Quality Problems |
| 01-11-2017 16:45 | Walt Ritscher | General Session (75 minutes) | Analyze | From Dull to Dazzling: How Visualization Enhances Data Comprehension |
| 01-11-2017 16:45 | John Martin | Partner Session (75 minutes) | Support | Using PowerShell to Send Notifications with SentryOne |
| 01-11-2017 16:45 | Joe Yong, Shivani Gupta | Microsoft Session (75 minutes) | Perform | Getting Peak Performance from your SQL Data Warehouse Column Store |
| 01-11-2017 16:45 | Niko Neugebauer, Gabi Münster | General Session (75 minutes) | Design | Columnstore Killed the OLAP-Star: Did it Really? |
| 01-11-2017 16:45 | Keith Tate | General Session (75 minutes) | Support | Profiler is Dead! Long Live Extended Events! |
| 01-11-2017 16:45 | Bill Graziano | General Session (75 minutes) | Support | Preparing to be Hacked |
| 01-11-2017 16:45 | Ust Oldfield | General Session (75 minutes) | Build | A Deep Dive into Data Lakes |
| 01-11-2017 16:45 | Thomas LaRock | General Session (75 minutes) | Evolve | Speaker Idol: Round 1 |
| 01-11-2017 16:45 | Jordan Goldmeier | General Session (75 minutes) | Innovate | Data Science for Social Good: Challenges & Successes |
| 01-11-2017 16:45 | Steve Wake | General Session (75 minutes) | Build | Make Power BI Your Own with the Power BI APIs |
| 01-11-2017 16:45 | Scott Currie | General Session (75 minutes) | Build | BimlCatalog: Your Open Source Runtime and Orchestration Solution for Biml Projects |
| 02-11-2017 06:45 | Jimmy Wong | Sponsor Breakfast | Build | Deep Dive into SSIS 2017 and Beyond |
| 02-11-2017 06:45 | Denny Cherry, Joseph D'Antoni, David Klee, Geoff Hiten | Sponsor Breakfast | Perform | Tales from the Field: SQL Server Experts Share Key Lessons Learned About Fixing SQL Server Performance Issues |
| 02-11-2017 06:55 | Bryan Walsh, Doug Bernhardt | Sponsor Breakfast | Innovate | Breakfast with Dell EMC Storage Solutions |
| 02-11-2017 08:15 | Rimma Nehme | Keynote (90 minutes) | Innovate | Globally Distributed Databases Made Simple |
| 02-11-2017 10:15 | Jens Vestergaard | General Session (75 minutes) | Build | BI DevOps |
| 02-11-2017 10:15 | Arvind Shyamsundar, Bob Albright, Subhra Bose | Microsoft Session (75 minutes) | Analyze | Real-world SQL Server R Services |
| 02-11-2017 10:15 | Samir Behara | General Session (75 minutes) | Build | Making Developers Lives Easier with SQL Server 2016 |
| 02-11-2017 10:15 | Jen Stirrup | General Session (75 minutes) | Analyze | Lighting up Big Data Analytics with Apache Spark in Azure |
| 02-11-2017 10:15 | James Rowland-Jones | Microsoft Session (75 minutes) | Scale | Dining on Data: Consume and Query Petabytes of Data with Azure SQL Data Warehouse |
| 02-11-2017 10:15 | Jovan Popovic | Microsoft Session (75 minutes) | Support | How Can Intelligent Azure SQL Database Improve the Performance of your Application? |
| 02-11-2017 10:15 | Melody Zacharias | General Session (75 minutes) | Design | Introduction to Cortana – Turning Data into Intelligent Action |
| 02-11-2017 10:15 | Mike Walsh | General Session (75 minutes) | Build | Azure SQL Databases: A Guided Tour |
| 02-11-2017 10:15 | Aaron Nelson, Ben Miller, Chrissy LeMaire, Rob Sewell, Ken Van Hyning | General Session (75 minutes) | Support | All About PowerShell - A Panel Discussion |
| 02-11-2017 10:15 | Sean McCown | General Session (75 minutes) | Support | Monster Text Manipulation: Regular Expressions for the DBA |
| 02-11-2017 10:15 | Alex Andrushchenko | MS Tiger Session (75 minutes) | Perform | Comprehensive Guide for Monitoring SQL Server and Azure SQL DB |
| 02-11-2017 10:45 | Andy Yun | General Session (75 minutes) | Perform | Exploring Why UDFs and Nested Views Hinder the Query Optimizer |
| 02-11-2017 10:45 | Paul Turley | General Session (75 minutes) | Design | Your Complete BI Toolbelt: Using Power BI, Excel & SSRS Together to Create Integrated BI Solutions |
| 02-11-2017 10:45 | Lord Richard Douglas | General Session (75 minutes) | Support | Understanding the Transaction Log For Faster Throughput |
| 02-11-2017 10:45 | Allan Hirt | General Session (75 minutes) | Build | Linux Clustering for the SQL Server DBA |
| 02-11-2017 10:45 | Denis Dubeau | Partner Session (75 minutes) | Scale | Best Practices -- AtScale on HDI using PowerBI |
| 02-11-2017 12:15 | Heather Ritchie | Luncheon (60 minutes) | Evolve | Women in Technology Luncheon |
| 02-11-2017 12:30 | Cathrine Wilhelmsen | Marketing Community Session (45 minutes) | Evolve | Advance Your Career by Becoming a Volunteer |
| 02-11-2017 13:30 | Kevin Farlee | Microsoft Session (75 minutes) | Perform | Delivering High Performance Analytics with Columnstore Index on Traditional DW and HTAP Workloads |
| 02-11-2017 13:30 | Jennifer McCown, Melody Zacharias, Kathi Kellenberger, Mindy Curnutt, Meagan Longoria, Rie Irish, Cathrine Wilhelmsen | General Session (75 minutes) | Evolve | Women's Voices from the Data Platform |
| 02-11-2017 13:30 | Pedro Lopes | MS Tiger Session (75 minutes) | Perform | From Zero to Hero: Troubleshooting SQL Server Performance Made Easier |
| 02-11-2017 13:30 | Jens Vestergaard | General Session (75 minutes) | Build | Windows 10 IoT Core, Raspberry PI & Azure IoT |
| 02-11-2017 13:30 | Patrick O'Keeffe, Peter O'Connell | Partner Session (75 minutes) | Evolve | Is the DBA Dead?... or Alive (and Preparing for the Future)? |
| 02-11-2017 13:30 | Ajay Jagannathan, Sourabh Agarwal | MS Tiger Session (75 minutes) | Design | Real-Time Business Insights Using SQL Server 2016 Distributed Availability Groups |
| 02-11-2017 13:30 | Denny Lee | Microsoft Session (75 minutes) | Build | Real-time Data Science with Azure Cosmos DB |
| 02-11-2017 13:30 | Karen Lopez | General Session (75 minutes) | Design | Data Modeling and Design for New Features in SQL Server and Cosmos DB |
| 02-11-2017 13:30 | Grant Fritchey | General Session (75 minutes) | Support | Using Powershell to Manage Your Azure Databases |
| 02-11-2017 13:30 | Joseph D'Antoni | General Session (75 minutes) | Support | Linux for the SQL Server DBA—Getting Started with a New OS |
| 02-11-2017 13:30 | Terry McCann | General Session (75 minutes) | Design | Enhancing Relational Models with Graph Processing in SQL Server |
| 02-11-2017 13:30 | Patrick LeBlanc, Ryan Wade | General Session (75 minutes) | Perform | Should You Use M or R for Data Wrangling in Power BI? It Depends. |
| 02-11-2017 13:30 | Miguel Llopis, Robert Bruckner | Microsoft Session (75 minutes) | Build | Keeping Your On-premises Data Up-to-Date with On-premises Gateway |
| 02-11-2017 13:30 | Markus Ehrenmueller-Jensen | General Session (75 minutes) | Analyze | Create Stunning Visualizations with the Help of R |
| 02-11-2017 13:30 | Tobias Ternstrom, Travis Wright | Microsoft Session (75 minutes) | Build | Microsoft SQL Server 2017 Deep Dive |
| 02-11-2017 13:30 | Brad Llewellyn | General Session (75 minutes) | Analyze | Azure Machine Learning: Making Data Science Easy(er) |
| 02-11-2017 15:15 | Adam Jorgensen | General Session (75 minutes) | Innovate | Data Driven Digital Transformation |
| 02-11-2017 15:15 | Chris Finlan | Microsoft Session (75 minutes) | Design | Power BI Report Server: Self Service BI & Enterprise Reporting On-Premises |
| 02-11-2017 15:15 | Thomas LeBlanc | General Session (75 minutes) | Build | Data Mining in Analysis Services (2005, 2008, 2012, 2014 & 2016) |
| 02-11-2017 15:15 | Carlos Bossy | General Session (75 minutes) | Analyze | Data Science Tips and Tricks using R and SQL |
| 02-11-2017 15:15 | Bob Ward | MS Tiger Session (75 minutes) | Build | Experience SQL Server 2017: The Fast and the Furious |
| 02-11-2017 15:15 | Michael Rys | Microsoft Session (75 minutes) | Build | Modernizing ETL with Azure Data Lake: Hyperscale, Multi-format, Multi-platform, and Intelligent |
| 02-11-2017 15:15 | Eric Kang, Sanjay Nagamangalam, Ken Van Hyning | Microsoft Session (75 minutes) | Support | DevOps with SQL Server 2017 |
| 02-11-2017 15:15 | Jason Horner | General Session (75 minutes) | Build | Trying on the Glass Slipper: Is Azure SQL Data Warehouse Right for You? |
| 02-11-2017 15:15 | Adam Wilson | Microsoft Session (75 minutes) | Scale | Enterprise BI Deployments and Governance with the Power BI Service |
| 02-11-2017 15:15 | Thomas LaRock | General Session (75 minutes) | Evolve | Speaker Idol: Round 2 |
| 02-11-2017 15:15 | Dmitri Korotkevitch | Half-Day Session (2.5 hours) | Design | Everything You Always Wanted to Know about Data Partitioning but Were Afraid to Ask |
| 02-11-2017 15:15 | Ike Ellis | General Session (75 minutes) | Build | Best Practices for SQL Developers |
| 02-11-2017 15:15 | Steve Stedman | General Session (75 minutes) | Support | Basics of Database Corruption Repair |
| 02-11-2017 15:15 | Reza Rad | General Session (75 minutes) | Scale | Ultimate Security and Sharing in Power BI |
| 02-11-2017 15:15 | Kathi Kellenberger | Half-Day Session (2.5 hours) | Build | Indexing Deep Dive for Beginners |
| 02-11-2017 15:15 | Ben Miller | Half-Day Session (2.5 hours) | Perform | Tips and Tricks for the PowerShell DBA |
| 02-11-2017 16:45 | Raj Pochiraju | Microsoft Session (75 minutes) | Scale | Migrating to Azure: Moving from On-premises SQL Server and Oracle Databases to Azure SQL Database |
| 02-11-2017 16:45 | Kevin Kline | General Session (75 minutes) | Perform | Secrets of the Query Optimizer Revealed Using Trace Flag 86xx |
| 02-11-2017 16:45 | Julie Koesmarno, Tobias Ternstrom, Lindsey Allen, John Macintyre | Microsoft Session (75 minutes) | Design | UNPLUGGED: SQL Server and Azure SQL Services |
| 02-11-2017 16:45 | Melissa Coates | General Session (75 minutes) | Build | Tips for Getting Started with the Azure Data Platform |
| 02-11-2017 16:45 | Tracy Boggiano | General Session (75 minutes) | Support | Beyond The Install: Monitoring Availability Groups |
| 02-11-2017 16:45 | Victor Isakov | General Session (75 minutes) | Design | Business Case for Deploying SQL Server on Linux |
| 02-11-2017 16:45 | Reeves Smith | General Session (75 minutes) | Analyze | Data Science for the SQL Server Professional |
| 02-11-2017 16:45 | Miguel Llopis, Will Thompson | Microsoft Session (75 minutes) | Analyze | Effective Report Authoring Using Power BI Desktop |
| 02-11-2017 16:45 | Meagan Longoria | General Session (75 minutes) | Build | Transitioning from Integration Services to Azure Data Factory |
| 02-11-2017 16:45 | Ed Leighton-Dick | General Session (75 minutes) | Support | Three Steps to Lasting Encryption |
| 02-11-2017 16:45 | Eddie Wuerch, Erin Stellato, Mark Simms, Argenis Fernandez, David Klee | General Session (75 minutes) | Scale | Data Systems at Scale - A Panel Discussion |
| 02-11-2017 16:45 | Glenn Berry | General Session (75 minutes) | Perform | Improving SQL Server Performance |
| 03-11-2017 08:00 | Chris Hyde | General Session (75 minutes) | Analyze | Python In SQL Server 2017 |
| 03-11-2017 08:00 | Ed Leighton-Dick | General Session (75 minutes) | Support | How to Keep Your Databases Secure in Just Minutes a Day |
| 03-11-2017 08:00 | Chris Webb | General Session (75 minutes) | Analyze | Using Analysis Services Multidimensional as a Data Source for Power BI |
| 03-11-2017 08:00 | Aaron Cutshall | General Session (75 minutes) | Design | "There Be Whales Here!" -- Big Data in SQL Server |
| 03-11-2017 08:00 | Anthony Nocentino | General Session (75 minutes) | Perform | Monitoring Linux Performance for the SQL Server Admin |
| 03-11-2017 08:00 | Kendra Little | General Session (75 minutes) | Perform | When Partitioning Indexes Hurts Performance (and How to Fix It) |
| 03-11-2017 08:00 | Vern Rabe | General Session (75 minutes) | Build | Proper DataType Usage=Guaranteed Better Performance and Accuracy |
| 03-11-2017 08:00 | Marco Russo | General Session (75 minutes) | Design | DAX Best Practices |
| 03-11-2017 08:00 | Pedro Lopes, Parikshit Savjani | MS Tiger Session (75 minutes) | Scale | Upgrade to SQL Server 2017: Intelligent Diagnostics Just Built-in |
| 03-11-2017 08:00 | Stuart Moore | General Session (75 minutes) | Design | Get on the Azure Service Bus |
| 03-11-2017 08:00 | Artur Kiulian | General Session (75 minutes) | Innovate | Future of Work: Human Assistance in the Intelligent Workplace |
| 03-11-2017 08:00 | Shabnam Watson | General Session (75 minutes) | Build | Build a Performance Monitoring Toolset for SSAS Using Power BI |
| 03-11-2017 08:00 | Peter Kral | General Session (75 minutes) | Build | SQL Server Integration Services Project Deployment: The T-SQL Way |
| 03-11-2017 08:00 | Mladen Prajdić | General Session (75 minutes) | Support | An End-to-End Approach to App and DB Security |
| 03-11-2017 08:00 | Lance Tidwell | General Session (75 minutes) | Perform | New Features in SQL That Will Change the Way You Tune |
| 03-11-2017 09:30 | Stijn Wynants | General Session (75 minutes) | Perform | Realtime Analytics: OLAP & OLTP in the mix! |
| 03-11-2017 09:30 | Brent Ozar | General Session (75 minutes) | Perform | "But It Worked in Development!" - 3 Hard Performance Problems |
| 03-11-2017 09:30 | Jimmy May | General Session (75 minutes) | Design | SQL Server 2016 Always On AGs: Perf, Internals, Lessons Learned |
| 03-11-2017 09:30 | Meagan Longoria, Marcelo Fernandes, Scott Gleason, Sander Stad, Paul Andrew, Constantine Kokkinos | Lightning Talks (75 minutes) | Innovate | Lightning Talks |
| 03-11-2017 09:30 | Rajnikant Tandel, Anup Gopinathan | Partner Session (75 minutes) | Perform | Optimize SQL Server: Become a Query Tuning Master |
| 03-11-2017 09:30 | Eddie Wuerch | General Session (75 minutes) | Evolve | Be the Next Great Speaker: The Complete Speaker Starter Kit |
| 03-11-2017 09:30 | Shawn Meyers, Rob Girard | General Session (75 minutes) | Perform | Deep Dive on pNUMA & vNUMA – Save Your SQL VMs from Certain DoomA |
| 03-11-2017 09:30 | Alberto Ferrari | General Session (75 minutes) | Analyze | DAX Optimization Examples |
| 03-11-2017 09:30 | Ronit Reger | Microsoft Session (75 minutes) | Design | Introducing the Newest Innovations in Advanced SQL Security |
| 03-11-2017 09:30 | Matt Martin | General Session (75 minutes) | Support | 5 Ways to Bypass or Ensure Security in SQL Server |
| 03-11-2017 09:30 | Denzil Ribeiro | Microsoft Session (75 minutes) | Perform | SQL Server on Linux: DBA Focused Lessons Learned from Early Deployments |
| 03-11-2017 09:30 | Kenneth Urena | General Session (75 minutes) | Build | Azure SQL VM: Implementing Multi-subnet Basic AG in SQL2016 STD |
| 03-11-2017 09:30 | Richard Waymire | General Session (75 minutes) | Scale | Amazon Web Services RDS SQL Server Overview |
| 03-11-2017 09:30 | Ben Miller | General Session (75 minutes) | Support | Gathering Trending Data with PowerShell |
| 03-11-2017 09:30 | Warner Chaves | General Session (75 minutes) | Build | Cosmos Db for the SQL Server DBA |
| 03-11-2017 09:30 | Thomas LeBlanc | General Session (75 minutes) | Build | Using Integration Services 2016 to Manage a Dimensional Model |
| 03-11-2017 11:00 | Jason Anderson | Microsoft Session (75 minutes) | Build | Introduction to Azure Database for MySQL and PostgreSQL |
| 03-11-2017 11:00 | Sunil Agarwal | MS Tiger Session (75 minutes) | Perform | Strategies to Speed Up Data Load into Clustered Columnstore Index |
| 03-11-2017 11:00 | Steve Stedman | General Session (75 minutes) | Support | Your Backup and Recovery Strategy |
| 03-11-2017 11:00 | Grant Fritchey, Chris Woodruff | General Session (75 minutes) | Evolve | Bridging the DBA and Developer Relationship |
| 03-11-2017 11:00 | Matt Gordon | General Session (75 minutes) | Build | Where Should My Data Live (and Why)? |
| 03-11-2017 11:00 | Wee Hyong Tok, Danielle Dean | Microsoft Session (75 minutes) | Scale | Using Big Data, the Cloud, and AI to Enable Intelligence at Scale |
| 03-11-2017 11:00 | Christian Wade, Bret Grinslade | Microsoft Session (75 minutes) | Design | Creating Enterprise Grade BI Models with Azure Analysis Services or SQL Server Analysis Services |
| 03-11-2017 11:00 | Robert Cain | General Session (75 minutes) | Build | Migrate Local SQL Server Databases to SQL Azure with PowerShell |
| 03-11-2017 11:00 | Vlad Vlasceanu | Partner Session (75 minutes) | Build | Best Practices for Deploying SQL Server on Amazon Web Services |
| 03-11-2017 11:00 | Patrick LeBlanc, William Wolf | General Session (75 minutes) | Perform | Who's on First? SQL Server statistics & Dynamic Power BI Visuals! |
| 03-11-2017 11:00 | Amit Banerjee | MS Tiger Session (75 minutes) | Analyze | Building One Million Predictions Per Second Using SQL-R |
| 03-11-2017 11:15 | Olivier Matrat, Marc Reguera | Microsoft Session (75 minutes) | Design | Power to the Masses: BI, Apps and Bots for the Rest of Us |
| 03-11-2017 11:15 | Tim Mitchell | General Session (75 minutes) | Build | SSIS and the Cloud: Yes, They Can Get Along |
| 03-11-2017 11:15 | Niko Neugebauer, Bob Ward, Kevin Farlee, Jos de Bruijn, Tejas Shah, Ned Otter | General Session (75 minutes) | Perform | In-Memory OLTP: A Panel Discussion |
| 03-11-2017 11:15 | Thomas LaRock | General Session (75 minutes) | Evolve | Speaker Idol: Round 3 |
| 03-11-2017 11:15 | André Kamman | General Session (75 minutes) | Perform | Azure SQL DW Guidance for ETL Developers |
| 03-11-2017 13:00 | Kevin Kline | Marketing Community Session (45 minutes) | Evolve | Staying Involved with PASS |
| 03-11-2017 14:00 | Andy Leonard | General Session (75 minutes) | Build | Use Biml to Automate SSIS Design Patterns |
| 03-11-2017 14:00 | Davide Mauri | General Session (75 minutes) | Perform | Dapper: The MicroORM That Will Change Your Life |
| 03-11-2017 14:00 | Hamish Watson | General Session (75 minutes) | Scale | ?Achieving Continuous Delivery for Your Database Using SSDT |
| 03-11-2017 14:00 | Wayne Sheffield | General Session (75 minutes) | Support | More Fundamentals for Your SQL Server Toolbox |
| 03-11-2017 14:00 | Ola Hallengren | General Session (75 minutes) | Perform | Performance Monitoring Using Extended Events, DMVs & Query Store |
| 03-11-2017 14:00 | Dean Furness | General Session (75 minutes) | Evolve | Take Each Day and Work on Making it Better |
| 03-11-2017 14:00 | Louis Davidson | General Session (75 minutes) | Support | Implementing Row Level Security in SQL Server |
| 03-11-2017 14:00 | William Durkin | Half-Day Session (2.5 hours) | Build | SQL Server Replication: A Deeper Look Under the Covers |
| 03-11-2017 14:00 | Steve Moss | General Session (75 minutes) | Design | Modern Data Modeling for Azure Data Lake and Azure SQL DW |
| 03-11-2017 14:00 | Eric Kang, Sanjay Nagamangalam, Kevin Cunnane | Microsoft Session (75 minutes) | Support | Avoid Common Database Development Pitfalls with SQL Server Data Tools and Visual Studio 2017 |
| 03-11-2017 14:00 | Jamey Johnston | General Session (75 minutes) | Analyze | Code Like a Snake Charmer - Intro to Python! |
| 03-11-2017 14:00 | Amy Herold | General Session (75 minutes) | Build | Database Server Templates in Azure Resource Manager |
| 03-11-2017 14:00 | Andy Yun | General Session (75 minutes) | Build | T-SQL Tips & Tricks to Make Your Life Easier! |
| 03-11-2017 14:00 | Cher Fox, Lynn Winterboer | Half-Day Session (2.5 hours) | Build | Behavior-Driven Development and Test Automation: Agile Enablement for DW and BI Teams |
| 03-11-2017 14:00 | Swagatika Sarangi | General Session (75 minutes) | Design | Master Data: Theory & Reality |
| 03-11-2017 15:30 | Jay Robinson | General Session (75 minutes) | Scale | Better Performance in the SqlClient Namespace |
| 03-11-2017 15:30 | Kellyn Pot'Vin-Gorman | General Session (75 minutes) | Perform | Oracle vs. SQL Server- The War of the Indices |
| 03-11-2017 15:30 | Eugene Meidinger | General Session (75 minutes) | Analyze | Introduction to M (a.k.a Power Query) |
| 03-11-2017 15:30 | Hugo Kornelis | General Session (75 minutes) | Design | Get Creative with Service Broker |
| 03-11-2017 15:30 | Maxim Lukiyanov | Microsoft Session (75 minutes) | Build | Building Modern Data Pipelines with Spark on Azure HDInsight |
| 03-11-2017 15:30 | Arvind Shyamsundar, Shreya Verma | Microsoft Session (75 minutes) | Build | Building a Graph Database Application with SQL Server 2017 and Azure SQL Database |
| 03-11-2017 15:30 | Bob Pusateri, David Klee | General Session (75 minutes) | Build | Linux Administration for the SQL Server DBA |
| 03-11-2017 15:30 | Gabriel Villa, Marc Beacom | General Session (75 minutes) | Design | Two Guys and a Transformation: ETL Best Practices and Techniques |
| 03-11-2017 15:30 | Kalen Delaney | General Session (75 minutes) | Build | Tuning In-Memory Indexes |
| 03-11-2017 15:30 | Carlos L Chacon | General Session (75 minutes) | Support | Measure Performance Through Baselines |
| 03-11-2017 15:30 | Gail Shaw | General Session (75 minutes) | Perform | Adaptive Query Plans? What’s Up With That? |
| 03-11-2017 15:30 | Thomas LaRock | General Session (75 minutes) | Evolve | Speaker Idol: Final Round |
| 03-11-2017 15:30 | Sourabh Agarwal | MS Tiger Session (75 minutes) | Perform | Effectively Troubleshooting Latency and Failover of Always On |
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
The options for achieving and increasing the reliability of SQL Server databases and instances as well as storing the associated data have changed in the past few years. Not only are the features and combinations for deploying SQL Server instances and databases greater than in the past, but as we move to a software defined world, achieving availability and performance is both easier and more difficult at the same time.
This full day pre-conference session will cover the latest SQL Server availability and storage solutions including how to plan, deploy, and administer them. Topics covered will include: <ul> <li>Distributed Availability Groups</li><li>Domain Independent Availability Groups</li><li>In-place WSFC upgrades</li><li>Scale Out File Server</li><li>Storage Spaces Direct</li><li>Storage Replica</li><li>SQL Server 2017 on Linux and its availability story</li><li>SQL Server features versus hardware and other things in the operating system or hypervisor</li><li>Tips, tricks, and gotchas for on premises virtualization, and public cloud deployments</li></ul>In addition to the instructional content, each student will gain hands on experience via lab scenarios using their own laptop connected to Web-based virtual machines where learning translates into action to bring a solution to life.
Whether you are looking to update your availability arsenal or catch up on what is new for availability and storage for SQL Server, this pre-conference will put you ahead of the curve to be able to take advantage of what features are offered today and what is coming tomorrow.
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Analyze
The methods used to create a data science solution are broken down into understandable sections, to make the concepts readily grasped and provide a structure to implement them in real-world environments. By first understanding the process, then building on that by learning methods for algorithm selection, solutions can be created and applied using Python, Azure ML, R or Power BI. As these tools and languages are not well known in the data community, each will be introduced to provide a basic understanding of each, as no prior data science knowledge is expected by session attendees.
Deploying data science solutions is a topic nearly as important as creating the solution itself as improperly deployed the solution cannot be successful. This course will also cover how to optimally configure a SQL Server 2016 or 2017 environment to run and monitor data science solutions in R and Python on SQL Server without adversely impacting other SQL Server operations. Learn how R and Python solutions can be deployed and what can be done to improve the solution performance. Visualization techniques in the solution will be explored so that attendees will know their options and the best tool for the job, which may be Power BI or SQL Server itself.
With the introduction of SQL Server 2017, there are an increasing number of different tools, including, R, Python, Azure ML, and Power BI, which can be used to implement data science solutions. This session explores how to determine the best tool for a given situation by revealing the strengths and weakness of each technology to provide attendees with the knowledge they will need for that evaluation in their unique environment.
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
This workshop starts with a review of popular open source APIs and addresses the difference between procedure-based, event-based, and data-based approaches. Understand approaches to API security including the popular JavaScript Web Token (JWT) standard, learn how to handle authorization for authenticated users, review common patterns for validating data and handling errors, and proactively tackle common enterprise challenges such as versioning endpoints.
See hands-on how APIs are built, implemented, and deployed leveraging modern tools like Visual Studio and the Microsoft Azure Cloud. Learn how to use Swagger to document API endpoints, how to manage legacy APIs using Azure API Management, and how to gain insights into the usage and health of endpoints.
Finally, leverage the power of building a client SDK to empower end users to quickly and easily connect to APIs with examples in .NET and Node.js.
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Perform
It’s time to stop reacting; it’s time to let Query Store help.
In this full-day workshop we’ll dive into the internals of Query Store and cover configuration; the data it captures; and how to use it analyze performance, find regressions, and force plans. The demos will teach you how to interrogate the data to find common patterns in query performance using T-SQL and visualization techniques, and how to take advantage of the wait statistics information captured. Finally, we will end the day working with the Automatic Tuning feature in SQL Server 2017, so you can see how to free up your time for other tasks. You'll leave this class with the skills to find and leverage important information in Query Store to make query tuning easier.
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.
As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations.
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
This full-day pre-con introduces the basic techniques of shaping data models in Power BI. We’ll assess real-world examples that will help you look at your reports in a different way, and show you that with the right data model, the correct answer is always a simple one!
In this workshop, you will learn how to: <ul> <li>Define business model entities and measures (dimensions and facts)</li><li>Properly model header/details structures</li><li>Use multiple fact tables, like sales and purchases, in a complex data model</li><li>Manage calendar-related calculations using the proper date tables </li><li>Track historical attributes, like previous addresses of customers or manager assignments</li><li>Use snapshots to compute quantity on hand</li></ul>
Event Date: 30-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Build
This seminar is dedicated to correct understanding of T-SQL querying fundamentals. You will learn about logical query processing—probably the most critical aspect of T-SQL that any T-SQL practitioner should master. It explains how queries are interpreted, and how to write T-SQL code with the correct mindset. The seminar also covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators. With each of the topics there’s also a section covering several trickier aspects that are beyond the fundamentals. The seminar also covers some of the newest additions to T-SQL in SQL Server 2016 and 2017 like DROP IF EXISTS, CREATE OR ALTER, CMINE, TRIM, STRING_SPLIT, STRING_AGG, DATEDIFF_BIG, AT TIME ZONE, temporal tables and SQL Graph. If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions.
Know your T-SQL querying fundamentals well, and then tackling advanced challenges will be so much easier.
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
This session covers: <ul> <li>What’s new in Reporting Services 2017 (and 2016)?</li><li>Reporting Services and Power BI Report Server Architecture</li><li>Parameter improvements</li><li>Overview of report solution design general best practices</li><li>Integrating and managing Power BI on-premises</li><li>Integrating SSRS with the Power BI service</li><li>Graphical report design</li><li>Visualization choices</li><li>Chart visual types and new visual options</li><li>Indicators and sparklines</li><li>Creating dashboard reports</li><li>Advanced and analytic reporting</li><li>Advanced design techniques</li><li>Conditional visibility & drill-down</li><li>Pagination & flow control</li><li>Error management</li><li>Drill-through navigation</li><li>Query design beyond the basics</li><li>Reporting with SQL Server and Analysis Services</li><li>Using the DAX and MDX query editors</li><li>Analytical and Business intelligence reporting</li><li>Managing report projects and consolidating reports</li><li>Upgrading from prior versions of SSRS</li><li>Framing and integrating reports the easy way</li><li>Introducing Mobile Reports</li><li>Multi-device mobile reporting, business cases & scenarios</li><li>Visual control categories & behavior</li><li>Mobile reports and parameters</li><li>Filtering an navigating mobile reports</li><li>Building mobile report solutions</li><li>Mobile drillthrough – targeting mobile reports and paginated reports</li><li>Content management</li><li>Managing the web portal</li><li>SSRS and Power BI Report Server administration</li><li>Custom branding</li><li>Instance caching</li><li>Server management and configuration</li></ul>
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
Topics covered include:<ul> <li>The basic concepts of loading data in the Query Editor: queries and steps</li><li>A guided tour of the data sources that you can connect to</li><li>Transforming data using the Query Editor user interface</li><li>Working with multiple queries: duplicating, referencing, merging and appending</li><li>Introduction to the M language for writing expressions and queries</li><li>Creating and using parameters</li><li>Creating functions from parameterized queries and by writing M code, and using them to apply the same business logic to multiple data sources</li><li>Understanding data privacy levels and making sure queries can be refreshed in the On-Premises Gateway</li><li>Calling web services in M code</li><li>Creating custom data connectors in M</li></ul>
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Perform
Who Should Attend:<ul><li>Current SentryOne customers</li><li>Data professionals who are evaluating database performance solutions</li><li>Data professionals interested in general SQL Server performance tuning guidelines</li></ul> Find out more about the SentryOne Bootcamp <a href="http://info.sentryone.com/bootcamp">here</a>.
Sessions:
Keynote (30 Minutes) - 200 Greg Gonzalez, CEO
SentryOne Configuration (75 Minutes) - 300 Lori Edwards
SentryOne Advanced Alerting (60 minutes) - 400 Scott Fallen
The What, Why, and How of Collecting Telemetry Data (30 minutes) - 200 Melissa Coates
Get Your SQL Server in Shape (60 Minutes) - 300 Rich Douglas
Troubleshooting Query Performance Using Top SQL (60 minutes) - 400 John Martin
Interactive Demo (60 minutes) - 400 Group
Resource Forecasting with SentryOne (30 minutes) – 300 Fred Frost
Operation Debrief (45 minutes) - 300 SentryOne Team
Stick around for a beer and engage with the entire SentryOne team. This will be an open Q&A session, feedback opportunity, and chance to learn a few things we don't cover in the sessions. Enjoy a cold one on us and ask the burning questions you have about SentryOne or SQL Server.
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Perform
With a nod to each of the available SQL Server versions (2012, 2014, 2016, 2017 and the Azure SQLDB), this full day session focuses on practical solutions and applications of Columnstore Indexes and the Batch Execution Mode. We also review the limitations of both and learn how to solve some of those limitations.
Covering all available relational engines supporting Columnstore Indexes (including parts of the SQL DataWarehouse), this pre-conference will give you insight on why and when to use Columnstore Indexes, and when to take a step back and use a different type of technology.
Since November 2016 (and more specifically since Service Pack 1 for SQL Server 2016), Columnstore Indexes have been available for every Edition of SQL Server (including Express and Local editions). Join this workshop and become a part of the columnar revolution that is positively affecting database platforms around the world.
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Scale
You've heard a lot about PowerShell recently because a lot has changed. Now, you don't need to be a coder to get things done; you can lean on hundreds of community-created commands that solve many of the problems we all share.
In development and need a nightly refresh? Architecting and need to find duplicate indexes fast and easy? Putting on your BI hat and need quick importing and exporting of data? Join us and we'll supply a hands-on lab for your laptop where you can experience PowerShell’s realized potential, crafted by both Microsoft and the SQL community. Whether you need a prepackaged solution or the building blocks to roll your own fix, you will leave with awesome tools to manage your most annoying problems. And maybe - hopefully - you'll even be confident enough to contribute your own solutions to share with the community.
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Design
With all the hype around big data, many organizations continue to struggle with creating ‘useful and intelligent’ analytics that deliver true impact to their business. One of the easiest and most effective ways to do this is by using visual storyboards. Not only are they fun, but by implementing a formula for a four-part BI dashboard storyboard concept, you’ll learn how to focus 100% on business impact, while telling a ‘true’ story that will lead to more immediate action and informed decisions.
Whether you are a beginner or a dashboard veteran, this workshop will take you from understanding the fundamentals of storyboarding to applying more advanced techniques to enhance user understanding. By working in teams with your peers, you will get an opportunity to apply these techniques directly to various dashboards.
You will learn:<ul> <li>Why visual storytelling is more effective than traditional reporting in today’s data-rich world</li><li>The three most important elements 98% of dashboards are missing and how it is negatively affecting user adoption</li><li>How to create a simple, four-part visual storyboard on paper in minutes and not weeks</li><li>How to use smart context and visual cues to make visuals more intelligent and actionable</li><li>Learn your personal visual literacy score by taking a short quiz</li><li>Leave with steps on how to take your data visualization journey to the next level!</li></ul>
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Perform
Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out. You’ve heard things have gotten way better with 2016 and 2017, but you haven’t had the chance to dig into the new plan cache tools, DMVs, adaptive joins, and wait stats updates.
In one fun-filled day, Brent Ozar and Erik Darling will future-proof your tuning skills. You’ll learn our most in-depth techniques to tune SQL Server leveraging DMVs, query plans, sp_BlitzCache, and sp_BlitzFirst. You’ll find your server’s bottleneck, identify the right queries to tune, and understand why they're killing your server. If you bring a laptop with SQL Server 2016 and 120GB free space, you can follow along with us in the Stack Overflow database, too.
Along the way, we’ll give out great prizes for the best questions and run an end-of-day competition to win the best stuff. You’ll go back to the office with free scripts, great ideas, and even a plan to convince the business to upgrade to SQL Server 2016 or 2017 ASAP.
Can’t upgrade to 2016? We’ll even show you memory grant and compilation tracking tricks that work in newer service packs for 2012 and 2014.
This is not an introductory class: you should have 2-3 years of experience with SQL Server, reading execution plans, and working on making your queries go faster.
Event Date: 31-10-2017 08:30 - Category: Pre-Conference Session (Full Day) - Track: Perform
Intended Audience The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.
Course Topics The following topics will be addressed during the course:<ul> <li>The Physical Infrastructure Underneath the VM</li><li>Storage and SAN Concepts and Design</li><li>Virtualization and Infrastructure Fundamentals</li><li>The SQL Server Virtual Machine</li><li>Networking, Support, and Licensing</li><li>SQL Server Infrastructure in the Cloud</li><li>High Availability and Disaster Recovery and SQL Server</li><li>Performance Investigation and Tuning of the Entire Stack</li></ul> Course Objectives Upon completion of this course, attendees will be able to:<ul> <li>Understand key virtualization and cloud concepts</li><li>Determine the optimal infrastructure configuration for best performance</li><li>Construct a SQL Server virtual machine template with best practices for agility and performance</li><li>Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement</li><li>Identify and remediate common virtualized SQL Server performance killers</li><li>Understand proper virtualized capacity management techniques for long term management</li></ul> Prerequisites Attendees with the following experiences will benefit the most from this course:<ul> <li>Basic familiarity with the core components of a server</li><li>SQL Server installation and configuration</li><li>Exposure to SQL Server performance metric measurement and identification</li></ul> A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with virtualized SQL Server in their own environments.
Event Date: 31-10-2017 16:45 - Category: General Session (75 minutes) - Track: Evolve
Sponsored by Solarwinds
Event Date: 01-11-2017 06:55 - Category: Sponsor Breakfast - Track: Innovate
Event Date: 01-11-2017 07:00 - Category: Sponsor Breakfast - Track: Innovate
Event Date: 01-11-2017 08:15 - Category: Keynote (90 minutes) - Track: Innovate
Join Rohan Kumar, General Manager Database Systems Engineering, and the Database Systems Engineering team as they demonstrate the latest innovations from Microsoft across Data and AI.. Come celebrate the launch of SQL Server 2017 on Linux, Windows and Docker and see the features that will make your day-to-day job easier and more fun. We’ll also show you how you can leverage the latest capabilities in our Azure Data Services that build upon your existing SQL skillset to make your journey to the cloud the easiest of any data provider. See all the latest innovations in performance and security for Operational, Business Intelligence (BI) and Analytics workloads – on-premises and at cloud scale.
Event Date: 01-11-2017 10:15 - Category: MS Tiger Session (75 minutes) - Track: Build
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Build
This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets & their integrations with SSRS, SSIS, & SSAS.
By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly deploy hundreds of SSRS objects to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also be able to take care of some pesky ETL tasks, some by automating SSIS, and others using just plain old PowerShell.
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Support
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Perform
a. Baselining current performance b. How to identify the right candidates for In-Memory c. Generate sample production data d. Create simulated production workload e. Test & benchmark In-Memory performance with simulations f. Compare In-Memory performance with the baseline You will also learn about a verity of tools and techniques that can be used in your proof-of-concept.
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Evolve
Awareness and advocacy around employee mental health is crucial to maintaining an effective workforce. Research shows happy employees are more productive and less likely to leave their job. This talk is focused on reducing the stigma around mental illness and expanding education and awareness. Dr. Akullian will provide background in to mental health and illness, and review the mental health in tech research, including industry-specific burnout. Strategies for improving working conditions will be focused on an organizational and individual level. Founders and executives will walk away with concrete steps for improving mental health in the workplace. Individuals will learn indicators of mental health problems and how to best address them. Finally, participants will have the opportunity to ask questions in a Q&A session following the talk.
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Support
With a myriad tools for companies to choose from - open source, free, paid and enterprise level - there are decisions that can impact the level of quality and success rate of DevOps projects. This session discusses why you should choose certain tools, what tools work best together and how, even in siloed teams, these choices can create successful DevOps implementations. Examples of features, command line vs. user interface, and the skill needs of IT will all be discussed.
This session focuses on DevOps from the DBA point of view.
Event Date: 01-11-2017 10:15 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 01-11-2017 10:15 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 10:15 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 01-11-2017 10:45 - Category: General Session (75 minutes) - Track: Build
Event Date: 01-11-2017 10:45 - Category: Microsoft Session (75 minutes) - Track: Analyze
Event Date: 01-11-2017 10:45 - Category: Partner Session (75 minutes) - Track: Design
Additionally, while business users are heavily invested in getting the information they need to make decisions as quickly as possible, they seldom have the technical knowledge to ask for the “right data” for the decision the first time. Agile projects are designed for this challenge – start with what we know, build a prototype, socialize, adapt and refine. But, unfortunately, delays associated with traditional tools and projects, such as those relying on ETL tools, can further exasperate and ultimately drive business users to work around IT and start experimenting with their own BI tools.
Organizations are best served with a single, persistent, enterprise data repository (data warehouse) that will travel with the business as its evolves rather than short-sighted, decentralized development and desktop efforts. So how do we empower our skilled IT development teams to be more agile and deliver useful solutions to the business sooner? Automation can help teams greatly speed up agile project development and turn “time to value” into an asset when measuring the success of your IT organization.
In this session, you’ll learn how data warehouse automation can help IT teams to: • Speed up project delivery by leveraging flexible design and code patterns backed by metadata • Automatically generate documentation to aid support and reduce development backlog • Payback technical debt that is typically lost within agile projects
Come and learn how automating the design, development and ongoing operation of data warehouse projects is setting hundreds of IT organizations worldwide, large and small, in a stronger position to deliver to the business and make better use of their resources.
Event Date: 01-11-2017 10:45 - Category: General Session (75 minutes) - Track: Support
This session will include tons of demos to illustrate the concepts and raise more than one eyebrow. After this talk, you're probably going to want to have a chat with your Security team at work.
Event Date: 01-11-2017 10:45 - Category: General Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 12:30 - Category: Marketing Community Session (45 minutes) - Track: Evolve
Kevin Kline welcomes both our first-timers and seasoned veterans alike in this introduction to PASS Summit 2017. The session provides attendees with a general overview of the conference and related events.
Event Date: 01-11-2017 13:30 - Category: MS Tiger Session (75 minutes) - Track: Scale
Event Date: 01-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Build
We will cover the lambda architecture as a framework for your business intelligence data. You will learn about the options to store business intelligence data in your organisation. We will cover when to select data sources such as Hadoop, Azure Cosmos DB, Azure Data Lake, SQL Data Warehouse, Azure SQL Database, Azure blob storage, Table storage, Redis Cache, and Azure Database for MySQL. You will appreciate the 'why' as well as the 'what' in order to give you an in-depth understanding of the options to store your business intelligence data, whether you are thinking of a cloud architecture in Azure, a hybrid approach of on-premise and Azure, or specifically a on-premise environment.
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Support
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, RLS, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Build
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 13:30 - Category: Partner Session (75 minutes) - Track: Build
Event Date: 01-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Build
Today, a customer seeking to deploy an enterprise scale EDW application with the pre-requisite features such as security, scalability, availability, authentication/authorization etc; has a plethora of analytics, data, storage and compute options in Azure. This diversity of offerings presents challenges in picking the right components and architecture that are proven to be enterprise ready in capabilities and interoperability, and easy to implement as an end to end system, in a timely manner.
The Technical Reference Implementation (TRI) presented in this talk is deployable software that integrates a set of Data technologies that are well tested for enterprise requirements. The entire solution can be deployed in a few hours – as opposed to the current norm of weeks. This enables users to accelerate the build-out of their production grade applications.
The TRI packages various cloud components with associated job managers and monitors that orchestrate the interoperability between components, enable the end to end data pipeline flow, monitor all key operations, accommodating for the rough edges in the components. The deployment ships with all the relevant code and detailed documentation. This allows customers to focus on their main goal of running their enterprise-critical business applications at scale and efficiently in the cloud.
In this talk, we will explain the architecture and components of the TRI and its end to end operation from data ingestion, large scale data warehousing, BI and Reporting. We will complement the talk with the demo of the TRI.
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 01-11-2017 13:30 - Category: Partner Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Perform
In this session, we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016 or 2017. We'll review the different options for Query Store, look at the data collected (including wait stats!), check out how to force a plan, and dive into how you can leverage Automatic Plan Correction and reduce the time you spend on Severity 1 calls fighting fires. It’s time to embrace the future and learn how to make troubleshooting easier using the plethora of intelligent data natively captured in SQL Server and SQL Azure Database.
Co-presenter: Dejan Krakovic, a Senior Software Engineer from Microsoft who helped develop Query Store and originally implement it for those 2 million (!) user databases in SQL Azure.
Event Date: 01-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Analyze
Event Date: 01-11-2017 13:30 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Perform
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions. We will also offer a different approach to analyzing captured events, without shredding XML files.
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 01-11-2017 15:15 - Category: Partner Session (75 minutes) - Track: Build
In this session, Redgate shows how a DevOps approach to the database – including the automated provisioning, testing, deploying, monitoring and desensitizing of databases - is actually an essential component of compliance, not a barrier.
Event Date: 01-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
Attend this interactive session for an overview of SQL Server Audit, learn how to create and configure audits, and discuss the best ways to consume, centralize, and analyze audit logs.
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Evolve
This session will teach you many of the mistakes that IT pros make when pitching an idea and how to avoid those. We’ll also cover a tried-and-true workflow for IT pros that gets positive results when pitching ideas to management and executives. Don’t you want your next idea to be successfully implemented? Attend this session to learn the ropes!
Event Date: 01-11-2017 15:15 - Category: Half-Day Session (2.5 hours) - Track: Perform
This session will cover several different methods for migrating your data to SQL Server 2017 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that a complete data platform upgrade makes excellent sense from a business perspective.
You will also learn how to do effective capacity planning for the new environment to ensure that you have the best performance possible with a manageable SQL Server 2017 licensing cost.
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 15:15 - Category: Half-Day Session (2.5 hours) - Track: Analyze
You'll observe how to use R for intermediate level statistics, like bivariate associations, including correlations and analysis of variance. You'll also learn to create some popular linear models. Focus on advanced machine learning, beginning with undirected algorithms, including principal component analysis, factor analysis, and clustering. And learn to create directed models for classification, using logistic regression and different version of decision trees. Demos will build upon each other to show a practical process of measuring and improving models. Session attendees should already have basic exposure to the R language and R support in SQL Server.
Event Date: 01-11-2017 15:15 - Category: MS Tiger Half-Day Session (2.5 hours) - Track: Build
Event Date: 01-11-2017 15:15 - Category: MS Tiger Session (75 minutes) - Track: Support
Event Date: 01-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Support
In this session, we will show you how to access execution plans and read them. Then we will dive into real examples and explain what each of them means and how it impacts performance. We will cover all of the most common operators in execution plans. These examples apply to any version of SQL. By the end of this talk, you'll feel comfortable getting started with execution plans.
Event Date: 01-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
Azure Data Lake Store allows storing of massive data without setting up name nodes, worrying about partitioning, or wondering how much space you’ll eventually need. Pay for what you use, use what you pay for. It also exposes a Hadoop compatible API, so you can use popular products on the data stored there. In this session, we’ll see how we can use Storm and Hive over data in ADLS.
Azure Data Lake Analytics allows us to write analytics jobs using a combination of SQL and C#. Want to see a SQL script with a C# code behind file? Want to see how you can choose your degree of parallelism for each individual job run (think MAXDOP but for ADLA)? Want to see how you can apply your SQL Server Optimizer skills to ADLA? This session will show how you can harness the power of C# with the inherent parallelism of SQL.
Finally, we’ll discuss real world examples of how the product can be implemented and optimized. Bring the power of big analytics to your organization with little overhead.
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Design
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Design
In a demo driven presentation, we show what libraries you can use to build score matrices, to build standardization processes, to do deduplication in ADLA or to build a Data Quality Dashboard in Power BI. There are a lot of fantastic functionalities in the Microsoft Data Platform to curate data. You need just to know how...
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 01-11-2017 16:45 - Category: Partner Session (75 minutes) - Track: Support
We will look at how to use PowerShell to interact with web services and pass information to a service with a cmdlet. As well as how it is possible to interact with other services. And then how we can integrate SentryOne Alert output into external services by using PowerShell condition actions.
Event Date: 01-11-2017 16:45 - Category: Microsoft Session (75 minutes) - Track: Perform
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Design
And maybe you will discover new approaches for your own challenges.
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Support
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events. Profiler was a friend of mine, but it is time to embrace the new king!
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Support
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Build
First of all exploring: Azure Data Lake Store: How is data stored? What are the best practices?; Azure Data Lake Analytics: How does the query optimiser work? What are the best practices?
Second, a practical demonstration of: Tuning U-SQL: Partitioning and distribution: Job Execution in Visual Studio
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Innovate
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Build
Event Date: 01-11-2017 16:45 - Category: General Session (75 minutes) - Track: Build
Before you release it into the wild, you will need to extend the default auditing and logging behavior of SSIS to capture meaningful audit and debug information. Of course, you can invest tremendous time and effort to build your own, but why not just reuse our free open source framework with provided BimlCatalog database, custom components, documentation, and extensive Biml samples?
This framework is robust and able to restart from the last failure skipping already loaded packages. As an example, if one of your 50 parallelized table load packages fails, the following execution will skip the packages that succeeded and resume at the next package.
In this session, you will learn how to integrate the framework into your solution and learn how to include: <ul><li>Row Counts</li><li>Row Errors</li><li>Persist Variables and Parameters</li><li>Package and Task Execution Duration</li><li>Package and Task Execution Errors</li></ul>
This session and the accompanying code will provide you with everything you need to easily implement and maintain this orchestration framework in your own solution for free.
Event Date: 02-11-2017 06:45 - Category: Sponsor Breakfast - Track: Build
Event Date: 02-11-2017 06:45 - Category: Sponsor Breakfast - Track: Perform
Event Date: 02-11-2017 06:55 - Category: Sponsor Breakfast - Track: Innovate
Event Date: 02-11-2017 08:15 - Category: Keynote (90 minutes) - Track: Innovate
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Build
Focus in this session will mainly be delivered on processes around SSAS, SSIS and SSRS and we will also briefly touch on Continuous Delivery for the underlying Data Warehouse.
Come join this session, if you are ready to take the first few steps towards automation of your deployment processes and want to know how Microsoft tools can help you.
Event Date: 02-11-2017 10:15 - Category: Microsoft Session (75 minutes) - Track: Analyze
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Build
Are you using JSON as your data interchange format and want to integrate with SQL Server? Do you wish to have more statistical/historical information while troubleshooting a T-SQL performance issue? Do you face any problem while troubleshooting a long running query? Have you encountered performance issues after server/application upgrades?
If your answer to any of the above questions is YES, then this session is for YOU.
During this content rich and demo intensive session, you will understand the rich capabilities of SQL Server 2016 and how the life of a SQL Developer is getting transformed with features like Query Store, Live Query Statistics, Comparing Execution Plans, Built-in JSON Support, Temporal Database and other nice T-SQL enhancements.
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Analyze
For the Business Intelligence professional, how can you introduce Open Source for analytics into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?
We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Apache Spark as our backdrop to delivering open source Big Data analytics.
Join this session to learn more about open source with Azure for Business Intelligence.
Event Date: 02-11-2017 10:15 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 02-11-2017 10:15 - Category: Microsoft Session (75 minutes) - Track: Support
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Design
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Build
The goal is to take the mystery out, to show the capabilities and get you thinking about what going to the cloud could look like and what it can do for you and your company. I believe the future belongs to those who have this knowledge and know where to apply it.
This will be nearly PowerPoint free and we’ll log into my Azure Portal and build out an environment from scratch and learn as we go. We’ll migrate data from an “on-premises” database into our SQL DB and we’ll query it. You’ll leave with an understanding of the capabilities, some resource links outlining what we did and hopefully some curiosity to see what else is up there in the cloud as you start exploring.
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Support
Event Date: 02-11-2017 10:15 - Category: General Session (75 minutes) - Track: Support
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: 02-11-2017 10:15 - Category: MS Tiger Session (75 minutes) - Track: Perform
You will learn how to: <ul><li>Monitor MSSQL Server with SCOM, OMS SQL BP Analyzer</li><li>Configure SCOM to monitor on premise SQL Server and Azure SQL DB</li><li>Use SCOM to monitor SQL Server on Linux</li></ul>
Event Date: 02-11-2017 10:45 - Category: General Session (75 minutes) - Track: Perform
In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that will aid you in unraveling nested code.
Event Date: 02-11-2017 10:45 - Category: General Session (75 minutes) - Track: Design
Event Date: 02-11-2017 10:45 - Category: General Session (75 minutes) - Track: Support
There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. From understanding the internals we can design for faster recovery and batch processes and ironically a smaller transaction log!
Event Date: 02-11-2017 10:45 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 10:45 - Category: Partner Session (75 minutes) - Track: Scale
Join this this session to learn…
Attendees of this session will be shown how to use the free evaluation kit on the Azure Marketplace.
Event Date: 02-11-2017 12:15 - Category: Luncheon (60 minutes) - Track: Evolve
Doors open at 11:30 AM - Begins at 12:15 PM
Event Date: 02-11-2017 12:30 - Category: Marketing Community Session (45 minutes) - Track: Evolve
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: 02-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Perform
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 02-11-2017 13:30 - Category: MS Tiger Session (75 minutes) - Track: Perform
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 13:30 - Category: Partner Session (75 minutes) - Track: Evolve
This session will present real world statistics on the evolving role of the DBA, the concerns facing DBAs today and valuable insights on the DBAs path to career success. Learn how the megatrends of DevOps, Cloud, NoSQL, Big Data and more are affecting your role today and how they are likely to shape it into the future.
Join Quest’s Executive Director of Development, Patrick O’Keeffe and Senior Product Manager, Peter O’Connell to explore: <ul><li>What are top trends impacting DBAs today?</li><li>How do you compare with other DBAs in the industry</li><li>Are you a cost center or a value center?</li><li>How do DBA’s manage their evolving role while planning for the future</li><li>How to increase your value to the organization</li> </ul>
Event Date: 02-11-2017 13:30 - Category: MS Tiger Session (75 minutes) - Track: Design
Event Date: 02-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Design
In this session, we’ll look at: <ul><li>Why these features still need data models</li><li>How to prepare data models, logical and physical, for these target features</li><li>How these features change the data model/database design process</li><li>How tools support these new features (or don’t)</li><li>How to approach tuning for these non-relational features</li></ul>Finally, we end with 10 tips for working with non-relational features while still maintaining data model-driven database design.
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Support
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Support
<ul> <li>Managing disks</li><li>Monitoring processes and performance</li><li>Scheduling jobs</li></ul>You will learn the key commands and skills you need to manage your servers, and how SQL Server on Linux differs from the Windows platform. You will be introduced to the High Availability and Disaster Recovery options that are available to you on the Linux platform.
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Design
In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns do they solve and how does SQL Server compares with competitors. We will explore each of these based on real data shredded from IMDB.
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Perform
R is a very popular statistical programming language that has some powerful “data wrangling” capabilities. In this session Patrick Leblanc and Ryan Wade will explore several data wrangling task in Power BI using both M and R. We will compare the two and show when it is best to use one over the other.
Event Date: 02-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 02-11-2017 13:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 02-11-2017 13:30 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Innovate
Event Date: 02-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Design
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
After the data is formatted adequately for predictive modeling, we can start modeling and finding the best fit for examining forecasts and what if scenarios. SSAS provides models for clustering, neural networks, logistic and linear regression, decision tress and Naïve Bayes classifiers. We will not have time for all models, but be stepping through 2 or 3, you will leave with your brain firing on all cylinders about predicting data for your company or consulting firm.
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 02-11-2017 15:15 - Category: MS Tiger Session (75 minutes) - Track: Build
Event Date: 02-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 02-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Support
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 15:15 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 02-11-2017 15:15 - Category: Half-Day Session (2.5 hours) - Track: Design
This session will explain how to properly architect and implement data partitioning in your systems. You will learn the benefits and downsides of different data partitioning techniques and understand how to combine them together to get the most from the solution especially in the systems with the mixed workload.
You will see how data partitioning may help with the common tasks, such as implementation of the data purge with sliding window pattern; improving system availability and shorten the downtime with piecemeal restore; reducing index maintenance overhead; improving cardinality estimations on the large tables and several others.
Finally, the session will demonstrate how to address the issues that may arise with data partitioning and optimize queries against partitioned data.
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Support
Event Date: 02-11-2017 15:15 - Category: General Session (75 minutes) - Track: Scale
Event Date: 02-11-2017 15:15 - Category: Half-Day Session (2.5 hours) - Track: Build
Event Date: 02-11-2017 15:15 - Category: Half-Day Session (2.5 hours) - Track: Perform
Event Date: 02-11-2017 16:45 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Perform
First, we will examine using undocumented trace flags to look at the steps of parsing, binding, and query optimization. Second, we will show how SQL Server builds internal memo structures and it interrogates the heuristics of the optimizer search space. Finally, we will discuss a secret trace flag that gives the optimizer more time to produce alternative execution plans for queries that push the boundaries of extreme database processing.
Event Date: 02-11-2017 16:45 - Category: Microsoft Session (75 minutes) - Track: Design
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Support
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Design
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Analyze
Data professionals play a key role in the success of a data science project. With your overall knowledge of the data architecture within your enterprise, you are in an excellent position to help with the next advanced analytics project at your company. What are the additional skills needed to improve your role in the next data science project? Learn about the different parts of a data science project and how they relate to the skillset you already have.
This session will cover: <ul><li>Data Cleansing</li><li>Data Normalization/Discretization</li><li>Missing Values</li><li>Data Reduction</li><li>Model Integration</li></ul>
Event Date: 02-11-2017 16:45 - Category: Microsoft Session (75 minutes) - Track: Analyze
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Build
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Support
To keep your encryption at full strength, you need to add three practices to your regular maintenance schedule. First, backup your keys frequently and securely to ensure you can always retrieve the data you’ve encrypted. Second, rotate your keys regularly to limit your exposure due to a lost or compromised key. Third, add an encryption key management solution (like Azure Key Vault) to make managing large numbers of keys easier or to enable someone else to manage the keys. In this session, we’ll discuss how you can implement each of these practices in your own environment.
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Scale
Event Date: 02-11-2017 16:45 - Category: General Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Analyze
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and deliver maximum value to your Business Intelligence customers with the power of analytics!
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Support
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Analyze
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Design
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Perform
But some queries may get slower after you partition your tables: the SQL Server optimizer doesn’t always use indexes the same way after those indexes are partitioned into chunks.
This session teaches you to use execution plans to troubleshoot regressed queries using partitioned tables. You will learn what “non-aligned” indexes are, how to tell how many partitions a query is really using, and see options for TSQL and indexing changes to speed up your queries.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Build
In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Design
In this session, we will show several DAX formulas, taken from our experience as consultants and teachers, analyzing (very briefly) the performances and looking for errors, or for different ways of writing them. As you will see, writing good DAX means following some simple rules and, of course, understanding well how evaluation contexts work!
Event Date: 03-11-2017 08:00 - Category: MS Tiger Session (75 minutes) - Track: Scale
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Design
Azure Service Bus may be the solution you're looking for.
On-Premise Service Bus architectures have been around for a while, but setting one up, maintaining it, and scaling it have been a full time job in themselves. Now with Azure Service Bus, setting up requires just a few clicks, scaling takes a few more and maintenance is done for you.
We'll cover common design patterns, what Azure Service Bus can offer you, setting it up, configuring for performance and availability, and showing how your clients can interact with it.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Innovate
But how do machines make certain decisions? Even Google engineers are out of touch with how their algorithms work now thanks to the system’s complexity, which could prevent us from completely trusting AI. To clear up this issue Defense Advanced Research Projects Agency (DARPA) recently funded research to make new a kind of artificial intelligence algorithms that can properly explain themselves and their conclusions.
And what better way to know something than to ask directly? Conversation as a technology has been creeping its way into the picture for many years. It seems now we are finally reaching a state where it can become usable to some extent. This trend will set apart companies that are leveraging intelligent assistance from those that are still trying to better processes by simply hiring more humans.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Build
Join me in this session as I show you how to use Windows Perfmon, SQL Server Extended Events, SSAS Tabular and Power BI Desktop to build a performance monitoring tool for a SSAS server.
We will start by reviewing some of the SSAS performance metrics you can collect. Then we will learn how to use Windows Perfmon and SQL Server Extended Events to collect performance counters and query execution information from a server and store it in a SQL Server database. Next we will use SSAS to build a Tabular model from the information collected. Finally, we will use Power BI Desktop to present this information.
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Build
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 08:00 - Category: General Session (75 minutes) - Track: Perform
In this session we will explore these new features and how they can make your life easier. We will also look at some of the pitfalls and potential issues that can arise from these new features.
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Perform
We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are & how to maintain your columnstore indexes.
We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Perform
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they're very hard to detect in a development environment.
In a very fast-paced session, I'll show these three performance problems pop up under load. I won't be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you'll be able to recognize the symptoms when they strike, and I'll show you where to go to learn more.
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Design
Event Date: 03-11-2017 09:30 - Category: Lightning Talks (75 minutes) - Track: Innovate
Event Date: 03-11-2017 09:30 - Category: Partner Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Analyze
As you will see, most optimizations are the direct application of best practices, but the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.
Event Date: 03-11-2017 09:30 - Category: Microsoft Session (75 minutes) - Track: Design
We will demonstrate the new features in action and show a peak at where we expect to take these technologies going forward.
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 09:30 - Category: Microsoft Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Build
Basic Availability Groups enable Data Professionals to provide enterprise class Hight Availability solutions using SQL Server Standard Edition, which allows organizations to save money by providing High Availability (HA) for applications that require HA without paying for SQL Server Enterprise Edition features they do not need.
In this session, we will be covering: <ul> <li>Limitations on Basic Availability Groups</li><li>Components and steps necessary to configure a Basic AG for an Azure Virtual Machine (VM) running SQL Server 2016 and multi-subnet scenario</li><li>Advantages, components and steps to configure Windows Storage Spaces to improve IO throughput in a Azure VM running SQL Server 2016 SP1</li></ul>
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Scale
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Build
Cosmos offers different access APIs, consistency models and performance management models that are different from a classic relational database like SQL Server. However, the same principles that you already apply as a SQL Dba are as important as ever to build a Cosmos application that performs well, is cost efficient and resilient to failures.
In this session we will look at how Cosmos is different from a relational database, it's major features as a NoSQL cloud product and how you can apply your SQL Server experience to perform successful Cosmos deployments.
Event Date: 03-11-2017 09:30 - Category: General Session (75 minutes) - Track: Build
This session will go through some old and new features of Integration Service to help with loading data for Slowly Changing Dimensions as well as incremental loads for fact tables in a Dimensional Model. Data Quality Services was added in a previous version but it still a great end-user tool that can manage lookups for bad data from source systems. The SSISDB Catalog for Project deployment, management and reporting has been enhanced with a Package deployment mode everybody has been waiting for. The ability to extract column names when piping error rows is now available in 2016.
Take the jump with me to SQL Server Integration Services 2016 for modern data importing and cleansing.
Event Date: 03-11-2017 11:00 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 03-11-2017 11:00 - Category: MS Tiger Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 11:00 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 11:00 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 03-11-2017 11:00 - Category: General Session (75 minutes) - Track: Build
Event Date: 03-11-2017 11:00 - Category: Microsoft Session (75 minutes) - Track: Scale
Event Date: 03-11-2017 11:00 - Category: Microsoft Session (75 minutes) - Track: Design
Event Date: 03-11-2017 11:00 - Category: General Session (75 minutes) - Track: Build
In this session you'll be introduced to the PowerShell cmdlets for migrating to the Azure SQL infrastructure. You'll see how to:
Create resource groups Create Azure storage containers Package your SQL Database Upload your SQL Database to Azure Import your SQL Database into SQL Azure
By the end of this demo packed session you'll understand how to use PowerShell to migrate your SQL Databases to SQL Azure.
Event Date: 03-11-2017 11:00 - Category: Partner Session (75 minutes) - Track: Build
Event Date: 03-11-2017 11:00 - Category: General Session (75 minutes) - Track: Perform
The SQL Server optimizer uses distribution statistics when creating execution plans. Statistics are used to provide the optimizer with estimations for the best way to process the query and hopefully optimize performance.
Power BI is a powerful tool that has been released in the last few years that helps you visualize your information to help make informative decisions with rich visualization.
In this session, we will show you how SQL Server uses statistics to create the execution plan and Power BI to visualize that statistical distribution; with a TWIST. Roles will be reversed to show a dynamic and interactive learning experience helping users with two different concepts in one exciting session!
Event Date: 03-11-2017 11:00 - Category: MS Tiger Session (75 minutes) - Track: Analyze
Event Date: 03-11-2017 11:15 - Category: Microsoft Session (75 minutes) - Track: Design
Event Date: 03-11-2017 11:15 - Category: General Session (75 minutes) - Track: Build
In this session, we will cover how SQL Server Integration Services can play well with the cloud. We'll review and demonstrate how existing SSIS tasks and components can be used for cloud or hybrid load scenarios, and will walk through some of the newest tools built specifically for cloud endpoints. We will also discuss the role SSIS plays in the enterprise alongside other cloud data integration tools, including Azure Data Factory (ADF).
Event Date: 03-11-2017 11:15 - Category: General Session (75 minutes) - Track: Perform
This Q & A panel on In-Memory OLTP can resolve questions about difficulties you may encounter when migrating to In-Memory OLTP, as well as debunk myths, and bring clarity to common misconceptions.
This panel will provide a great opportunity to interact with community and Microsoft experts about In-Memory OLTP features, benefits, and usage scenarios.
Event Date: 03-11-2017 11:15 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 03-11-2017 11:15 - Category: General Session (75 minutes) - Track: Perform
Event Date: 03-11-2017 13:00 - Category: Marketing Community Session (45 minutes) - Track: Evolve
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Build
In this session, you will learn: <ul> <li>How to rapidly build multiple SSIS packages using Biml</li><li>How to apply different SSIS Design Patterns using Biml</li><li>How to automate SSIS Design Patterns using Biml</li></ul>
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Perform
Well, thanks to StackOverflow's Dapper, all these fights are finished. Dapper is a blazing fast microORM that allows developers to map SQL queries to classes automatically, leaving (and encouraging) the usage of stored procedures, parameterized statements and all the good stuff that SQL Server offers (JSON and TVP are supported too!) In this session I'll show how to use Dapper in your projects from the very basis to some more complex usages that will help you to create really fast applications without the burden of huge and complex ORMs. The days of Impedance Mismatch are finally over!
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Scale
Using SSDT we can achieve automation from code push to delivery of consistent published artifacts (or packages) when integrated with Continuous Delivery.
?The DEMO will showcase these processes and will include creating a consistent database model using SSDT, feature branching in source control and include running automated Continuous Integration build tests using SQL Server on Linux. Using Visual Studio Team Services for Continuous Delivery will achieve automated reliable deploys.
This session will also show how to utilize Infrastructure as Code using PowerShell, combined with Azure Resource Manager, to automate the deployment of a scalable SQL Server solution that is a hybrid database solution (on-premises and Azure SQL database).
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Support
In this session you will explore how SQL Server has made the data professional's job easier through the addition of new features and enhancements to some of the well-established features. This session will expose you to some of the new toys now available to you (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server.
Coming away from this session, you will have more tools to help showcase your rock-star skills back on the job.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Perform
Imagine a scenario where you are getting timeouts from a business critical application, the users are complaining, and you are trying to understand what is happening. You have data from XEvents, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems. We will look at common real-world problems, do the troubleshooting step by step, and visualize the data using PowerBI.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Evolve
Come listen to my story – perhaps you can learn to be average like me, and along the way learn how average can win every time.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 14:00 - Category: Half-Day Session (2.5 hours) - Track: Build
We will look at: <ul> <li>Considerations for topology choices in a replication deployment</li><li>How to keep replication running smoothly</li><li>How to identify internal performance issues in replicating data</li><li>How to approach schema modifications in a replicated database</li><li>Approaches for troubleshooting errors</li><li>Uses for replication in modern SQL Server environments</li></ul> You will leave this session with a deeper understanding of the internals of replication. You will also be confident in identifying and triaging issues connected with replication systems.
This session will cover features that are available in all versions of SQL Server from 2005 up to the latest and greatest release.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Design
This presentation will explore when the concepts of dimensional modeling are still relevant to give value to your Data Lake and Big Data solutions and then cover the reason why a modern DW on Azure SQL DW is still needed. It will conclude with some implementation details of a Modern DW on Azure SQL DW, that relate to modeling including how to maximize performance by minimizing Data Movement (Shuffle Move and PartitionMove operations).
Event Date: 03-11-2017 14:00 - Category: Microsoft Session (75 minutes) - Track: Support
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Analyze
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Build
In this session we will explore the use of JSON server templates and PowerShell to customize and create environments for all phases of the development life cycle. After this session you will be better equipped to keep up with the infrastructure needs that will keep development moving.
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Build
This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.
This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!
Event Date: 03-11-2017 14:00 - Category: Half-Day Session (2.5 hours) - Track: Build
This session will cover:<ul><li>Why test automation is important for agile DW/BI teams</li><li>Why DW/BI teams are not automating their tests today</li><li>The path to data-focused test automation</li><li>Using Behavior-Driven Development for clear specification and automatable tests</li><li>Where to start and what tests to automate first</li><li>Demo of a simple test automation tool that any DW/BI team can build and use</li></ul>
Event Date: 03-11-2017 14:00 - Category: General Session (75 minutes) - Track: Design
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Scale
In this session, we will address the performance of data access code through careful analysis of several features of the SqlClient namespace in the .NET Framework. We will explore how common approaches can appear to work sufficiently, yet mask underlying problems that can lead to overall application issues.
Selected topics include:
Following this session, attendees should be better prepared to develop scalable solutions that depend on the SqlClient namespace.
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Perform
Based off this use case, enhanced builds of more advanced index features and discussions of the advantages, reasons for the introduction and how it's effected the direction of each product, the DBAs who are responsible for them and resources.
Takeaways are:
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Analyze
In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Design
In this session, after a quick introduction of Service Broker’s key components, you will see some real world solutions involving Service Broker. Minimum impact adaptation of 3rd party products? Coordinated parallel tasks? Ultralow latency distributed updates? All of these are possible, thanks to Service Broker!
Event Date: 03-11-2017 15:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 03-11-2017 15:30 - Category: Microsoft Session (75 minutes) - Track: Build
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Build
This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production-ready VM.
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Design
Gain helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Build
You'll learn how to: <ul> <li>Understand the internal structure of hash and range indexes</li><li>Discuss the pros, cons, and best practices for both types of indexes</li><li>Examine the metadata that shows how the indexes on memory-optimized tables are being used</li></ul>
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Support
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Perform
This session will show why this is a radical departure from the way that things have worked until now and how it can improve the performance of some query forms. We’ll look at the places where adaptive query plans work and compare the performance of queries using adaptive query plans to see just what kind of improvement it can make.
Event Date: 03-11-2017 15:30 - Category: General Session (75 minutes) - Track: Evolve
Event Date: 03-11-2017 15:30 - Category: MS Tiger Session (75 minutes) - Track: Perform
In this session, we will cover:<ul><li>The internals of SQL Server Always On</li><li>Identifying and detecting latency and failover issues with Always On</li><li>Artifacts and data pointers available to troubleshoot latency and failover issues</li><li>Tips and Tricks to troubleshoot Always On availability groups</li><li>New enhancements which make troubleshooting Latency and Failover issues easier</li></ul>