Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type



Sessions Found: 42
We dive into the common knowledge subjects and principles that we already know about but forget to use or just blatantly ignore, 

Delta management, Project recovery, Best and Worst practice and more.

Session is recommended for the intermediate to advanced but the beginner will also gain from this.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 2:30 PM - 3:30 PM

Room: Room 108

Cloud adoption has happened and almost every organisation now uses some form of public cloud services.  This means we no longer have to listen to how vendors want us to use their cloud services, instead we can see how those around us are actually are.  For those new to working with the cloud, this makes it easier to know what we need to learn so we can design, deploy and operate in the cloud era.  However, adapting your skills isn’t just about understanding how a few new technologies work.  Today’s IT professional also needs to know how trends like DevOps, the API economy and containers are going to affect them.

This session aims to give clarity and share real world experience with those getting ready or getting used to working with public cloud services.  Whether you’re a developer, an administrator or an architect, it will help you turn a complex world of cloud jargon into an actionable learning plan. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 05

Time: 9:45 AM - 10:45 AM

Room: Room 107

Anchor Modelling is a fantastic database modelling paradigm that uses sixth normal form (6NF) to store data and provides third normal form (3NF) views for ease of use. 

This session deep dives into all the concepts behind Anchor Modelling (and indeed databases generally!) and then takes you through how Anchor Modelling uses these concepts to move away from the traditional data warehouse paradigm to deliver a purely additive, agile database.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: December 05

Time: 3:45 PM - 5:15 PM

Room: Room 103

Are relational databases too restrictive for you?  Developers want to store data as they get it?  Need to store arrays, query as first class citizens instead of performing gymnastics? Yes?  then this session is for you.  It introduces Microsoft's Document database.  Come see what it is and how it could make your developers happy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 1:15 PM - 2:15 PM

Room: Room 101

### 
!! Please note Pre-Conference sessions are available for an additional registration of £150+fees !!

This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.

To view full details of this session & book please go to - http://bit.ly/1KtBdsW.
###

Being a DBA, you are the one responsible for helping to protect some of the most important assets that a business has, namely the data. In this pre-conference session we will look at some of the tasks that you as a DBA will likely encounter and need to deal with in order to maintain a fully functional and efficient SQL Server Environment, including;
- Setup and Configuration
- Backup & Recovery
- Monitoring, Baselines & Performance
- Security & Administration

Full Details: http://bit.ly/1PiLtY8
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-con (whole day) (540 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 04

Time: 8:30 AM - 5:30 PM

Room: Room 101

Today, SQL Server DBAs are more than likely at some point in their careers to come across Oracle and Oracle DBAs.To the unwary this can be very daunting and, at first glance, Oracle can look completely different with little obvious similarities to SQL Server.
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.

At the end of this session you will have a better understanding of Oracle and the differences between the Oracle RDBMS and SQL Server. 
Although you won’t be ready to be an Oracle DBA it will give you a foundation to build on.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: December 05

Time: 1:15 PM - 2:15 PM

Room: Room 103

When planning your SQL Server deployments there are a lot of different options to choose from and configurations that you can use, but which ones are for you? Here I will discuss and highlight some of the key recommended practices that you should follow and put in place when you build your SQL Servers and ways that you can automate these in order to standardize your server deployments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 05

Time: 2:30 PM - 3:30 PM

Room: Room 101

Power BI offers new and exciting features that are leading a lot of companies into the cloud. However, there are several additional considerations that you must factor into deciding how to architect your overall BI solution. 

In this session, you will learn about the available Microsoft Azure components and services that support a BI ecosystem. In addition, you learn how to properly configure your solution, whether it’s a completely cloud-based solution or a hybrid solution that includes on-premises data sources and on-premises client tools. You will gain an overview of Azure networking, and how it works in Azure VMs as well as for Office 365.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 05

Time: 3:45 PM - 4:45 PM

Room: Room 108

### 
!! Please note Pre-Conference sessions are available for an additional registration of £150+fees !!

This is a PAID FOR session hosted by SQLSoton which you must have signed up and paid before you can attend.

To view full details of this session & book please go to - http://bit.ly/1KtBdsW.
###

In this full-day workshop, you’ll learn about Business Intelligence Markup Language (Biml), your secret weapon for saving time on SSIS package development. We’ll start by learning about the history of Biml, the tools you can use to work with Biml, what it looks like, and the problems it’s designed to solve.

Then we’ll dive into the syntax of Biml by building out a simple SSIS package step by step. You’ll learn the structure of a Biml file and how to generate a package that you can view in Business Intelligence Development Studio (BIDS) or SQL Server Data Tools for BI (SSDT-BI).

Full details: http://bit.ly/1Kr1SIZ
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-con (whole day) (540 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 04

Time: 8:30 AM - 5:30 PM

Room: Room 107

Power BI Designer is a new standalone Desktop application that enables business analysts to create reports that can then be shared into the Power BI Dashboards service. The Power BI Designer combines the Get Data, Modeling and Reporting capabilities from Power Query, Power Pivot and Power View, but it also does many other things. In this session to learn about this new tool, both in terms of current features as its capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 3:45 PM - 4:45 PM

Room: Room 106

With retail businesses operating in multiple sales channels, the velocity of sales data and the quality of that data can vary greatly.

This is a key consideration when designing the operational characteristics of your backroom ETL subsystems, that stage and transform sales data into usable FACTs.

Cloning of key tables and utilising a parallel processing ETL stream, enables cookie cutter software development and controlled, synchronised loading of FACTs into the data warehouse presentation layer. The use of dynamically created table clones can reduce database entity clutter, optimise the development and execution of Fact Creation SSIS packages and improve data quality & auditing.

These elements are crucial to scaling out the data warehouse solution as the business grows.

In this session I will review the design, describe the basic components and demonstrate the core functionality.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 8:30 AM - 9:30 AM

Room: Room 101

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation.  John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects.  In particular, the session will cover: 
* Automating your build and deployments with SQL Server Data Tools
* Auto-code generation within SSDT using T4 templates and DacFx
* Harnessing the power of BIML
* Automated Integration and Regression testing of your Data Warehouse
* Deploying and on-going management of OLAP databases using the SSAS Partition Manager
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 2:30 PM - 3:30 PM

Room: Room 106

Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 05

Time: 9:45 AM - 10:45 AM

Room: Room 106

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 Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 9:45 AM - 10:45 AM

Room: Room 108

One of the of the most under-utilized management features of SQL Server is SQL Agent Multi-Server Administration, which allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. This allows you to have consistency with your SQL Agent jobs by managing them in a single location. You’ll learn about the benefits, drawbacks, workarounds, and underlying objects behind this technology. You’ll discover how to monitor job execution status and handle the security implications of the master-target relationship. SQL Server MVP Mike Hillwig will show you how to to deploy this simple, yet powerful feature right out of the box without writing a single line of additional code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 05

Time: 11:00 AM - 12:00 PM

Room: Room 107

Want to make the most of the cloud but not yet ready to re-implement your systems in Data Factory? There is another way.

In this session I'll run through how to architect your BI solution on Azure. We'll discuss some general principles of cloud architecture, look at the new azure pricing calculator, then dive into demonstrations of automation services and how to turn any traditional on-premise solution into a Platform-as-a-Service cloud app.

SSIS in the cloud is actually more possible than you think!

Also there may be some terrible jokes. I make no apologies for this.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 05

Time: 11:00 AM - 12:00 PM

Room: Room 103

This is an evergreen session, it follows Azure SQL Database evolution and each time is different: it looks at how to implement, maintain and evolve/update solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 05

Time: 8:30 AM - 9:30 AM

Room: Room 107

PowerBI provides a cloud based collaborative platform to manage and share business insights anytime and anywhere. This session will explore how to access the PowerBI site, manage integration with on premise data and set the availability of data to individuals within the business. Finally exploring some of the cool capabilities that will enable users to quickly create and share business data in a highly visual way 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: December 05

Time: 2:30 PM - 3:30 PM

Room: Room 103

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels.

Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 05

Time: 8:30 AM - 9:30 AM

Room: Room 109

SQL Server MVP Mike Hillwig hates using maintenance plans. He believes they don't scale well and frequently lack flexibility.  Maintenance plans are easy to set up and deploy. Deploying them to many servers is cumbersome. Modifying them on multiple servers at once is an exercise in futility. 

The dirty little secret is that anything you can do with a maintenance plan can be done with T-SQL. And by leveraging several community-based solutions, you can accomplish anything without maintenance plans. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 05

Time: 3:45 PM - 4:45 PM

Room: Room 101

Sessions Found: 42
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids