| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Reza Rad | BI Information Delivery | Power BI From Rookie to Rockstar |
| 09:00:00 | Warwick Rudd | Enterprise Database Administration Deployment | Beginners Guide to HA/DR, that can save your Bacon. |
| 09:30:00 | Rob Douglas | Enterprise Database Administration Deployment | DBA 101 - The things you absolutely MUST be doing in your SQL environment! |
| 09:30:00 | Reza Rad | BI Platform Architecture, Development Administration | Security in Power BI; Everything You Need to Know |
| 09:30:00 | Craig Ryan | Application Database Development | Tuning SQL Server Standard Edition |
| 09:30:00 | Nick Burns | Analytics and Visualization | A practical introduction to ML for the Data Professional |
| 11:00:00 | Geoff Black | Analytics and Visualization | The Power of Power BI |
| 11:00:00 | Patrick Flynn | Enterprise Database Administration Deployment | Schroedinger’s Backup – will your recovery work? |
| 11:00:00 | Manjot Kaur | Application Database Development | DW SuperHero-Columnstore Index |
| 13:00:00 | Nagaraj Venkatesan | Application Database Development | Cardinality Estimator: A Ride from SQL 7.0 to SQL Server 2016 |
| 13:00:00 | Warwick Rudd | Enterprise Database Administration Deployment | 2016 – The Rise and Fall of DBM |
| 13:00:00 | Steve Knutson | Enterprise Database Administration Deployment | The DBA's guide to SharePoint |
| 13:00:00 | Anupama Natarajan | BI Information Delivery | On-Premise Reporting - Choosing the Right Strategy (SSRS 2016 Power BI) |
| 14:30:00 | Kevin Alcock | Application Database Development | Protecting your data from SQL Injection attacks |
| 14:30:00 | Martin Cairney | Enterprise Database Administration Deployment | Database Administration for Azure SQL DB |
| 14:30:00 | Leila Etaati | Cloud Application Development Deployment | CortanaAnalytics : with RaspberryPI WeatherSensor |
| 14:30:00 | Matt Allington | BI Platform Architecture, Development Administration | Power Query is more than just a desktop BI ETL tool |
| 15:45:00 | Hamish Watson | Enterprise Database Administration Deployment | DevOPs and the DBA |
| 15:45:00 | Martin Catherall | BI Platform Architecture, Development Administration | SSIS Tips and Tricks |
| 15:45:00 | Phillip Seamark | BI Information Delivery | Unleash the power of Power BI |
| 15:45:00 | Manohar Punna | Enterprise Database Administration Deployment | Building a Centralised Database Maintenance and Monitoring Solution |
Event Date: 08-04-2017 - Session time: 09:00:00 - Track: BI Information Delivery
Module 1: Introduction to Power BI Module 2: Getting Data Module 3: Power Query for Data Transformation Module 4: Data Modelling Module 5: Data Visualization Module 6: Gateways Module 7: Power BI Service, Administration Security
Detailed description of agenda here: http://www.radacad.com/power-bi-training
Event Date: 08-04-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
I will cover the following topics across 3 modules for the day: • Define and characterize HA/DR and the options provided by SQL Server • Design an appropriate HA/DR solution to meet requirements for either an On-premises, Cloud, or Hybrid environments • Examine multiple technologies / features together to satisfy complex requirements and their implementation in complex environments
Event Date: 08-04-2017 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
The role of the DBA is never static or easy to define. It means different things to different businesses and can include development, maintenance, performance tuning, project management, system architecture, data mining and reporting. But at it's core a DBA works with, and takes responsibility for an organisations data. In this talk we'll go over the core things that should be implemented on all database servers, how you can quickly tame your SQL environment and stay in control.
Event Date: 08-04-2017 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
This is a demo-heavy session. Come and get answer to all your questions about Security in Power BI.
Event Date: 08-04-2017 - Session time: 09:30:00 - Track: Application Database Development
Event Date: 08-04-2017 - Session time: 09:30:00 - Track: Analytics and Visualization
We will build a prediction pipeline using AzureML and cover the essential elements of the machine learning workflow, from data preparation, prediction, evaluation and communication.
Event Date: 08-04-2017 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 08-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
While Schrödinger’s cat was a thought experiment that may have injured an imaginary feline, a failure to be able to recover databases when required can prove terminal to both careers and Companies.
In this session Patrick will walk you through how to design, create and test Recovery strategies. Using T-SQL and PowerShell you will leave with the tools necessary to avoid you own failed Schroedinger’s Backup experiment.
Event Date: 08-04-2017 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 08-04-2017 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 08-04-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-04-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-04-2017 - Session time: 13:00:00 - Track: BI Information Delivery
SQL Server Reporting Services (SSRS) 2016 offers many new features and capabilities that makes it a complete solution for On-Premise Reporting.
In this session, I will walk you through the New features of SSRS 2016 Power BI Integration both in Native and SharePoint modes Power BI Mobile Apps to view SSRS Reports SSRS Tools
Event Date: 08-04-2017 - Session time: 14:30:00 - Track: Application Database Development
And here is a blurb from:
https://www.owasp.org/index.php/Top_10_2013-A1-Injection
" The best way to find out if an application is vulnerable to injection is to verify that all use of interpreters clearly separates untrusted data from the command or query. For SQL calls, this means using bind variables in all prepared statements and stored procedures, and avoiding dynamic queries. Checking the code is a fast and accurate way to see if the application uses interpreters safely. Code analysis tools can help a security analyst find the use of interpreters and trace the data flow through the application. Penetration testers can validate these issues by crafting exploits that confirm the vulnerability."
Kevin will give us a demo that will show an injection attack in action and how to mitigate it.
Event Date: 08-04-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
This session will identify the main aspects of the Azure SQL DBA role, including how to ensure you have longer term backups (if you need them for compliance), how to manage your Tier level automatically, how to ensure you have the best performance to keep your DTUs to a minimum. You will leave this session with a better story for your manager to convince him to move your workload to Azure and lower your total SQL Server costs.
Event Date: 08-04-2017 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Event Date: 08-04-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
• Use Power Query as a data provider for traditional Excel Pivot Tables without using Power Pivot.
• Building a Power Pivot calendar table from scratch using pure Power Query steps.
• Add commentary to bank statements and make those comments "stick" using self-referencing tables.
• Using Power Query as an auditing and exception management
• Using Power Query as a pure ETL tool and exporting more than 1 m rows of transformed data to a file.
Event Date: 08-04-2017 - Session time: 15: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 production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 08-04-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Come along to this session and learn some tips and tricks that have been gained over many years. Having additional knowledge and design patterns in your SSIS tool belt can be the difference between a very average package and one you, your manager, your team and your clients can be really happy and proud of.
Event Date: 08-04-2017 - Session time: 15:45:00 - Track: BI Information Delivery
Learn how to; Create self-annotating Dashboards Use Power BI to optimise Power BI User the API Take advantage of bi-directional relationships Use Measures more creatively And much more…..
Event Date: 08-04-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
In this session I will walk you through the simple steps of building a centralised database maintenance and monitoring solution. This solution will help a database professional to query all the monitored instances, collect performance metrics, run customized scripts and any maintenance task a database professional needs to perform across the database environment. Talk about a easy DBA life, this is a definite simple solution you should build.