SQLSaturday #418 - Manchester 2015

Event Date: 07/25/2015 00:00:00

Event Location:

103 Princess Street
Manchester, 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: SSRS Inception: Reporting on Reporting services.

Abstract: Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. “WAIT! We still need that for Jill in HR to do her end-of-month”, or “We might still need that” - these types of comments are what leads to having a load of reports that are not being used.

Wouldn’t it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn’t it then be even better if we could automate a process to email the owner of that report to say “HA! I told you no one looked at this report!”. In this session we will look at how we can do all of this and more by mining the SSRS DB.

Speaker(s):

Terry McCann

Track and Room: Business Intelligence - John Torcher

Title: What do I need to know about SQL Server platform upgrade?

Abstract: Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources. A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.

Speaker(s):

Satya Jayanty

Track and Room: DBA - PeterLoo

Title: Data 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: Business Intelligence - John Torcher

Title: Advanced SSIS Techniques

Abstract: As an ETL developer using SQL Server Integration Services have you ever wondered how to:

Import all .csv files from a folder
Replace dynamic SQL using variables in SSIS
How to configure the data flow buffer
Create custom logging solutions
Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to:
Import/export multiple sources/destinations
Use an execute SQL task with variables to replace dynamic SQL within a package
Dynamically handle errors within any part of a package

Speaker(s):

David Dye

Track and Room: Business Intelligence - John Torcher

Title: The first step towards continuous integration for SQL Server

Abstract: Continuous integration (CI) is a development practice that has become widely adopted for the application layer because it allows teams to detect problems quickly and locate errors more easily. By regularly integrating code into a shared repository and automatically verifying it you’ll build confidence in your code.

But database CI continues to be a painful, manual process in many projects. There are many reasons for this, most obviously the issue of data persistence, but there are ways to handle these issues.

In this session, I will show you:

-How easy it is to get your SQL Server database changes in source control -How to set up an automated build process for your databases -How this process helps you spot and fix errors quicker -How to produce an artifact you can use for reliable, repeatable deployments in the future

Speaker(s):

Alex Yates

Track and Room: Sponsor - John Torcher

Title: Machine Learning without a PhD in statisitcs

Abstract: Machine learning is the science of making computers act without being unambiguously programmed. Machine learning is something that we use every day when we search and shop on the web and talk to our devices. Microsoft AzureML is a fully-managed cloud service that enables data aware developers to efficiently embed predictive analytics into their applications, without a PhD in statistics helping organizations use massive data sets and bring all the benefits of the cloud to machine learning. So join Andrew for a practical insight into the fascinating world of Machine Learning, where you can be significantly different but never certain, deviation is normal, and you are amongst friends if you found the above quote funny.

Speaker(s):

Andrew Fryer

Track and Room: Azure - Mary Quaille

Title: Beginners Guide to MDX

Abstract: Give your queries a multidimensional makeover. In this session we’ll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.

MDX can seem a very daunting language, but when it’s broken down into the basics it’s easier than you think.

We’ll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!

We’ll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we’ll look at some of the awesome power that MDX can provide to our reporting.

Speaker(s):

Alex Whittles

Track and Room: Business Intelligence - Woods Room

Title: BI Application Lifecycle Management with TFS and Octopus Deploy

Abstract: Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how Team Foundation Server (TFS) and Release Manager or Octopus Deploy will help you in in that feat. I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit and Octopus Deploy, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using Octopus Deploy. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.

Speaker(s):

Dmytro Andriychenko

Track and Room: Business Intelligence - Dean Room

Title: Exploring the Microsoft Data Platform the Changing Role of the DBA

Abstract: The Microsoft Data Platform used to be Microsoft SQL Server, now we have a variety of different options spanning on-premises and cloud. With this increasing array of options the role of the DBA is changing, understanding how these technologies compliment each other and what they are will become more important for the DBA as the roles change.

In this session we will look at Microsoft SQL Server, Azure SQL DB, DocumentDB and Azure Table Storage, all of which can be used to provide a highly effective data platform on which to build applications. I will help you understand what each of the offerings is, how it differs from the others and demonstrate some examples of when you might want to use one over another.

Speaker(s):

John Martin

Track and Room: Azure - Dean Room

Title: SQL Server 2014 In-memory technologies - Columnstore, In-Memory O

Abstract: Register @ http://manchesterpass.ddns.net/Speaker5.html

Assuming no prior knowledge of In-memory technologies we first introduce concepts, what do we mean by in-memory, what features exist in SQL Server 2012 and SQL Server 2014. We then drill into each feature giving you a working knowledge that can be applied into your own environments, the day will be example led.

Introduction to in-memory technologies and features baked into SQL Server 2012 and 2014 OLAP - Columnstore •Nonclustered •Clustered •Design considerations, how it works and troubleshooting/monitoring OLTP - In-memory OLAP •Tables •Natively compiled stored procedures •Design considerations, how it works and troubleshooting/monitoring

Speaker(s):

Tony Rogerson

Track and Room: DBA - Dean Room

Title: Introducing Azure SQL Data Warehouse

Abstract: Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand. Come to this session and learn all about it from the co-author of the official documentationlt;https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/gt;!

Speaker(s):

James Rowland-Jones

Track and Room: Azure - Mary Quaille

Title: SanDisk – Delivering the Application Accelerated Data Centre

Abstract: Since the acceptance of enterprise flash technology as a viable alternative to legacy hard disk drives; there has emerged a diverse range of solid state products. Consumers are faced with daunting task of needing to consider (amongst others) cost, capacity, endurance, interfaces; and the reality that not all flash is the same.

Principal Solutions Architect Phil Clarke, will discuss these challenges, enabling you to make an informed choice for your SQL infrastructure

Speaker(s):

Steve Wharton

Track and Room: Sponsor - Mary Quaille

Title: Practical R: A hands-on training day

Abstract: Register @ http://manchesterpass.ddns.net/Speaker6.html

Bring your own laptop!

R is a powerful language to add to the BI, analytics and data science technologies you may already be using. This one day training session circumvents the painful experience of on-boarding a new technology and will give you the foundation needed to use R effectively via a series of focussed modules complete with hands-on labs. Topics covered will include effective R coding, development best-practices, using R as a reporting tool, and how to build and administer a solid platform for analysis. •Effective R will take you from “0 to Hero” and with no prior knowledge required, we’ll get R installed and get you wrangling and visualising data in no time.

•DevelopeR Skills teaches you how to build robust, scalable, and version controlled code.

•R is for Reporting takes you through the “reproducible research” and reporting functionality so you can deliver cost free awesome reports to your business

Speaker(s):

Stephanie Locke

Track and Room: Business Analytics - Mary Quaille

Title: Tempdb - a database developer’s perspective

Abstract: Ask the internet for help when you have a performance issue with tempdb and you will find a slew of articles on how to configure and setup tempdb on your server, how many files to use, where to place them on the disk subsystem, even what hardware to use. But what if you are a developer, with no access or control over the configuration of the server. In this session Kevan explains what tempdb is and what it is used for and leading on from that how you can, through development approaches, control how you use it. The usage of tempdb will go hand-in-hand with the overall performance of your queries, so do not be surprised if you learn how to make your queries fly at the same time.

Speaker(s):

Kevan Riley

Track and Room: DBA - PeterLoo

Title: The elephant in the room: Continuous Delivery for Databases

Abstract: Let’s talk about constraints. What’s holding you back from achieving Continuous Delivery?

Databases.

If it’s painful, do it often… Your app is automatically integrated, tested and packaged for deployment in minutes. But what about databases?

Of course, databases come with complications and risks. We’ll talk about both the human and technical changes which are necessary to achieve a reliable, nimble, and automated database deployment process.

You’ll learn how to bring Dev and Ops closer together as well as customise established practices and existing toolsets to build a database deployment pipeline and speed up delivery while at the same time protecting the data (and your sanity).

In particular, we’ll look at two alternative solutions to the problem and their relative pros and cons. Declarative/state based development vs purely migrations driven development.

By the end of the session, delegates will have learned not only that this elephant in the room can be tamed, b

Speaker(s):

Alex Yates

Track and Room: DBA - Woods Room

Title: Implementing and Maintaining an Azure SQL Database project

Abstract: This session looks at how to implement, maintain and evolve 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: Azure - Mary Quaille

Title: Deep Dive into In-Memory OLTP (Hekaton)

Abstract: For those who already have a basic understanding of Hekaton this session takes a deeper look; the session focus will be: Row Chains and MVCC, Hash and Range index internals and when and how to use. We will cover how to diagnose and deal with issues (through DMV’s and Perfmon). Hekaton basics are assumed.

Speaker(s):

Tony Rogerson

Track and Room: DBA - PeterLoo

Title: One BI Platform to Rule Them All

Abstract: Whether you are a Data Wizard, a Dwarf mining for insights, an Elf creating elegant visualisations or an ordinary Hobbit seeking business enlightenment before second breakfast, BI Office from Pyramid Analytics can help you achieve your quest for insights and timely business information. By demonstrating how to build a BI Solution in 45 minutes, this session will show you how BI Office can make you a BI Hero in your organisation!

Speaker(s):

Ian Macdonald

Track and Room: Sponsor - Woods Room

Title: AD 2015. 2 AM. A Disaster just began…

Abstract: 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I’ll show You how to be BEST prepared.

Speaker(s):

Tobias Koprowski

Track and Room: Data Practices - Dean Room

Title: Creating Mobile Dashboards with DataZen

Abstract: With Microsoft’s acquisition of DataZen, dashboard and mobile BI is now easier than ever. Come along and see how to get started with DatZen.

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

Speaker(s):

Bob Duffy

Track and Room: Business Intelligence - John Torcher

Title: Everything’s bigger these days – even data!

Abstract: Join us for a lightning tour of Microsoft’s Azure HDInsight service for Big Data. Based on open-source Hadoop technologies, HDInsight provides the tools you need to process and analyze large volumes of diverse data; and in this session you’ll find out how to provision an HDInsight cluster and get started with a veritable alphabet soup of Hadoop technologies such as Hive, Pig, Sqoop, Oozie, HBase, Storm, and Mahout.

Speaker(s):

Graeme Malcolm

Track and Room: Azure - Mary Quaille

Title: Database source control workshop

Abstract: If you want to take the first step in improving your database development process with DLM, this is the workshop for you.

You’ll learn how to:

1.Source control your database – the first step in any DLM process 2.Deploy your databases from source control 3.Monitor and track database changes across development, testing, and production environments

Are you ready for this workshop?

To get the most out of this workshop, you should be:

•Performing database development •Looking to improve your processes •Working with: ◦SQL Server 2005+ ◦SQL Server Management Studio (SSMS) ◦T-SQL

Speaker(s):

Alex Yates

Track and Room: Data Practices - PeterLoo

Title: Introduction to Replication from concepts to a running system!

Abstract: We will be taking you through how to setup replication, what types of options are available to you (snapshot,merge,transaction,peer to peer), how to implement them, an explanation of the various SQL Agent Jobs and Replication binaries involved and what the limitations are. This session will provide you with almost everything you need to know to get started with replication or give you a valuable refresher to the topic if you haven’t done it in a while.

Speaker(s):

David Williams

Track and Room: DBA - Woods Room

Title: The 30 minute data warehouse

Abstract: This session takes you through the Power BI product set and explains how you can get analyse, experiment and iterate during the first stages of data warehouse proof of concept using Excel and Power BI. You will see how to model your data warehouse schema, make the processes more intuitive and specify the required outputs, aggregations and KPIs more efficiently while giving users an instant feel for the necessary outputs,

Speaker(s):

Adam Aspin

Track and Room: Business Intelligence - John Torcher

Title: DBA Guide to Extended Events

Abstract: Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we’ve had available before, using new features can take time to learn

This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what’s happening inside your SQL Servers in ways no possible before

Speaker(s):

Neil Hambly

Track and Room: DBA - PeterLoo

Title: Approaches to database Unit Testing

Abstract: Database testing can be challenging, for a number of reasons that will be touched on in this session.

We will discuss the motivations for unit testing, as well as some of the particular challenges involved in testing database code and integrating this testing into the software development process.

Over the years, a number of tools and approaches have been developed to address these difficulties, and we will draw comparisons between some of these in order to highlight the questions you need to consider in choosing a testing approach for your own projects.

Speaker(s):

Gavin Campbell

Track and Room: Data Practices - Woods Room

Title: Building your first Microsoft Azure IaaS infrastructure

Abstract: Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.

Speaker(s):

John Martin

Track and Room: Azure - Dean Room

Title: Building Big Data Solutions with Microsoft Azure HDInsight

Abstract: Register @ http://manchesterpass.ddns.net/Speaker1.html

Need to work with big data? Attend this session to learn how to use Microsoft Azure HDInsight to process big data and to generate results for analysis and reporting. The session will explain how to provision and manage Azure HDInsight, how to use Hadoop technologies like Pig, Hive, Oozie, Sqoop, HBase, and Storm to process data, and how to consume and visualize the results.

Speaker(s):

Graeme Malcolm

Track and Room: Azure - Woods Room

Title: INSERT / UPDATE / DELETE - deep dive

Abstract: DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level. After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated. SEE, what a workload will be caused by a “forwarded record”. What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes

Speaker(s):

Uwe Ricken

Track and Room: DBA - PeterLoo

Title: Agile BI

Abstract: Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.

Speaker(s):

Stephanie Locke

Track and Room: Data Practices - Woods Room

Title: Data Quality Improvement through Master Data Driven Business Inte

Abstract: Today’s Business Intelligence systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. How can you improve BI value by ensuring data quality through Microsoft SQL Server Master Data Services, accelerated by Profisee’s Master Data Maestro.

Speaker(s):

Ben Cooper

Track and Room: Sponsor - PeterLoo

Title: SQL Server Batch Mode and CPU Architectures

Abstract: This session starts out with a demo which defies conventional wisdom, the purpose of this being to provide a ‘Hook’ into how CPUs are designed, how they work and how batch mode leverages modern CPU architectures. The concept of batch mode back pressure will be explored along with the pressure points batch mode places on modern CPUs and where the next quantum leap in performance might come from.

Speaker(s):

Christopher Adkin

Track and Room: DBA - Dean Room

Title: Session Details not available

Abstract: Session Details not available

Speaker(s):

n/a n/a

Track and Room: Business Intelligence - John Torcher

Title: Session Details not available

Abstract: Session Details not available

Speaker(s):

n/a n/a

Track and Room: Azure - Mary Quaille

Title: Machine Learning without a PhD in statistics

Abstract: Register @ http://manchesterpass.ddns.net/Speaker2.html

Traditional BI has been all about creating consistent data sets fronted with easy to use tools to allow our users to explore data and make decisions. While this still has its place it doesn’t cover predictions well nor does it deliver any actionable insight. That gap is starting to be filled by machine learning and while this has been expensive and complex to implement, Azure Machine Learning takes away a lot of this and at low risk. So if you are curious, you know the data you work with and the business you are in let us enlighten you about how this might really transform your business with only the most basic knowledge of statistics!

Speaker(s):

Andrew Fryer

Track and Room: Azure - Purcell

Speakers

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

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Ian Macdonald

LinkedIn: Ian Macdonald

Contact: http://uk.linkedin.com/pub/ian-macdonald/1/381/2a1

Ian is a data wizard, who has nearly 30 years’ experience in the Enterprise Business Intelligence market. Starting in Technical Support, training and consulting with Information Builders in 1986, he subsequently developed a career in presales, product marketing and marketing , holding senior VP positions with companies such as Microsoft, Hyperion Solutions and HP. Ian has been working with Pyramid Analytics for five years, initiating their UK presence in 2011.

Gavin Campbell

LinkedIn: Gavin Campbell

Contact: http://arapaima.uk

Gavin Campbell is a recovering Business Intelligence developer specialised in improving working practices in database delivery through the use of tools such as SQL Server Data Tools, tSQLt, Visual Studio Team Services, Git and Jenkins, on platforms such as AWS and Microsoft Azure, and methodologies such as Continuous Delivery and Agile.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

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

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.

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.

Alex Whittles

Twitter: - @PurpleFrogSys

LinkedIn: Alex Whittles

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

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

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.

Kevan Riley

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

LinkedIn: Kevan Riley

Contact: https://www.rileywaterhouse.co.uk/blog

Kevan Riley (MCSE: Data Management and Analytics) has been working with SQL Server since 1999 in a variety of DBA and DB developer roles. He now works as a freelance SQL Server Consultant in the UK and is no more happier than when knee-deep in performance tuning. He can be often found contributing at ask.sqlservercentral.com and getting involved with the SQL community at UK user groups, SQLSaturdays, SQLBits and SQL Relay.

Andrew Fryer

Twitter: - @deepfat

Contact: http://www.andrewfryer.com

Andrew Fryer is a Technical Evangelist at Microsoft UK Ltd, specialising in database management amp; BI. When not blogging and making screencasts in the office he can be found presenting at various technical events across the UK including, Future Decoded, TechDays OnLine, and any event with the acronym SQL in the title.

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.

Uwe Ricken

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

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.

Dmytro Andriychenko

Twitter: - @dataunited

LinkedIn: Dmytro Andriychenko

Contact: http://www.data-united.co.uk

Dmytro Andriychenko has over 10 years of SQL Server experience working as analyst, admin, developer and designer. Dmytro is a Microsoft Certified BI Expert with plenty of experience in all components of SQL Server in a variety of business settings (Betting, Banking, Legal, NHS and Bio-Pharma). His most recent focus is on BI architecture and delivery.

Tony Rogerson

Twitter: - @tonyrogerson

LinkedIn: Tony Rogerson

Contact: http://dataidol.com/tonyrogerson

Tony is a freelance SQL Server and Data Specialist, he is a Fellow of the British Computer Society, has a masters degree in BI and a PGCert in Data Science. For the past 18 years he has been using SQL Server, received the SQL Server MVP award for the past 16 years. Interested in distributed commodity data processing.

Ben Cooper

LinkedIn: Ben Cooper

Ben has over 15 years’ experience working with SQL Server and supporting Microsoft data platform technologies. Ben joined Profisee 6 months ago as a Pre-Sales Solutions Consultant to build capability and revenue streams in the UK.

Prior to Profisee, Ben spent 9 years working at Microsoft as a SQL Server Premier Field Engineer and recently as a Technical Solution Architect designing solutions and supporting the Enterprise Sales teams position SQL Server as a tier 1 mission critical platform.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

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

n/a n/a

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.

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.

n/a n/a

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.

Andrew Fryer

Twitter: - @deepfat

Contact: http://www.andrewfryer.com

Graeme Malcolm

Twitter: - @graeme_malcolm

Graeme Malcolm has been a trainer, consultant, and author for longer than he cares to remember, specializing in SQL Server and the Microsoft data platform. After years of working with Microsoft as a partner and vendor, he joined Microsoft as a full-time employee and now works in the Microsoft Learning Experiences team as a Senior Content Developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.

Alex Yates

Twitter: - @alexyates

LinkedIn: Alex Yates

Contact: http://www.workingwithdevs.com

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.

Graeme Malcolm

Twitter: - @graeme_malcolm

Stephanie Locke

Twitter: - @stefflocke

LinkedIn: Stephanie Locke

Contact: https://itsalocke.com

Alex Yates

Twitter: - @alexyates

LinkedIn: Alex Yates

Contact: http://www.workingwithdevs.com

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.

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.

Terry McCann

Twitter: - @SQLShark

LinkedIn: Terry McCann

Contact: https://www.advancinganalytics.co.uk/blog

Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master’s degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.

Tony Rogerson

Twitter: - @tonyrogerson

LinkedIn: Tony Rogerson

Contact: http://dataidol.com/tonyrogerson

Adam Aspin

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for nineteen years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite. He is the author of quot;High Impact Data Visualization with Power View, Power Map, and Power BIquot;, “SQL Server Data Integration Recipes” and quot;Business Intelligence with SQL Server Reporting Servicesquot; - all with Apress

James Rowland-Jones

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

LinkedIn: James Rowland-Jones

James Rowland-Jones (JRJ) is a Principal Program Manager at Microsoft. He is currently part of the SQL Server team working on SQL Server 2019 Big Data Clusters and data virtualization. Prior to joining SQL Server, JRJ worked extensively on Azure SQL Data Warehouse. He helped the team launch Gen 1 of the service and led the product management effort to bring Gen 2 into preview.

Steve Wharton

Twitter: - @SanDiskEurope

Steve Wharton is a Principal Systems Engineer at Fusion-io a SanDisk Company. Steve has been working in IT for more than 20 years and has previously held positions at Data Domain, Dell, Compaq and several bluechip companies in IT delivery roles.

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.

SQLSaturday #418 - Manchester 2015

Sessions

Title: SSRS Inception: Reporting on Reporting services.

Title: What do I need to know about SQL Server platform upgrade?

Title: Data modeling for data analysis and cubes

Title: Advanced SSIS Techniques

Title: The first step towards continuous integration for SQL Server

Title: Machine Learning without a PhD in statisitcs

Title: Beginners Guide to MDX

Title: BI Application Lifecycle Management with TFS and Octopus Deploy

Title: Exploring the Microsoft Data Platform the Changing Role of the DBA

Title: SQL Server 2014 In-memory technologies - Columnstore, In-Memory O

Title: Introducing Azure SQL Data Warehouse

Title: SanDisk – Delivering the Application Accelerated Data Centre

Title: Practical R: A hands-on training day

Title: Tempdb - a database developer’s perspective

Title: The elephant in the room: Continuous Delivery for Databases

Title: Implementing and Maintaining an Azure SQL Database project

Title: Deep Dive into In-Memory OLTP (Hekaton)

Title: One BI Platform to Rule Them All

Title: AD 2015. 2 AM. A Disaster just began…

Title: Creating Mobile Dashboards with DataZen

Title: Everything’s bigger these days – even data!

Title: Database source control workshop

Title: Introduction to Replication from concepts to a running system!

Title: The 30 minute data warehouse

Title: DBA Guide to Extended Events

Title: Approaches to database Unit Testing

Title: Building your first Microsoft Azure IaaS infrastructure

Title: Building Big Data Solutions with Microsoft Azure HDInsight

Title: INSERT / UPDATE / DELETE - deep dive

Title: Agile BI

Title: Data Quality Improvement through Master Data Driven Business Inte

Title: SQL Server Batch Mode and CPU Architectures

Title: Session Details not available

Title: Session Details not available

Title: Machine Learning without a PhD in statistics

Speakers

Sponsors