SQLSaturday #228 - Cambridge 2013
Event Date: 09/28/2013 00:00:00
Event Location:
- Queens College
- Silver Street
- Cambridge, 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: Rapid Data Integration using SharePoint Business Connectivity Services
Abstract: Anthony Obi – Performing CRUD operations against SQL data sources using SharePoint Business Connectivity Services.Many organizations see SharePoint as yet another silo of information that can only access data stored in its Lists and Libraries. In this session, Anthony will review working with external SQL data from within SharePoint using Business Connectivity Services (BCS). He will cover the basic fundamentals required to perform ‘CRUD’ (Create, Read, Update and Delete) operations against external SQL Databases, whilst also exploring a variety of SharePoint features available through a series of real time demonstrations. Finally, Anthony will attempt to highlight key points/comparisons to look out for when attempting to use in real world scenarios.
Speaker(s):
- Anthony Obi
Track and Room: Dead Parrot (SharePoint) - N/A
Title: From Big Data to secret sauce: power your organisation with PowerBI
Abstract: Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce that will help the business to make data-driven decisions to drive the enterprise forward, using familiar tools such as the new Microsoft Power BI tools
In this session, we will look at RHadoop, which is a match made in heaven for data scientists. It is a combination of R, the world’s favourite free data analysis tool, and Hadoop. In this session, we will look at an example of using RHadoop to analyse Big Data, from data to result.
We will also look at evangelising your secret sauce throughout the business, using Microsoft’s new Power BI tools in Office 365: Power View, Power Map and Power Query. Come and see how to make Big Data accessible, relevant and perhaps even fun!
Speaker(s):
- Jen Stirrup
Track and Room: …and now for something completely different - N/A
Title: Advanced Data Visualisation with Reporting Services
Abstract: As a report creator and designer, it’s your role to make the message of the data come alive for data consumers and decision-makers. This requires a balance between conveying the ‘truth’ of the data across to the target audience, in addition to making the report look interesting that it will draw people’s attentions in the first place.
SSRS is one of the most widely-used Business Intelligence products within the Microsoft stack. Come to this session to pick up some tips and tricks for advanced reporting writing, that is also in accordance with thinking by Data Visualisation gurus such as Stephen Few and Edward Tufte. This session will cover more advanced and less well-known features of reporting services with Data Viz in mind!
Speaker(s):
- Jen Stirrup
Track and Room: SPAM (BI) - N/A
Title: Database Development with SQL Server Data Tools
Abstract: With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and Windows Azure SQL Database. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the new generation of database tools for developers!
Speaker(s):
- Leonard Lobel
Track and Room: Ministry of funny walks (DEV) - N/A
Title: Microsoft training and certification for SQL Server and Cloud solutions
Abstract: Join Global Knowledge, a leading Microsoft Learning Partner, to hear about the latest Microsoft training and certifications available to you as SQL Server professionals, BI and SQL server developers.
Speaker(s):
- Les Reading
Track and Room: …and now for something completely different - N/A
Title: The Irish Economic Crisis, Visualized
Abstract: In this session we will explore the Irish Economic Crisis as it unfolded, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and SharePoint”. It starts from a very common business perspective, needing to make sense of data, fast, but not knowing what questions to ask, nor how to combine available sources in a way that makes sense. This session converts the Irish Economic crisis into a story that can be explored in an interactive way, using familiar tools, in a way that people may feel should have been noticed in the run-up to the crisis.
Speaker(s):
- Mark Broadbent
Track and Room: SPAM (BI) - N/A
Title: How to build process based applications on top of your SQL Data
Abstract: See the live build of a process based business application using your SQL Server data. See how an effective business data layer can speed up your time to delivering custom user forms and process driven business applications.
Speaker(s):
- Les Reading
Track and Room: Just a slither - N/A
Title: When to use which installation of SQL Server: On-prem, IaaS in Windows Azure, or Windows Azure SQLDB
Abstract: Buck will explain the various pivot-points to consider for using SQL Server on-premises, in virtualization, or in the Windows Azure Cloud Service - either as a full installation of SQL Server in IaaS, or in “SQL Azure” (Windows Azure SQL Databases). You’ll get technical guidance on which option suits your solution architecture best.
Speaker(s):
- Mark Broadbent
Track and Room: Just a slither - N/A
Title: StreamInsight: Complex Event Processing by MS
Abstract: The number of sensors is growing and growing and brings us closer to the “Internet of things”. Applications, that have to process a big amount of data from event streams are a logical consequence. Some developers might have heard from Reactive Extensions (Rx) already, but Microsoft offers with StreamInsight (SI) another comprehensive platform for these scenarios.
In this session you will learn what a great addition for your toolbox StreamInsight is, if you have to develop applications, that have to handle complex events (CEP- Complex Event Processing). See how you can start with this technologie and how easy it is to jump in for .NET developers.
Speaker(s):
- Constantin Klein
Track and Room: …and now for something completely different - N/A
Title: Automate All The Things! Best Practices for Fast, Painless Database Deployments
Abstract: “In this speed-through session, Emma will give a bird’s eye-view of database deployment best practices, covering where – and how - automation fits into your workflow. We’ll look at how to combine your database and application code changes for maximum effect, what kind of processes to put in place, and some of the tools – like Deployment Manager – that will get you there.”
Speaker(s):
- Les Reading
Track and Room: The Meaning of Life (DBA) - N/A
Title: Migrating to the Cloud
Abstract: So your CTO wants you to migrate your mission critical database application to the Azure. What’s involved and what are the pitfalls?
In one hour we will take a sample ecommerce application and database, show tools available for migrating schema, data and application components. Then we aim to demo performance and scalability impacts.
Speaker(s):
- Les Reading
Track and Room: The Meaning of Life (DBA) - N/A
Title: Business Intelligence Options for SharePoint 2013
Abstract: This presentation will provide the audience with an overview of the options available to them across the BI toolkit proivided by SharePoint 2013 and Office 2013. We will break these options down into Personal, Team and Corporate BI and look at the pros and cons of each. Specifically we will look at PowerView, PowerPivot, Excel Services and PerformancePoint covering a good mix of slides and demonstrations.
Speaker(s):
- Mark Macrae
Track and Room: Dead Parrot (SharePoint) - N/A
Title: High Performance and Highly Available SANLess Clustering for MS SQL Server
Abstract: Join SIOS to learn how to eliminate the IO bottlenecks, costs and failure points with traditional SAN-based clustering. By leveraging the performance of high-speed storage such as that offered by Fusion- io, and by adopting a SANless architecture to achieve higher levels of availability with SIOS – this ‘blueprint’ gives you the best of both worlds – cost effective performance and protection. Join us and you could win a £75 gift card.
Speaker(s):
- Les Reading
Track and Room: SPAM (BI) - N/A
Title: Introduction to SQL Server 2014 In-Memory OLTP
Abstract: This session will introduce the In Memory OLTP engine that is planned for SQL Server 2014, covering off the implementation approach, migration considerations and tips and tricks in effective use.
Speaker(s):
- Les Reading
Track and Room: Just a slither - N/A
Title: SharePoint what are you doing at my SQL event
Abstract: SQL is fundamental to every deployment of SharePoint, and increasingly many organisations have or are planning some form of SharePoint deployment. Building on the presentation from last year this session will explain the importance of SharePoint to SQL Professionals and thus why there is a dedicated SharePoint track this year. The session will be an introduction to some of the key considerations around SQL for SharePoint including different database, sizing, naming and a few common issues encountered. It will also introduce the SharePoint integration to Reporting Services which has been enhanced in SQL 2012. Finally it will make the case that you how and why you should get actively in your organisations SharePoint deployment.
Speaker(s):
- Peter Baddeley
Track and Room: Dead Parrot (SharePoint) - N/A
Title: PDW : Introduction to the Data Movement Service
Abstract: Question: How do you get multiple SQL Servers to act as one monstrously powerful processing scale out database engine?
Answer: Go to California and acquire some kick-ass technology! Introducing the DMS. Learn what it is, how it works and why it holds the key to the future for PDW. All in 30 minutes.
Speaker(s):
- Les Reading
Track and Room: SPAM (BI) - N/A
Title: Deep Dive into DQS
Abstract: Is DQS here to stay or is it the emperor’s new clothes ? in this session we will a look at how DQS can empower data cleansing in the enterprise , how we can use it in SSIS and some advanced techniques to solved complex data cleansing problems that’ll make you a cleansing and matching hero with concepts such as Term Based Relationships, Domain/Composite Domain Rules, and using Remote Data Services in Windows Azure marketplace. We will also demonstrate how to enhance your DQS KB as you cleanse, enabling a cycle of data quality improvement. If you’ve looked at DQS but aren’t sure how to get the most out of it for your data, come to this session to see how to move beyond the basics
Speaker(s):
- Regis Baccaro
Track and Room: Just a slither - N/A
Title: Leveraging PowerShell for SharePoint Database Operations
Abstract: PowerShell has become the lifeblood of SharePoint Administrators and it’s simplicity, elegance and intuitive nature makes our lives easier, or does it?
Many SharePoint admins suffer from “decisions made by SharePoint” when using both the UI and PowerShell to configure and manage their farms, database operations in particular are often clunky and inefficient due to how SharePoint uses its own stored procedures to manage its databases.
In this session we will look at how SharePoint admins can unleash their DBA-fu via PowerShell to help their SharePoint farm databases run efficiently, optimally and (the big one) FASTER.
If you want to understand how you can utilise PowerShell in SharePoint database scenarios, this session is for you.
Speaker(s):
- Seb Matthews
Track and Room: Dead Parrot (SharePoint) - N/A
Title: Now that’s what I call the worst dataviz – ever!
Abstract: Information: We will discuss the worst data visualisations in the world - ever. Join in the fun and bring along the worst data visualisation you’ve ever seen. Come and see why certain visualisations are bad, and wonder why people ever thought that it was a good idea to display data like that!
Speaker(s):
- Les Reading
Track and Room: Dead Parrot (SharePoint) - N/A
Title: Automating Database Restores and Verification with PowerShell
Abstract: SQL Server makes it simple to automate backups with jobs and maintenance, but doesn’t provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable.
This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database
Speaker(s):
- Stuart Moore
Track and Room: The Meaning of Life (DBA) - N/A
Title: Getting the most from your SAN - File and Filegroup design patterns
Abstract: You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?
Are your SAN guys telling you your storage can process 2 GB/s but you’re only seeing 200 MB/s?
This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer’s table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.
Topics covered include:
- Layout for OLTP
- Data Warehousing Fast Track Style
- Data Warehousing on a SAN
- Get data into your SSAS cubes faster (ProcessData)
- Hidden options and “go faster” buttons
- How to maximise performance in enterprise edition and master read ahead
Speaker(s):
- Stephen Archbold
Track and Room: The Meaning of Life (DBA) - N/A
Title: Advanced Indexing
Abstract: So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: The Meaning of Life (DBA) - N/A
Title: Hadoop for the Microsoft Guy
Abstract: Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone. Hadoop is different to SQL Server. Not necessarily better, just different. It is a tool for a job. if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things. This session is going to take Hadoop and break it apart. I will also look at some of the tooling Hive and Pig. Keep an open mind and let me show you that Hadoop has lots to offer.
Speaker(s):
- Allan Mitchell
Track and Room: SPAM (BI) - N/A
Title: Data Driven Branding for SSRS
Abstract: Ever had marketing send out that email saying that they are re-branding the company with new colours and fonts, normally not a problem until they mention that the 300+ SSRS reports need to be changed too…
This session will show you how to make use of SSRS project templates, and built in data sets, variable, expressions and a bit of modification to the SSRS database to help make these sorts of requests a simple matter of updating some values in a database. As opposed to pulling the reports out of source control before modifying them and trying to get a deployment scheduled.
Speaker(s):
- John Martin
Track and Room: Ministry of funny walks (DEV) - N/A
Title: Come and meet my little friend - Using Hyper-V on Windows 8 Pro
Abstract: We’ve all been there, utilising Virtualisation packages on our previous Windows installations on our desktops or laptops to test new things, in this practical session I’ll introduce you to the version of Hyper-V that comes with Windows 8 Professional, and show you how to utilise it to test various SQL Server 2012 scenarios on your machine and some useful tips.
Speaker(s):
- Kevin Chant
Track and Room: …and now for something completely different - N/A
Title: Advanced Performance Tuning Tips with Ignite
Abstract: Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. Neil will use real-life case studies to demonstrate the techniques.
Speaker(s):
- Les Reading
Track and Room: Ministry of funny walks (DEV) - N/A
Title: Idera SQL Diagnostic Manager
Abstract: Come to this session to learn about Idera SQL Diagnostic Manager
Speaker(s):
- Les Reading
Track and Room: The Meaning of Life (DBA) - N/A
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!
Speaker(s):
- Kevin Boles
Track and Room: …and now for something completely different - N/A
Title: SQL Server Estate Rationalisation
Abstract: Learn how SoftwareONE help their clients get a grip on database sprawl and poorly or semi-hidden deployments in order to improve database performance and availability whilst reducing SQL Server licence liability.
Speaker(s):
- Les Reading
Track and Room: Dead Parrot (SharePoint) - N/A
Title: MDX 101 - getting started with MDX
Abstract: Getting Multi-dimensional with Queries! 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. We’ll start at the beginning, so you need no previous MDX experience.
Speaker(s):
- Alex Whittles
Track and Room: SPAM (BI) - N/A
Title: The Day After Tomorrow: Why you need to baseline
Abstract: Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best-possible performance, you need to make sure you’re monitoring the right things. But how do you know if the figures you’re seeing are good or bad? Baseline comparisons can help, and in this session Richard will show you how to get the most from them. Richard will explain what a baseline is, why and when you need to take one, and how you can create one. You’ll also learn about a number of native Windows and SQL Server tools that will allow you to do just that.
Speaker(s):
- Lord Richard Douglas
Track and Room: Ministry of funny walks (DEV) - N/A
Title: Bitmap and Bloom Filter Indexing in SQL Server
Abstract: We look at how you can role your own indexing strategies to complement SQL Server’s B+Tree; this session will refresh you on how SQL Server Indexes work, bitwise operations. We will then look at how Bloom Filters and Bitmap Indexing can be used to dramatically improve the performance of certain query patterns within SQL Server. Session is based partly on the blog series on Bloom Filters: http://tinyurl.com/bloomfilter
Speaker(s):
- Tony Rogerson
Track and Room: The Meaning of Life (DBA) - N/A
Title: SQL 2014 Clustered Columnstore - An Introduction
Abstract: SQL Server 2014 receives a very new important feature - Clustered Columnstore Indexes. Using a xVelocity compression and a batch processing mode this type of indexes which was introduced in SQL Server 2012 is greatly enhanced by making it a Clustered and making it a default recommend solution for the DataWarehouse solutions. Join to discover the Clustered Columnstore Indexes by understanding on which principles they are built and what should you do get the best out of them. This new feature is targeted at the OLAP installations and it is already available for the PDW (Parallel DataWarehouse) v2.
Speaker(s):
- Niko Neugabauer
Track and Room: …and now for something completely different - N/A
Title: Create Your Own Data Type
Abstract: Have you ever needed a data type that SQL Server simply does not support? So why not add it? Ever since SQL Server 2005, you can easily create additional data types for use in SQL Server. Using .NET integration, you can define a data type and program all the methods you need to make it behave exactly the way you want it to - both in the database and in your .NET application programs. This session will show you exactly how to create a CLR user-defined data type, and how to integrate it in your database. Will you be the one who creates the next Big Thing, the data type that puts Spatial and Hierarchyid to shame?
Speaker(s):
- Hugo Kornelis
Track and Room: Ministry of funny walks (DEV) - N/A
Title: TraceFlag Fun
Abstract: SQLServer has many TraceFlags that are, for the most part, used to alter a specific part of functionality of SQLServer and are documented as such. Many of the more interesting flags, however are undocumented, usage is not guaranteed to work across releases, but none the less can reveal some important insight about the product, your data and your queries.
In this session a selection of flags ( both documented and undocumented ) will be explained and why you would (and would not) want to enable them.
Speaker(s):
- Dave Ballantyne
Track and Room: Ministry of funny walks (DEV) - N/A
Title: DataExplorer - the reason you might not need SQL Server
Abstract: The DataExplorer plugin for Excel( which is currently in preview) is targeting Excel users and Business Analysts by providing them a homegrown ETL process without any additional Servers. Powered by the flexibility of the “M” language, DataExplorer is capable reaching out for such diverse sources as OData, File System, HDInsight or Facebook, for example. Besides providing an accessible interface for the non-IT people, the real potential behind DataExplorer lies in creating customizable functions and processes far beyond any GUI. Join me for an hour of “DataExploration”! :)
Speaker(s):
- Niko Neugebauer
Track and Room: SPAM (BI) - N/A
Title: Analysis Services Security - Steel Curtain Cubes
Abstract: Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to XMLA and AMO as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
Speaker(s):
- Jens Vestergaard
Track and Room: SPAM (BI) - N/A
Title: Natural Born Killers, performance issues to avoid
Abstract: You’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Plus, you’ll learn how to take corrective action when: •The optimizer isn’t using all available processors •The database engine fails to report all the resources a query has used •The optimizer uses the wrong plan •Database tables cause memory issues
Speaker(s):
- Lord Richard Douglas
Track and Room: Ministry of funny walks (DEV) - N/A
Title: SQL anti patterns
Abstract: You can learn SQL in three days but it’ll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn’t work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven’t done them yet.
We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
Speaker(s):
- Kennie Pontoppidan
Track and Room: Ministry of funny walks (DEV) - N/A
Title: Access Services are cool! Are you kidding? :)
Abstract: No! Access Services in SharePoint 2013 are really cool, if used in the right way and with clear expectations. This session will give you a detailed demo-driven look to the possibilities you have with Access Services, how you integrate it with SSRS, how you can use it as RAD toolset or as an simple but effective MDS approach. A comparison to the version in SharePoint 2010, deployment and change management tips and tricks will round up the session.
Speaker(s):
- Oliver Engels
Track and Room: …and now for something completely different - N/A
Title: SharePoint HA and DR
Abstract: When it comes to SharePoint High Availability (HA) and Disaster Recovery (DR) are often merged and confused. In this session we’ll take a look at the various HA tools that are available to you when configuring a SharePoint Farm. We’ll look at this from a SQL perspective and from a SharePoint perspective and consider what the implications are when applying patches and deploying customisations to a SharePoint Farm for HA and DR. We’ll consider some HA and DR scenarios for SharePoint 2010 and SharePoint 2013 and take a look at the use of SQL Always On as it relates to SharePoint.
Speaker(s):
- David McMahon
Track and Room: Dead Parrot (SharePoint) - N/A
Title: SQL Internal Storage – P2
Abstract: This session describes how SQL Server internally stores table data. Although you can use SQL without understanding the internals of data storage, a deep knowledge of how data is stored will improve the development of efficient applications. This second part of this session explores the basic of metadata that keeps track of index storage and compression.
Speaker(s):
- Bruno Basto
Track and Room: The Meaning of Life (DBA) - N/A
Title: So you’re getting SharePoint - What’s a DBA to do?
Abstract: Learn about the databases that SharePoint creates: how to plan for the databases; what sizes to expect; what type of IO profile they have; how fast they will grow.
Understand the SQL Server pre-requisites that need to be in place for a successful implementation of SharePoint.
Learn how to manage the SharePoint databases: Maintenance, Disaster Recovery High Availability
Speaker(s):
- Al Eardley
Track and Room: Dead Parrot (SharePoint) - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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
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.
Stuart Moore
Contact: http://stuart-moore.com
Stuart has been working with SQL Server since 1998 and version 7, splitting the years between roles as a DBA and a Developer.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Bruno Basto
Bruno Basto, senior consultant #160;and senior trainer #160;at Rumos. SQL certified since 6.5 version (1998). Work with MSFT tools and infrastructure since 1992 in the financial, banking and insurance areas. Responsible for several training projects for software solutions with MSFT infrastructure. Speaker at several MSFT and SQLPass events.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
David McMahon
Contact: http://davemcmahon81.wordpress.com
Dave McMahon is a SharePoint Server MVP who works for Ridgian, a Microsoft Gold Partner who specialise in SharePoint and BI. He has had extensive experience over the last 6 years of building and configuring BI SharePoint farms with end to end security models utilising the Kerberos Authentication Protocol and with Single-Sign on. His background was originally in Development, but he also has many years experience of running IT Systems and thus considers himself a “hybrid” SharePoint man!
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Mark Broadbent
Twitter: - retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
Kevin Chant
Twitter: - kevchant
LinkedIn: Kevin Chant
Contact: https://www.KevinRChant.com/
Senior Database Architect originally from the UK and now living in the Netherlands.
Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.
In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.
Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.
In addition, done various things over the years for the Data Platform Community.
John Martin
John is a SQL Sever developer DBA, working with SQL Server since 2007 in a range of environments ranging from defense to manufacturing retail. All of which have had stringent security requirements for their data systems that include not only regulatory compliance but also availability and recoverability requirements.
Constantin Klein
Twitter: - KostjaKlein
Contact: http://kostjaklein.wordpress.com
Constantin is working at Syntax Systems GmbH Co. KG. He mainly deals with the design and development of solutions based on Microsoft products and technologies. Since 2010 he was each year designated Most Valuable Professional (MVP) for the Microsoft Data Platform. In addition he is member of the board of Just Community e.V. (http://www.justcommunity.de) and PASS Deutschland e.V. (http://www.sqlpass.de). He also leads the .NET User Group Frankfurt/Germany (http://dnug-frankfurt.de). Find his blog at: http://kostjaklein.wordpress.com
Al Eardley
Contact: http://www.creative-sharepoint.com
Al Eardley is the technical manager at Creative Sharepoint. He has worked with SQL Server since version 7 and with SharePoint for the last five years. He has been involved in the planning and delivery of SQL and SharePoint solutions for a wide variety of clients ranging in size from small to global.
Kennie Pontoppidan
Twitter: - @KennieNP
LinkedIn: Kennie Pontoppidan
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
Regis Baccaro
Twitter: - @regbac
LinkedIn: Regis Baccaro
Contact: http://theblobfarm.wordpress.com
Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.
Anthony Obi
Twitter: - https://twitter.com/obilogic
Contact: http://community.obilogic.co.uk/blogs/
Anthony Obi - Independent SharePoint Consultant - Obilogic LtdWorking with SharePoint since Portal Server 2001 (10 years+)MCITP / MCTS SharePoint 2010
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.
Jens Vestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services to report in Reporting Services, Targit or similar tool. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in MS SQL Server, Jens has also worked with Microsoft. Net platform for more than 10 years.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
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
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
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.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Mark Macrae
Mark has been actively involved with SharePoint technologies since 2003, but with the product becoming so vast, chosen to focused on Business Intelligence. Mark has co-ordinated many large scale, Microsoft BI projects around the world and brings a wealth of real world experience. Mark has been an active member of the SharePoint community for many years, both as a speaker and organiser for the SharePoint User Group UK and SharePoint Saturday.
Peter Baddeley
Contact: http://www.baddaz.com
Peter is a Solution Architect focusing on delivering Microsoft solutions including SharePoint, Dynamics CRM and Office 365. He has been working with SharePoint since 2004, lives in Cambridgeshire (United Kingdom) and can often be found on Twitter (@Baddaz) or his blog (www.baddaz.com). Peter is one of the organisers of East Anglia Region of the SharePoint User Group UK. His working life is spent leading a team of consultants delivering Microsoft Solutions to companies across UK and Ireland.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
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.
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
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Niko Neugabauer
Contact: http://www.nikoport.com
Niko Neugebauer is a Community Evangelist for PASS. A SQL Server MVP with over 15 years experience in IT, he is very passionate about SQL Server and Community. He is a founder and a leader of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com). His passion about SQLSaturday led him to organise the first SQLSaturday outside of North America – SQLSaturday #78. Niko has already presented at PASS Summit, SQLRally Nordic, and SQLSaturdays all around the world.
Mark Broadbent
Twitter: - retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Oliver Engels
Twitter: - @oengels
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
Seb Matthews
Contact: http://sebmatthews.net
Seb Matthews is a Platform Architect with over 20 years’ experience working with organizations of all shapes and sizes to get the very best out of Microsoft technologies including SharePoint, SQL Server, Exchange and System Center.
Fortunate to be a frequent speaker at conferences, in the community and at vendor events, Seb is an enthusiastic and active member of the Microsoft community in Europe, Africa and the USA.
Les Reading
Bio: Les Reading has over 9 years’ experience working as a Production DBA, Database Systems Architect and DBA Manager. Most of his experience has been centred on delivering solutions on the Microsoft product stack and has recently included a number of Azure deployments. When not working Les enjoys spending time with his family or escaping for a cycle ride and cheeky pint of real ale.
Stephen Archbold
Twitter: - @stephenarchbold
LinkedIn: Stephen Archbold
Contact: http://simplesql.blogspot.com
Stephen is a Microsoft Certified Master, and a Lead DBA at Arrowstreet Capital, with over 8 years experience working in SQL Server as a Production DBA and consultant. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Sponsors
The following is a list of sponsors that helped fund the event: