| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Julie Koesmarno | Enterprise Database Administration Deployment | What's new in SQL Server Tools? |
| 08:30:00 | Gilbert Quevauvilliers | BI Platform Architecture, Development Administration | How I reduced my actual Power BI Dataset by a whopping 60% |
| 08:30:00 | Andy Mallon | Application Database Development | When to use Indexing Pro Features |
| 08:30:00 | Arvind Shyamsundar | Cloud Application Development Deployment | DevOps for Azure SQL |
| 09:45:00 | Daniel Marsh-Patrick | Analytics and Visualization | Practising Safe Custom Visuals |
| 09:45:00 | Angela Henry | Enterprise Database Administration Deployment | Intro to Azure Data Catalog |
| 09:45:00 | Greg Low | Application Database Development | The lowdown on character data types in SQL Server |
| 09:45:00 | Ginger Grant | Analytics and Visualization | Creating Modern Data Platform with Azure Synapse Workspace |
| 11:00:00 | Alice Drummond | BI Information Delivery | Top 10 Power BI Data Storytelling Techniques - An Environmental Story |
| 11:00:00 | Martin Cairney | Other | Data Classification and Masking: the What and How of Data Protection |
| 11:00:00 | Bob Pusateri | Cloud Application Development Deployment | Dipping Your Toes In: Azure Data Lake for DBAs |
| 11:00:00 | Hamish Watson | Other | Successfully Virtualizing SQL Server on VMware vSphere: Straight from the Source |
| 12:15:00 | Zoran Barac | Enterprise Database Administration Deployment | Migration path from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS) |
| 12:15:00 | Kevin Feasel | Application Database Development | Data Virtualization with PolyBase |
| 12:15:00 | Reid Havens | BI Platform Architecture, Development Administration | Performance, Optimization, and Intelligent Error Handling in Power Query |
| 12:15:00 | Rob Farley | Professional Development | Breaking the fourth wall to connect with your audiences |
| 13:30:00 | Patrick Flynn | Enterprise Database Administration Deployment | Get Comfortable with Query tuning and Execution Plans |
| 13:30:00 | Will Velida | Cloud Application Development Deployment | Developing Cosmos DB for the Enterprise |
| 13:30:00 | Kelly Broekstra | BI Platform Architecture, Development Administration | Lessons learnt to improve the durability of PowerBI reports |
| 13:30:00 | Martin Catherall | Application Database Development | Exploring Window Functions |
| 14:45:00 | Craig Bryden | BI Platform Architecture, Development Administration | Paginated Reporting with Power BI |
| 14:45:00 | Jason Brimhall | Application Database Development | Bare Naked Skinny on SQL Server |
| 14:45:00 | Victor Isakov | Strategy and Architecture | Architecting Microsoft Azure Data Platform Solutions Correctly |
| 14:45:00 | Anupama Natarajan | Advanced Analysis Techniques | DevOps for AI Applications |
| 16:00:00 | Christian Borovac | BI Information Delivery | Exploring the ‘people’ element of a Power BI project – its more than just data!! |
| 16:00:00 | Ben Weissman | Enterprise Database Administration Deployment | SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything |
| 16:00:00 | Rob Sewell | Enterprise Database Administration Deployment | Jupyter Notebooks for DBAs |
| 16:00:00 | Anderson Rangel | Application Database Development | DevOps for Databases: 10 steps to failure |
Event Date: 30-05-2020 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-05-2020 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
The session will cover the following topics:
- Real world optimizations that you can put into practice
- Best practice design with data modelling with the Star Schema
- Looking at your columns and data types and how this affects the size of your dataset
- How to use DAX Studio for the analysis of your datasets
Event Date: 30-05-2020 - Session time: 08:30:00 - Track: Application Database Development
Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.
We won't only talk about what these options are, we'll also cover how and when to use these different indexing options, and how to make sure you have enough--but not too many--indexes for your workload.
Event Date: 30-05-2020 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Come to this session to learn how to use tools like Visual Studio, Azure DevOps, git, build and release pipelines, etc. for a first-class, modern, and easy-to-use database DevOps experience when working with Azure SQL. You will leave the session equipped with the knowledge and
Event Date: 30-05-2020 - Session time: 09:45:00 - Track: Analytics and Visualization
While you should ideally be able to trust that custom visuals are improving your ability to tell your data story, it’s often worth knowing exactly what these can and can’t do with respect to your data so that you can make informed decisions around the right ones to use.
In this session, we’ll talk about considerations to make when selecting custom visuals for your reports, what potential pitfalls to look out for when evaluating them (including demonstration of a “black hat” custom visual), and how to manage usage policies for custom visuals by your users at an enterprise level.
Event Date: 30-05-2020 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-05-2020 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 30-05-2020 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 30-05-2020 - Session time: 11:00:00 - Track: BI Information Delivery
Event Date: 30-05-2020 - Session time: 11:00:00 - Track: Other
However, copies of data used in dev/test or in analytics need to be an accurate representation of the primary data so omitting, or doing a simple replacement of sensitive values, may skew any results.
This session will introduce tools and processes that can be used to help protect your data. It will firstly show how the Data Classification utility in SSMS and SQL Server can identify and categorize your sensitive data. We will then see how Data Masking can be used to either hide sensitive data from selected users or to completely replace specific classifications of data with new values that both protect the source and also ensure that the distribution of data values remains consistent for your test environments.
Event Date: 30-05-2020 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Event Date: 30-05-2020 - Session time: 11:00:00 - Track: Other
• vCPU allocation and deep dive in vNUMA • Memory allocation and configurations options • Storage configuration best practices including PMem/NFS/Snapshots • Network configuration myths and best practices
If all that you want to know about virtual platform configuration but hesitated to ask!
Event Date: 30-05-2020 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment
DMA (Assessment), DEA (Capture the trace / Replay the trace / Analyze), DMS (Migrate database)
Data Migration Assistant (DMA) Use DMA tool to detect potential compatibility issues which may impact database functionality after migration to Azure SQL managed Instance.
Database Experimentation Assistant (DEA) Evaluate targeted version of SQL Server instance for a specific workload, in this example Azure SQL Managed Instance. Create workload from the source SQL Server Instance using Extended Events XEL trace, replay that workload against the targeted Azure SQL Managed Instance, and then create report and analyze those two traces.
Azure Database Migration Service (DMS) Use Azure DMS as end-to-end solution for migrating source SQL Server databases to the cloud, in this example from SQL Server Instance on Azure VM (IaaS) towards Azure SQL Managed Instance (PaaS).
Event Date: 30-05-2020 - Session time: 12:15:00 - Track: Application Database Development
Event Date: 30-05-2020 - Session time: 12:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 30-05-2020 - Session time: 12:15:00 - Track: Professional Development
Event Date: 30-05-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Central to ability to tune queries is an ability to use information provided from Execution plans, DMVs, Query Store and Extended Events.
In this demo based session we will look into:
Attendees will leave with an understanding of possibilities of turning queries and a roadmap for further learning.
This session will assume a basic knowledge of T-SQL and execution plans.
Event Date: 30-05-2020 - Session time: 13: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: 30-05-2020 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
The good news is, there are a few different ways to enable this growth and durability and still use the Power BI features that everyone loves. Join us for lessons learnt, demos and a discussion about moving to Power BI Premium, redesigning your data model, incremental refreshes and composite models. We will cover the pros and cons of each option and why each could be your saviour.
Event Date: 30-05-2020 - Session time: 13:30:00 - Track: Application Database Development
They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may - at first - seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.
Event Date: 30-05-2020 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
In this session, Craig will discuss the various options available for implementing paginated reports in the cloud and/or on-premises using Power BI. We will explore this in depth from all angles so that you can come away understanding these options and implications.
Event Date: 30-05-2020 - Session time: 14:45:00 - Track: Application Database Development
Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.
In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.
Event Date: 30-05-2020 - Session time: 14:45:00 - Track: Strategy and Architecture
Event Date: 30-05-2020 - Session time: 14:45:00 - Track: Advanced Analysis Techniques
In this session you will learn how to build a Continuous Integration pipeline step by step for an AI Application using Azure DevOps.
Event Date: 30-05-2020 - Session time: 16:00:00 - Track: BI Information Delivery
Event Date: 30-05-2020 - Session time: 16: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: 30-05-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Spend a day with me, and 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: 30-05-2020 - Session time: 16:00:00 - Track: Application Database Development
In this session, we’ll use reverse psychology to evidence the steps that will inevitably cause us to fail database DevOps - so we can avoid it! By knowing what to NOT do, the path becomes clearer, leading your business and your career to a higher ground.