| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Pinal Dave | Database Administration Deployment | Kick Start! SQL Server 2016/2017 Performance Tips and Tricks |
| 09:00:00 | David Alzamendi | BI Platform Architecture, Development Administration | Azure Analysis Services rocks! |
| 09:00:00 | Erland Sommarskog | Cloud/Enterprise Application Development Deployment | When Things go Wrong - Error Handling in SQL Server |
| 09:00:00 | Leila Etaati | Advanced Analytics and Information Delivery | SQL Server 2017 with Python R: On-premises Machine Learning |
| 10:15:00 | Warwick Rudd | Database Administration Deployment | A Beginners Guide to HA/DR |
| 10:15:00 | Dave Dustin | Database Administration Deployment | What do you mean there are no maintenance Windows? |
| 10:15:00 | Reza Rad | Advanced Analytics and Information Delivery | Introduction to DAX |
| 10:15:00 | Edwin M Sarmiento | Database Administration Deployment | The Smart Way to Troubleshoot SQL Server Always On Cluster and Av |
| 11:30:00 | Hamish Watson | Database Administration Deployment | DevOPs and the DBA |
| 11:30:00 | Satya Jayanty | BI Platform Architecture, Development Administration | Flex your data muscles from DBA Workbench |
| 11:30:00 | Phillip Seamark | BI Platform Architecture, Development Administration | Advanced DAX for the SQL Professional |
| 11:30:00 | Mohamed Mawla | Database Administration Deployment | SQL Server on Linux? Yes, Linux! |
| 11:30:00 | Emma Vitz | Advanced Analytics and Information Delivery | Using SQL as the basis for analysis in Python - Walking through an example on Kiwisaver in NZ |
| 13:00:00 | Simon Carryer | BI Platform Architecture, Development Administration | Machine Learning Services in SQL Server, Featuring Dinosaurs! |
| 13:30:00 | Martin Cairney | Database Administration Deployment | Split, Merge and Eliminate - An Introduction to Partitioning |
| 13:30:00 | Ram Katepally | Advanced Analytics and Information Delivery | Azure Machine Learning and its real world use cases |
| 13:30:00 | Arohan Naidoo | BI Platform Architecture, Development Administration | Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub |
| 13:30:00 | Julie Woolner | Cloud/Enterprise Application Development Deployment | GDPR - What is it? Why should I care? |
| 13:30:00 | Edwin M Sarmiento | Database Administration Deployment | What SQL Server DBAs Need To Know About Distributed Availability |
| 14:45:00 | Patrick Flynn | Database Administration Deployment | DBATools! The reason to finally start learning and using Powershell |
| 14:45:00 | Martin Catherall | Database Administration Deployment | Data Privacy and the Data Professional. |
| 14:45:00 | Reza Rad | BI Platform Architecture, Development Administration | Ultimate Security and Sharing in Power BI |
| 14:45:00 | Indira Bandari | Advanced Analytics and Information Delivery | Power BI Report Server Demystified |
| 15:45:00 | Steven Ensslen | Database Administration Deployment | Migrating SQL Server to AWS Cloud |
| 15:45:00 | Anupama Natarajan | Women in Technology | Networking with Women |
| 16:00:00 | Victor Isakov | Database Administration Deployment | Hidden "Gems" in SQL Server 2017 |
| 16:00:00 | Dharmendra Keshari | Database Administration Deployment | Troubleshooting Issues with Extended Events in real time |
| 16:00:00 | Anupama Natarajan | Advanced Analytics and Information Delivery | Real-Time Data Processing - How do I choose the Right Solution |
| 16:00:00 | Brian Bradley | BI Platform Architecture, Development Administration | Introduction to Data Vault |
| 16:00:00 | Phillip Seamark | Advanced Analytics and Information Delivery | MDX Cubes and Azure |
Event Date: 17-02-2018 - Session time: 09:00:00 - Track: Database Administration Deployment
• Adaptive Query Plans • Batch Mode Adaptive Join • New cardinality estimate for optimal performance • Adaptive Query Processing • Indexing Improvements • Introduction to Automatic Tuning This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.
Event Date: 17-02-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
This session will cover fundamentals of using Azure Analysis Services. I will go through the new capabilities of the service and compare it with the SQL Server Analysis Services on-premises.
I will also explain why we should take it into account for our solutions and how to build models in the new service.
Event Date: 17-02-2018 - Session time: 09:00:00 - Track: Cloud/Enterprise Application Development Deployment
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Event Date: 17-02-2018 - Session time: 09:00:00 - Track: Advanced Analytics and Information Delivery
Event Date: 17-02-2018 - Session time: 10:15:00 - Track: Database Administration Deployment
Event Date: 17-02-2018 - Session time: 10:15:00 - Track: Database Administration Deployment
Need to update a schema to support an application change? Since the old versions of the app will still be using the database during update, you can’t do a breaking change until after the new app is rolled out everywhere. How do you do fit index maintenance in when there is constantly a heavy workload? What about backups? In this session we’re going to look at real world problems faced by many organisations and some ways to "work around them"
Event Date: 17-02-2018 - Session time: 10:15:00 - Track: Advanced Analytics and Information Delivery
Event Date: 17-02-2018 - Session time: 10:15:00 - Track: Database Administration Deployment
This session will look at understanding how the underlying WSFC platform works to help us maintain availability of our databases. This is for DBAs and systems administrators who are responsible for administering SQL Server FCIs and AGs but are not so comfortable with figuring out why the databases went offline and what they can do about it. We’ll walk thru the troubleshooting process that I follow to quickly identify and resolve SQL Server FCI and AG availability issues.
Event Date: 17-02-2018 - Session time: 11:30:00 - Track: Database Administration Deployment
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 17-02-2018 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
We need a process and procedure to follow upgrading to SQL Server 2016., let's walk through a high-level upgrade workflow to help us put the process in perspective by breaking down the upgrade process - DBA Workbench.
We will overview live demo with suite of Upgrade Advisor, a single consistent tool that contains three categories of advisors: Upgrade, New Features, and Best Practices, with an extensibility option to add new scenarios over time. A showcase of analyser to go through detailed list of upgrading and features that we have from SQL Server 2016 arsenal.
This session focus is upon what-to-do and what-not-to-do in your data platform upgrade management.
Event Date: 17-02-2018 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
We will create data from thin air and show how you can shape your data model using DAX.
Event Date: 17-02-2018 - Session time: 11:30:00 - Track: Database Administration Deployment
The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well
Event Date: 17-02-2018 - Session time: 11:30:00 - Track: Advanced Analytics and Information Delivery
These questions can be answered using SQL within Python to join summarise data from multiple sources, and subsequently performing some analysis and data visualisation in Python.
KiwiSaver has been around since 2007, but how much do we really know about its impact? Analysing this further requires gathering data from various sources and shaping it so that it is ready to be combined using SQL. The classifications used by different data sources needs to be addressed before choosing appropriate SQL joins.
Once this is done, we can calculate new summary statistics using SQL within Python. These then form the basis of the analysis and visualisation that can be performed in Python.
Event Date: 17-02-2018 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
I wanted to investigate what this would look like in practice, to see if it was a good fit for Xero's use cases.
In this session, I'll give a brief overview of the results of my investigation, demonstrate what using R for machine learning in SQL Server looks like, and give some opinions on how that fits with Xero's needs. And because we're all sick of the usual toy datasets, I'll be using data about dinosaurs!
Event Date: 17-02-2018 - Session time: 13:30:00 - Track: Database Administration Deployment
In this session we'll cover the basics of partitioning - from getting started with partition switching to partition elimination to make your queries go faster - with plenty of demos for you to take away.
Event Date: 17-02-2018 - Session time: 13:30:00 - Track: Advanced Analytics and Information Delivery
This should also get you accustomed to ML concepts like regression, classification, over-fitting, cross validation etc., The goal of the session is to make audience knowledgeable enough to be able to build, deploy and consume a machine learning models easily.
Event Date: 17-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 17-02-2018 - Session time: 13:30:00 - Track: Cloud/Enterprise Application Development Deployment
This legislation comes with painful penalties for those who don't comply. As a data professional, you will need to be aware of its implications for your organisation and the data which it holds.
This is a high-level look at the requirements of and obligations arising from GDPR for application designers and data professionals.
For specific guidance for your company, please seek specialised legal advice. I am not a lawyer. I am only qualified to utter my own opinions.
Event Date: 17-02-2018 - Session time: 13:30:00 - Track: Database Administration Deployment
Event Date: 17-02-2018 - Session time: 14:45:00 - Track: Database Administration Deployment
In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.
With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.
In this session we will look how to download, install and begin using the power within both this module and Powershell.
No prior experience with Powershell required!
Event Date: 17-02-2018 - Session time: 14:45:00 - Track: Database Administration Deployment
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.
Event Date: 17-02-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 17-02-2018 - Session time: 14:45:00 - Track: Advanced Analytics and Information Delivery
This session will cover
• Tips on getting your Power BI Report Server installed • Create a power BI report • Publish the report on the Power BI Report Server
Event Date: 17-02-2018 - Session time: 15:45:00 - Track: Database Administration Deployment
Event Date: 17-02-2018 - Session time: 15:45:00 - Track: Women in Technology
Event Date: 17-02-2018 - Session time: 16:00:00 - Track: Database Administration Deployment
Event Date: 17-02-2018 - Session time: 16:00:00 - Track: Database Administration Deployment
Extended Events were introduced in SQL Server 2008 but by SQL Server 2016, it has enhanced significantly. After this session, hopefully you will start using extended event, if you haven't started using till now.
Event Date: 17-02-2018 - Session time: 16:00:00 - Track: Advanced Analytics and Information Delivery
In this session you will learn about different Real-Time Data Processing solutions on Azure and how to choose the right one for your business problem.
Event Date: 17-02-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
What is it? Why is it interesting? Where can it be used? How is it implemented in SQL Server? This presentation will give you a flavour of Data Vault. It will introduce: The concepts which make up Data Vault; The common tools used for building Data Vaults; How it works in SQL Server; The importance of Data Modelling and how it is structured; Interaction with modern Analytic Tools; Where to go for more information.
Event Date: 17-02-2018 - Session time: 16:00:00 - Track: Advanced Analytics and Information Delivery