| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Rob Douglas | Database Administration | Are You High? Can You Recover? - HA and DR in SQL Server. |
| 09:30:00 | Jonathan Stewart | BI Platform Architecture, Development Administration | Data Visualization: How to truly tell a great story! |
| 10:45:00 | Dave Dustin | Database Development | Introduction to the Query Store |
| 10:45:00 | Andrew Worsley | BI Platform Architecture, Development Administration | Package Management in Microsoft R Open with Checkpoint |
| 11:15:00 | kokila kondasamy | Database Development | Restoring SQL Server Database to Old Version |
| 12:45:00 | Amit Arora | Database Development | Temporal Databases in Microsoft SQL server 2016 |
| 12:45:00 | Kevin Alcock | Database Administration | Protecting your data from SQL Injection attacks |
| 14:00:00 | Patrick Flynn | Database Administration | Adding Power to the DBA toolkit! |
| 14:00:00 | Reza Rad | BI Platform Architecture, Development Administration | Security in Power BI |
| 15:30:00 | Manjot Kaur | Database Development | DW SuperHero-Columnstore Index |
| 15:30:00 | Leila Etaati | BI Platform Architecture, Development Administration | R; One Ring to Rule Them All |
Event Date: 15-10-2016 - Session time: 09:30:00 - Track: Database Administration
We'll also look at the why of High Availability, Disaster recovery and how to get the business to commit to a design to provide Business Continuity when disaster strikes.
Event Date: 15-10-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-10-2016 - Session time: 10:45:00 - Track: Database Development
The Query Store also lets you identify queries that may degrade performance over time and make necessary adjustments. I#39;ll show how easy it is to work with the Query Store and work with query plans.
Event Date: 15-10-2016 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-10-2016 - Session time: 11:15:00 - Track: Database Development
Event Date: 15-10-2016 - Session time: 12:45:00 - Track: Database Development
More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.
Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.
This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.
Event Date: 15-10-2016 - Session time: 12:45:00 - Track: Database Administration
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: 15-10-2016 - Session time: 14:00:00 - Track: Database Administration
By adding a little "Power" to your DBA toolkit you can!
By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.
Event Date: 15-10-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-10-2016 - Session time: 15:30:00 - Track: Database Development
Event Date: 15-10-2016 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data cleaning, visualization, and prediction will be presented. Subsequently, an introduction to use R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML with R will be shown.