| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Chris Seferlis | BI Platform - Architecture, Development, Deployment or Administration | The Modern Data Warehouse and Azure |
| 09:00:00 | Taiob Ali | Enterprise Database - Administration Deployment | New features in Management Studio -- Performance Troubleshooting made easier! |
| 09:00:00 | Chris Hyde | Application, Analytics, Database or ML Development | Python in SQL Server 2017 and 2019 |
| 09:00:00 | Todd Chittenden | Cloud Platform - Architecture, Development, Deployment or Administration | Monitor Your Azure Resources Effectively |
| 09:00:00 | Andy Yun | Application, Analytics, Database or ML Development | Let's Dive Into SQL Server I/O To Improve T-SQL Performance |
| 10:00:00 | Ray Kim | Professional Development or Other | Blogging for Success: Advancing your career by blogging |
| 10:00:00 | Edward Pollack | BI Platform - Architecture, Development, Deployment or Administration | Finding Islands, Gaps, and Clusters in Complex Data |
| 10:00:00 | Matthew Anderson | Enterprise Database - Administration Deployment | Documenting your SQL Server environment with PowerShell |
| 10:00:00 | Reinhard Flügel | Application, Analytics, Database or ML Development | Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics |
| 10:00:00 | Andy Mallon | Enterprise Database - Administration Deployment | Shortcuts from an Impatient DBA |
| 11:00:00 | Christian Cote | BI Platform - Architecture, Development, Deployment or Administration | Feeding the modern data warehouse (Power BI, Azure Data Factory and Databricks) |
| 11:00:00 | Joe Gavin | Enterprise Database - Administration Deployment | We Need To Talk Security |
| 11:00:00 | Bryan Cafferky | Application, Analytics, Database or ML Development | Data Science at Warp Speed with Azure Machine Learning service |
| 11:00:00 | Satya Jayanty | Enterprise Database - Administration Deployment | Modernise your data migration with Azure Data Migration Service |
| 11:00:00 | Andy Yun | Enterprise Database - Administration Deployment | A Beginner's Guide to Seven Practices that Kill Performance |
| 13:00:00 | Deborah Melkin | Application, Analytics, Database or ML Development | Looking "Normal" and Seeing "Stars": Table Designs Working Together |
| 13:00:00 | Andy Mallon | Enterprise Database - Administration Deployment | Demystifying Data Compression |
| 13:00:00 | Paresh Motiwala | Enterprise Database - Administration Deployment | Painlessly Upgrade to SQL 2017 or SQL 2019 |
| 13:00:00 | Surbhi Pokharna | Enterprise Database - Administration Deployment | Will Query Store fix all my Performance Issues? |
| 13:00:00 | John Miner | Application, Analytics, Database or ML Development | Basic Database Design |
| 14:00:00 | Grant Fritchey | Enterprise Database - Administration Deployment | SQL Injection: What Is It, Prevent It, Monitor For It! |
| 14:00:00 | Christian Cote | BI Platform - Architecture, Development, Deployment or Administration | Power BI Report Server for the enterprise |
| 14:00:00 | Jeff Moden | Enterprise Database - Administration Deployment | “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance |
| 14:00:00 | Rayis Imayev | Cloud Platform - Architecture, Development, Deployment or Administration | Continuous integration and delivery (CI/CD) in Azure Data Factory |
| 14:00:00 | George Walters | Enterprise Database - Administration Deployment | Organizational Security Compliance with SQL 2012 through 2016/2017/2019 |
| 15:00:00 | Grant Fritchey | Enterprise Database - Administration Deployment | Extending DevOps To SQL Server |
| 15:00:00 | Thomas Grohser | Professional Development or Other | "Schadenfreude" - Let's enjoy the mistakes other people made... |
| 15:00:00 | Jeff Moden | Enterprise Database - Administration Deployment | “Black Arts” Index Maintenance #2: Better Methods that Can Actual |
| 15:00:00 | Linda Groszyk | Professional Development or Other | Breaking the Social Code: How to be Socially Intelligent at Work |
| 15:00:00 | Bryan Cafferky | Professional Development or Other | Learn or Churn ~ Navigating your Career in 2020 and Beyond |
Event Date: 24-08-2019 - Session time: 09:00:00 - Track: BI Platform - Architecture, Development, Deployment or Administration
Event Date: 24-08-2019 - Session time: 09:00:00 - Track: Enterprise Database - Administration Deployment
Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Event Date: 24-08-2019 - Session time: 09:00:00 - Track: Application, Analytics, Database or ML Development
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Event Date: 24-08-2019 - Session time: 09:00:00 - Track: Cloud Platform - Architecture, Development, Deployment or Administration
Event Date: 24-08-2019 - Session time: 09:00:00 - Track: Application, Analytics, Database or ML Development
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.
Event Date: 24-08-2019 - Session time: 10:00:00 - Track: Professional Development or Other
In this presentation, I'll tell you how I got started with 'blogging, where it's taken me since then, and lessons I've learned along the way. We'll discuss 'blog platforms, how to get started, what to write about, and what to do (and what NOT to do) when writing articles.
Event Date: 24-08-2019 - Session time: 10:00:00 - Track: BI Platform - Architecture, Development, Deployment or Administration
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: 24-08-2019 - Session time: 10:00:00 - Track: Enterprise Database - Administration Deployment
Finding a free and simple method to gather information about my SQL Server environment was difficult. Using a combination of PowerShell, the dbatools module, and a PowerBI report I finally found something that works for me. I hope it can be helpful for you as well.
Event Date: 24-08-2019 - Session time: 10:00:00 - Track: Application, Analytics, Database or ML Development
Event Date: 24-08-2019 - Session time: 10:00:00 - Track: Enterprise Database - Administration Deployment
We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.
Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.
Slides and handouts available on GitHub: http://am2.co/shortcuts-ppt
Event Date: 24-08-2019 - Session time: 11:00:00 - Track: BI Platform - Architecture, Development, Deployment or Administration
Event Date: 24-08-2019 - Session time: 11:00:00 - Track: Enterprise Database - Administration Deployment
This means data security has never been more important which means SQL Server security has never been more important.
We'll take a high level look at security starting with physical security, see the two authentication modes, differences between logins and users, troubleshooting some common login issues, see how to gain access to a SQL Server and wrap up with security similarities and differences between on premise SQL Server and Azure SQL Database.
Event Date: 24-08-2019 - Session time: 11:00:00 - Track: Application, Analytics, Database or ML Development
Event Date: 24-08-2019 - Session time: 11:00:00 - Track: Enterprise Database - Administration Deployment
Azure Data Migration Service (DMS) is here to perform, lift and shift migrations to Azure SQL Database Managed Instance. Not just with migration using GUI, you can perform scripting to scale migration and plan minimal downtime migrations from different data sources to SQL Server.
Let us jump into Database Migration Service, and how you can utilize and modernize your data estate to fully managed services in Azure.
Event Date: 24-08-2019 - Session time: 11:00:00 - Track: Enterprise Database - Administration Deployment
Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.
When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.
Event Date: 24-08-2019 - Session time: 13:00:00 - Track: Application, Analytics, Database or ML Development
In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa.
By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.
Event Date: 24-08-2019 - Session time: 13:00:00 - Track: Enterprise Database - Administration Deployment
Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.
By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Slides materials available at: https://github.com/amtwo/Presentations/tree/master/Demystifying-Data-Compression
Event Date: 24-08-2019 - Session time: 13:00:00 - Track: Enterprise Database - Administration Deployment
This presentation is a part of the event "Modern Data Tour" organized by PASS. In this session we will cover:
Event Date: 24-08-2019 - Session time: 13:00:00 - Track: Enterprise Database - Administration Deployment
Event Date: 24-08-2019 - Session time: 13:00:00 - Track: Application, Analytics, Database or ML Development
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.
Topics are focused on data storage structures, security, and integrity. After this presentation, will be ready to meet that clients need.
Coverage:
1 - Files File Groups 2 - Logins Users 3 - Security using schemas 4 - Database roles for access. 5 - Table design via SSMS or TSQL. 6 - Default, Check, and NULL constraints 7 - Handling table relationships (PK vs FK). 8 - To index or not to index? 9 - Testing database integrity using DML.
Event Date: 24-08-2019 - Session time: 14:00:00 - Track: Enterprise Database - Administration Deployment
Event Date: 24-08-2019 - Session time: 14:00:00 - Track: BI Platform - Architecture, Development, Deployment or Administration
Event Date: 24-08-2019 - Session time: 14:00:00 - Track: Enterprise Database - Administration Deployment
In this 1st of two back-to-back sessions, we'll learn how the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory/disk space, costly/continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance and how it all negatively impacts your code even if it’s perfect code.
We'll also discover the true costs of page splits, how REORGANIZE can perpetuate them, their effect on performance, introduce and learn how to use "sp_IndexDNA" to see indexes as you've never seen them before, and introduce methods to make even active GUID-based indexes 100% fragmentation free for months at a time, which will also fix the problems we’ve discovered.
This 1st session is also a recommended segue into the second sessio
Event Date: 24-08-2019 - Session time: 14:00:00 - Track: Cloud Platform - Architecture, Development, Deployment or Administration
Let's explore how we can use Microsoft DevOps and GitHub to build and release our ADF pipelines to other environments.
Event Date: 24-08-2019 - Session time: 14:00:00 - Track: Enterprise Database - Administration Deployment
Event Date: 24-08-2019 - Session time: 15:00:00 - Track: Enterprise Database - Administration Deployment
Event Date: 24-08-2019 - Session time: 15:00:00 - Track: Professional Development or Other
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"! After a log day, come in and have some fun before the evening event starts
Event Date: 24-08-2019 - Session time: 15:00:00 - Track: Enterprise Database - Administration Deployment
In this 2nd of two back-to-back sessions, we’ll learn the 5 main “Insertion Patterns” and how they cause or prevent fragmentation, introduce the additional page splitting/fragmenting horror of “ExpAnsive Updates”, continue to learn about the true costs of using REORGANIZE and why it should be avoided, how it all affects performance and disk/memory usage, how it all affects Index Maintenance, and steps that can be taken to seriously improve all of that.
We'll also learn that simply reducing Fill Factors isn't the "fix" for fragmentation and can actually cost you serious amounts of additional totally wasted memory while providing little to no value.
Unfortunately, there won’t be time to cover it all but well documented code will be provided to help identify the sources of page splits and “ExpAnsive Updates” so that they can be eliminated.
Session #1 is a strongly recommend prerequisite for this session.
Event Date: 24-08-2019 - Session time: 15:00:00 - Track: Professional Development or Other
If you answered yes to any of these questions, then this session is for you! For many people, “social” does not come naturally and has to be explicitly taught. In this presentation, you will learn about the mindset that is required for developing new competencies, key cognitive skills needed for social success, and tools and strategies that you can use immediately with your team. This session is for people who have difficulty navigating the social world, as well as for their managers.
Event Date: 24-08-2019 - Session time: 15:00:00 - Track: Professional Development or Other