SQLSaturday #496 - Exeter 2016
Event Date: 03/12/2016 00:00:00
Event Location:
- Jurys Inn Exeter
- Western Way, Exeter
- Exeter, England, United Kingdom
This event has completed. All data shown below is from the historical XML public data available.
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: 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 - Gwithian
Title: From SSMS to SSDT why and how to move your SQL database development to SSDT
Abstract: SSMS is the love child of what was Query Analyzer and Enterprise Manager and has ever since been used as the dev tool of choice for people creating and modifying database schemas and code. Whilst SSMS is a really good management tool it is not suited to modern development. Instead Microsoft has created SSDT (SQL Server Data Tools) which has had a lot of attention from Microsoft in the last few years which means that it is now ready for us to use full time.
We will cover:
- How to get your databases into SSDT and critically how to get them to compile correctly.
- A tour of the SSDT features that show how T-SQL development is actually easier and how SSDT makes you more productive
- The build deployment process so you can start concentrating on writing useful code instead of upgrade and release scripts.
If you write, debug or modify SQL Server database code and haven’t yet started using SSDT full time then this session will help you get started and be productive quickly.
Speaker(s):
- Ed Elliott
Track and Room: Application Database Development - Widemouth
Title: You don’t need Enterprise Edition to do that!
Abstract: The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who “window shop” the latest and greatest features and return to the office wishing they never saw those features presented. This session will show you how you can achieve the same, or at least a similar, outcome to some of those features without having to fork out for Enterprise Edition licenses or breaking any license agreements. You will leave the session with a set of solution concepts covering Partitioning, Data Compression and High Availability that you can build upon or extend and maybe save you and your company a nice pile of cash.
Speaker(s):
- William Durkin
Track and Room: Application Database Development - Bude
Title: A first look at the Azure Data Lake Analytics service
Abstract: Do you want to be able to query huge amounts of data at cloud scale on a distributed infrastructure that is capable of scaling with your needs? Do you want to use a language that is both familiar and powerful to extract valuable insights from your data? If the answer to both of these questions is “yes” then Data Lake is definitely something you should be looking at. In this session we will look at the Data Lake analytics service, a service capable of handling queries against data of any size instantly simply by requesting more compute for each query. U-SQL is a query language that blends the declarative nature of SQL with the expressive power of C#. Visualisations of your U-SQL jobs let you see how your code runs at scale. Come to this session to see why people are talking about this new offering from Microsoft and see some of the problems it solves
Speaker(s):
- Allan Mitchell
Track and Room: Analytics and Visualization - Fistral
Title: Re-architecting your old-school database to maximize Azure cloud options
Abstract: The quickest way to migrate your on-premises OLTP database to Azure is to simply “Lift Shift”. You create a vm in Azure and size it to match your local system and move your database into it. This might not be the most cost effective way though and also, you still have to do all the database maintenance yourself. In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc. in order to truly scale our system. And we’ll see if this increases or lowers the total cost of ownership. This excercise is about an OLTP system but we will also look at how it affects loading our DWH from this new setup.
Speaker(s):
- André Kamman
Track and Room: Cloud Application Development Deployment - Gwithian
Title: SQL Server 2016, New Features and Enhancements - DBA Features
Abstract: SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing and implementing SQL Server solutions. We will focus on the SQL Server engine, covering topics including Operational Analytics, Temporal amp; Stretch Tables and Always Encrypted. And we will be having a look at some of the old favourites, including enhancements to In-Memory OLTP (Hekaton) AlwaysOn Availability Groups.
In part 1 we will look at the new DBA features which include:
- Setup and behaviour Changes
- HA/DR (Availability Groups, Backup/Restore)
- Stretch DB
- Temporal Tables
Speaker(s):
- John Martin
Track and Room: Advanced Analysis Techniques - Widemouth
Title: Dive into SSISDB Catalog using Power BI
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 Information Delivery - Gwithian
Title: Dealing With Errors in SSIS
Abstract: Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.
You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details
Speaker(s):
- David Dye
Track and Room: BI Platform Architecture, Development Administration - Gwithian
Title: MI6 Secrets - Data Security For Developers
Abstract: You are a secret agent with Licence To Kill, posing as a developer in Exeter. This is your briefing (For Your Eyes Only) on how to turn business logic into database objects. Learn about SQL Server’s data security mechanisms (including SQL Server 2016), implement multi-tiered data access with business rules and roles, make your app/database immune to infrastructure changes (like scaling from single server into clustered or to the cloud) and M’s moods in the future, avoid SQL injection and other security and app coding bugs using stored procedures and database server side logic. Session suited for Developers and Students (Johnny English level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Speaker(s):
- André Melancia
Track and Room: Application Database Development - Bude
Title: SQL Server 2016, New Features and Enhancements - Dev Focus
Abstract: SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing and implementing SQL Server solutions. We will focus on the SQL Server engine, covering topics including Operational Analytics, Temporal amp; Stretch Tables and Always Encrypted. And we will be having a look at some of the old favourites, including enhancements to In-Memory OLTP (Hekaton) AlwaysOn Availability Groups.
In part 2 we will focus on dev features:
- New Security Features (AlwaysEncrypted, Row Level Security Dynamic Data Masking)
- In -Memory OLTP (Hekaton)
- Query Data Store setup and overview
Speaker(s):
- John Martin
Track and Room: Advanced Analysis Techniques - Widemouth
Title: Still running SQL 2005? Thinking about upgrading to SQL 2014?
Abstract: Learn about Microsoft’s SQL Data Warehouse Fast Track solutions.
Microsoft’s Data Warehouse Fast Track program offers:
#183; Faster deployment and tamed complexity with pre-configured, partner-led solutions
#183; Flexibility and choice of the latest generation of hardware from top vendors in the industry
#183; Out-of-the-box offerings with reduced risk and greater confidence
With support for SQL Server 2005 ending in April 2016, now is the time to upgrade to SQL Server 2014. With Flash architectures now being considered mainstream, now is also an opportunity to optimise your data platform infrastructure.
This presentation discusses the process undertaken to achieve a certification, whilst focusing on a cost effective (single socket), scalable 7 TB SMP Data Warehouse solution (Lenovo x360M5 and SanDisk SSD) which achieves an efficient out-of-box balance between SQL Server data processing capability and hardware resources.
Speaker(s):
- Niall MacLeod
Track and Room: Advanced Analysis Techniques - Gwithian
Title: Estimation and Statistics : The Basis of query optimization
Abstract: At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken. How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
Speaker(s):
- Dave Ballantyne
Track and Room: Application Database Development - Bude
Title: Investigate TempDB like Sherlock Holmes
Abstract: The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.
Speaker(s):
- Lord Richard Douglas
Track and Room: Enterprise Database Administration Deployment - Bude
Title: Lightning Talks
Abstract: Lightning talks to include: Alex Yates - Post-its on the wall Andrew Pruski - Introduction to partitioning Ben Watt - Three Ingredients. Only three pieces of data to produce 60+ visualisations. Gavin Campbell - Unit testing with tsqlt and Visual Studio
Speaker(s):
- Annette Allen
Track and Room: Advanced Analysis Techniques - Fistral
Title: Office 365 - The Art of the Possible
Abstract: Office 365 plays a key role in the Microsoft Cloud offering. It combines many different capabilities that have historically been separated into different products. The convergence of the products on one platform is opening up new possibilities for delivering new and exciting ways of collaborating.
This session will explain some of the ways that Office 365 is being used and demonstrate some of the capabilities that convince millions of companies to invest in Office 365 to replace existing products with a single unified environment making the most of the familiar business critical tools from Microsoft.
Speaker(s):
- Al Eardley
Track and Room: Strategy and Architecture - Bude
Title: Adding another Dimension type to SQL Server 2016
Abstract: In this session, we will focus in on how we can use temporal tables, along with a Stretch table, to provide an alternative solution to Type 2 Dimensions and archiving data with SQL Server 2016 and Azure DB. We will cover an overview of each technology, feature setup/install, compatibility with other SQL Server 2016 features, wait types and how to monitor these two important features.
Speaker(s):
- Mike Boswell
Track and Room: BI Information Delivery - Widemouth
Title: The new world of enterprise Business Intelligence
Abstract: Any data, anywhere and at any time. A discussion on the latest roadmap and features from SQL server 2016 BI though to cloud capabilities with PowerBI. Understand how to leverage and create an integrated hybrid BI experience across your enterprise.
Speaker(s):
- Andrew Fryer
Track and Room: BI Platform Architecture, Development Administration - Gwithian
Title: The first step towards release management for SQL Server
Abstract: Do you find SQL deployments risky and painful? Do you struggle to keep track of changes across multiple environments? Do you need to find a balance between automation and human intervention?
If the business wants you to deploy more frequently but your SQL deployments are a bottleneck, this session may provide you with some answers.
At last year’s SQLSaturday Alex showed you how to set up a working automated build and test process. This year he will take a you one step further by adding release management to that set-up.
Speaker(s):
- Alex Yates
Track and Room: Information Delivery - Gwithian
Title: Why and how to Implement PowerShell DSC for SQL Server - Part 1
Abstract: We will cover the basics of PowerShell DSC with the differing deployment modes - what it is and why it matters for your future infrastructure deployments and why this is one of the technologies to work with in future.This will then give the audience opportunity to begin to understand how this can be used with SQL Server which we will cover in Part 2. We will also cover in this session why Source control is a crucial feature to use alongside PowerShell DSC also the OSS movement by Microsoft for the Server Configurations.
Speaker(s):
- Ryan Yates
Track and Room: Enterprise Database Administration Deployment - Fistral
Title: Social Engineering: Hacking People
Abstract: “It is much easier to trick someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s secrets. The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to hack you.
Speaker(s):
- Mladen Prajdić
Track and Room: Professional Development - Widemouth
Title: Think work like a Data Scientist with SQL 2016 R.
Abstract: What are these DATA Scientists upto? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the outcome within SQL 2016 itself.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Advanced Analysis Techniques - Widemouth
Title: Why and how to Implement PowerShell DSC for SQL Server - Part 2
Abstract: In this session we will look at the dedicated SQL specifics that we will be looking to apply using PowerShell DSC and in this session we will have standup a SQL Server using DSC and with an existing SQL Server we will cover with a live demo the changing of some SQL Settings in the Configuration and how this makes life easier for Management of SQL Servers at scale - No more need for manually changing Service Account passwords on mulitple SQL Servers when we can apply it via a configuration to many servers at once.
Speaker(s):
- Ryan Yates
Track and Room: Enterprise Database Administration Deployment - Fistral
Title: Necto - Smart Data Discovery
Abstract: Introduction to Panorama Necto 14: Suggestive, Collaborative Visual BI Platform.
Panorama believe the next big business idea will arise, by cultivating the collective brain-power of your team with the leading BI 3.0 system. That is why Panorama developed Necto - Suggestive Visual Insight Discovery Solution. Necto provides your users within one unique platform all the tools to focus, collaborate, decide and act.
Speaker(s):
- Santiago Castro
Track and Room: Analytics and Visualization - Fistral
Title: Session Details not available
Abstract: Session Details not available
Speaker(s):
- n/a n/a
Track and Room: Analytics and Visualization - Widemouth
Title: Stats 101
Abstract: Those maths lessons in school were long ago, and now the new hotness requires lots of statistics. It’s enough to make a person think about changing careers. Tackle this worry by coming along to this session where I make statistics simple(-ish)!
Speaker(s):
- Stephanie Locke
Track and Room: Analytics and Visualization - Bude
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. With the summer announcement of the integration of Power BI and BI Office, on premise BI solutions are now easily achievable. This session will show you how Power BI with BI Office can make you a Superhero in your organisation!
Speaker(s):
- Ian Macdonald
Track and Room: Advanced Analysis Techniques - Bude
Title: Introduction to U-SQL
Abstract: U-SQL is the new kid on the SQL language block. In this session we’ll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? How do you learn it? We’ll discuss all this and more.
Speaker(s):
- Alex Whittles
Track and Room: BI Platform Architecture, Development Administration - Fistral
Title: String Concatenation Done Right
Abstract: Numerous techniques for concatenating string data can be found online, and even in some books. In this session you will learn two of them that are reliable, and fairly easy to understand, implement, and deploy. You will also learn how to control the order of the values being concatenated, a feature that is not natively provided by SQL Server.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Fistral
Title: Creating Mobile Dashboards with DataZen
Abstract: With Microsoft’s acquisition of DataZen dashboard and mobile BI is not easier than ever, with DataZen being bundled with SQL Server. Come along and see how to get started with DataZen.
We will be showing an end to end demo of creating and publishing dashboards for mobile and tablet devices.
Speaker(s):
- Bob Duffy
Track and Room: Analytics and Visualization - Fistral
Title: Keynote
Abstract: To be confirmed
Speaker(s):
- Annette Allen
Track and Room: Advanced Analysis Techniques - Gwithian
Title: Responding to Extended Events in near real-time
Abstract: Extended Events provide deep insight into SQL Server’s behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking.
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions.
Speaker(s):
- Gianluca Sartori
Track and Room: Enterprise Database Administration Deployment - Bude
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
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 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
Andrew Fryer
Twitter: - @deepfat
Contact: http://www.andrewfryer.com
Andrew Fryer (@deepfat) is 8 years in to his role as a Technical Evangelist at Microsoft UK Ltd, specialising in Cortana Analytics, 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 SQL Bits, SQL Relay, and of course SQLSaturdays. He also works on various data science projects in collaboration with Microsoft Research.
Ben Watt
Twitter: - @benrebooted
LinkedIn: Ben Watt
Ben came from a SQL Server developer background moving to Business Intelligence consulting in the UK, Australia and Switzerland and now Ireland.
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.
Ryan Yates
Twitter: - ryanyates1990
Contact: http://www.kilasuit.org/blog
SharePoint amp; PowerShell Specialist - moving more into a dedicated PowerShell focus to help coach organisations in methods that they can use to improve their configuration management on a larger scale allowing them to deploy production ready code quicker, easier and with more confidence and importantly at scale in a repeatable manner.
Co-Ordinator of the UK PowerShell User Groups - with groups in Manchester amp; London but with a view to expand this across the UK in 2016 - If interested in getting one going in your area then lets talk about it :-)
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.
n/a n/a
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.
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.
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
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.
William Durkin
Twitter: - @sql_williamd
LinkedIn: William Durkin
Contact: http://williamdurkin.com
William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
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.
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.
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.
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 different 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).
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.
Ryan Yates
Twitter: - ryanyates1990
Contact: http://www.kilasuit.org/blog
SharePoint amp; PowerShell Specialist - moving more into a dedicated PowerShell focus to help coach organisations in methods that they can use to improve their configuration management on a larger scale allowing them to deploy production ready code quicker, easier and with more confidence and importantly at scale in a repeatable manner.
Co-Ordinator of the UK PowerShell User Groups - with groups in Manchester amp; London but with a view to expand this across the UK in 2016 - If interested in getting one going in your area then lets talk about it :-)
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.
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.
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
Santiago Castro
Santiago has fourteen years of experience facilitating change for a wide variety of clients to become data driven decision making organisations. He’s experienced in data analytics and technical skills combined with management consulting work. He has substantial knowledge and practical skills with a range of data products for decision analysis, Reporting, Business Intelligence, Data Analytics and Decision Support Systems.
As Head of Business Analytics, Santiago primarily oversees the UK operations for BIPB and also takes on wider group responsibilities providing deep knowledge and leadership to the Analytics Practice. His role combines strong technical capability of self-service BI tools, data modelling, relational databases and program
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.
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.
Ed Elliott
Twitter: - @EdDebug
LinkedIn: Ed Elliott
Contact: https://the.agilesql.club
Ed has worked with SQL Server for 10 years and is a SQL developer who uses his skills gained as a DBA, Developer and Support Engineer to build continuous integration and automated deployment processes.
Ed is passionate about getting SQL databases under source control, under test and deployable whether they want it or not.
Ed is always happy to talk development processes and SQL server any time (except tea time).
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.
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.
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.
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.
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Sponsors
The following is a list of sponsors that helped fund the event: