Event Location:
Jurys Inn Exeter
Western Way, Exeter
Exeter, England, United Kingdom
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 SQL Saturday 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,
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,
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ć,
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,
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,
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,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
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,
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,
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,
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,
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,
Abstract:
To be confirmed
Speaker(s): Annette Allen,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
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.
LinkedIn: https://www.linkedin.com/profile/preview?locale=en_USamp;trk=prof-0-sb-preview-primary-button
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.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
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 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
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 SQL Saturdays. He also works on various data science projects in collaboration with Microsoft Research.
LinkedIn: https://www.linkedin.com/in/benonline/
Ben came from a SQL Server developer background moving to Business Intelligence consulting in the UK, Australia and Switzerland and now Ireland.
LinkedIn: http://uk.linkedin.com/in/dageop
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.
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 :-)
LinkedIn: http://uk.linkedin.com/in/richardpdouglas
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.
LinkedIn: http://uk.linkedin.com/in/gavincampbell
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 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 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
LinkedIn: http://uk.linkedin.com/in/aleardley
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.
LinkedIn: http://www.linkedin.com/in/wdurkin
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).
LinkedIn: http://it.linkedin.com/pub/gianluca-sartori/23/50b/a12
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.
LinkedIn: https://www.linkedin.com/in/andrewpruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year's experience. Originally from Wales but now living in Ireland
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.
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 SQL Saturday Holland.
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 SQL Saturday Exeter and am involved in the organisation of SQL Bits.
LinkedIn: https://www.linkedin.com/in/mladenprajdic
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).
LinkedIn: https://uk.linkedin.com/in/robsewellsqldba
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.
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 :-)
LinkedIn: https://uk.linkedin.com/in/stephanielocke
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.
LinkedIn: http://uk.linkedin.com/in/boswellmike
Mike works for Microsoft as a Data Platform Solution Architect. He likes to get involved in SQL Saturdays 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.
LinkedIn: https://uk.linkedin.com/in/alexwhittles
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, SQL Saturdays as well as numerous SQL Pass chapters around Europe
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
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 SQL Saturday Exeter and am involved in the organisation of SQL Bits.
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.
LinkedIn: https://uk.linkedin.com/in/edelliottuk
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).
LinkedIn: http://uk.linkedin.com/in/alexanderyates
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.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
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.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
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.
LinkedIn: https://uk.linkedin.com/in/prathy
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.
LinkedIn: http://si.linkedin.com/in/matijalah/
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.
The following is a list of sponsors that helped fund the event.