| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Anupama Natarajan | BI Information Delivery | Empowering your Business with Measure (Power BI), Act (Powerapps) and Automate (Flow) Tools |
| 09:00:00 | Warwick Rudd | Enterprise Database Administration Deployment | A Beginners Guide to HA/DR |
| 09:00:00 | Warwick Rudd | Enterprise Database Administration Deployment | An Introduction to SQL Server 2017 |
| 09:00:00 | Murilo Miranda | Cloud Application Development Deployment | Patterns For Building Hybrid Scenarios With SQL Server And Azure |
| 10:15:00 | David Alzamendi | BI Platform Architecture, Development Administration | Azure SQL Data Warehouse for beginners |
| 10:15:00 | Martin Catherall | Application Database Development | Get Asynchronous - Build your first Service Broker application |
| 10:15:00 | Leila Etaati | Analytics and Visualization | Endless Possibilities: R and Power BI |
| 11:30:00 | Vitor Fava | BI Platform Architecture, Development Administration | Stretch Database - Historical data storage in SQL Server |
| 11:30:00 | Manjot Kaur | Enterprise Database Administration Deployment | SQL server Operational Validation with Powershell |
| 11:30:00 | Karen Lopez | BI Platform Architecture, Development Administration | The Tricky Part of Doing Tricky Things in your Database |
| 13:30:00 | Phillip Seamark | BI Platform Architecture, Development Administration | Advanced DAX for the SQL Professional |
| 13:30:00 | Dave Dustin | Application Database Development | Graph Databases on SQL Server |
| 13:30:00 | Martin Catherall | BI Platform Architecture, Development Administration | Dip your toe into analytics and data warhousing |
| 13:30:00 | Reza Rad | BI Platform Architecture, Development Administration | 10 Amazing Things About Power BI You Don't Know |
| 14:45:00 | Hamish Watson | Enterprise Database Administration Deployment | DevOPs and the DBA |
| 14:45:00 | Craig Bryden | Application Database Development | Visual Studio SQL Server Database Projects and integrating into VSTS |
| 14:45:00 | Michael van Halderen | Enterprise Database Administration Deployment | Managing VLDB’s in SQL Server. Challenges and tips for managing multi-Terabyte databases. |
| 16:00:00 | Indira Bandari | Analytics and Visualization | Predictive Analysis using R in SQL Server 2016 |
| 16:00:00 | Karen Lopez | Enterprise Database Administration Deployment | DBA and DEV Panel Discussion |
| 16:00:00 | Reza Rad | Advanced Analysis Techniques | BI and Analytics Panel Discussion |
Event Date: 02-09-2017 - Session time: 09:00:00 - Track: BI Information Delivery
a) What is Microsoft Business Application Platform? b) What is Flow and how to use it for automation? c) What is Powerapps and how to create an app without writing code? d) How to create an business application using Flow, Powerapps and Power BI?
Event Date: 02-09-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-09-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
From Analytics, Availability, Configuration and Performance there is something for everyone in this session to introduce you to the latest version of SQL Server.
Event Date: 02-09-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost.
In this demo-heavy session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure. SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds.
Key Learning: Integrating SQL Server and Azure Scaling on-premises SQL Server using Azure Extending on-premises to the cloud
Demos: The demo will demonstrate some of the
Event Date: 02-09-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
This session will cover the fundamentals of using Azure SQL Data Warehouse. From a beginner's perspective, the benefits of using this product will be discussed, as well as pricing measurements and the differences from Azure SQL Database and Big Data.
I will explain how to deploy this service in only a few minutes by using some of the latest features such as extracting data from Azure Data Lakes and Azure Blob Storage through PolyBase.
Event Date: 02-09-2017 - Session time: 10:15:00 - Track: Application Database Development
However, Service Broker is possibly one of the least used components of SQL Server despite debuting in the product in 2005. This session will aim to demystify Service Broker and introduce people to some of the major benefits that it offers. We’ll build a full application which will demonstrate just how easy it is to get up and running with this technology. This session is aimed at people with little to no Service Broker knowledge and aims to show how applications can be easily created with Service Broker. You should leave this session with enough knowledge to then take your Service Broker skills to the next level and be capable of handling more complex projects.
Event Date: 02-09-2017 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 02-09-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 02-09-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-09-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
We'll demo tricks that we've seen in our database design reviews and show you how they work and talk about the trade offs for using them. You' learn about: Building a database engine inside your database, Implementing Hierarchies, Dealing with data structures that don't do as well in RDBMSs, Generating code out of the database, Optimizing the developer versus the data or the app, Using design patterns that don't reflect modern architectures and tools, and a lot more.
Event Date: 02-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 02-09-2017 - Session time: 13:30:00 - Track: Application Database Development
SQL Server 2017 offers graph database capabilities to model many-to-many relationships. The graph relationships are integrated into T-SQL and receive the benefits of using SQL Server as the foundational database management system.
In this session we're going to be looking at the key differences between a standard relational database and a graph database, including what datasets are best suited for each type, and how to work between them.
Event Date: 02-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Your management have decided that they need some reports and they are going to use your systems - and that you are going to build them. You'll need to design these to work optimally with your current system - and although you've heard and read a fair bit about data warehousing, you have limited experience. Where should you start? what are your options? Come along to this session and find out some of the things that you might want to take notice of and some of the options that are open to you as well as ways to make those reports really shine - which will really impress your management team
Event Date: 02-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Event Date: 02-09-2017 - Session time: 14:45:00 - Track: Enterprise 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: 02-09-2017 - Session time: 14:45:00 - Track: Application Database Development
In this session, I will demonstrate how to use SQL Server Database Projects, discuss the benefits of using SQL Server Database Projects for authoring databases, and demonstrate the benefits of integrating your database development with Microsoft Visual Studio Team Services.
Event Date: 02-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-09-2017 - Session time: 16:00:00 - Track: Analytics and Visualization
Event Date: 02-09-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-09-2017 - Session time: 16:00:00 - Track: Advanced Analysis Techniques