| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:45:00 | Rob Volk | Application Database Development | Tame Your Unruly Data With Constraints |
| 09:45:00 | Anupama Natarajan | Analytics and Visualization | Enterprise Big Data Analytics using Azure Data Lake Storage Gen2 |
| 09:45:00 | Reza Rad | BI Information Delivery | Power BI Basic: Introduction to DAX |
| 09:45:00 | Paul O'Flaherty | Application Database Development | Bring vision to your Apps with PowerApps, Cognitive Services, Flow... and SQL Server |
| 09:45:00 | Kelly Broekstra | BI Information Delivery | Improved data models; what you need to increase the usability and speed of Power BI reports |
| 11:00:00 | Steve Jones | Application Database Development | Always Encrypted in SQL Server |
| 11:00:00 | Indira Bandari | Analytics and Visualization | Top 10 tips every Power BI developer should know |
| 11:00:00 | Warwick Rudd | Enterprise Database Administration Deployment | Azure Data Studio – The New Frontier |
| 11:00:00 | Yingying Myra Ma | Cloud Application Development Deployment | Azure Data Factory - An overview of modern data integration service in the cloud |
| 11:00:00 | Hamish Watson | Enterprise Database Administration Deployment | SQL Server 2019 - Modern Migration Tour Part 1 |
| 12:45:00 | Anderson Rangel | Strategy and Architecture | Provisioning Dev/Test environments efficiently (speed/storage) whilst protecting your data |
| 12:45:00 | Warwick Rudd | Enterprise Database Administration Deployment | Configuring your SQLServer optimally on VMWare |
| 13:30:00 | Manjot Kaur | BI Platform Architecture, Development Administration | The Massively Parallel Processing Azure SQL Data Warehouse |
| 13:30:00 | Kevin Kline | Application Database Development | Ten Query Tuning Techniques Every SQL Programmer Should Know |
| 13:30:00 | Martin Catherall | Cloud Application Development Deployment | Looking at the Cosmos(DB) |
| 13:30:00 | Tejaswi Datla | Strategy and Architecture | Survival Techniques for Lone DBA |
| 13:30:00 | Hamish Watson | Enterprise Database Administration Deployment | SQL Server 2019 - Modern Migration Tour Part 2 |
| 14:45:00 | Craig Ryan | Application Database Development | It's a Trap! SQL Server Gotcha’s |
| 14:45:00 | Martin Cairney | Enterprise Database Administration Deployment | Smart Alerts in SQL DB using Automation and Logic Apps |
| 14:45:00 | Manohar Punna | Strategy and Architecture | Bridging the gap between SSRS and Power BI |
| 14:45:00 | Greg Low | Professional Development | Technologies to Watch: A Gaze into Greg's Crystal Ball |
| 14:45:00 | Marsha Pierce | Enterprise Database Administration Deployment | Virtualizing SQL Server |
| 16:00:00 | Patrick Flynn | Enterprise Database Administration Deployment | dbatools 1.0 - Updated, Cross Platform and ready for Production use. |
| 16:00:00 | Rob Douglas | Strategy and Architecture | Demystifying Encryption |
| 16:00:00 | David Alzamendi | Cloud Application Development Deployment | Fundamentals of Blockchain Azure Blockchain Workbench |
| 16:00:00 | Heidi Hasting | BI Platform Architecture, Development Administration | MDS from the ground up - let your users maintain their data? |
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
In this session you will learn • How to ingest structured and unstructured data into Azure Data Lake Storage Gen2? • How to access Azure Data Lake Storage Gen2 data with Azure Data Bricks using Spark? • How to secure data in Azure Data Lake Storage Gen2? At the end of the session you will learn how to implement end to end Analytics for a modern Data Warehouse using Azure Data Lake Storage Gen2.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: BI Information Delivery
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
The session will give an overview of setting up the services and the code required to build AI-powered Apps (step by step guides are available in the accompanying YouTube video series).
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: BI Information Delivery
To ensure great usability, performance, adaptability and scalability, you need to apply some basic data modelling practices to your Power BI models. In this session, we will discuss: • How to interpret business peoples requirements to conceptualise the model • Planned development with tables structured in a star schema • Organisation-wide conformed dimensions • Moreover, how to apply all this theory to your actual models
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this demo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Big data requires service that can orchestrate and operationalise processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is the perfect cloud ETL or ELT tool for those complex hybrid business data scenarios. The session will walk you through an Azure Data Factory overview of WHY-WHAT-HOW process. All levels of technical backgrounds are welcome.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy. But, do you have a plan in place? What approach should you take to ensure a smooth transition? To guide you through these questions, PASS, Microsoft, and Intel® have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. Please register at:
https://www.eventbrite.ca/e/modern-migration-tour-2019-christchurch-new-zealand-tickets-62009350637
Event Date: 08-06-2019 - Session time: 12:45:00 - Track: Strategy and Architecture
We also need to make sure that this process is performed as quickly as possible and at the same time ensuring that it uses the least amount of storage.
With the effective usage of virtualization and data masking capabilities, provisioning full copies of protected databases takes a few seconds and saves up to 99% disk space. SQL Provision helps create, protect and manage SQL Server database copies for compliant DevOps without increasing the risk of a data breaches.
On this session we will learn how to:
SQL Provision supports database DevOps while keeping compliance central to the process.
Event Date: 08-06-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-06-2019 - Session time: 13:30:00 - Track: Application Database Development
Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.
Attend this session to take your query writing and query tuning skills to the next level!
Event Date: 08-06-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
In this session we’ll take a look at this technology and learn how it might be useful – either now or in the future.
Event Date: 08-06-2019 - Session time: 13:30:00 - Track: Strategy and Architecture
Event Date: 08-06-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy. But, do you have a plan in place? What approach should you take to ensure a smooth transition? To guide you through these questions, PASS, Microsoft, and Intel® have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. Please register at:
https://www.eventbrite.ca/e/modern-migration-tour-2019-christchurch-new-zealand-tickets-62009350637
Event Date: 08-06-2019 - Session time: 14:45:00 - Track: Application Database Development
In this session we’ll look examples of these performance "landmines" and show how they can be avoided.
This session is for anyone who writes TSQL or has to troubleshoot SQL performance .
Event Date: 08-06-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Fortunately there's options available to get over this hurdle such as Azure Automation which can be used as a scheduling engine to run PowerShell or Python scripts to perform your tasks. However, Azure Automation Runbooks can also be triggered from Azure SQL DB alerts.
This session will introduce Azure Automation, from a basic manually executed Runbook to an alert-driven responsive utility that can save you considerable effort.
We'll then take our Alert responses a step further and use them to trigger an Azure Logic App workflow. Azure Logic Apps provide a robust workspace with built-in scalability and retry logic for your workflow along with many connectors which can expand the response to your alert.
Imagine capturing an Alert, performing remedial action, logging the issue response in your ticketing system and switching on the kettle for a cuppa while Azure does all the work.
Event Date: 08-06-2019 - Session time: 14:45:00 - Track: Strategy and Architecture
Event Date: 08-06-2019 - Session time: 14:45:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
In February 2019 the production ready 1.0 release is expected.
With more than 500+ commands, a comprehensive help system and coverage for almost all core Dba tasks knowledge of this PowerShell module should be required for any database professional that needs to use or support one or more SQL Server instances
In this session we will take a short look at the history of the module but will spend majority of time in examples of how it can be used to solve many common Database management tasks.
No prior experience with Powershell required!
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Strategy and Architecture
In this session we'll talk about the various ways you can implement Encryptian natively within SQL Server - with Backup Encryption, Transparent Data Encryption(TDE), AlwaysEncrypted, and connection encryption
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
This session will provide you with the answers for each one of these questions. We will jump into Azure Blockchain Workbench to learn about this cloud service, its key benefits and the basics to start your journey as a blockchain developer.
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Eliminate data sprawl, while using the same tools business users already love - Excel! Let's talk about how MDS puts data management in the hands of those who understand the data best. Areas covered will include;