SQLSaturday #467 - Southampton 2015

Event Date: 12/05/2015 00:00:00

Event Location:

Jury’s Inn
Charlotte Place, Southampton
Southampton, England, United Kingdom

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

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.

Speaker(s):

Lord Richard Douglas

Track and Room: Enterprise Database Administration Deployment - Room 103

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.

Speaker(s):

Alex Whittles

Track and Room: BI Platform Architecture, Development Administration - Room 106

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.

Speaker(s):

Bob Duffy

Track and Room: Application Database Development - Room 107

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.

Speaker(s):

Neil Hambly

Track and Room: Enterprise Database Administration Deployment - Room 109

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.

Speaker(s):

Mike Hillwig

Track and Room: Enterprise Database Administration Deployment - Room 107

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

Speaker(s):

Rob Sewell

Track and Room: Enterprise Database Administration Deployment - Room 107

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.

We will see what is needed to secure the data
We will build a simple C# program to Consume and manipulate data
We will see how data looks in the table
And finally every attendees, should be able to implement this neat feature at their own SQL server 2016

Speaker(s):

Kenneth Nielsen

Track and Room: Application Database Development - Room 103

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.

Speaker(s):

Alex Yates

Track and Room: Application Database Development - Room 107

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.

Speaker(s):

Allan Mitchell

Track and Room: BI Platform Architecture, Development Administration - Room 101

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.

Speaker(s):

Al Eardley

Track and Room: Enterprise Database Administration Deployment - Room 109

Title: Dive into SSISDB Catalog using PowerBI

Abstract: 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(s):

Prathy Kamasani

Track and Room: BI Platform Architecture, Development Administration - Room 108

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.

Speaker(s):

David Conlan

Track and Room: BI Platform Architecture, Development Administration - Room 101

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.

Speaker(s):

Eric Lawson

Track and Room: BI Platform Architecture, Development Administration - Room 101

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.

Speaker(s):

Jen Stirrup

Track and Room: Advanced Analysis Techniques - Room 109

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;

Setup and Configuration
Backup Recovery
Monitoring, Baselines Performance
Security Administration

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

Speaker(s):

John Martin

Track and Room: Enterprise Database Administration Deployment - Room 101

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.

Speaker(s):

David Postlethwaite

Track and Room: Professional Development - Room 103

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.

Speaker(s):

André Melancia

Track and Room: Data Platform Security Compliance - Room 106

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:

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(s):

John Tunnicliffe

Track and Room: BI Platform Architecture, Development Administration - Room 106

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

Abstract: The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures, optimised for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity.

Speaker(s):

Niall MacLeod

Track and Room: Application Database Development - Room 108

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

Speaker(s):

Stacia Varga

Track and Room: BI Platform Architecture, Development Administration - Room 107

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:

Basic normal forms, data structures and data types.
The query optimizer, workers and threads.
Isolation levels and locking.
Tips and tricks will teach you to write better queries. Diving into the .Net SqlClient will teach you some interesting database access features to make your programming easier

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

Speaker(s):

Mladen Prajdić

Track and Room: Application Database Development - Room 108

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.

Speaker(s):

Stacia Varga

Track and Room: Cloud Application Development Deployment - Room 108

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;

pros and cons
differences
place to start
security
tools, methods and ideas
SWOT analyse
backup and restore
RPO, RTO, ROI, SLA, SLO and more
Service Level Agreements,
compliance and responsibility
best and worst practices

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

Speaker(s):

Tobias Koprowski

Track and Room: Cloud Application Development Deployment - Room 109

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

Speaker(s):

Dave Ballantyne

Track and Room: Application Database Development - Room 106

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

Abstract: SQL Server 2016 New Features (Not Query Store!)

In-memory OLTP Enhancements
Native JSON
Always Encrypted
Row Level Security
Dynamic Data Masking
Enhance Database Caching
Enhanced Always On
Power Query for Analytics and Reporting
Enterprise Grade Analysis Services
Enhanced MDS
Enhanced Reporting Services
Built in Advanced Analytics with R

Speaker(s):

David Williams

Track and Room: SQL Server 2016 New Features - Room 108

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.

Speaker(s):

Stephanie Locke

Track and Room: Application Database Development - Room 103

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.

Speaker(s):

Justin Langford

Track and Room: Enterprise Database Administration Deployment - Room 109

Title: Session Details not available

Abstract: Session Details not available

Speaker(s):

n/a n/a

Track and Room: Cloud Application Development Deployment - Room 103

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.

Speaker(s):

Tobias Koprowski

Track and Room: Enterprise Database Administration Deployment - Room 101

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.

Speaker(s):

Mladen Prajdić

Track and Room: Application Database Development - Room 106

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.

Speaker(s):

Mike Hillwig

Track and Room: Enterprise Database Administration Deployment - Room 101

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.

Speaker(s):

Mike Boswell

Track and Room: BI Platform Architecture, Development Administration - Room 106

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.

Speaker(s):

Andreas Bergstedt

Track and Room: BI Platform Architecture, Development Administration - Room 108

Title: Building Configuring SQL Server : Recommended Practices

Abstract: 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(s):

John Martin

Track and Room: Enterprise Database Administration Deployment - Room 101

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.

Speaker(s):

Christopher Adkin

Track and Room: Application Database Development - Room 108

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.

Speaker(s):

Dr. Subramani Paramasivam

Track and Room: Cloud Application Development Deployment - Room 103

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.

Speaker(s):

Simon Whiteley

Track and Room: BI Platform Architecture, Development Administration - Room 103

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.

Speaker(s):

Dave Ballantyne

Track and Room: Application Database Development - Room 109

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.

Speaker(s):

André Kamman

Track and Room: Enterprise Database Administration Deployment - Room 109

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.

Speaker(s):

Emanuele Zanchettin

Track and Room: Cloud Application Development Deployment - Room 107

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.

Speaker(s):

Annette Allen

Track and Room: Application Database Development - Room 106

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Al Eardley

Twitter: - https://twitter.com/al_eardley

LinkedIn: Al Eardley

Contact: http://blog.eardley.org.uk

Alan Eardley is a Solution Architect at Corporate Project Solutions (CPS) specialising in Office 365. He has worked with SQL Server since version 7 and with SharePoint and associated products for the last seven years. He has been involved in the planning and delivery of on-premises and on-line solutions for a wide variety of clients ranging in size from small to global.

Bob Duffy

Twitter: - @bob_duffy

LinkedIn: Bob Duffy

Contact: http://blogs.prodata.ie/author/bob.aspx

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.

Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

Stephanie Locke

Twitter: - @stefflocke

LinkedIn: Stephanie Locke

Contact: https://itsalocke.com

Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.

David Williams

Twitter: - @smooth1x1

LinkedIn: David Williams

Contact: http://justdave.info

David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQLSaturdays as well as local usergroups and is a regular volunteer at events including SQLBits.

Eric Lawson

Contact: http://www.ericjlawson.co.uk/

I have 25 years experience in the database field, beginning with IBM DB2, specialising in Tandem NonStop SQL and in the last few years branching out onto SQL Server.

My core experience is with business intelligence (BI) solutions amp; strategy, database modelling, design amp; performance tuning, large scale ETL systems infrastructure and data migrations.

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Mladen Prajdić is a Data Platform MVP from Slovenia. He’s been programming for 20 years, developing diﬀerent types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He’s a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.

Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

John Tunnicliffe

Twitter: - Dr_John_T

LinkedIn: John Tunnicliffe

Contact: https://devops-your-dwh.com/

Dr John Tunnicliffe is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. John is a recognised expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. As a regular speaker at the SQLBits conference and PASS SQLSaturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.

Kenneth Nielsen

Twitter: - https://twitter.com/DoktorKermit

LinkedIn: Kenneth Nielsen

Contact: http://funkylab.com

Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.

n/a n/a

Neil Hambly

Twitter: - Neil_Hambly

LinkedIn: Neil Hambly

Contact: http://dataidol.com/NeilHambly

Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.

Justin Langford

Twitter: - @justinlangford

Justin Langford is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for platform, analytics and cloud consulting and support for SQL Server. Coeo provide 24x7 Remote DBA services for mission critical SQL Server platforms. Justin is an MVP and co-authored Wrox IT Pro: SQL Server 2012 Internals and Troubleshooting, as well as the same title for SQL Server 2008 and SQL Server 2005 Performance Tuning.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

Niall MacLeod

Niall is a Senior Applications Architect for SanDisk, specializing in Microsoft SQL Server and Flash Storage Solutions. Niall has extensive knowledge and experience in utilizing infrastructure resources to deliver application performance. Having began his career in IT in the late 1990s at Data General and EMC, Niall has since worked with several enterprise storage companies; the latter being Fusion-io where he was responsible for the direction of technical marketing in EMEA.

Alex Whittles

Twitter: - @PurpleFrogSys

LinkedIn: Alex Whittles

Contact: http://www.PurpleFrogSystems.com/blog

Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence.

He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK.

Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe

Lord Richard Douglas

Twitter: - SQLRich

LinkedIn: Lord Richard Douglas

Contact: http://SQL.RichardDouglas.co.uk

Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.

Mladen Prajdić

Twitter: - @MladenPrajdic

LinkedIn: Mladen Prajdić

Contact: http://weblogs.sqlteam.com/mladenp

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Emanuele Zanchettin

Twitter: - @thinkIT

LinkedIn: Emanuele Zanchettin

Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Traveler. Coffee Addicted.

Simon Whiteley

Twitter: - MrSiWhiteley

LinkedIn: Simon Whiteley

Contact: http://blogs.adatis.co.uk/blogs/simonwhiteley/

Simon Whiteley is the Director of Engineering for Advancing Analytics Ltd and a Microsoft Data Platform MVP. Simon is a seasoned solution architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying “big data” thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.

David Postlethwaite

Twitter: - @postledm

LinkedIn: David Postlethwaite

Contact: http://www.gethynellis.com/

David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company’s first cloud solution using Microsoft Azure SQL Database and web services

Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.

He is an occasional blogger on www.gethynellis.com

David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL

Dave Ballantyne

Twitter: - @davebally

Dave has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment. Tuning and optimizing SQLServer processes is his particular talent but no newbie either when it comes to database development and design. Dave regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the SQL Lunch UK user group

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

Rob Sewell

Twitter: - sqldbawithbeard

LinkedIn: Rob Sewell

Contact: http://sqldbawithabeard.com

Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.

Prathy Kamasani

Twitter: - @pkamasani

LinkedIn: Prathy Kamasani

Contact: http://prathy.com/

Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organizes the London PASS Local Group. She is a regular speaker at events like SQLSaturday and local user groups.

Dave Ballantyne

Twitter: - @davebally

Annette Allen

Twitter: - mrs_fatherjack

I have worked with SQL Server for 15 years predominantly as a Developer and more recently moving into the role of DBA. I am an author on Simple Talk, co-run the SQL South West User group and SQLSaturday Exeter and am involved in the organisation of SQL Bits.

Alex Yates

Twitter: - @alexyates

LinkedIn: Alex Yates

Contact: http://www.workingwithdevs.com

Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.

A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.

Andreas Bergstedt

Twitter: - @AndreasBergstedt

LinkedIn: Andreas Bergstedt

Contact: https://blog.bi360.ml

24+ Years in the IT Sector, Last 12 years in the BI Space, Passionate about knowing and understanding data and what business actually want from their information.

Mike Boswell

Twitter: - MikeBozBoswell

LinkedIn: Mike Boswell

Mike works for Microsoft as a Data Platform Solution Architect. He likes to get involved in SQLSaturdays and the larger Data Platform conferences within Europe. You will also often see him talking at Microsoft events and how data is changing the way we work.

During his time, in Microsoft, he has worked with customers across the EMEA region in Finance, Utilities, Healthcare Public Sector and Retail. He was one EMEA Data Platform leads, where he has worked with others to with engineer’s knowledge, product launches, IP and career development.

He has extensive knowledge on our APS Systems along with core, and BI skills on SQL Server 2014/2016 and hybrid solutions on Azure.

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

David Conlan

Twitter: - @SQL_Diver

LinkedIn: David Conlan

David is a Senior Business Intelligence Developer with nearly four years experience of Microsoft Stack - T-SQL, SSIS, SSAS, SSRS. His main expertise is in building complex SSRS dashboards and the infrastructure to support them.

His hobbies include Scuba Diving (Certified PADI Advanced), Squash, Swimming, Cryptic Crosswords, Classical Music, Reading and Travel.

SQLSaturday #467 - Southampton 2015

Sessions

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

Title: Data Warehouse modeling, for data analysis and cubes

Title: When good SQL design goes bad

Title: Load Testing With SQL Server Tools

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

Title: Using Power BI with my DBA Database

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

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

Title: Azure DocumentDB

Title: SharePoint Databases - What you need to know

Title: Dive into SSISDB Catalog using PowerBI

Title: SSRS - The Dark Side: Custom Rendering

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

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

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

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

Title: MI6 Secrets - Data Security For Developers

Title: Continuous Integration and the Data Warehouse

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

Title: Building Blocks of BIML

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

Title: Building a BI Solution in the Cloud

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

Title: Query Processing Internals

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

Title: Anchor Modelling: Sixth normal form databases!

Title: Performance troubleshooting SQL Server

Title: Session Details not available

Title: SQL Server Backup in the Era of the Cloud

Title: SQL Server and Application Security for Developers

Title: Maintenance Plans: Planning to Fail

Title: Changing the face of your desktop with PowerBI

Title: 10 Things that you already knew about SSIS

Title: Building Configuring SQL Server : Recommended Practices

Title: Super Scaling Clustered Index Inserts

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

Title: ETL in the Clouds

Title: Query Optimizer internals

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

Title: Implementing and Maintaining an Azure SQL Database project

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

Speakers

Sponsors