sqlsathistory

Nr: 467

Back to Main list

SQLSaturday #467 - Southampton 2015

Start Time (24h) Speaker Track Title
08:30:00 John Martin Enterprise Database Administration Deployment Being a DBA - A day in the life.
08:30:00 Dave Ballantyne Application Database Development Query Processing Internals
08:30:00 Mladen Prajdić Application Database Development SQL Server for Developers: Database is no dumping ground!
08:30:00 Stacia Varga BI Platform Architecture, Development Administration Building Blocks of BIML
08:30:00 Tobias Koprowski Cloud Application Development Deployment Windows Azure SQL Database - A Journey from Zero to be Hero
08:30:00 Neil Hambly Enterprise Database Administration Deployment Load Testing With SQL Server Tools
08:30:00 David Williams SQL Server 2016 New Features SQL Server 2016 New Feaures (Not Query Store!)
08:30:00 Dr. Subramani Paramasivam Cloud Application Development Deployment Tired of connecting on-prem cloud data? Take a DB stretch
08:30:00 Eric Lawson BI Platform Architecture, Development Administration Click Clone - a simple model for managing data quality and scaling out
08:30:00 Emanuele Zanchettin Cloud Application Development Deployment Implementing and Maintaining an Azure SQL Database project
08:30:00 André Melancia Data Platform Security Compliance MI6 Secrets - Data Security For Developers
09:45:00 Alex Whittles BI Platform Architecture, Development Administration Data Warehouse modeling, for data analysis and cubes
09:45:00 Lord Richard Douglas Enterprise Database Administration Deployment Understanding the Transaction Log, Your Key to Unlocking Greater Throughput
09:45:00 David Conlan BI Platform Architecture, Development Administration SSRS - The Dark Side: Custom Rendering
09:45:00 Prathy Kamasani BI Platform Architecture, Development Administration Dive into SSISDB Catalog using PowerBI
09:45:00 Dave Ballantyne Application Database Development Query Optimizer internals
11:00:00 Tobias Koprowski Enterprise Database Administration Deployment SQL Server Backup in the Era of the Cloud
11:00:00 Christopher Adkin Application Database Development Super Scaling Clustered Index Inserts
11:00:00 Mike Hillwig Enterprise Database Administration Deployment Do More With Less: Inside SQL Agent Multi-Server Administration
11:00:00 Annette Allen Application Database Development The What, Why and How of Unit Testing SQL Server
11:00:00 Simon Whiteley BI Platform Architecture, Development Administration ETL in the Clouds
11:00:00 André Kamman Enterprise Database Administration Deployment No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt
13:15:00 Allan Mitchell BI Platform Architecture, Development Administration Azure DocumentDB
13:15:00 David Postlethwaite Professional Development Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA
13:15:00 Mladen Prajdić Application Database Development SQL Server and Application Security for Developers
13:15:00 Al Eardley Enterprise Database Administration Deployment SharePoint Databases - What you need to know
13:15:00 Rob Sewell Enterprise Database Administration Deployment Using Power BI with my DBA Database
13:15:00 Niall MacLeod Application Database Development Microsoft SQL Server Data Warehouse Fast Track – Understanding th
14:30:00 John Tunnicliffe BI Platform Architecture, Development Administration Continuous Integration and the Data Warehouse
14:30:00 Andreas Bergstedt BI Platform Architecture, Development Administration 10 Things that you already knew about SSIS
14:30:00 n/a n/a Cloud Application Development Deployment Session Details not available
14:30:00 Bob Duffy Application Database Development When good SQL design goes bad
14:30:00 Kenneth Nielsen Application Database Development SQL Server 2016 - Always Encrypted - secure your data from the prying eye
14:30:00 Justin Langford Enterprise Database Administration Deployment Performance troubleshooting SQL Server
14:30:00 John Martin Enterprise Database Administration Deployment Building Configuring SQL Server : Recommended Practices
15:45:00 Stephanie Locke Application Database Development Anchor Modelling: Sixth normal form databases!
15:45:00 Jen Stirrup Advanced Analysis Techniques What a boozy day at the Guinness factory teaches us about Analytics
15:45:00 Mike Hillwig Enterprise Database Administration Deployment Maintenance Plans: Planning to Fail
15:45:00 Alex Yates Application Database Development State-based or migrations-based database development? The pros and cons...
15:45:00 Stacia Varga Cloud Application Development Deployment Building a BI Solution in the Cloud
15:45:00 Mike Boswell BI Platform Architecture, Development Administration Changing the face of your desktop with PowerBI

SessionID: 40648

Being a DBA - A day in the life.

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Martin

Title: Being a DBA - A day in the life.

Abstract:

!! Please note Pre-Conference sessions are available for an additional registration of #163;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;

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

SessionID: 40925

Query Processing Internals

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Dave Ballantyne

Title: Query Processing Internals

Abstract:

!! Please note Pre-Conference sessions are available for an additional registration of #163;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 precon, we will be looking at the processes involved of taking a simple statement and forming a workable well performing execution plan.

Firstly, we will be looking at Execution plans themselves and picking them apart to describe the physical actions that are executed by the engine to perform the required statement. This will be followed by statistics, estimation and caching and the role that they play in forming and costing execution plans. We will see how SQL Server 2014 has new functionality and the problems that they are designed to resolve, we will finish with query optimizer internals.

Full Details: http://bit.ly/1NGjd2P

SessionID: 40926

SQL Server for Developers: Database is no dumping ground!

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Mladen Prajdić

Title: SQL Server for Developers: Database is no dumping ground!

Abstract:

!! Please note Pre-Conference sessions are available for an additional registration of #163;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 pre-conference session we'll go over what every developer dealing with SQL Server and .Net has to know to be as effective and productive as possible. Because speed is important too, we'll also focus on areas where you as a developer can contribute most.

We'll cover:

Full session details at: http://bit.ly/1Jk3HU5

SessionID: 40940

Building Blocks of BIML

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Building Blocks of BIML

Abstract:

!! Please note Pre-Conference sessions are available for an additional registration of #163;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

SessionID: 40941

Windows Azure SQL Database - A Journey from Zero to be Hero

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Tobias Koprowski

Title: Windows Azure SQL Database - A Journey from Zero to be Hero

Abstract:

!! Please note Pre-Conference sessions are available for an additional registration of #163;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.

Four years in the market, continuously changing, but still not understood. In AD2015 is it the right time to change this. With a full day Pre-Conf we start with our on-premises instances, next we touch the Sky, and as masters we will parachute back to the Earth.

In my Pre-Conf I want to show you how we can work with Windows Azure SQL Database (formerly known as SQL Azure) focused on;

Full Details: http://bit.ly/1FYbFC6

SessionID: 39217

Load Testing With SQL Server Tools

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Neil Hambly

Title: Load Testing With SQL Server Tools

Abstract:

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.

SessionID: 39411

SQL Server 2016 New Feaures (Not Query Store!)

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: SQL Server 2016 New Features

Speaker: David Williams

Title: SQL Server 2016 New Feaures (Not Query Store!)

Abstract:

SQL Server 2016 New Features (Not Query Store!)

SessionID: 39703

Tired of connecting on-prem cloud data? Take a DB stretch

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Dr. Subramani Paramasivam

Title: Tired of connecting on-prem cloud data? Take a DB stretch

Abstract:

You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily and this session will enable you to understand enabling / disabling data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow Deep backups. However, Deep backups are not currently supported with SQL Server 2016 CTP2.

SessionID: 39990

Click Clone - a simple model for managing data quality and scaling out

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Eric Lawson

Title: Click Clone - a simple model for managing data quality and scaling out

Abstract:

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.

SessionID: 40545

Implementing and Maintaining an Azure SQL Database project

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Emanuele Zanchettin

Title: Implementing and Maintaining an Azure SQL Database project

Abstract:

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.

SessionID: 40695

MI6 Secrets - Data Security For Developers

Back to calendar

Event Date: 05-12-2015 - Session time: 08:30:00 - Track: Data Platform Security Compliance

Speaker: André Melancia

Title: MI6 Secrets - Data Security For Developers

Abstract:

If you're a developer, this is for you (DBAs should already know this!)...

Here is your chance to learn how to turn business logic into database objects. Learn about SQL Server's data security mechanisms and 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 cloud) and your boss' moods in the future, and avoid SQL injection and other security and app coding bugs using stored procedures and database server side logic. Session suited for developers and students (padawan level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.

SessionID: 38980

Data Warehouse modeling, for data analysis and cubes

Back to calendar

Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alex Whittles

Title: Data Warehouse modeling, for data analysis and cubes

Abstract:

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.

SessionID: 39250

Understanding the Transaction Log, Your Key to Unlocking Greater Throughput

Back to calendar

Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Lord Richard Douglas

Title: Understanding the Transaction Log, Your Key to Unlocking Greater Throughput

Abstract:

Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log?

There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.

SessionID: 40489

SSRS - The Dark Side: Custom Rendering

Back to calendar

Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Conlan

Title: SSRS - The Dark Side: Custom Rendering

Abstract:

For those with the time, programming expertise and willingness to get their hands dirty, Microsoft provides a mechanism to write your own custom rendering engine for SSRS in .NET. Whether you want to create an interactive, self-service dashboard or a mechanism for exporting to Open Document Format, David will talk you through the stages required to write and implement your own renderer.

The first part of this session will focus on how reports are rendered. David will describe the Report Definition Language Specification and how to access the Report Object Model .NET API.

However, creating an individual custom rendering engine is a mammoth task. Therefore the second part of of this presentation focuses on how to leverage Microsoft's existing HTML renderer to deliver enhanced reporting capabilities. By taking a short-cut you will be able deliver some quite impressive new features and breathe life back into those online reports.

SessionID: 40524

Dive into SSISDB Catalog using PowerBI

Back to calendar

Event Date: 05-12-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Prathy Kamasani

Title: Dive into SSISDB Catalog using PowerBI

Abstract:

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.

SessionID: 40665

Query Optimizer internals

Back to calendar

Event Date: 05-12-2015 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Dave Ballantyne

Title: Query Optimizer internals

Abstract:

The query optimizer is at the heart of SQLServer. Without it SQLServer would be a vastly inferior product, queries would have to be manually tuned at each and every turn, and generally speaking, the optimizer protects us from the complexities and mechanics involved.

Much of the optimizer's internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.

This session will be a deep dive into the optimizers' internals and not for the feint of heart.

SessionID: 39726

SQL Server Backup in the Era of the Cloud

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Tobias Koprowski

Title: SQL Server Backup in the Era of the Cloud

Abstract:

Backup? Who cares! Now and Then? We store our data in the cloud. Somewhere in the Cloud. Which Cloud? Who cares! But we are still SQL Server Professionals, so... are we need backup? Should we use newest opportunities or old methods? Are we going step further or step back? On my session I will try to find answers for all of those (and more) questions. Demos, cases and examples from world of backup. And of course worst practices.

SessionID: 39796

Super Scaling Clustered Index Inserts

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Christopher Adkin

Title: Super Scaling Clustered Index Inserts

Abstract:

Want to know how to go from 13,000 to 550,000 inserts per second on the same hardware ?, this session will show you how from key construction, reducing the overhead of SQL language processing, database engine tuning, delayed durability etc. During this journey core database concepts will be explained at a level not touched at in the SQL Server internals book and windows performance toolkit will be used to provide some deep insights into what the database engine is doing.

SessionID: 39887

Do More With Less: Inside SQL Agent Multi-Server Administration

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: Do More With Less: Inside SQL Agent Multi-Server Administration

Abstract:

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.

SessionID: 40494

The What, Why and How of Unit Testing SQL Server

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Annette Allen

Title: The What, Why and How of Unit Testing SQL Server

Abstract:

We all write SQL scripts but how do we know that what we write is returning the correct results? In this session I will explain the importance of unit testing your code, what to test for and most importantly what free tools you can use to make this easy. By the end of this session you will be equipped with the information you need to go and implement unit testing on your code so that you can confidently carry out stress-free system releases.

SessionID: 40551

ETL in the Clouds

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Whiteley

Title: ETL in the Clouds

Abstract:

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.

SessionID: 40598

No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Back to calendar

Event Date: 05-12-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: André Kamman

Title: No stress with OSTRESS, Lessons Learned from a high traffic Replay attempt

Abstract:

One of my client engagements lately was about replaying a workload. The system had so many batches per second that I couldn't actually do a replay but had to run in stress mode and try to slow down the replay in such a way that it resembled the production system.

I'll show you how to do that amongst a bunch of other things that I learned and would love to share with you. If you are thinking about using OSTRESS / RML Utilities to analyse your system and stress test it on a different machine to find bottlenecks, then this session is for you.

SessionID: 38922

Azure DocumentDB

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Allan Mitchell

Title: Azure DocumentDB

Abstract:

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.

SessionID: 38935

Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Professional Development

Speaker: David Postlethwaite

Title: Beware of the Dark Side - A Guided Tour of Oracle for the SQL DBA

Abstract:

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.

SessionID: 39021

SQL Server and Application Security for Developers

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Mladen Prajdić

Title: SQL Server and Application Security for Developers

Abstract:

A lot of companies have a philosophy of "ship early with as many features as possible.” Security is an afterthought since it isn't fun to do and no one will attack them anyway. However, the dark side never sleeps, and security breaches have always happened, often leaving companies severely exposed or even bankrupt.

In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.

SessionID: 39176

SharePoint Databases - What you need to know

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Al Eardley

Title: SharePoint Databases - What you need to know

Abstract:

An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.

SessionID: 40160

Using Power BI with my DBA Database

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Sewell

Title: Using Power BI with my DBA Database

Abstract:

Every good DBA should have a DBA database. A place to store information about all of their instances and databases. They should automatically gather information into that database. They are also often required to query that information to answer questions from other technical teams, Project Managers, Client Account managers, Compliance Teams, Auditors, Directors In this session I will talk about the way that I automate the gathering of this information and also how I use Power BI to be able to allow people to self serve answers to their own questions and remove some load from the DBA team. I am no BI expert so this session is aimed at DBAs who want to be able to show information using the latest tools rather than BI professionals

SessionID: 41705

Microsoft SQL Server Data Warehouse Fast Track – Understanding th

Back to calendar

Event Date: 05-12-2015 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Niall MacLeod

Title: Microsoft SQL Server Data Warehouse Fast Track – Understanding th

Abstract:

SessionID: 38925

Continuous Integration and the Data Warehouse

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: John Tunnicliffe

Title: Continuous Integration and the Data Warehouse

Abstract:

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:

SessionID: 38937

10 Things that you already knew about SSIS

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andreas Bergstedt

Title: 10 Things that you already knew about SSIS

Abstract:

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.

SessionID: 38939

Session Details not available

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: n/a n/a

Title: Session Details not available

Abstract:

Session Details not available

SessionID: 39341

When good SQL design goes bad

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Bob Duffy

Title: When good SQL design goes bad

Abstract:

Take what you’ve learned about SQL Server and turn it upside down.

In this humorous session I’ll be debating many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down. •When you should NOT use stored procedures. •When we don’t need indexes. •When Clustered Tables are bad. •When Identity Columns should not be Primary Keys. •When we don’t care about fragmentation. •When good naming convention’s go bad. •Why Partitioning often makes your queries slower. •Why do ORMs really makes sense when they make all your parameters nvarchar (max)

Health Warning: These may not be the design tips you should be using on your production OLTP.

SessionID: 39366

SQL Server 2016 - Always Encrypted - secure your data from the prying eye

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Kenneth Nielsen

Title: SQL Server 2016 - Always Encrypted - secure your data from the prying eye

Abstract:

In this session we will focus on the new feature in SQL Server 2016, Always Encrypted. A new feature that will keep your data encrypted all the way from the database to the application, and only the application consuming the data will be able to see and manipulate the data. Even a DBA in SQL Server management Studio will not be able to see and manipulate the data.

SessionID: 42046

Performance troubleshooting SQL Server

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Langford

Title: Performance troubleshooting SQL Server

Abstract:

Many DBAs, System Admins and developers experienced intermittent SQL Server performance problems and struggle to identify the root cause and resolve. Customers often waste lots of time investigating the wrong areas of performance - whether that's infrastructure or application.

This session presents an approach and tools to consistently troubleshooting performance problems with SQL Server.

SessionID: 42047

Building Configuring SQL Server : Recommended Practices

Back to calendar

Event Date: 05-12-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Martin

Abstract:

SessionID: 38929

Anchor Modelling: Sixth normal form databases!

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Stephanie Locke

Title: Anchor Modelling: Sixth normal form databases!

Abstract:

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.

SessionID: 39313

What a boozy day at the Guinness factory teaches us about Analytics

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Advanced Analysis Techniques

Speaker: Jen Stirrup

Title: What a boozy day at the Guinness factory teaches us about Analytics

Abstract:

Anyone who can type commands into R but that does not mean that can 'do' statistics for analytics. They may even misuse those methods, and it's an entirely different thing to really understand what’s happening. This is vital, because this knowledge is what really drives each phase of your analysis and create effective models for the business to use in order to create actionable insights. It can be difficult to see when someone is building faulty statistical models, especially when their intentions are good, and their results look pretty! Results are important, and it's down to you to create models that are sound and robust.

Drinking Guinness is optional, but admittedly might be preferred for this intensive session.

In this session, we will look at modeling techniques in Predictive Analytics using R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today.

SessionID: 39886

Maintenance Plans: Planning to Fail

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: Maintenance Plans: Planning to Fail

Abstract:

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.

SessionID: 39968

State-based or migrations-based database development? The pros and cons...

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Alex Yates

Title: State-based or migrations-based database development? The pros and cons...

Abstract:

For the last few years MS have been promoting declarative, state-based database development with tools like SSDT. For many this is the way forward – gone are the days of managing endless upgrade scripts and manual deployments.

At the same time, leaders and shakers of our industry including ThoughtWorks, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool.

I'm irritated that whenever I go to a “how to do database continuous delivery” session, the speaker invariably believes in one approach or the other and present their way as good and the other as bad. It irritates me so much I want to do something about it.

I’ll discuss scenarios from projects I’ve worked with to explain the pros and cons of each approach. I’ll describe which projects are better suited to state or migrations and I’ll discuss whether it’s possible to get the best of both worlds.

SessionID: 40473

Building a BI Solution in the Cloud

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Stacia Varga

Title: Building a BI Solution in the Cloud

Abstract:

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.

SessionID: 42045

Changing the face of your desktop with PowerBI

Back to calendar

Event Date: 05-12-2015 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mike Boswell

Title: Changing the face of your desktop with PowerBI

Abstract:

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.