| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 05-11-2018 08:30 | Andy Leonard | Pre-Conference Session (Full Day) | Business Intelligence and Data Warehousing | Intelligent Data Integration with SSIS |
| 05-11-2018 08:30 | Dejan Sarka | Pre-Conference Session (Full Day) | Advanced Analytics | Advanced R |
| 05-11-2018 08:30 | Kendra Little | Pre-Conference Session (Full Day) | Database Administration and Development | Prevent 'Fake News' in Your Data! Isolation Levels Demystified |
| 05-11-2018 08:30 | Melissa Coates, Meagan Longoria | Pre-Conference Session (Full Day) | Business Intelligence and Data Warehousing | Designing Modern Data and Analytics Solutions in Azure |
| 05-11-2018 08:30 | Denny Cherry | Pre-Conference Session (Full Day) | Database Administration and Development | SQL Server Security |
| 05-11-2018 08:30 | Rob Collie | Pre-Conference Session (Full Day) | Advanced Analytics | Immediate Business Impact with Power Pivot |
| 05-11-2018 08:30 | Devin Knight, Brian Knight, Mitchell Pearson | Pre-Conference Session (Full Day) | Business Intelligence and Data Warehousing | Digital Storytelling with Power BI |
| 05-11-2018 08:30 | Itzik Ben-Gan | Pre-Conference Session (Full Day) | Database Administration and Development | Performance-Centric T-SQL |
| 06-11-2018 08:30 | Brent Ozar, Erik Darling | Pre-Conference Session (Full Day) | Database Administration and Development | Performance Tuning in 21 Demos? |
| 06-11-2018 08:30 | Rob Sewell | Pre-Conference Session (Full Day) | Database Administration and Development | Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions |
| 06-11-2018 08:30 | Mico Yuk | Pre-Conference Session (Full Day) | Advanced Analytics | The Art & Science of Designing Smart Data Stories |
| 06-11-2018 08:30 | Argenis Fernandez, Pam Lahoud, Bob Ward, Amit Banerjee, Pedro Lopes, Suresh Kandoth, Sourabh Agarwal, Vin Yu, Sean Gallardy | Pre-Conference Session (Full Day) | Database Administration and Development | Modernize Your SQL Server with Bob Ward, the Tiger Team, and CSS Escalation Engineers |
| 06-11-2018 08:30 | Leonard Lobel | Pre-Conference Session (Full Day) | Application Development | Developer Dive into Azure Cosmos DB |
| 06-11-2018 08:30 | Kimberly Tripp | Pre-Conference Session (Full Day) | Database Administration and Development | Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality |
| 06-11-2018 08:30 | Lyndsey Padget | Pre-Conference Session (Full Day) | Application Development | Master Git in a Day |
| 06-11-2018 08:30 | Peter De Tender, Koenraad Haedens | Pre-Conference Session (Full Day) | Cloud Solutions | The Latest and Greatest on Azure IAAS and PAAS: A Demo-Filled Workshop |
| 06-11-2018 08:30 | John Welch, Kevin Kline, Steven Wright, Jason Hall, Douglas McDowell, Andy Yun, Andy Mallon, Bob Potter, Nick Harshbarger | Pre-Conference Session (Full Day) | Database Administration and Development | SentryOne Data Day |
| 06-11-2018 08:30 | Pinal Dave | Pre-Conference Session (Full Day) | Database Administration and Development | 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs |
| 07-11-2018 10:15 | Lyndsey Padget | General Session (75 minutes) | Application Development | GitHub for Business: Pro Tips for Success |
| 07-11-2018 10:15 | Lindsey Allen, Kevin Farlee, Ajay Jagannathan, Xiaochen Wu | Microsoft Session (75 minutes) | Cloud Solutions | Introducing Azure SQL Database Hyperscale |
| 07-11-2018 10:15 | Rob Mandeville | General Session (75 minutes) | Database Administration and Development | Five DevOps Essentials for Better DBA and Developer Collaboration |
| 07-11-2018 10:15 | Denise McInerney | General Session (75 minutes) | Big Data and IoT | Data Catalogs: Trendy & Necessary |
| 07-11-2018 10:15 | Joseph Barth | General Session (75 minutes) | Cloud Solutions | Azure Data Factory Version 2 - Early Adopters |
| 07-11-2018 10:15 | Pinal Dave | General Session (75 minutes) | Database Administration and Development | Kick Start! SQL Server 2017 Performance Tips and Tricks |
| 07-11-2018 10:15 | Joseph D'Antoni, Stephanie Bruno | General Session (75 minutes) | Business Intelligence and Data Warehousing | Data4Good – How Technology + Community is Saving Lives |
| 07-11-2018 10:15 | Andy Yun | General Session (75 minutes) | Database Administration and Development | Uncovering Duplicate, Redundant, & Missing Indexes |
| 07-11-2018 10:15 | Enrico van de Laar | General Session (75 minutes) | Advanced Analytics | Moving Advanced Analytics to Your SQL Server Databases |
| 07-11-2018 10:15 | Rob Sewell | General Session (75 minutes) | Database Administration and Development | dbatools Powershell Library - The Complete Introduction |
| 07-11-2018 10:15 | Angela Henry | General Session (75 minutes) | Database Administration and Development | Data Types Do Matter |
| 07-11-2018 10:45 | Johan Ludvig Brattås | General Session (75 minutes) | Big Data and IoT | Don't Cross the Streams! A Closer Look at Azure Stream Analytics |
| 07-11-2018 10:45 | Denny Cherry | General Session (75 minutes) | Database Administration and Development | SQL Server Database Administration for the Non-DBA |
| 07-11-2018 10:45 | Bob Ward, Amit Banerjee, Asad Khan | Microsoft Session (75 minutes) | Database Administration and Development | The Roadmap for SQL Server |
| 07-11-2018 10:45 | Richard Campbell | General Session (75 minutes) | Application Development | The Coming Disruptions in Development (and what it means to you!) |
| 07-11-2018 10:45 | David Klee | General Session (75 minutes) | Database Administration and Development | On-Prem SQL Servers, Interstellar Performance |
| 07-11-2018 12:30 | Kevin Kline | Marketing Community Session (45 minutes) | Other (Professional Development) | Introduction to PASS Summit 2018 |
| 07-11-2018 13:30 | Douglas Barrett | General Session (75 minutes) | Business Intelligence and Data Warehousing | Automate Development of Streaming Data Pipelines |
| 07-11-2018 13:30 | Ginger Grant | General Session (75 minutes) | Advanced Analytics | Improving Career Prospects by Incorporating Advanced Analytical Skills |
| 07-11-2018 13:30 | Paul Turley, Chris Webb, Brian Knight, Cathrine Wilhelmsen, Mitchell Pearson | Lightning Talks (75 minutes) | Business Intelligence and Data Warehousing | Lightning Talks: BI |
| 07-11-2018 13:30 | Marco Russo | General Session (75 minutes) | Advanced Analytics | My Power BI Report is Slow: What Should I Do? |
| 07-11-2018 13:30 | Melody Zacharias, John Morehouse, Kellyn Pot'Vin-Gorman, Rie Irish, Randolph West, Tracy Boggiano, Angela Tidwell | General Session (75 minutes) | Other (Professional Development) | Let Them Finish: Stories from the Trenches |
| 07-11-2018 13:30 | Argenis Fernandez, Pam Lahoud, Pedro Lopes | MS Tiger Half-Day Session (2.5 hours) | Database Administration and Development | SQL Server Migrations Done the Right Way |
| 07-11-2018 13:30 | Bill Gibson, Anand Subbaraj | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Building a Modern Data Warehouse on Azure |
| 07-11-2018 13:30 | Perry Skountrianos, Mirek Sztajno | Microsoft Session (75 minutes) | Database Administration and Development | Improving Availability in SQL Server and Azure SQL Database |
| 07-11-2018 13:30 | Andy Leonard | General Session (75 minutes) | Business Intelligence and Data Warehousing | Faster SSIS |
| 07-11-2018 13:30 | Gabriel Villa | General Session (75 minutes) | Cloud Solutions | Dive into Amazon Web Services Databases |
| 07-11-2018 13:30 | John Martin | Half-Day Session (2.5 hours) | Cloud Solutions | Introduction to Managed Instances |
| 07-11-2018 13:30 | Travis Wright, Dr. Rony Chatterjee | Microsoft Session (75 minutes) | Big Data and IoT | The Future of SQL Server and Big Data |
| 07-11-2018 13:30 | Amy Herold | General Session (75 minutes) | Database Administration and Development | The Case for Change: Identifying and Remedying Bad Code |
| 07-11-2018 13:30 | Leonard Lobel | General Session (75 minutes) | Application Development | Database Development with SQL Server Data Tools |
| 07-11-2018 13:30 | John McAbel | General Session (75 minutes) | Cloud Solutions | SQL Server Infrastructure Alternatives |
| 07-11-2018 13:30 | Brent Ozar | General Session (75 minutes) | Application Development | Getting Better Query Plans by Improving SQL’s Estimates |
| 07-11-2018 15:15 | Kathi Kellenberger | General Session (75 minutes) | Business Intelligence and Data Warehousing | Configure Kerberos for SSRS |
| 07-11-2018 15:15 | Ike Ellis | General Session (75 minutes) | Business Intelligence and Data Warehousing | Introduction to DAX |
| 07-11-2018 15:15 | Richard Waymire | General Session (75 minutes) | Cloud Solutions | Running Microsoft SQL Server on Amazon Web Services |
| 07-11-2018 15:15 | Andy Leonard, Melissa Coates, Meagan Longoria, Mico Yuk, Ryan Wade | General Session (75 minutes) | Advanced Analytics | BI & Data Visualization Panel |
| 07-11-2018 15:15 | Michael Wall | General Session (75 minutes) | Other (Professional Development) | Becoming a Master by Giving it All Away |
| 07-11-2018 15:15 | Edward Pollack | General Session (75 minutes) | Business Intelligence and Data Warehousing | Finding Islands, Gaps, and Clusters in Complex Data |
| 07-11-2018 15:15 | Kimberly Tripp | General Session (75 minutes) | Database Administration and Development | Architecting for Scalability and Performance in Hybrid Workloads |
| 07-11-2018 15:15 | Patrick O'Keeffe | General Session (75 minutes) | Database Administration and Development | Adopting Azure Cosmos DB: Time to Learn What You Don’t Know |
| 07-11-2018 15:15 | Joe Obbish | General Session (75 minutes) | Database Administration and Development | Four Rules for Columnstore Query Performance |
| 07-11-2018 15:15 | Ron Ortloff | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | What’s New with SQL Data Warehouse ? |
| 07-11-2018 15:15 | Andrew Kelly | Half-Day Session (2.5 hours) | Database Administration and Development | Getting Started with Practical Performance Monitoring |
| 07-11-2018 15:15 | Jen Underwood | General Session (75 minutes) | Advanced Analytics | Storytelling for Machine Learning and Advanced Analytics |
| 07-11-2018 15:15 | Ryan Booz | General Session (75 minutes) | Application Development | Service Broker - Async in the DB |
| 07-11-2018 15:15 | Robert Cain | General Session (75 minutes) | Other (Professional Development) | The Joy of DevOps |
| 07-11-2018 16:45 | Bob Pusateri | General Session (75 minutes) | Database Administration and Development | SSMS & T-SQL Tricks: Working Smarter, Not Harder |
| 07-11-2018 16:45 | Denis Reznik | General Session (75 minutes) | Application Development | Why Should I Care About SQL if I Have ORM? |
| 07-11-2018 16:45 | Rob Collie | General Session (75 minutes) | Advanced Analytics | Scorecards: A Bright New Future for an Old Idea |
| 07-11-2018 16:45 | Joe Chang | General Session (75 minutes) | Database Administration and Development | Rethink Server Sizing |
| 07-11-2018 16:45 | Grant Fritchey | General Session (75 minutes) | Cloud Solutions | Disaster Recovery & High Availability on the Azure Data Platform |
| 07-11-2018 16:45 | Dejan Sarka | General Session (75 minutes) | Advanced Analytics | Data Overview and Manipulation – T-SQL, R, Python |
| 07-11-2018 16:45 | Meagan Longoria | General Session (75 minutes) | Advanced Analytics | Do Your Data Visualizations Need A Makeover? |
| 07-11-2018 16:45 | Ola Hallengren | General Session (75 minutes) | Database Administration and Development | Analyzing Performance Problems Using XEvents, DMVs & Query Store |
| 07-11-2018 16:45 | Joachim Hammer, Jakub Szymaszek, Mirek Sztajno | Microsoft Session (75 minutes) | Cloud Solutions | SQL DB Security Overview |
| 07-11-2018 16:45 | Mike Walsh | General Session (75 minutes) | Cloud Solutions | Azure Managed Instances: Getting There |
| 07-11-2018 16:45 | Denny Cherry | General Session (75 minutes) | Other (Professional Development) | Speaker Idol: Round One |
| 07-11-2018 16:45 | Reeves Smith | General Session (75 minutes) | Advanced Analytics | Follow Gartner’s Lead, Become a Citizen Data Scientist |
| 07-11-2018 16:45 | Tracy Boggiano | General Session (75 minutes) | Cloud Solutions | Azure SQL Database Maintenance and Automation |
| 07-11-2018 16:45 | Sourabh Agarwal | MS Tiger Session (75 minutes) | Database Administration and Development | Architecting a Highly Available Database Platform with SQL Server |
| 07-11-2018 16:45 | Oliver Engels, Gabi Münster | General Session (75 minutes) | Cloud Solutions | Azure Analysis Services or PowerBI - Which service fits you best? |
| 08-11-2018 10:15 | Cathrine Wilhelmsen | General Session (75 minutes) | Business Intelligence and Data Warehousing | Level Up Your Biml: Best Practices and Coding Techniques |
| 08-11-2018 10:15 | Tim Corey | General Session (75 minutes) | Application Development | Meet Dapper: The Powerful Alternative to Entity Framework |
| 08-11-2018 10:15 | Peter De Tender | General Session (75 minutes) | Cloud Solutions | Azure Is Highly Available, Thus So Are Your Workloads. Or Are They? |
| 08-11-2018 10:15 | Leslie Weed | General Session (75 minutes) | Business Intelligence and Data Warehousing | Innovative Data Modeling: Make Data Warehousing Cool Again |
| 08-11-2018 10:15 | Eric Peterson | General Session (75 minutes) | Big Data and IoT | SQL vs NoSQL: a Comparison of SQL vs MongoDB |
| 08-11-2018 10:15 | Nico Jacobs | General Session (75 minutes) | Big Data and IoT | Using Azure Machine Learning in Stream Analytics |
| 08-11-2018 10:15 | Alberto Ferrari | General Session (75 minutes) | Advanced Analytics | Understanding Relationships in Power BI |
| 08-11-2018 10:15 | Paul Bertucci | General Session (75 minutes) | Big Data and IoT | Cleaning up your Big Data Lakes with Data Quality as a Service |
| 08-11-2018 10:15 | Denise McInerney, Eric Peterson, Johan Ludvig Brattås, Simon Whiteley | Lightning Talks (75 minutes) | Big Data and IoT | Lightning Talks: Big Data and Cloud |
| 08-11-2018 10:15 | Joe Sack, Pedro Lopes | MS Tiger Session (75 minutes) | Database Administration and Development | What's New - Query Performance Insights |
| 08-11-2018 10:15 | Nellie Gustafsson, Shreya Verma | Microsoft Session (75 minutes) | Database Administration and Development | Meet the Modern SQL Server: Graph and Machine Learning Services |
| 08-11-2018 10:45 | Andy Galbraith | General Session (75 minutes) | Database Administration and Development | Getting Started with Extended Events |
| 08-11-2018 10:45 | Joseph D'Antoni | General Session (75 minutes) | Database Administration and Development | Containers, Pods, and Databases- The Future of Infrastructure |
| 08-11-2018 10:45 | Bob Ward, Ryan Stonecipher | Microsoft Session (75 minutes) | Database Administration and Development | Inside Columnstore Indexes |
| 08-11-2018 10:45 | Borko Novakovic | Microsoft Session (75 minutes) | Cloud Solutions | Azure SQL DB Managed Instances - Built to Easily Modernize Application Data Layer |
| 08-11-2018 10:45 | John Morehouse | General Session (75 minutes) | Cloud Solutions | Azure Basics for the DBA |
| 08-11-2018 13:30 | Scott Currie | General Session (75 minutes) | Cloud Solutions | Incrementally Moving to the Cloud Using Biml |
| 08-11-2018 13:30 | Carlos Bossy | General Session (75 minutes) | Advanced Analytics | Data Science Tips and Tricks using Python and SQL |
| 08-11-2018 13:30 | Chris Webb | General Session (75 minutes) | Business Intelligence and Data Warehousing | Working with Web Services in M |
| 08-11-2018 13:30 | Steve Jones | General Session (75 minutes) | Other (Professional Development) | Branding Yourself for a Dream Job |
| 08-11-2018 13:30 | Amy Herold | General Session (75 minutes) | Database Administration and Development | PowerShell for the DBA |
| 08-11-2018 13:30 | John Deardurff | General Session (75 minutes) | Database Administration and Development | The Vocabulary of Performance Tuning |
| 08-11-2018 13:30 | John Martin | General Session (75 minutes) | Cloud Solutions | Planning Your Migration to Azure SQL DB Managed Instance |
| 08-11-2018 13:30 | Allen White | General Session (75 minutes) | Business Intelligence and Data Warehousing | Get Near Real-time ETL with Service Broker |
| 08-11-2018 13:30 | Bob Pusateri, David Klee | General Session (75 minutes) | Cloud Solutions | Select Stars: A SQL DBA's Introduction to Azure Cosmos DB |
| 08-11-2018 13:30 | Dan Mallott | General Session (75 minutes) | Application Development | New Frontiers: Platform Independent Full Stack Development |
| 08-11-2018 13:30 | Devin Knight | General Session (75 minutes) | Business Intelligence and Data Warehousing | Top 5 Power BI Custom Visuals |
| 08-11-2018 13:30 | Allan Hirt | General Session (75 minutes) | Database Administration and Development | Top Tips for Deploying AGs and FCIs On Premises or In the Cloud |
| 08-11-2018 13:30 | Bob Ward, Vin Yu | Microsoft Session (75 minutes) | Database Administration and Development | What’s New in SQL Server on Linux and Containers |
| 08-11-2018 13:30 | Mine Tokus | Microsoft Session (75 minutes) | Cloud Solutions | Enhanced SQL Server on Azure VM Service |
| 08-11-2018 13:30 | Kevin Kline | Half-Day Session (2.5 hours) | Database Administration and Development | Query Tuning Internals for the Advanced SQL Developer |
| 08-11-2018 13:30 | Itzik Ben-Gan | General Session (75 minutes) | Database Administration and Development | Sequencing Solutions: Comparing IDENTITY, SEQUENCE and Custom Solutions |
| 08-11-2018 15:15 | David Maxwell | General Session (75 minutes) | Database Administration and Development | Understanding and Implementing System-Versioned Temporal Tables |
| 08-11-2018 15:15 | Rob Collie | General Session (75 minutes) | Advanced Analytics | Power BI Governance: Humans, Tech, and the “Goldilocks Line” |
| 08-11-2018 15:15 | Marco Russo | General Session (75 minutes) | Business Intelligence and Data Warehousing | Optimizing Multi-Billion Row Tables in Tabular in 2018 |
| 08-11-2018 15:15 | Kuber Sharma | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Customer Success Stories with SQL Data Warehouse? |
| 08-11-2018 15:15 | Tim Mitchell | Half-Day Session (2.5 hours) | Business Intelligence and Data Warehousing | Build a Metadata-Driven ETL Repository with Biml and SSIS |
| 08-11-2018 15:15 | Simon Whiteley | General Session (75 minutes) | Big Data and IoT | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 08-11-2018 15:15 | Helge Rege Gårdsvoll | General Session (75 minutes) | Big Data and IoT | Make your Data Lake Smarter with U-SQL Extensions |
| 08-11-2018 15:15 | Paul Turley, Jonathan Stewart | General Session (75 minutes) | Business Intelligence and Data Warehousing | Visualize World Peace Through the Art and Science of Presenting Beautiful Data |
| 08-11-2018 15:15 | Joseph deBunza, Anu Oladele | General Session (75 minutes) | Business Intelligence and Data Warehousing | GoEasy’s Road to Real-Time Analytics |
| 08-11-2018 15:15 | Umachandar Jayachandran, Travis Wright, Mihaela Blendea | Half-Day Microsoft Session (2.5 hours) | Big Data and IoT | Deep Dive on SQL Server and Big Data |
| 08-11-2018 15:15 | Andrew Pruski | General Session (75 minutes) | Database Administration and Development | An Introduction to Partitioning |
| 08-11-2018 15:15 | Alexandre Bergere, Jonathan Petit | General Session (75 minutes) | Application Development | Azure Cosmos DB – Accelerate a Real-Time Big Data Solution |
| 08-11-2018 15:15 | Kalen Delaney | General Session (75 minutes) | Application Development | Everlasting Issues with Temporary Tables and tempdb |
| 08-11-2018 15:15 | Ed Leighton-Dick | General Session (75 minutes) | Database Administration and Development | Principle of Least Privilege: The Key to Strong Security |
| 08-11-2018 15:15 | Amir Netz, Arun Ulagaratchagan | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Microsoft Power BI: The Future for Modern and Enterprise BI |
| 08-11-2018 16:45 | Raj Pochiraju, Shamik Ghosh | Microsoft Session (75 minutes) | Cloud Solutions | Perform Live Migrations from On-Premises SQL Server and Oracle Databases to Azure |
| 08-11-2018 16:45 | Richard Campbell | General Session (75 minutes) | Other (Professional Development) | Building Trust in Teams |
| 08-11-2018 16:45 | Tillmann Eitelberg, Frank Geisler | General Session (75 minutes) | Application Development | Use Docker to Deploy SQL Server Applications |
| 08-11-2018 16:45 | John Hoang, Mike Weiner, Alexei Khalyako | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Learnings and Best Practices in Building an Enterprise Data Warehouse Using Azure SQL DW |
| 08-11-2018 16:45 | Seth Mottaghinejad | Microsoft Session (75 minutes) | Database Administration and Development | Data Science 101 for the SQL DBA |
| 08-11-2018 16:45 | Aaron Nelson | General Session (75 minutes) | Business Intelligence and Data Warehousing | PowerShell for BI Pros: Automating SSIS, SSRS, SSAS, and Power BI |
| 08-11-2018 16:45 | Rajnikant Tandel, Anup Gopinathan | General Session (75 minutes) | Database Administration and Development | Optimize SQL Server: Query Tuning Techniques |
| 08-11-2018 16:45 | Denny Cherry | General Session (75 minutes) | Other (Professional Development) | Speaker Idol: Round Two |
| 08-11-2018 16:45 | Vicky Harp, Alan Yu | Microsoft Session (75 minutes) | Database Administration and Development | The Future of SQL Server Tooling |
| 08-11-2018 16:45 | Ted Way, Henry Jerez | Microsoft Session (75 minutes) | Advanced Analytics | Supporting Data Science in Your Organization – ML Model Deployment, Management and Inferencing |
| 08-11-2018 16:45 | Rob Sewell | General Session (75 minutes) | Database Administration and Development | Validate Your SQL Server Estate with Ease Using dbachecks |
| 08-11-2018 16:45 | Adam Saxton, Lukasz Pawlowski | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Microsoft Power BI: Distributing Insights and Governing Self-Service Analytics with the Microsoft Power BI Service |
| 08-11-2018 16:45 | Hamish Watson | General Session (75 minutes) | Database Administration and Development | Test Driven Development in SQL Server – How to Deploy Code Safer |
| 08-11-2018 16:45 | Kevin Feasel | General Session (75 minutes) | Advanced Analytics | Applying Forensic Accounting Techniques Using SQL and R |
| 09-11-2018 08:00 | Sourabh Agarwal | MS Tiger Session (75 minutes) | Database Administration and Development | How it Works – Availability Groups with SQL Server on Linux |
| 09-11-2018 08:00 | Eric Peterson | General Session (75 minutes) | Cloud Solutions | Security Considerations for the Cloud |
| 09-11-2018 08:00 | Melissa Coates | General Session (75 minutes) | Big Data and IoT | Azure Data Lake: What, Why, and How |
| 09-11-2018 08:00 | Arvind Shyamsundar | Microsoft Session (75 minutes) | Database Administration and Development | Advanced SQL Server Troubleshooting with SQLCallStackResolver |
| 09-11-2018 08:00 | Matt How | General Session (75 minutes) | Advanced Analytics | A Heart to Heart with your Data: Emotional Intelligence in Azure |
| 09-11-2018 08:00 | Cyndi Johnson | General Session (75 minutes) | Database Administration and Development | Behold the Power of Dynamic SQL |
| 09-11-2018 08:00 | Samir Behara | General Session (75 minutes) | Application Development | Monolith to Microservices: Making a Successful Transition |
| 09-11-2018 08:00 | Vishwac Sena Kannan | Microsoft Session (75 minutes) | Advanced Analytics | AI at Your Service – Creating Enterprise-Scale AI and Bots |
| 09-11-2018 08:00 | Joseph D'Antoni | General Session (75 minutes) | Database Administration and Development | Automagic Tuning - SQL Server 2017 and Beyond |
| 09-11-2018 08:00 | Mihail Mateev | General Session (75 minutes) | Big Data and IoT | Azure IoT Solution Architecture Best Practices |
| 09-11-2018 08:00 | Kendra Little | General Session (75 minutes) | Database Administration and Development | Fix My Functions: Speeding Up Scalar and Table Valued UDFs |
| 09-11-2018 08:00 | Vern Rabe | General Session (75 minutes) | Database Administration and Development | T-SQL Habits and Practices That Can Kill Performance |
| 09-11-2018 08:00 | Cristian Petculescu, Roy Gal, Adi Regev | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Introducing Advanced Data Preparation Using Power BI Dataflows |
| 09-11-2018 08:00 | Hamish Watson | General Session (75 minutes) | Cloud Solutions | Building a Database DevOps Pipeline in the Cloud in < 59 minutes |
| 09-11-2018 08:00 | Ginger Grant | General Session (75 minutes) | Big Data and IoT | Using Azure Databricks to Develop Scalable Data Solutions |
| 09-11-2018 08:00 | Frank Gill | General Session (75 minutes) | Application Development | The SQL Server Transaction Log for Developers |
| 09-11-2018 09:30 | JP Chen, Luca Fagetti | General Session (75 minutes) | Database Administration and Development | Kaplan Shares Key Learnings and Best Practices in Optimizing Database Administration |
| 09-11-2018 09:30 | Glenn Berry | Half-Day Session (2.5 hours) | Database Administration and Development | Migrating to SQL Server 2017 |
| 09-11-2018 09:30 | Dan Clark | General Session (75 minutes) | Business Intelligence and Data Warehousing | Self-Service ETL with Power Query |
| 09-11-2018 09:30 | Reeves Smith | General Session (75 minutes) | Business Intelligence and Data Warehousing | Master Data Management in the GDPR Era |
| 09-11-2018 09:30 | Niko Neugebauer | General Session (75 minutes) | Database Administration and Development | Columnstore Clustered vs Nonclustered, When to Choose What |
| 09-11-2018 09:30 | Parikshit Savjani, Charles Christian | Microsoft Session (75 minutes) | Database Administration and Development | OSS Databases on Azure Session |
| 09-11-2018 09:30 | Anupama Natarajan | General Session (75 minutes) | Advanced Analytics | Transform your Business Using Intelligent Bots |
| 09-11-2018 09:30 | Brad Llewellyn | General Session (75 minutes) | Other (Professional Development) | What is a Data Scientist and How Do I Become One? |
| 09-11-2018 09:30 | Kellyn Pot'Vin-Gorman | General Session (75 minutes) | Application Development | DevOps and Decoys- How to Build a Successful Microsoft DevOps Solution Including Your Data |
| 09-11-2018 09:30 | Vinod Kurpad | Microsoft Session (75 minutes) | Advanced Analytics | AI for Knowledge Mining – Intelligently Search and Act Upon all Your Enterprise Data |
| 09-11-2018 09:30 | Kevin Feasel | General Session (75 minutes) | Advanced Analytics | Getting Started With Apache Spark |
| 09-11-2018 09:30 | Christian Wade, Josh Caplan | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Building Enterprise-Grade BI Models with Microsoft Power BI |
| 09-11-2018 09:30 | Kun Cheng, Mike Weiner, Dimitri Furman | Microsoft Session (75 minutes) | Cloud Solutions | SQL DB Managed Instance - Best Practices and Lessons Learned |
| 09-11-2018 09:30 | Kavitha Jonnakuti | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Build the Most Secure Data Warehouse on Azure? |
| 09-11-2018 09:30 | Matt Gordon | General Session (75 minutes) | Cloud Solutions | Democratizing Data Analysis: How/Why of Social Sentiment Scoring |
| 09-11-2018 09:30 | Bob Pusateri, David Klee | General Session (75 minutes) | Cloud Solutions | Cosmos DB for SQL Server Pros |
| 09-11-2018 11:00 | Warner Chaves | General Session (75 minutes) | Cloud Solutions | Choosing the Right Azure SQL Service for You |
| 09-11-2018 11:00 | Carlos Bossy | General Session (75 minutes) | Advanced Analytics | Operationalize Data Science for Advanced Decision Support |
| 09-11-2018 11:00 | James McGillivray | General Session (75 minutes) | Database Administration and Development | Windowing Functions: How Spying on Neighbors Enhances Your Data |
| 09-11-2018 11:00 | Arindam Chaterjee | Microsoft Session (75 minutes) | Big Data and IoT | Gaining Deeper Insights from Big Data Using Open Source Analytics on Azure HDInsight |
| 09-11-2018 11:00 | Jeremy Frye | General Session (75 minutes) | Business Intelligence and Data Warehousing | Speed Up Your SSAS Data Refresh With Dynamic Partition Processing |
| 09-11-2018 11:00 | Patrick LeBlanc, Chris Webb, Adam Saxton, Matthew Roche, Meagan Longoria | General Session (75 minutes) | Business Intelligence and Data Warehousing | BI Power Hour |
| 09-11-2018 11:00 | Erland Sommarskog | General Session (75 minutes) | Database Administration and Development | Dynamic Search Conditions |
| 09-11-2018 11:00 | Steve Jones | General Session (75 minutes) | Database Administration and Development | Adopting a Compliant Database DevOps Process |
| 09-11-2018 11:00 | Chris Woodruff | General Session (75 minutes) | Application Development | What’s New in Entity Framework Core 2.1? |
| 09-11-2018 11:00 | Idan Cohen | General Session (75 minutes) | Business Intelligence and Data Warehousing | KPIs from the Field |
| 09-11-2018 11:00 | Ben Miller | General Session (75 minutes) | Database Administration and Development | Tips and Tricks for the PowerShell DBA |
| 09-11-2018 11:15 | Amy Herold, Angela Henry, Richard Campbell, Lyndsey Padget, Tim Corey | General Session (75 minutes) | Other (Professional Development) | Better Together – How to Get Developers and DBAs to Collaborate More |
| 09-11-2018 11:15 | Denny Cherry | General Session (75 minutes) | Other (Professional Development) | Speaker Idol: Round Three |
| 09-11-2018 11:15 | David Maxwell | General Session (75 minutes) | Database Administration and Development | Using Extended Events for Wait Stats Analysis |
| 09-11-2018 11:15 | Kellyn Pot'Vin-Gorman | General Session (75 minutes) | Database Administration and Development | GDPR - The Buck Stops Here |
| 09-11-2018 13:00 | Kevin Kline | Marketing Community Session (45 minutes) | Other (Professional Development) | Staying Involved with PASS |
| 09-11-2018 14:00 | Andrew Liu, Luis Bosquez Gonzalez | Microsoft Session (75 minutes) | Cloud Solutions | Technical Overview of Azure Cosmos DB |
| 09-11-2018 14:00 | Alberto Ferrari | General Session (75 minutes) | Business Intelligence and Data Warehousing | Deep Dive in DAX Evaluation Context |
| 09-11-2018 14:00 | David Besemer | General Session (75 minutes) | Advanced Analytics | Speed Meets Scale: Interactively Analyzing & Visualizing Billions of Rows with GPU-powered Analytics |
| 09-11-2018 14:00 | Joshua Johnson | General Session (75 minutes) | Application Development | Working with JSON in SQL Server |
| 09-11-2018 14:00 | Allan Hirt, Pinal Dave, Ed Leighton-Dick, Andy Yun, Hamish Watson | Lightning Talks (75 minutes) | Database Administration and Development | Lightning Talks: DBA |
| 09-11-2018 14:00 | Chris Finlan | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Modern Enterprise Reporting with Power BI Report Server & the Power BI Service |
| 09-11-2018 14:00 | Pam Lahoud | MS Tiger Session (75 minutes) | Database Administration and Development | TempDB: The Good, The Bad, and The Ugly |
| 09-11-2018 14:00 | Ryan Wade | General Session (75 minutes) | Advanced Analytics | Create Amazing Visualizations in Power BI using ggplot2 |
| 09-11-2018 14:00 | Anthony van Gemert, Kevin Ngo | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Simplify your Data Warehouse in the Cloud ? |
| 09-11-2018 14:00 | Janis Griffin | General Session (75 minutes) | Database Administration and Development | What’s New in the 2017 Query Store |
| 09-11-2018 14:00 | Bob Ward | Microsoft Session (75 minutes) | Database Administration and Development | Inside SQL Server with Containers |
| 09-11-2018 14:00 | Manohar Punna | General Session (75 minutes) | Advanced Analytics | Real-Time Analytics with Power BI |
| 09-11-2018 14:00 | Jeff Renz | General Session (75 minutes) | Advanced Analytics | Introduction to the R Programming Language for BI Professionals |
| 09-11-2018 14:00 | Nathan Patrick Taylor | General Session (75 minutes) | Advanced Analytics | Transforming Business with Automated Machine Learning |
| 09-11-2018 14:00 | Hugo Kornelis | General Session (75 minutes) | Database Administration and Development | What's New With Adaptive Query Processing? |
| 09-11-2018 15:30 | Amit Banerjee, Vin Yu | MS Tiger Session (75 minutes) | Database Administration and Development | SQL Server in Containers for Application Development and Deployment |
| 09-11-2018 15:30 | Dan Clark | General Session (75 minutes) | Business Intelligence and Data Warehousing | Power Query Deep Dive |
| 09-11-2018 15:30 | Ike Ellis | General Session (75 minutes) | Business Intelligence and Data Warehousing | Automated Testing in an Enterprise Data Architecture |
| 09-11-2018 15:30 | Johan Ludvig Brattås | General Session (75 minutes) | Business Intelligence and Data Warehousing | Implementing a Hybrid Data Warehouse |
| 09-11-2018 15:30 | Steve Stedman | General Session (75 minutes) | Application Development | Exploring SQL Server Join Types – INNER, OUTER, and Much More |
| 09-11-2018 15:30 | Steve Jones | General Session (75 minutes) | Database Administration and Development | Minimizing the Impact of Data Breaches in Dev and Test Databases |
| 09-11-2018 15:30 | Grant Fritchey | General Session (75 minutes) | Database Administration and Development | Maximize Availability and More with SQL Server Estate Monitoring |
| 09-11-2018 15:30 | Phil Helmer, Peter Kral | General Session (75 minutes) | Business Intelligence and Data Warehousing | SSIS Deployment Smackdown! Package vs. Project! |
| 09-11-2018 15:30 | Brandon Leach | General Session (75 minutes) | Database Administration and Development | A DBAs Guide to the Proper Handling of Corruption |
| 09-11-2018 15:30 | Andrew Liu, Deborah Chen | Microsoft Session (75 minutes) | Cloud Solutions | Modeling Data and Best Practices for Azure Cosmos DB |
| 09-11-2018 15:30 | Denny Cherry | General Session (75 minutes) | Other (Professional Development) | Speaker Idol: Final Round |
| 09-11-2018 15:30 | Kevin Feasel | General Session (75 minutes) | Advanced Analytics | Cleaning is Half the Battle: Launching a Data Science Project |
| 09-11-2018 15:30 | Pinal Dave | General Session (75 minutes) | Database Administration and Development | SQL Server Performance Monitoring Made Easy |
| 09-11-2018 15:30 | Eric Blinn | General Session (75 minutes) | Database Administration and Development | Encryption: Not Just for the NSA Anymore |
| 09-11-2018 15:30 | Chris Bell | General Session (75 minutes) | Application Development | Reducing Security Risks with Application Roles |
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
Framework.
Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.
Attendees will learn:
Topics include:
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
Modules:
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
In this day-long, demo packed session, you'll learn why a single statement may read rows twice, miss rows entirely, or return combinations of data that never existed in the database -- and why that's not a bug. You'll learn what "read phenomena" are, which isolation levels are vulnerable to them, and the performance trade-offs which come from raising your isolation level to protect your users from bad data.
You'll see how isolation levels work with newer technologies such as columnstore indexes, In-Memory OLTP, and Always On Availability Groups. You'll discover why version-based isolation levels can be awesome, and what you need to look out for with these isolation levels to avoid race conditions that produce-- you guessed it-- incorrect results.
At the end of the day, we'll pull together all this information into a guide. You'll leave the seminar with the tools and knowledge to choose the right isolation levels for new and existing applications based on business and performance requirements.
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
Approximately 30% of the day will be hands-on labs, 50% presentation, and 20% open discussion and questions. Specific technologies discussed will include: Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Data Lake Analytics, U-SQL, Azure Storage, Azure Data Factory, Azure Databricks, Spark, Hive, HDInsight, Azure Analysis Services, PolyBase, Elastic Queries, Azure Event Hub, Azure Stream Analytics, Azure Data Catalog, Machine Learning Services, Azure Machine Learning, Azure Cognitive Services, Power BI, BIML, ARM templates, PowerShell, and Azure Virtual Machines. Attendees of this session will gain a broad understanding of the fundamentals for designing data solutions in Azure, techniques for navigating the wide variety of platform choices in Azure, and suggestions for developing sound architectural systems.
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
During this full day Precon, we will review a variety of ways to secure your SQL Server databases and data from attack. In this session we will review proper network designs, recommended firewall configurations, and physical security options. We will also review data encryption options, password protection options, using contained databases, and Always On Availability Groups security.
There will also be discussions about additional measures which should be taken when working with Internet-facing applications. From there we will move to the most common attack vector: SQL Injection. We will include all the ways that attackers can use SQL Injection to get into your system and how to protect against it. The security options for database backups is the next topic on the list followed by proper SAN security designs. We will then finish up by reviewing the auditing options which are available against a database and how they can be used to monitor everything else which we've just talked about during the day.
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
You may not have heard of Power Pivot, but it is a close cousin of Power BI. In fact, the two share the same “brain” under the hood – which means the industrial-strength agility of Power BI is already lurking in the copy of Excel already on your desktop, and in your colleagues’. Absolutely game-changing analytical powers are therefore already at your fingertips, AND in a form that your organization’s analysts will enthusiastically embrace.
In this workshop, Rob Collie – co-author of the world’s #1-selling Power Pivot and Power BI books and founder of consulting firm PowerPivotPro – will introduce you to the capabilities of Power Pivot, and just as importantly, explain how it can quickly transform your organization’s relationship with data.
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
The most exciting part of the day may be our “Make it Real” section, where we encourage you to bring your own data to implement the best practices studied during the day. With three instructors you can rest assure you will be able to take away something you can implement right away when you get back to the office.
Event Date: 05-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
In one demo-filled day with Brent Ozar and Erik Darling, you’ll see SQL Server, Azure SQL DB, and Azure Managed Instances make questionable lifestyle choices. They’ll wildly underestimate the work required with a query, pick the wrong indexes, and jump off the roof into the pool while holding the TV - all in an effort to deliver the right query results. Brent and Erik will show you how to coach the database engine into better performance and less problems.
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
At the end of this fun filled day with Rob, a former SQL Server DBA turned professional automator, you will be much more confident in being able to approach any task with PowerShell and you will leave with all of the code and demos. You can even follow along if you bring a laptop with an instance of SQL Server installed.
We will cover
• How to learn how to interact with any technology using PowerShell • Understanding the syntax • The importance of Get-Help and how PowerShell enables you to help yourself • Why to write your own Modules and how to make them available to all of your team • A quick automated method to creating your module framework • Unit testing and debugging your code • How to continuously deliver changes to your PowerShell modules using GitHub and VSTS • Tips and tricks for script writing with the popular open-source community dbatools module • How to validate your SQL Server estate with PowerShell • Advanced SQL Server Agent and PowerShell management
We will have a lot of fun along the way and you will return to work with a lot of ideas, samples and better habits to become a PowerShell ninja and save yourself and your organisation time and effort.
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
Whether you are a BI beginner or veteran, this 100% hands-on, non technical workshop will teach you how to take KPI/metrics and transform them into a compelling data story! By working in teams with your peers, you will apply the techniques you learned during the short lectures immediately to a real world use case. The workshop is 20% lecture and 80% hands-on
By attending this intense but fun-filled workshop, you will learn: • How to change the 'conversation' with your users by focusing on the story, not data • Your personal BI Maturity IQ score and what areas need your attention • How to use the BIDF visual storyboard to engage your users like never before • What questions to ask, and what questions NOT to ask your users to create a compelling data story • What to do to take your data visualization journey to the next level!
Note: The workshop is 20% lecture and 80% hands-on. Wear comfortable shoes as you will be on your feet and come well rested with an open mind. We are going to be dong a lot of right brain, creative work!
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
This session will walk you through practical options for modernizing older releases of SQL Server. There are lots of choices and the engineers at Microsoft are here to guide you and find the right solutions to help you modernize your systems. In this full day session, Bob and the Microsoft engineering team will go over the benefits of newest releases, such as SQL Server 2016 and 2017, that provide built-in features for performance, intelligent diagnostics, security, HADR, and Machine Learning – now accessible on Linux and Docker containers. Plus, they’ll also go in-depth on Azure Managed Instance, a new cloud PaaS offering that makes moving to Azure far easier for the data professional. If you are using an older release of SQL Server and need a detailed plan to modernize to the latest products and services, this session is for you.
Join Bob Ward, the Tiger Team, and top CSS Escalation Engineers for a day of learning, covering: • Your choices for modernizing. • Tools and techniques for migration. • Security, availability and performance benefits of the latest releases. • Tools they use for troubleshooting common issues around performance and the storage engine.
This session will be full of technical details on all of these topics plus demos and samples you can take with you. We promise you will walk away with the technical expertise you need to make an immediate impact in your organization.
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Application Development
We’ll explore all the major aspects of Cosmos DB, starting with a quick overview, so you don’t need prior Cosmos DB experience (or any NoSQL experience) to jump on board. Learn how to provision throughput for predictable performance, and scale both storage and throughput with elastic containers and horizontal partitioning. Then, easily distribute your data globally, wherever your users are located. After locking down core concepts, we’ll examine the multi-model capabilities of Cosmos DB. Using the SQL, MongoDB, Table, Gremlin, and Cassandra APIs, you can model your data as JSON documents, key-value, graph, and columnar. We’ll migrate data from SQL Server, build applications using the .NET SDK, and use the SQL API to run SQL queries and write server-side stored procedures, triggers, and user-defined functions against a JSON document collection. We’ll also explore the Table API for a key-value data model, and the Gremlin API for modeling and querying complex graphs. By the end of the day, you’ll know how to provision throughput, partition, index, and globally distribute your Cosmos DB database. You’ll also know everything you need to start building Cosmos DB applications using the various APIs and supported data models. Attend this workshop and get up to speed on Cosmos DB today!
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
Between skewed data distribution, cardinality estimation (and the compatibility mode you’re currently running under), out-of-date statistics, or even the lack of statistics/heuristics, each can create wildly-different query problems and result in degraded performance. You've probably heard advice to rebuild indexes or update statistics - but is that the right advice (even if it has “worked”)? In many cases, NO! These "sledgehammer" approaches only appear to work and really just mask the actual problem. In this full-day workshop, you'll learn more accurate ways to solve query plan quality problems.
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Application Development
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Cloud Solutions
Content is targeted to IT Pros, Architects, and Developers who are interested in a good combination of architect–to–architect knowledge sharing, inspired by a demo-packed workshop day.
You will learn: • Best practices of Azure subscriptions and how to configure the right access roles • About architecting and deploying Azure VMs, storage and complex network solutions • Understanding Azure Disaster Recovery and High Availability solutions • Implementing Azure Identity and enabling Single Sign–On to SaaS applications • Deploying Azure Applications Services • Overview of the different Azure Monitoring tools available today • DevOps concepts in an Azure world, aka Infrastructure as Code
Contents/Topics covered in the workshop: • Azure subscriptions, Role Based Access Control, Azure Resource Policies • Azure VMs, Azure Storage Overview, Availability Sets • ARM Template design & deployment using Visual Studio / Visual Studio Code • Azure Active Directory, Azure AD Connect, Azure Application Access Panel • Azure Web Sites and Azure Mobile Services • Log Analytics, Application Insights, Azure Monitor
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
Who Should Attend:<ul><li>Database administrators and managers</li><li>BI professionals</li><li>IT managers</li><li>DevOps teams and database application developers</li><li>GDPR/compliance managers</li><li>SentryOne partners</li></ul> What You’ll Learn: <ul><li>How to proactively monitor, diagnose, and optimize SQL Server and the Microsoft data platform to ensure business continuity</li><li>How to find and fix performance problems with SQL Server Analysis Services to streamline data delivery</li><li>How to address problems across the IT infrastructure that can affect database performance, including virtual environments on VMware and Microsoft Hyper-V</li><li>How to empower DevOps teams to deliver accurate, fast-performing database applications with SSIS components and tasks, automated testing tools, and more</li><li>How to seamlessly manage GDPR and other regulation compliance requirements with document and metadata management solutions that include detailed data lineage and impact analysis</li></ul> AGENDA:
7:30 AM to 8:30 AM Registration & Light Breakfast
8:30 AM to 8:45 AM Driving Business Value with SentryOne - <i>Bob Potter, SentryOne CEO</i>
8:45 AM to 9:15 AM The Future of Data Performance Management - <i>Douglas McDowell, SentryOne CSO</i>
9:15 AM to 10:15 AM Move from Reactive to Proactive with SentryOne Tools - <i>Jason Hall, SentryOne VP of Product</i>
10:30 AM to 11:30 AM Need for Speed: Empowering DevOps Teams to Develop, Deploy, and Manage Fast-Performing Database Apps - <i>John Welch, VP of Engineering</i>
11:30 AM to 1:00 PM Breakout Lunch Sessions: Journey to the Cloud: How These Companies Are Planning and Executing Data Migrations to the Cloud<i> (Moderators: Kevin Kline [SentryOne Principal Program Manager] and Andy Mallon)</i> Expanding Your Partner Potential with SentryOne<i> (Moderator: Nick Harshbarger [SVP of SentryOne Global Partner Network])</i>
1:00 PM to 2:00 PM Boosting Performance of SSAS - <i>Steve Wright, SentryOne Director of Advanced Analytics</i>
2:15 PM to 3:15 PM De-Risking your Move to the Cloud with SentryOne - <i>Andy Mallon, SentryOne Product Manager</i>
3:15 PM to 4:00 PM Fix My Query! Watch and Learn as SentryOne Experts Troubleshoot Bad Queries - <i>Andy Yun, Senior Solutions Engineer</i>
4:00 PM to 5:00 PM SentryOne Data Day Social Hour
To see a more detailed agenda for SentryOne's Data Day click <a href="https://www.sentryone.com/data-day-at-pass-summit-2018">here&
Event Date: 06-11-2018 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration and Development
Accidental DBAs quickly learn all the routine administrative tasks as clear instructions are often available at various educational portals, product support website and on the internet. The real big challenge accidental DBAs often face when they have to identify and resolve application performance problems of the system under a heavy workload.
This quick-paced demo-oriented session will cover the real-world pain points for accidental DBAs who have keen interesting in catching performance troublemakers.
Here are the major topics which we will cover in this session: • Optimal server configuration for performance • Efficient database settings for balanced resource consumption • Understanding self-healing index tuning mechanism • Maintenance strategy and guidance • Faster backup and restore strategy • DBCC best practices • Troubleshooting slow running query with Wait Statistics • SQL Server 2017 New Features (Auto-Tuning, Query Store, Adaptive Joins, etc.)
In the last hour, we will play an interactive fun game with WHERE clause and Multi-Column index, where the individual who gets the maximum wrong answer will be a winner!
In this session, we will explore 21 essential scripts which every DBA should keep handy, so they can stay alert fight and win the real-world problems.
At the end of the pre-con, DBAs will learn how they can convert the accidents into opportunities.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 07-11-2018 10:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
For many software-as-a-service (SaaS) and Web-enabled businesses, database performance issues in production can cause a steady, relentless drain in business performance. In fact, some estimate that as much as 70% of application performance problems are caused by problems with the database.
These problems that plague application performance have much in common with the problems that have led many CIOs to adopt Agile development practices and DevOps approaches to streamlining service delivery.
In this presentation, SolarWinds database evangelist, Janis Griffin describes specific actions that can be taken to build a proactive application and database performance monitoring practice that is shared throughout the development and IT organizations. Such a proactive approach serves to demonstrate the strategic value of IT in developing and delivering business - driven services, and contributes significantly to an organization’s overall success.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
Why? Most of these big data solutions lack a crucial component: the data catalog. Gartner estimates that only 20% of these data lakes will include a useful data catalog, but organizations that have an effective, modern data catalog will “realize twice the business benefits of those that do not."
In this session I will draw on lessons learned while implementing a data catalog as part of an analytics solution. I will cover: • Why data catalogs are key to the success of an analytics solution • How to build a catalog that meets your organization’s needs • The characteristics of an effective catalog in today’s data environment • The importance of combining domain knowledge, crowd-sourcing and technical expertise • The common mistakes made when building a catalog and how to avoid them
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Here is a glimpse of the features we will cover in this session: • Adaptive query plans • Batch mode adaptive join • New cardinality estimates for optimal performance • Indexing Improvements • Automatic Tuning • Memory optimizations
At the end of the session, DBAs will learn 3 essential processes which can be game changers for their career. After implementing the suggestions discussed in this session, DBAs will have extra time to handle more pressing issues which they were not able to focus on earlier.
This 75 minutes will be the most productive time for any DBA or Developer.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
The Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) works in Sub-Saharan Africa and India to end HIV and AIDS in children through a three-pronged approach of advocacy, program implementation, and research. In each of the 12 countries where we work, clinicians and researchers must be able to access and use data to ultimately improve the health outcomes of the patients we serve. At a global level, we need to ensure not only that we are using country data for better strategic planning and decision making, but EGPAF must also prove to stakeholders and donors that it has the data to back up its work.
Come learn about EGPAF’s Informatics team went from zero to hero through the implementation of Power BI, SharePoint, Azure, and Teams with invaluable assistance from this very community. Learn how we copied the model of user groups by creating our own internal EGPAF Power BI User group that now has over 100 members in 12 countries. Finally, you will learn about how we are implementing our latest project: a global data warehouse in Azure.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, & redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
With the release of SQL Server 2016 Microsoft integrated a solution to the questions above, in-database analytics, allowing you to bring the analytics to your data instead of the other way around. Through in-database analytics we can design, train and score models directly from SQL Server without moving data out and back into the database.
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
With over 350 commands it can be used for instance for migrations, disaster recovery scenarios, troubleshooting, keeping your community SQL scripts up to date, and a lot more. In this session we will take a number of scenarios to show you the power of dbatools.
There will also be an extensive look behind the scenes. We will go into how to install dbatools in a locked down environment, how the centralized logging and error handling works, and even how the dbatools contributor team handles automated testing. After this session you will want to start using dbatools right away when going back to work on Monday!
Event Date: 07-11-2018 10:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 10:45 - Category: General Session (75 minutes) - Track: Big Data and IoT
Event Date: 07-11-2018 10:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Event Date: 07-11-2018 10:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 10:45 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 07-11-2018 10:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
This session is packed with many live examples of tips and tricks gained from years of experience for getting the most performance from your physical and virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure teams so that you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
Event Date: 07-11-2018 12:30 - Category: Marketing Community Session (45 minutes) - Track: Other (Professional Development)
Kevin Kline welcomes both our first-timers and seasoned veterans alike in this introduction to PASS Summit 2018. The session provides attendees with a general overview of the conference and related events.
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
With the growing emergence of IoT, social media and other online, real-time data sources, organizations now have greater opportunity than ever before to leverage new insights through data science to drive better business decisions, speed up organizational response, and increase competitive advantage. However, the challenge for established IT organizations is how to begin to work with these new data pipelines given the current resourcing and skillsets of its team while also keeping an existing data infrastructure based on traditional data sources operating.
Join Douglas Barrett, Senior Solution Architect for WhereScape, as he shares how organizations use automation to leverage streaming data and integrate it efficiently into their existing data landscapes – bypassing much of the inherent complexity and ensuring they will be ready to adapt as technologies change. In the session, Douglas will share:
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 07-11-2018 13:30 - Category: Lightning Talks (75 minutes) - Track: Business Intelligence and Data Warehousing
Sessions and Speakers will include: <ul><li>"Planning your Modeling Career: The Importance of Correct Data Modeling in Power BI, Power Pivot and SSAS Tabular" Paul Turley</li><li>"Q&A about Power BI Q&A" Chris Webb</li><li>"New Data Transformation Capabilities in Azure Data Factory v2" Cathrine Wilhelmsen</li><li>“Integrating PowerApps into PowerBI for Actionable Intelligence” Brian Knight</li><li>“Extending the Capabilities of Power BI by Unlocking the Power of R” Mitchell Pearson</li><ul>
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.
At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Technology is an innovative and exciting area to work in. Working in the tech industry we understand the world and the opportunities around us in a way that many others are yet unable to see without our guidance. We owe it to everyone else to take the lead in this area, so that they can follow our example. Stories from the Trenches is a collection of stories from a diverse group of people who lead the charge, in exemplifying diversity and strength. Our panel discussion will allow you to glimpse their passion and learn some positive ways to deal with the challenges we face in expanding diversity in technology.
Event Date: 07-11-2018 13:30 - Category: MS Tiger Half-Day Session (2.5 hours) - Track: Database Administration and Development
We will also discuss the merits and caveats of following a database compatibility based upgrades along with the tools Microsoft is building to ensure customers have a smoother upgrade and migration experience.
After this session, you will be able to: • Position Database Compatibility as a real alternative to support complex modernization projects as critical moments like 2008 End-of-Life. • Leverage Microsoft SQL Server features and tools to support a DB Compat based upgrade or migration.
Event Date: 07-11-2018 13:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2018 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2018 13:30 - Category: Half-Day Session (2.5 hours) - Track: Cloud Solutions
The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what these options are and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server, including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges of using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration, including workload analysis, selecting the appropriate migration pathway and then putting it in place.
Event Date: 07-11-2018 13:30 - Category: Microsoft Session (75 minutes) - Track: Big Data and IoT
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Application Development
In this session, Lenni describes the various difficulties that developers face, and demonstrates how SSDT can be used to remedy those pain points. You will learn how to use features such as code navigation, IntelliSense, and refactoring with your database model — indispensable tools traditionally available only for application development in Visual Studio. We’ll also cover the declarative model that allows you to design databases offline and under source control, right from within the solution in Visual Studio, as well as how to deploy to SQL Database on Microsoft Azure. Don’t miss out on this demo-centric, information-packed session on the current generation of database tools for application developers!
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
The choice used to be easy. Simply purchase a server or system to host SQL Server and be sure it was configured for the maximum anticipated usage including an annual data growth rate. When performance or availability dropped, go purchase a new system and the cycle continued. Then Cloud technology hit the IT industry like a tsunami! Suddenly management wanted everything to move to the cloud driven as a way to cut the IT budget while offering new services etc. However, customer specific data cannot easily move to the cloud and recent government regulations such as General Data Protection Regulation (GDPR) hold IT management responsible to ensure compliance with stiff penalties applied.
Microsoft responded by developing Azure Stack as a way to run Azure within the customer’s data center providing the same user interface and API’s to enable easy movement of applications between the data center and the cloud. Thus a new infrastructure possibility was born for SQL Server, one that sparks a question over which databases can live in the cloud and is there a possibility to split a database between the cloud and the data center?
This session will first explore the unique value that Cisco’s Unified Computing System (UCS) provides for on premise databases and highlights the benefits that current designs offer and the huge impact that flash storage technologies have had on the industry. We then explore the Azure Stack infrastructure its strengths and weaknesses as related to SQL Server and the key use cases it addresses. These two infrastructures will be compared in an effort to provide you some guardrails to your thinking of these alternatives as you contemplate the road ahead in FY’19 and beyond.
Event Date: 07-11-2018 13:30 - Category: General Session (75 minutes) - Track: Application Development
The secret is often comparing the query plan’s estimated number of rows to actual number of rows. If they’re different, it’s up to you – not the SQL Server engine – to figure out why the guesses are wrong. To improve ’em, you can change your T-SQL, the way the data’s structured and stored, or how SQL Server thinks about the data.
This session won’t fix every query – but it’ll give you a starting point to understand what you’re looking at, and where to go next as you learn about the Cardinality Estimator.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
Amazon Web Services (AWS) has multiple ways to host and support Microsoft SQL Server. This session will review the Relational Database Service (RDS) offering of Microsoft SQL Server as well as using our virtual machine service (Elastic Compute Cloud, or EC2) to host SQL Server database services. We will review options for security, availability, and reliability operations in both offerings and how to choose the optimal solution for your existing and new SQL Server workloads.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Other (Professional Development)
The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? What happens when Bob takes off with one day of notice? How do you manage when Jane unfortunately has to spend a month in the hospital? The only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and new trends in learning and knowledge transfer, the reasons why you should (and shouldn’t) pass on knowledge, and methods for making this happen in your workplace and in your life. Be prepared for an interactive and lively discussion and to walk away with some new concepts that are going to make you think about how you too can become a Master!
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
By subdividing a data set into meaningful groups of islands, we can perform analytics against it that would otherwise be slow, error-prone, or seemingly impossible!
Data clustering can be applied to complex data sets in order to answer questions about winning streaks, financial performance, monitoring/alerting, goal achievement, and more!
Data quality becomes critical when crunching data in this fashion. We address duplicate data, bad data, NULL, and any other unexpected weirdness that a user might throw at us.
This is a fast-paced session that delves into methods that can be applied to any data. A complete set of historical baseball records will be used as our imperfect sample data for everything from a player's hitting streak to the longest winning streak by a team on Wednesdays at night.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Azure Cosmos DB was built from the ground up with global distribution and horizontal scale at its core. It offers turnkey global distribution across any number of Azure regions by transparently scaling and replicating data wherever your users are.
It’s Microsoft’s proprietary globally-distributed, multi-model database service "for managing data at planet-scale".
Perhaps you’ve been looking at adopting Cosmos DB for your application. You’ve provisioned a few collections and read up on RUs. You may have even tested getting data in and out. But do you know what you don’t know?
Microsoft’s Azure Cosmos DB is a great technology choice for many scenarios, yet there are some things you may want to know before you dive in.
Join Quest’s Vice President of Development, Patrick O’Keeffe to explore: • How to provision so that your costs remain reasonable • What to look out for in index policy • How to dig into performance to get the best from your deployment.
In this session, you’ll learn about all the mistakes we’ve made so you won’t have to.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 15:15 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2018 15:15 - Category: Half-Day Session (2.5 hours) - Track: Database Administration and Development
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators don’t wait until the end of the analysis but rather use the entire process as a vehicle to communicate with stakeholders. Please join me in this session to learn the essence of storytelling for advanced analytics.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Application Development
SQL Service Broker (SSB) is a hidden gem included for free in all editions starting with SQL Server 2005. For the right workload, this powerful messaging system is available to help decouple older monolithic processes and free your applications from waiting on long, synchronous processing.
In this session you'll learn what SSB is, how to use it for local database messaging, and why it's different from more popular messaging systems. Learn how to set up your first SSB conversation and hear ideas on how to refactor existing database code. We'll also discuss the most common pitfalls and conclude with a demo using SSB and PowerBI.
Event Date: 07-11-2018 15:15 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
Whether you're a developer or a DBA, whether you do your work on-premises or in the cloud, attend this session to learn how easy it is to write better T-SQL code and save the day, all while working smarter, not harder!
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Scorecards are far from a new thing – beginning primarily with “The Balanced Scorecard” in 1996, what was once a bestselling “hot new idea” has in some sense become a victim of its own success: so thoroughly assimilated into business lore as to be overlooked or discounted as “old school and stodgy.”
But given the advent of agile BI tools such as Power BI, it’s time to consider scorecards in a fresh new light. In this session, Rob Collie will share his firm’s considerable experiences with the intersection of agile BI and scorecarding, explain why the number of high-ROI opportunities is surprisingly high, and why the barriers to entry are surprisingly low. Along the way, he will also share a detailed, real-life case study of an agile scorecard that delivered $100M in ROI.
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, 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, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.
Event Date: 07-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
Come to this session and let's talk facts, real world, best practices and get the low down on what's good and what could be improved. We'll talk about the concept behind this technology, explain where it makes sense, admit where it doesn't make sense and then we'll stop talking about it - and start building and migrating to it. We'll "lift and shift" our "production" instance up there and talk about the user experience along the way. We'll pepper in best practices, and answer your questions about how this works for you.
Come curious about the technology, leave knowing if it makes sense for you and with an idea of how to get started.
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Gartner’s prediction is that citizen data scientists will surpass data scientists by 2019. In this new reality, data integration and data preparation remain the required skillset. Multiple surveys of data scientists back up this statement, highlighting the challenges inherent in something quite routine: cleaning dirty data. Although data manipulation tools such as Dplyr and Pandas are excellent additions to the R and Python libraries, but they will not replace SQL on any enterprise project.
Reproducibility is another area of concern in the data science community—tackling it for years with data linage and gated extract, transform, and load (ETL) processing steps.
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
Attendees will walk away from this session with a solid understanding of what maintenance needs to be performed, how to perform that maintenance and how to automate these maintenance tasks.
Event Date: 07-11-2018 16:45 - Category: MS Tiger Session (75 minutes) - Track: Database Administration and Development
Event Date: 07-11-2018 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
With PowerBI Pro and Azure Analysis services the classical self-service and enterprise BI niches were served. But PowerBI Premium already smeared out the typical boundaries of those perspectives.
Let's recap the development of those services in the recent past and have a close look at the known road map. This will help in identifying business scenarios that ask for one service or another. By this, we can create a kind of decision matrix that will help us for strategic decisions in the future.
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Attend this session for an overview of Biml best practices and coding techniques. Learn how to improve and simplify your solution by using some common and some lesser-known Biml features. If standard Biml is not enough, you can implement custom logic by creating your own C# classes and methods. Finally, see how to bring everything together in an example project for creating and loading a data mart with facts and dimensions.
Start improving your code today and level up your Biml in no time!
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
We'll learn about the flavors of NoSql and then dig down into MongoDB, the NoSQL database that drives many websites. Then we'll get an overview of JavaScript Object Notation (JSON) along with how and why it's used in NoSQL, focusing on its advantages and disadvantages.
You'll see how the SQL table structure compares to the NoSQL data structure. After that, we'll look at examples of storing the same data in both systems and how that data flows to the web page.
We'll discuss the factors that drive your choice of database along with the trade-offs involved. Then we'll wrap up by taking a look at Microsoft's on-premises and cloud efforts in the MongoDB NoSQL space.
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
So if you want to see how within 75 minutes we can learn patterns in streams of data and apply them on live data, be sure to attend this demo-oriented session.
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 08-11-2018 10:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
Mr. Bertucci will discuss an emerging strategy around how to plug a Data Quality as a Service (DQaaS) capability into your emerging data lakes (or current enterprise data architecture) which can best be thought of conceptually as a "data filtration" architecture and takes a "be actionable and design in the solution from the beginning" approach.
As a part of this presentation, Mr. Bertucci will also present a high-tech company's large scale use case and business drivers around using this type of Data Quality as a Service approach and share with the audience the result they realized. A live demonstration of some of the technologies used will be included that will make this "very real" and "very understandable".
Event Date: 08-11-2018 10:15 - Category: Lightning Talks (75 minutes) - Track: Big Data and IoT
Sessions and Speakers will include: <ul><li>"The Internet of Things is Here, Time to Get Paranoid!" Johan Ludvig Brattås</li><li>“3 Reasons Why Your Analytics Solution is a Disappointment” Denise McInerney</li><li>"Azure ETL with Data Factory and Data Bricks" Simon Whiteley</li><li>“High Availability and Tuning in the Cloud” Eric Peterson</li></ul>
Event Date: 08-11-2018 10:15 - Category: MS Tiger Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 10:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then, it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Event Date: 08-11-2018 10:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 10:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 10:45 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
This is done by providing almost 100% surface area compatibility with SQL Server through supporting features such as cross-DB queries and transactions, CLR, SQL Agent, Transactional Replication, Change Data Capture, Service Broker, and more. Even legacy SQL Server systems can now be easily migrated into a managed cloud service, to exploit the benefits of automatic backups, automatic patching and updates, built-in high-availability and disaster recovery, and much more. Thanks to native VNET support, the most stringent security and isolation requirements can be met.
Come and learn why Managed Instance is the best PaaS destination for all SQL Server workloads and how to start your cloud modernization at scale now, using Azure SQL Database Managed Instances.
Event Date: 08-11-2018 10:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
With Microsoft’s announcement that Azure SQL DB Managed Instance would be generally available on Oct. 1, organizations now have a viable alternative to Azure SQL Database that has a high degree of parity with retail on-premises SQL Server. But what is this new technology and how do you get the most out of it? Join us as we explore this new database option looking at key architectural considerations as well as options for moving your workloads from on-premises to Managed Instance. We will look at how SentryOne can help you work through the planning, migration, and operational phases of getting your workloads from your server room and into the cloud.
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 13:30 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 13:30 - Category: Half-Day Session (2.5 hours) - Track: Database Administration and Development
Event Date: 08-11-2018 13:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
That’s easy to say, but a delicate balancing act in practice. Most organizations understandably struggle with big questions on how to even begin. How much business involvement is too much, or too little? Who do you include as authors, and who remains in a consumer role? What kinds of training and policies are required? Do you roll it out all at once, or piecemeal? Above all, how do you prevent the whole thing from devolving into chaos?
Good news: these questions do have relatively simple answers once you see the challenge as a human one, and understand how to blend the right kind of relationships with a properly-tuned underlying tech framework. In this session, Power BI thought leader Rob Collie shares lessons and methodologies developed over 8+ years of consulting with clients specifically in this space.
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 15:15 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 15:15 - Category: Half-Day Session (2.5 hours) - Track: Business Intelligence and Data Warehousing
Managing metadata is one of the most important and time-consuming challenges an ETL developer will face. Simple changes can translate into many hours of discovery, code changes, and testing. However, there are ways to more easily manage this using tools you already have access to, which will ease the burden of SSIS package creation and maintenance. In this demo-packed session, we will discuss ETL metadata management using SSIS and Biml. We will review the challenges posed by “metadata guessing”, and will show a more predictable and robust way by building an end-to-end metadata repository to manage data types, sources and destinations, and transformations.
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.
We will follow the movement of data through batch and speed layers via Azure Data Lake Store & Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Big Data and IoT
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
We’ll start by exploring a few scientific principles and psychology of information, perception and understanding. And, we will explore the fringes of honest and ethical data presentation.
Learn simple techniques to transform your Power BI reports from HMM to WOW in a few easy steps. We will demonstrate how to apply report layouts, graphics and themes to create Goldilocks reports; not too boring or too sexy, but just right for the user audience.
Topics include: • Report visual choices • Using the right chart types • Visualizing geographic data • Making correct color choices • Using templates and layouts • Measuring progress and success • Visualizing key performance indicators
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
In this session, Anu Oladele, Director of Data Science & Business Insights from GoEasy and Joe DeBuzna, VP of Field Engineering—HVR, will discuss how they worked together to architect a solution that enabled GoEasy to achieve real-time business insights and faster loan processing speeds. GoEasy’s business model centers on its ability to make fast decisions on loan applications. This means the company must get necessary data into loan officers, managers, and executives hands as quickly as possible.
The company uses a Software as a Service (SaaS) based loan management system running on SQL Server to track all the loans it books and funds and to manage the lifecycle of each loan. goeasy brings data from the loan management system into a data warehouse, which also runs on SQL Server, to allow business users to report on and analyze the activity and performance of its loan portfolio.
Previously, the loan management system used a daily batch process to download, compress, transform, and load data into the data warehouse. The large size of the database meant that data wasn’t getting through quickly enough, and GoEasy wanted to have the ability to improve its loan turn-around times.
Join this technical session to hear more from Oladele and deBuzna as they discuss the solution architected to enable GoEasy to improve load turn-around times with the use of log-based change data capture. Find out the challenges and considerations needed to for a new architecture and how they made transition from ETL processing to real-time so that teams at GoEasy were working with the most relevant and up-to-date information for decision making.
Event Date: 08-11-2018 15:15 - Category: Half-Day Microsoft Session (2.5 hours) - Track: Big Data and IoT
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.
Topics covered will be: The definition of partitioning. Potential benefits and pitfalls. Overview of partitioning functions and schemes. Table and index design considerations. Splitting and merging partitions. Switching data. Implementing automatic sliding windows. Partitioned tables and filegroup restores.
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Application Development
We will start with a presentation of the main innovative features of Cosmos DB: scalability, high availability, guaranteed throughput and consistency of the solution. A live use case will be performed to demonstrate how to build an end-to-end solution using Cosmos DB, from ingestion to visualization.
The workshop will take place as follows:
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 08-11-2018 15:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.
Event Date: 08-11-2018 15:15 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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, and Power BI. 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 migrate and deploy hundreds of reports to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also solve some pesky ETL tasks: deploying large-scale SSIS solutions, updating parameters for existing packages and streamlining data imports for Power BI Report Server
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
We are back this year with more tips and techniques to improve the performance of SQL Server. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. This presentation will show scenarios of tuning the queries and before and after performance differences.
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up? And many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the SQL Collaborative team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
Event Date: 08-11-2018 16:45 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Database Administration and Development
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.
Event Date: 08-11-2018 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 08:00 - Category: MS Tiger Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Big Data and IoT
Event Date: 09-11-2018 08:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
This is where cognitive API’s come in. By harnessing the power of deep neural networks, we can accurately derive emotional insight from our data and use this to improve our offering to our customers. In this session we will look at the tools needed to connect your data to the right API’s and how we can leverage their capability. Starting out with sentiment analysis we move to facial expression recognition and image tagging.
Attendees will gain the knowledge of how to connect different types of data to appropriate cognitive services. This talk would be of interest to anyone that deals regularly with customer data or has a curiosity toward data science and its application within a business.
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Application Development
Are you developing a microservice or planning to introduce microservices in your organization? Do you want to understand the benefits of embracing the microservice architecture? Do you want to dive deep into the design principles of the microservice architecture?
If the answer to any of the above questions is a Yes, then this presentation is for YOU. Come join me in this 60 min session to learn about how we successfully embraced this modern architecture and made the switch in my organization. By the end of this session, you will have a good understanding of this new architectural style and best practices. You will walk away with better insights about transitioning from monolith to microservices, learning how to build microservices from the ground up and apply within your own organization.
Event Date: 09-11-2018 08:00 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish?
Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Big Data and IoT
This presentation provides a deeper architecture implementation overview of the Microsoft Azure services and Microsoft Data Platform components for IoT that you can use for solution development. In this session we will cover architectural considerations, best practices (common concepts and the context of Microsoft Azure) and implementation guidance for your IoT solution.
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.
Event Date: 09-11-2018 08:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Continuous integration is based around automated builds and tests. Continuous Delivery allows both application developers, database developers and DBAs alike to deploy better quality code/software.
In this DEMO heavy session, we will start off with source code only.
Over the course of 59 minutes we will build a deployment pipeline that starts off with pushing our database and application code to source control. We will utilize Visual Studio Team Services to automate our build and tests and perform Continuous Integration operations.
The output of these operations will be a standardized package of our built solution.
Utilizing PowerShell in the form of Infrastructure as Code, we will spin up multiple Azure based environments that will be deployed to using automated Continuous Delivery processes.
The finished result will be an automated and reliable deployment pipeline that was built under 59 minutes.
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Big Data and IoT
Event Date: 09-11-2018 08:00 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Discover how a leading global educational services company, Kaplan Inc., achieved best practices in database administration in their ever changing and growing industry. Hear directly from Kaplan’s Vice President of Business Systems and Architecture, who will discuss how he partnered with Datavail to augment his team using robust technical discovery, SQL Server Health Checks and assessments, knowledge transfer, runbook documentation, weekly meetings, status updates, and continuous service support and improvement. Hear their challenges and experience real-world examples on how to tackle them.
Event Date: 09-11-2018 09:30 - Category: Half-Day Session (2.5 hours) - Track: Database Administration and Development
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
How does GDPR effect businesses inside and outside of the EU? What is required to do business with EU citizens? There are many questions to address today, and those questions necessitate a reliable and accurate overview of not only your data but of individual customers. MDM addresses this necessity and can serve as the technical basis for GDPR compliance.
In this session, you will obtain:
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
This session will light up your path on what functionality to use and when, even though sometimes one of the Columnstore Indexes does not seem to appear as a default choice for your scenario.
Event Date: 09-11-2018 09:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
In this session you will learn how to develop Intelligent Bots using Azure Bot Service, Cognitive Services and Machine Learning. Through a demo, we will show how to automate a list of FAQs to a Bot with Intelligence added using LUIS and Machine Learning and enhance it with Rich Cards and Attachments.
By the end of the session you will gain enough knowledge to go and automate your FAQs in your organisation to Intelligent Bots and transform the way your organisation interact with your Customers.
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 09-11-2018 09:30 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 09:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 09:30 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 09:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
While having more options is usually a good thing, it can also be pretty confusing. We have Azure SQL Db both single model and elastic pool model, Azure SQL Managed Instance and finally Azure SQL Data Warehouse.
Sometimes the use case for each service will be obvious, other times they might overlap depending on your scenario. In this session we will go over the ideal use cases for each one of these services, decision factors to choose one over the other and go over demos of behavior differences between the offerings.
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
In this demo-heavy session, we will walk through the uses of Windowing Functions, from simple row orders to more complicated calculations like rolling averages. We'll explore each keyword in turn, building more sophisticated functions as we do. Each concept is illustrated in a visual, and SQL example so it is clearly understood.
So whether it's tracking a value against the previous row, creating running totals, or a rolling sum, when you walk out of this session, you'll be able to write a windowing function to make it happen.
Event Date: 09-11-2018 11:00 - Category: Microsoft Session (75 minutes) - Track: Big Data and IoT
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
In this session, we will focus on building an ETL framework while leveraging your SSAS solution’s logical partition design to process only the necessary data within your measure group. We will discuss audit logging, processing options, partition designs and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the database in your DevOps process, covering the entire pipeline from tracking development changes to automated building and integration of changes, to on-demand releases, to ongoing monitoring of your database system.
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Application Development
• Improved LINQ Translation • Owned Entities and Table Splitting • Global Query Filters • DbContext Pooling • String interpolation in raw SQL methods • Explicitly compiled queries • Parameters in entity constructors • Lazy Loading • Value conversions • LINQ GroupBy translation
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
It is essential for an analyst to understand the type of business he or she is dealing with—and find the right dashboard and KPIs to analyze it. In this session we will discuss a self-developed methodology to understand what a business needs to improve in terms of CRM/ERP/BI.
By attending this session you will: • Learn how to inspect any business or company and come up with a list of golden KPIs • Look at some really nice demos from the field! (using Power BI) • Learn how to start thinking about businesses in a “KPI” way
Some of the industries we will going to cover are retail chains, service based business like law firms or project management firms, real-estate (both construction and revenue generating), B2B product businesses (wholesalers), SaaS companies, marketing driven business, and more.
Event Date: 09-11-2018 11:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 11:15 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 09-11-2018 11:15 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 09-11-2018 11:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 11:15 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 13:00 - Category: Marketing Community Session (45 minutes) - Track: Other (Professional Development)
Event Date: 09-11-2018 14:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
During the session, you will see several examples of formulas that lead to unexpected results and learn the unifying theory of evaluation contexts based on expanded tables, filter context operators and blocking semantic. If you are serious about DAX, this session is a real must.
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Application Development
Event Date: 09-11-2018 14:00 - Category: Lightning Talks (75 minutes) - Track: Database Administration and Development
Sessions and Speakers will include: <ul><li>"SQL Server Performance Troubleshooting: Bottom to Top... or Top to Bottom?" Andy Yun</li><li>"How High Is Your Availability?" Allan Hirt</li><li>"The Top Five Things DBAs Need to Know About DevOps" Hamish Watson</li><li>"Evil Indexes Reducing Performance of SELECT" Pinal Dave</li><li>“SQL Server’s Most Wanted: Five Common Vulnerabilities” Ed Leighton-Dick</li><ul>
Event Date: 09-11-2018 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 14:00 - Category: MS Tiger Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 14:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
In this session:
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
In this session I will demonstrate how to use R Studio to generate and test R scripts; generate R visuals in PowerBI; call R code in machine learning workflows; and execute R code in SQL Server. Additionally, I will cover these R programming fundamentals: creating and assigning variables; performing simple calculations; understanding R data types; vectors; matrices; factors; lists; data frames; and ggplot2 graphics.
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
The future of business is data-driven. And no matter what business you are in, machine learning is key to enabling the artificial intelligence (AI)-driven organization. The effective use of machine learning will enable organizations to rapidly build predictive models by extracting the insights locked in large repositories of data from all sources. Machine learning will reduce costs, maximize revenue, improve business outcomes, and optimize operations throughout industry.
However, the majority of organizations are struggling to effectively utilize machine learning. Most companies do not have the skills, tools, or time to develop and deploy conventional machine learning solutions and face difficulties fully staffing their analytics organizations to address critical projects. Innovative organizations are transforming their analytics teams to do more with less and deliver on the promise of AI leveraging a new breed of “automated learning tools”. In this session, we will show how DataRobot’s automated machine learning platform can help you develop and deploy accurate predictive models, discussing challenges, popular techniques and use cases across industries.
Event Date: 09-11-2018 14:00 - Category: General Session (75 minutes) - Track: Database Administration and Development
What exactly does this mean, and what does it do? What are typical use cases, and where could this new feature cause issues? All those questions, and many more, will be answered in this session.
We will also look ahead at what is coming next. What other Adaptive Query Processing features have Microsoft been working on, and when will they be released?
Event Date: 09-11-2018 15:30 - Category: MS Tiger Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Application Development
Learn about INNER JOINS, OUTER JOINS (LEFT, RIGHT and FULL), OUTER JOIN with exclusions, CROSS JOIN. Also find out how multiple INNER JOINS impact your result set versus multiple OUTER JOINS. CROSS APPLY and OUTER APPLY behave much like a JOIN; learn how to quickly understand APPLY and how it can be conceptualized as a JOIN.
By the end of this presentation you will at a minimum be able to answer that common question “explain the difference between an INNER JOIN and an OUTER JOIN”. You will also be ready to write better queries with your more complete understanding to JOIN types.
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
First we will focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing our backups. We’ll also look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.
Then we will move onto how to properly manage an incident and discuss some common examples of corruption. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
Event Date: 09-11-2018 15:30 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Other (Professional Development)
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
Every DBA hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, DBAs are still faced with a slow server. Luckily, there are always some early indicators which can help DBAs predict upcoming issues. Proactively monitoring their database and keeping a vigilant eye on the database key areas are mandatory tasks for all DBAs.
Every DBA who has ever faced performance issues with their application will benefit from this session in which you can expect to learn about the following:
• How to identify inefficient queries • Recognizing queries causing blocking and deadlocks • Analyzing and resolving wait statistics or Analyzing wait statistics and resolutions • How to isolate performance root cause with Workload Analysis • Reviewing predictive performance alerts
Attending this session will give you the knowledge to monitor and diagnose performance tuning issues. You will also walk out with the scripts and knowledge that can be immediately applied to your servers.
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Database Administration and Development
In this session we will introduce and demo 4 methods of encryption available in SQL Server - Backup encryption, Transparent Data Encryption(TDE), AlwaysEncrypted, and connection encryption. The session will cover which of these features is available in each version and edition of SQL Server.
You will leave the session with an understanding of the role SQL Server’s encryption features can play as a part of your overall secure environment.
Event Date: 09-11-2018 15:30 - Category: General Session (75 minutes) - Track: Application Development
The same can be said of databases. Too many users can spoil your security efforts.
Application Roles for SQL Server have been around for a good while, but rarely used. With today’s more strict security and auditing requirements perhaps it is time for a revival. Discover how application logins work and how they can aide you in your security and auditing requirements.