| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 06:00:00 | David Patrick | BI Platform Architecture Administration | Intro to Power BI |
| 06:00:00 | Amit R S Bansal | Enterprise Database Administration Deployment | How to Troubleshoot a Slow Running Query in SQL Server |
| 06:00:00 | Joshua Higginbotham | BI Platform Architecture Administration | Common ETL Patterns using Azure Databricks |
| 06:00:00 | Ben Weissman | Enterprise Database Administration Deployment | SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything |
| 06:00:00 | William Assaf | Learning, Certification and Career Development | Certification Exams Inside Out |
| 06:00:00 | Edward Pollack | Application Database Development | Dynamic SQL: Writing Efficient Queries on the Fly |
| 06:00:00 | Wagner Crivelini | BI Development, Modeling and Visualization | First Steps to Work with Graphs in AZURE SQL DB |
| 06:00:00 | Dennes Torres | Enterprise Database Administration Deployment | SQL Server 2019: More Intelligent than ever |
| 07:30:00 | Steve Jones | Application Database Development | A Tour of Azure DevOps and TFS |
| 07:30:00 | Andrea Mascher | Learning, Certification and Career Development | SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1 |
| 07:30:00 | David Klee | Enterprise Database Administration Deployment | 10 Cloudy Questions to Ask Before Migrating Your SQL Server |
| 07:30:00 | Deepthi Goguri | Enterprise Database Administration Deployment | SQL Engine: Its Working Style |
| 07:30:00 | William Assaf | BI Development, Modeling and Visualization | Ethics in Modern Data |
| 07:30:00 | Hugo Kornelis | Tuning and Optimization | Execution plans ... where do I start? |
| 07:30:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | Azure SQL Managed Instance - Experiences from the Field |
| 07:30:00 | Adam Saxton | BI Platform Architecture Administration | Power BI QA/AMA with GuyInACube Microsoft Leaders |
| 09:00:00 | David Klee | Enterprise Database Administration Deployment | Modern SQL Server CPU Architectures for Performance |
| 09:00:00 | Jared Poché | Enterprise Database Administration Deployment | Every Millisecond Counts |
| 09:00:00 | Reid Havens | BI Development, Modeling and Visualization | Guiding User Experiences With Advanced Reporting Features |
| 09:00:00 | Rui Romano | BI Platform Architecture Administration | Power BI Tips, Tricks Hacks from the Trenches |
| 09:00:00 | Rob Sewell | Enterprise Database Administration Deployment | Jupyter Notebooks for DBAs |
| 09:00:00 | Wagner Crivelini | Cloud Application Development Deployment | Implementing Cryptography in AZURE SQL DB with Geo-Replication |
| 09:00:00 | Dennes Torres | BI Platform Architecture Administration | Why Synapse Analytics is beyond Azure SQL Datawarehouse |
| 09:00:00 | Vern Rabe | Application Database Development | Proper Data Type Usage=Guaranteed Better Performance and Accuracy |
| 16:00:00 | Jason Horner | BI Platform Architecture Administration | Real-World Data Movement and Orchestration Patterns using Azure Data Factory |
| 16:00:00 | Rahat Yasir | Application Database Development | Automated machine learning with Azure AutoML |
| 16:00:00 | Javier Villegas | Enterprise Database Administration Deployment | Monitoring SQL Server using Community solutions (Free) |
| 16:00:00 | Patrick Gallucci | Cloud Application Development Deployment | Build a Complete Azure Data Platform in 1 Hour |
| 16:00:00 | Erin Dempster | Application Database Development | Navigating Row Level Security |
| 16:00:00 | Rie Irish | Enterprise Database Administration Deployment | 10 DBA Tasks for Azure SQL: Whats Different from On-Prem |
| 16:00:00 | Paul Turley | BI Development, Modeling and Visualization | Data Modeling Solutions for Challenging BI Data Modeling Problems |
| 16:00:00 | Ondrej Aubrecht | Learning, Certification and Career Development | Can you trust the intelligence of Application tracking systems with your CV? |
| 17:30:00 | Andrew Kalik | Application Database Development | Python: Turn your SQL ETL up to 11 |
| 17:30:00 | Tracy Boggiano | Learning, Certification and Career Development | Mental Health in IT: Safeguarding our most precious resource |
| 17:30:00 | Ramesh Satya | Application Database Development | Understanding SQL Server Views - The Right Way |
| 17:30:00 | Julie Koesmarno | Enterprise Database Administration Deployment | Notebooks 101 for SQL People |
| 17:30:00 | Mark Runyon | Learning, Certification and Career Development | The Countless Benefits of Mentoring |
| 17:30:00 | Michael McKinley | BI Platform Architecture Administration | Basic Data Modeling for BI Reporting |
| 17:30:00 | Will Velida | Cloud Application Development Deployment | Developing Cosmos DB for the Enterprise |
| 17:30:00 | Jamey Johnston | Advanced Analysis and Machine Learning | Power BI dataflows and How to Leverage for Data Science |
| 19:00:00 | Kevin Boles | Tuning and Optimization | Common TSQL Mistakes |
| 19:00:00 | Ramesh Satya | Application Database Development | Understanding NULLs in SQL Server |
| 19:00:00 | Gaston Cruz | BI Platform Architecture Administration | New waves to Processing Tabular Models |
| 19:00:00 | Harry Chandra | Enterprise Database Administration Deployment | Intro to PowerShell for the DBAs |
| 19:00:00 | Armando Lacerda | BI Platform Architecture Administration | Azure Synapse back to back |
| 19:00:00 | Itshak David | Application Database Development | Data virtualization with SQL Server 2019 PolyBase and integration with Power BI . |
| 19:00:00 | Matt Gordon | Learning, Certification and Career Development | From Stutterer to Speaker: Overcoming Your Fears |
| 19:00:00 | Scott Klein | Enterprise Database Administration Deployment | The ins and outs of securing SQL Server traffic |
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment
This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS and Spark!
In this session we are going to explore the capabilities of the exciting new feature. How does it work and how can we work with datasets that are non-relational?
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Learning, Certification and Career Development
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Application Database Development
This is an often misunderstood tool that is underused in areas where it can provide immense value or abused by applications that it was never intended for. Well-written dynamic SQL can solve seemingly impossible problems while being easy to read and understand.
Applications that will be demonstrated include: mapping database relationships, schema searching, generating large volumes of TSQL, and much more. Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it!
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Development, Modeling and Visualization
Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment
What is it? What benefits it brings to us? What's the relation with Adaptive Query Processing, from SQL Server 2017?
Attending this session you will discover these answers and more
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Application Database Development
In this session we will look at the integration of work tracking with Scrum templates and Kanban boards with version control for your code. We will discuss and demonstrate pull requests to help manage the flow of work within a team and explain the build, test, and release tools available for your database and application code.
At the end of this session, attendees will be more comfortable getting started with their own project in Azure DevOps and using the tools with their own team.
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Learning, Certification and Career Development
This session will cover key concepts in DEI and how they apply to data practitioners.
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Enterprise Database Administration Deployment
Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: BI Development, Modeling and Visualization
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Tuning and Optimization
But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Cloud Application Development Deployment
Event Date: 24-10-2020 - Session time: 07:30:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
This session is a case study on improving a procedure that runs 350 million times per day, so any improvement is greatly magnified. We will discuss where we found opportunities to improve a procedure running in 3.1 milliseconds; how effective our attempts were, what didn't work, and the results achieved.
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Development, Modeling and Visualization
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Platform Architecture Administration
This session is a collection of my top tips, tricks hacks gathered over the years from simple tips to advanced hacks to boost your productivity.
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
I will share with you all of the knowledge I have gained over the past 12 months implementing Jupyter Notebooks for Data Operation teams.
You will leave
Enabling collaboration with your team, simplifying common tasks, improving Incident Wash-Up meetings, creating run-books, easily creating code for others to use are some of the benefits that you will take away. We will have fun as well.
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Application Database Development
In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: BI Platform Architecture Administration
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
Patrick Gallucci will share a service delivery approach that helps organizations move large and small data platforms to Azure. He will show you how to leverage proven cloud adoption methodologies, tools, resources, and best practices to enable your organization to simplify and accelerate their move to the cloud.
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: BI Development, Modeling and Visualization
Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Learning, Certification and Career Development
This session will answer some of the unspoken questions: - Can you trust ATS with your CV ? - Can ATS analyse your Resume correctly (with Real examples) ? - How ATS works?
Come along to this session and find out more about REAL DATA analysis and scanning mechanism by multiple ATS used in the job market and to find out if you can trust AI with your own CV.
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Application Database Development
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Learning, Certification and Career Development
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Application Database Development
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Enterprise Database Administration Deployment
The lack of rigor in being able to reproduce analysis in business context or to reproduce data troubleshooting can lead to confusion and time wasted on work that had been previously done. With Notebooks, Data Professionals can share their techniques and data sources used for the data analysis or troubleshooting for code review and reproducible insights/troubleshooting.
Azure Data Studio Notebooks support SQL and KQL natively with intellisense; with easy to use charting capabilities. With Notebooks and Jupyter Book (collection of Notebooks) in Azure Data Studio, it’s also easy now for your team to build an onboarding guide (user manual) / documentation on data sources, useful sample scripts and tutorials.
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Learning, Certification and Career Development
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: BI Platform Architecture Administration
In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do.
In this session, we will review how tools like Power BI work under the covers and how that impacts the way we construct our data models. This is an introductory level course, so we will not get too technical, just enough to get us to the next level and moving back up that learning curve!
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Cloud Application Development Deployment
In this session, I'll cover important topics that you'll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.
By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.
Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Advanced Analysis and Machine Learning
This session will show how to use dataflows, setup Azure Data Lake Services gen 2 and dataflows and how to connect to the resulting data in the Azure Data Lake Services gen 2 to do Data Science with tools like Azure Databricks.
This session will use real data and analytics to demonstrate Power BI dataflows, Azure Data Lake Services gen2 and Azure Databricks utilizing DAX, M and Python.
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Tuning and Optimization
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Application Database Development
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: BI Platform Architecture Administration
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Application Database Development
• Installing and Configuring PolyBase Windows Linux • Connecting to Hadoop • Using Predicate Pushdown to Enhance Query Performance • Packet Capture With\Without Predicate Pushdown • When to use Predicate Pushdown • Limitations on Pushdown with Complex Filters • Built-In Integrations: Oracle, MongoDB , Radis and More Integrating via ODBC : Apache Spark , Apache Hive, Microsoft Excel Monitor PolyBase with Dynamic Management Views . • PolyBase Query Tuning , Execution Plans and Statistics PolyBase Scenarios : ETL VS ELT jobs This is a demo session only with minimum theory lessons from the fields !
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Learning, Certification and Career Development
Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Enterprise Database Administration Deployment
While there are multiple levels of security (securing data at rest, data in traffic, etc.), this session will focus on securing data that is on the move; ie., securing traffic between a client and server. We'll discuss and look at two solutions: Certificates and IPsec, exploring them in detail, outlining the pros and cons of each, how to set up and configure them, and when to use what.