Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 32
Do you want to be able to query huge amounts of data at cloud scale on a distributed infrastructure that is capable of scaling with your needs?
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 12

Time: 11:30 AM - 12:30 PM

Room: Fistral

In this session, we will focus in on how we can use temporal tables, along with a Stretch table, to provide an alternative solution to Type 2 Dimensions and archiving data with SQL Server 2016 and Azure DB. We will cover an overview of each technology, feature setup/install, compatibility with other SQL Server 2016 features, wait types and how to monitor these two important features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: March 12

Time: 8:00 AM - 9:00 AM

Room: Widemouth

With Microsoft’s acquisition of DataZen dashboard and mobile BI is not easier than ever, with DataZen being bundled with SQL Server. Come along and see how to get started with DataZen.

We will be showing an end to end demo of creating and publishing dashboards for mobile and tablet devices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 12

Time: 8:00 AM - 9:00 AM

Room: Fistral

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail. 

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 12

Time: 4:30 PM - 5:30 PM

Room: Gwithian

If you have worked with SQL Server Integration Services (SSIS) 2012 or above for few years then you already familiar with SSIS Catalog reports. SSISDB Catalog reports - help us to monitor projects, which you've deployed to the server. By using these reports, we can quickly find information related to executions, logging and other interesting things with few mouse clicks.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: March 12

Time: 3:30 PM - 4:30 PM

Room: Gwithian

At the heart of SQL Server is the cost based optimizer.  Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken.  How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t.  It estimates!  How does it estimate ? That is statistics.
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: March 12

Time: 9:10 AM - 10:10 AM

Room: Bude

SSMS is the love child of what was Query Analyzer and Enterprise Manager and has ever since been used as the dev tool of choice for people creating and modifying database schemas and code. Whilst SSMS is a really good management tool it is not suited to modern development. Instead Microsoft has created SSDT (SQL Server Data Tools) which has had a lot of attention from Microsoft in the last few years which means that it is now ready for us to use full time.

We will cover:

* How to get your databases into SSDT and critically how to get them to compile correctly.
* A tour of the SSDT features that show how T-SQL development is actually easier and how SSDT makes you more productive
* The build & deployment process so you can start concentrating on writing useful code instead of upgrade and release scripts.

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 12

Time: 2:10 PM - 3:10 PM

Room: Widemouth

The Cortana Analytics Suite provides an array of cloud based technologies that enable the storage, analysis and presentation of data into information. This session will explain:

What technologies the Cortana Analytics Suite contains, 
What a solution architecture will look like,
A demo of some of the key technologies that will enable you to create and develop a solution.  

At the end of this session, you will have a clear understanding of what Cortana Analytics is, and how you can implement some of its technologies
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 12

Time: 4:30 PM - 5:30 PM

Room: Widemouth

U-SQL is the new kid on the SQL language block. In this session we'll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? How do you learn it? We'll discuss all this and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 12

Time: 9:10 AM - 10:10 AM

Room: Fistral

The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 12

Time: 11:30 AM - 12:30 PM

Room: Bude

To be confirmed
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 12

Time: 9:00 AM - 10:30 AM

Room: Gwithian

Lightning talks to include: Alex Yates - Post-its on the wall  Andrew Pruski	- Introduction to partitioning Ben Watt - Three Ingredients. Only three pieces of data to produce 60+ visualisations. Gavin Campbell - Unit testing with tsqlt and Visual Studio
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 12

Time: 10:30 AM - 11:30 AM

Room: Fistral

You are a secret agent with Licence To Kill, posing as a developer in Exeter. 
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 12

Time: 4:30 PM - 5:30 PM

Room: Bude

Introduction to Panorama Necto 14: Suggestive, Collaborative & Visual BI Platform.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 12

Time: 1:10 PM - 2:10 PM

Room: Fistral

Office 365 plays a key role in the Microsoft Cloud offering.  It combines many different capabilities that have historically been separated into different products. The convergence of the products on one platform is opening up new possibilities for delivering new and exciting ways of collaborating.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 12

Time: 8:00 AM - 9:00 AM

Room: Bude

Whether you are a Data Wizard, a Dwarf mining for insights, an Elf creating elegant visualisations or an ordinary Hobbit seeking business enlightenment before second breakfast, BI Office from Pyramid Analytics can help you achieve your quest for insights and timely business information. With the summer announcement of the integration of Power BI and BI Office, on premise BI solutions are now easily achievable. This session will show you how Power BI with BI Office can make you a Superhero in your organisation!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 12

Time: 1:10 PM - 2:10 PM

Room: Bude

The quickest way to migrate your on-premises OLTP database to Azure is to simply "Lift & Shift".
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 12

Time: 9:10 AM - 10:10 AM

Room: Gwithian

Extended Events provide deep insight into SQL Server's behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 12

Time: 3:30 PM - 4:30 PM

Room: Bude

"It is much easier to trick someone into giving a password for a system than to spend the effort to crack into the system."
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 12

Time: 3:30 PM - 4:30 PM

Room: Widemouth

SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing and implementing SQL Server solutions. We will focus on the SQL Server engine, covering topics including Operational Analytics, Temporal & Stretch Tables and Always Encrypted. And we will be having a look at some of the old favourites, including enhancements to In-Memory OLTP (Hekaton)  AlwaysOn Availability Groups.

In part 1 we will look at the new DBA features which include:

* Setup and behaviour Changes
* HA/DR (Availability Groups, Backup/Restore)
* Stretch DB
* Temporal Tables
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 12

Time: 10:30 AM - 12:00 PM

Room: Widemouth

Sessions Found: 32
Back to Top