| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:00:00 | Mike Boswell | BI Information Delivery | Adding another Dimension type to SQL Server 2016 |
| 08:00:00 | Al Eardley | Strategy and Architecture | Office 365 - The Art of the Possible |
| 08:00:00 | Bob Duffy | Analytics and Visualization | Creating Mobile Dashboards with DataZen |
| 09:00:00 | Annette Allen | Advanced Analysis Techniques | Keynote |
| 09:10:00 | Dave Ballantyne | Application Database Development | Estimation and Statistics : The Basis of query optimization |
| 09:10:00 | Alex Whittles | BI Platform Architecture, Development Administration | Introduction to U-SQL |
| 09:10:00 | Dr. Subramani Paramasivam | Advanced Analysis Techniques | Think work like a Data Scientist with SQL 2016 R. |
| 09:10:00 | André Kamman | Cloud Application Development Deployment | Re-architecting your old-school database to maximize Azure cloud options |
| 10:30:00 | Stephanie Locke | Analytics and Visualization | Stats 101 |
| 10:30:00 | John Martin | Advanced Analysis Techniques | SQL Server 2016, New Features and Enhancements - DBA Features |
| 10:30:00 | Niall MacLeod | Advanced Analysis Techniques | Still running SQL 2005? Thinking about upgrading to SQL 2014? |
| 10:30:00 | Annette Allen | Advanced Analysis Techniques | Lightning Talks |
| 11:30:00 | Allan Mitchell | Analytics and Visualization | A first look at the Azure Data Lake Analytics service |
| 11:30:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | Investigate TempDB like Sherlock Holmes |
| 11:30:00 | John Martin | Advanced Analysis Techniques | SQL Server 2016, New Features and Enhancements - Dev Focus |
| 11:30:00 | Andrew Fryer | BI Platform Architecture, Development Administration | The new world of enterprise Business Intelligence |
| 13:10:00 | Alex Yates | Information Delivery | The first step towards release management for SQL Server |
| 13:10:00 | Ian Macdonald | Advanced Analysis Techniques | One BI Platform to Rule Them All! |
| 13:10:00 | Santiago Castro | Analytics and Visualization | Necto - Smart Data Discovery |
| 14:10:00 | Rob Sewell | Enterprise Database Administration Deployment | Using Power BI with my DBA Database |
| 14:10:00 | William Durkin | Application Database Development | You don't need Enterprise Edition to do that! |
| 14:10:00 | Ed Elliott | Application Database Development | From SSMS to SSDT why and how to move your SQL database development to SSDT |
| 15:30:00 | Gianluca Sartori | Enterprise Database Administration Deployment | Responding to Extended Events in near real-time |
| 15:30:00 | Prathy Kamasani | BI Information Delivery | Dive into SSISDB Catalog using Power BI |
| 15:30:00 | Mladen Prajdić | Professional Development | Social Engineering: Hacking People |
| 15:30:00 | Ryan Yates | Enterprise Database Administration Deployment | Why and how to Implement PowerShell DSC for SQL Server - Part 1 |
| 16:30:00 | n/a n/a | Analytics and Visualization | Session Details not available |
| 16:30:00 | David Dye | BI Platform Architecture, Development Administration | Dealing With Errors in SSIS |
| 16:30:00 | André Melancia | Application Database Development | MI6 Secrets - Data Security For Developers |
| 16:30:00 | Ryan Yates | Enterprise Database Administration Deployment | Why and how to Implement PowerShell DSC for SQL Server - Part 2 |
Event Date: 12-03-2016 - Session time: 08:00:00 - Track: BI Information Delivery
Event Date: 12-03-2016 - Session time: 08:00:00 - Track: Strategy and Architecture
This session will explain some of the ways that Office 365 is being used and demonstrate some of the capabilities that convince millions of companies to invest in Office 365 to replace existing products with a single unified environment making the most of the familiar business critical tools from Microsoft.
Event Date: 12-03-2016 - Session time: 08:00:00 - Track: Analytics and Visualization
We will be showing an end to end demo of creating and publishing dashboards for mobile and tablet devices.
Event Date: 12-03-2016 - Session time: 09:00:00 - Track: Advanced Analysis Techniques
Event Date: 12-03-2016 - Session time: 09:10:00 - Track: Application Database Development
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
Event Date: 12-03-2016 - Session time: 09:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-03-2016 - Session time: 09:10:00 - Track: Advanced Analysis Techniques
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the outcome within SQL 2016 itself.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Event Date: 12-03-2016 - Session time: 09:10:00 - Track: Cloud Application Development Deployment
You create a vm in Azure and size it to match your local system and move your database into it. This might not be the most cost effective way though and also, you still have to do all the database maintenance yourself. In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc. in order to truly scale our system. And we'll see if this increases or lowers the total cost of ownership. This excercise is about an OLTP system but we will also look at how it affects loading our DWH from this new setup.
Event Date: 12-03-2016 - Session time: 10:30:00 - Track: Analytics and Visualization
Event Date: 12-03-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
In part 1 we will look at the new DBA features which include:
Event Date: 12-03-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
Microsoft’s Data Warehouse Fast Track program offers:
#183; Faster deployment and tamed complexity with pre-configured, partner-led solutions
#183; Flexibility and choice of the latest generation of hardware from top vendors in the industry
#183; Out-of-the-box offerings with reduced risk and greater confidence
With support for SQL Server 2005 ending in April 2016, now is the time to upgrade to SQL Server 2014. With Flash architectures now being considered mainstream, now is also an opportunity to optimise your data platform infrastructure.
This presentation discusses the process undertaken to achieve a certification, whilst focusing on a cost effective (single socket), scalable 7 TB SMP Data Warehouse solution (Lenovo x360M5 and SanDisk SSD) which achieves an efficient out-of-box balance between SQL Server data processing capability and hardware resources.
Event Date: 12-03-2016 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
Event Date: 12-03-2016 - Session time: 11:30:00 - Track: Analytics and Visualization
Do you want to use a language that is both familiar and powerful to extract valuable insights from your data? If the answer to both of these questions is "yes" then Data Lake is definitely something you should be looking at. In this session we will look at the Data Lake analytics service, a service capable of handling queries against data of any size instantly simply by requesting more compute for each query. U-SQL is a query language that blends the declarative nature of SQL with the expressive power of C#. Visualisations of your U-SQL jobs let you see how your code runs at scale. Come to this session to see why people are talking about this new offering from Microsoft and see some of the problems it solves
Event Date: 12-03-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-03-2016 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
In part 2 we will focus on dev features:
Event Date: 12-03-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-03-2016 - Session time: 13:10:00 - Track: Information Delivery
If the business wants you to deploy more frequently but your SQL deployments are a bottleneck, this session may provide you with some answers.
At last year’s SQL Saturday Alex showed you how to set up a working automated build and test process. This year he will take a you one step further by adding release management to that set-up.
Event Date: 12-03-2016 - Session time: 13:10:00 - Track: Advanced Analysis Techniques
Event Date: 12-03-2016 - Session time: 13:10:00 - Track: Analytics and Visualization
Panorama believe the next big business idea will arise, by cultivating the collective brain-power of your team with the leading BI 3.0 system. That is why Panorama developed Necto - Suggestive Visual Insight Discovery Solution. Necto provides your users within one unique platform all the tools to focus, collaborate, decide and act.
Event Date: 12-03-2016 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-03-2016 - Session time: 14:10:00 - Track: Application Database Development
Event Date: 12-03-2016 - Session time: 14:10:00 - Track: Application Database Development
We will cover:
If you write, debug or modify SQL Server database code and haven't yet started using SSDT full time then this session will help you get started and be productive quickly.
Event Date: 12-03-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions.
Event Date: 12-03-2016 - Session time: 15:30:00 - Track: BI Information Delivery
However, have you ever wondered how to design an SSIS Project so we can take maximum benefit of SSISDB Catalog? How to troubleshoot SSIS Project executions from the Catalog? How to navigate your way around the built-in catalog reports? How to design a dashboard with SSIDB Catalog data? This session will focus on these scenarios by diving into SSISDB catalog views using PowerBI.
Event Date: 12-03-2016 - Session time: 15:30:00 - Track: Professional Development
This is a common line of thought in today's world of increased cyber-security dangers. In this interactive session we'll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company's secrets. The best attacks happen when people don't even realize they are being attacked and in this session we're going to try to fix that and educate you on how to realize when someone is trying to hack you.
Event Date: 12-03-2016 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-03-2016 - Session time: 16:30:00 - Track: Analytics and Visualization
Event Date: 12-03-2016 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details
Event Date: 12-03-2016 - Session time: 16:30:00 - Track: Application Database Development
This is your briefing (For Your Eyes Only) on how to turn business logic into database objects. Learn about SQL Server's data security mechanisms (including SQL Server 2016), implement multi-tiered data access with business rules and roles, make your app/database immune to infrastructure changes (like scaling from single server into clustered or to the cloud) and M's moods in the future, avoid SQL injection and other security and app coding bugs using stored procedures and database server side logic. Session suited for Developers and Students (Johnny English level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Event Date: 12-03-2016 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment