SQLSaturday #543 - Manchester 2016
Event Date: 07/23/2016 00:00:00
Event Location:
- Mechanics Institute,
- 103 Princess Street, Manchester,
- Manchester, 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: NSA Secrets - Hacking SQL Server
Abstract: How easy is it to hack a SQL Server? In this session we’ll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We’ll start by gaining access to a SQL Server (using some creative ways of making man-in-the-middle attacks, and other ways), escalating priviledges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. Most importantly, we’ll also cover recommendations on how to avoid these attacks. This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi 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: Database Engine - Woods Room
Title: Bashboard Delight with Power BI
Abstract: Delivering eye-catching insight has now become almost ludicrously easy. You just fire up Power BI and … Wait a second. Yes it is has never been easier to add the “wow” factor to presentations based on data. However there are still techniques, tricks and traps that you need to know if you are going to leave your audience impressed with your insights rather than drowning in your data. This session takes you through the use and limitations of all the visualizations that come out-of-the-box with Power BI, as well as a quick tour of many of the custom visuals that are now available. You will see which type of delivery is best suited to which kind of data. You will also learn how best to structure and adapt the Power BI data model so that it can feed into the different visualizations for maximum effect.
Speaker(s):
- Adam Aspin
Track and Room: Business Intelligence - PeterLoo
Title: Making Row Level Security and Dynamic Data Masking work for you!
Abstract: Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it?
These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.
In this session we will look at how you can get the most out of these features and retain the performance of your system.
Speaker(s):
- John Martin
Track and Room: Database Engine - Woods Room
Title: Powerful T-SQL Improvements that Reduce Query Complexity
Abstract: We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!
Speaker(s):
- Hugo Kornelis
Track and Room: Database Development - Mary Quaille
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: Database Development - Mary Quaille
Title: Automated Database Developmer Testing
Abstract: Oscar Wilde once said “We are all in the gutter, but some of us have unit tests” and it is as true then as it is now - databases hold code and if you want to:
- Make changes faster
- Improve the quality of your code
- Provide guaranteed examples that are proven to work
Then you should look at database testing but what is database testing? What are unit tests? Integration tests? Acceptance tests? How do you get started and keep going with automated testing?
In this session we will answer these questions and give examples of how to test database code and some of the challenges you will face along the way.
Whether you are completly new to developer testing or have been been “a mocking and asserting” in c# or java for years this session will get you started writing tests for your database code.
Speaker(s):
- Ed Elliott
Track and Room: Database Development - Mary Quaille
Title: Teaching the IT Pro how to Dev - PowerShell, Source Control Unit Testing
Abstract: In this session we will look at how IT Pros (and developers) could be completing their day to day tasks in a more efficient manner with effective Unit Testing and Source Control of their Scripts.
This is a session where there will be chance to follow along (if you bring your own laptop) and learn in real time from the co-ordinator of the UK PowerShell User Groups - however you will also be lead to further community resources if you require further time after the session to get this built into your current day to day workflow.
As this session will be focused towards SQL Professionals we will take a look at SQL Specifics that can be used within PowerShell Scripts Unit Testing.
Speaker(s):
- Ryan Yates
Track and Room: PowerShell - Dean Room
Title: Deep Dive on the IoT Hub
Abstract: When you design IoT solutions in the Azure cloud there are some things you are going to need to do. Being able to send events to a resilient queue that can handle millions of transactions per second is fine but what do you do about security? Surely you only want registered devices to be able to send to that queue? What about storing details about those devices too? Maybe we want to be able to tell where a device is located, its model and serial number.
IoT solutions very often are not a one way street. Having devices send their data to the cloud is great but often you need the cloud to talk back to your device.
OK so our data is in the cloud but now what? What do we do with it? What can we do with it?
This session is going to show you how to solve all of these things. It is going to be heavy on demos and will build the solution in stages so nobody gets lost. We’ll use a mixture of technologies all of which are available in Azure.
Come to the session to learn more.
Speaker(s):
- Allan Mitchell
Track and Room: Azure - John Torcher
Title: Getting CI right for SQL Server
Abstract: This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.
However, you still haven’t written as many automated tests as you know you should and you aren’t convinced you’re going about it the right way. You haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins, and even if you have you aren’t sure how the process should work for SQL Server builds and tests.
In this session I’ll explain how to use tSQLt to build a suite of automated tests to give you confidence in the quality of your code. Then I’ll talk through various ways to automate your database builds and run those tests on some schedule or trigger. I’ll also discuss the pros and cons of various different approaches so that you can understand
Speaker(s):
- Alex Yates
Track and Room: Database Development - Mary Quaille
Title: Monitoring SQL Server, Everywhere, With SQL Sentry
Abstract: Want to get the best out of your SQL Server systems? Then you really ought to monitor them!
With the rise of Cloud, with hosted virtual machines and Azure SQL DB, adding to the mix of on-premises physical and virtual machines, having one tool that can give you this single view is vital.
Monitoring enables you to understand where you have pain points and allows you to make the most out of these disparate systems. With SQL Sentry tools we can monitor every type of SQL Server wherever it resides; AWS Virtual Machines, Azure SQL DB, in your Datacenter, or hosted in Rackspace.
Join us as we help you understand what, and how SQL Sentry can help you get the most from your SQL Server Data Platform, wherever it is.
Speaker(s):
- John Martin
Track and Room: Database Development - Woods Room
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: Business Intelligence - PeterLoo
Title: A dive into SSIS
Abstract: SSIS is an awesome ETL tool and can perform incredibly fast, when used right. Understanding more about how it works can help you make the best design decisions to maximise performance. In this session we’ll look at some of the internals, as well as a number of tips tricks to supercharge your SSIS life.
Speaker(s):
- Alex Whittles
Track and Room: Business Intelligence - PeterLoo
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: Database Engine - Woods Room
Title: Getting started with PowerShell - the hands on 101 session
Abstract: In this session we will cover off the different elements that make PowerShell a language that is built upon making itself easier to discover. We will cover Functions, Aliases, Help Topics, Modules, Cmdlets, Objects, Methods and Properties and how understanding these different aspects makes your time in PowerShell much simpler to get to grips with and can really help you adopt the language in a much more efficient way going forward.
This session should leave you with a greater understanding of the PowerShell Language and give you the ability to go and discover more of the language and how it works.
Speaker(s):
- Ryan Yates
Track and Room: PowerShell - Dean Room
Title: Deploy and manage Ola Hallengrens scripts with Powershell
Abstract: Are you enjoying Ola Hallengrens Maintenance Solution scripts as much as I am? I have written Powershell scripts to deploy and manage them across multiple servers. While building this I had to use more Powershell tips and tricks then I thought I would need. I would like to share these lessons learned with you. Do you like Powershell and Ola Hallengrens scripts? Then do not miss this session
Speaker(s):
- André Kamman
Track and Room: PowerShell - Dean Room
Title: Session Details not available
Abstract: Session Details not available
Speaker(s):
- n/a n/a
Track and Room: Azure - John Torcher
Title: New Automatic Insights Capabilities on Microsoft SQL SSAS
Abstract: In this session, we will discuss how 90% of the data, the Dark Data, is affecting organizations and how solutions providing automatic insights can make a real change on top of the Microsoft SQL SSAS Stack. It will be a fun and interesting session.
Speaker(s):
- Nigel West
Track and Room: Azure - Mary Quaille
Title: Configuring SQL Server Analysis Services for use with Azure SQL DW
Abstract: Configuring SQL Server Analysis Services for use with Azure SQL Data Warehouse (Preferred session) Session objectives: #183; Enable OLAP and tabular analytics against SQL DW #183; Provide technical configuration to get the best from SSAS when connecting to SQL DW #183; Recommendations for process and approach #183; Optimize OLAP and SQL DW for performance
Speaker(s):
- Mike Boswell
Track and Room: Business Intelligence - PeterLoo
Title: Publish Power BI visualisations on premise with BI Office
Abstract: BI Office, the data analytics platform, can now host Power BI visualisations and analyses on premise. Join us for this interactive session where you will learn how to publish and share your Power BI analyses to an on premise BI Office server and enhance the solution with content management, governance and integration with other advanced capabilities of the BI Office Platform
Speaker(s):
- Ian Macdonald
Track and Room: Business Intelligence - John Torcher
Title: The current state of Powershell DSC for DBAs
Abstract: Powershell Desired State Configuration (DSC) is a declarative configuration management system. Most DBAs are probably using unattended installs followed by a bunch of post configuration scripts make sure our SQL Server instances are production ready. We will take a look at how Powershell DSC works, and how this can be used by DBAs to install, configure and manage SQL Servers. We will try to answer questions like:
How does Powershell DSC work How would a DBA use Powershell DSC Are the resources to manage SQL Server mature enough
After this session you are better equiped to decide if Powershell DSC is useful for you, now or in the near future.
Speaker(s):
- André Kamman
Track and Room: PowerShell - Dean Room
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? Where is it? We’ll discuss all this and more.
Speaker(s):
- Alex Whittles
Track and Room: Azure - John Torcher
Title: Think work like a Data Scientist with SQL 2016 R
Abstract: What are these DATA Scientists up to? 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 results within SQL 2016.
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: Database Development - John Torcher
Title: Powershell Profile Prepares Perfect Production Purlieu
Abstract: A Purlieu is a place, an environment, a haunt The 6 P’s are usually Proper Prior Preparation Prevents Poor Performance. The Powershell profile is a powerful tool that can provide a perfect Powershell scripting environment. It runs on start up preparing your editor for the purposes and processes that you intend to produce If you use Powershell you should be making use of your profile and in this beginners session I will show you how you can start making your Powershell environment work even better for you
Speaker(s):
- Rob Sewell
Track and Room: PowerShell - Dean Room
Title: Big Data in Azure
Abstract: A look at the Big Data technologies that may be leveraged in Azure.
When and why to choose a Big Data solution, how the technologies fit together, why choose one over the other.
Speaker(s):
- Robin Lester
Track and Room: Azure - John Torcher
Title: Introduction to wait stats
Abstract: Wait statistics have been the predominant SQL Server tuning methodoogy since the release of SQL Server 2005 when wait statistics became much easier to capture and analyse. The methodology was documentend by Microsoft in a white paper not much later and has grown in popularity ever since. This presentation will introduce you to this methodology and introduce some of the most common wait types that you are likely to see on your own systems.
Speaker(s):
- Rainer Unwin
Track and Room: Database Engine - Woods Room
Title: Session Details not available
Abstract: Session Details not available
Speaker(s):
- n/a n/a
Track and Room: Business Intelligence - PeterLoo
Title: SQL Server 2016 AlwaysOn Availability Groups
Abstract: In this session I will show new features of AlwaysOn Availability Groups in SQL Server 2016 and how does it work and how we can take advantage of them to build good and complete solutions for HA + DR needs.
Speaker(s):
- Percy Reyes
Track and Room: Database Engine - Woods Room
Title: Normalization Beyond Third Normal Form
Abstract: Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”? Do you believe the people who claim that these statements are myths? Or do you prefer to form your own opinion? If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!
Speaker(s):
- Hugo Kornelis
Track and Room: Database Development - Mary Quaille
Title: Plan optimization from DBA to Developer
Abstract: This session looks at how to maximise resolution time with some joined up thinking between developers and DBAs. Martin Wild will run through a workflow showing how to identify poor performing SQL, how to navigate and analyse its plan and how to optimize for better performance. They will introduce some free tools to help you on your way and help connect your developers and DBAs to resolve issues faster.
Speaker(s):
- Martin Wild
Track and Room: Database Development - PeterLoo
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Allan Mitchell
Twitter: - @allanSQLIS
Contact: https://onlysearch.wordpress.com/
Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.
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 :-)
Martin Wild
Twitter: - @m__wild
Martin Wild is a systems consultant at Quest Software. Based at the European headquarters in the U.K., He has worked in IT for more almost 30 years, and for the last 19 years, he has worked in pre-sales at Quest Software. Martin has expertise with Oracle, SQL Server, Sybase, PostgreSQL and DB2, Windows, Linux, VMware, Hyper-V and Azure. You can often see Martin presenting at SQL Server events such as SQL Bits and SQLSaturday.
n/a n/a
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 :-)
Nigel West
LinkedIn: Nigel West
Accomplished Business Intelligence Consultant, possessing global implementation and project management experience in the Financial Services, Technology and Manufacturing industries. Panorama Necto certified, confident communicating BI concepts at all levels of an organisation in a pre-sales or consultant capacity.
• Proven to construct projects that minimise implementation time and return the highest possible value to an organisation. • Creates project success by swiftly building strong relationships with clients and colleagues. • Experienced project manager with a strong focus on costs, deliverables and time. • Strong problem solver with one eye on the details and one on the bigger picture.
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.
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).
Rainer Unwin
Twitter: - @RainerUnwin
LinkedIn: Rainer Unwin
Contact: http://rmunwin.com
Having worked with SQL Server since 2005 Rainer decided to become a DBA in 2011. Rainer has worked on large scale transactional systems as a DBA ever since. In 2015 he made the move to go contracting. His main areas of interest are internals and performance. He regularly attends his local PASS chapter in Manchester and enjoys giving presentations at user groups.
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.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
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
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
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.
n/a n/a
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…
n/a n/a
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.
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.
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.
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
Robin Lester
LinkedIn: Robin Lester
Contact: https://blogs.msdn.microsoft.com/robinlester/
I am a Cloud / Data Solutions Architect with Microsoft. Based in the UK and working closely with partners across the Azure data stack.
I have been working with data systems since SQL 6.5 but now I focus the majority of my time on modern database warehousing, advanced analytics and IoT workloads.
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.
Adam Aspin
Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for nineteen years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite. He is the author of quot;High Impact Data Visualization with Power View, Power Map, and Power BIquot;, “SQL Server Data Integration Recipes” and quot;Business Intelligence with SQL Server Reporting Servicesquot; - all with Apress
Percy Reyes
Twitter: - @percyreyes
LinkedIn: Percy Reyes
Contact: http://percyreyes.com/
Microsoft SQL Server MVP, Certified Sr. Database Administrator, Author at http://MSSQLTips.com | SQL PASS Peru Chapter Leader | MCITP DBA/Dev, MCTS, MCP. Bachelor in Systems Engineering and Senior Database Administrator focused on Microsoft SQL Server Internals with over 12+ years of extensive experience managing database servers. I am a frequent Speaker about SQL Server technologies for over 10 years at Local User Group Meetings, Webcasts, and National Conferences.
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 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.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
Robin Lester
LinkedIn: Robin Lester
Contact: https://blogs.msdn.microsoft.com/robinlester/
I am a Cloud / Data Solutions Architect with Microsoft. Based in the UK and working closely with partners across the Azure data stack.
I have been working with data systems since SQL 6.5 but now I focus the majority of my time on modern database warehousing, advanced analytics and IoT workloads.
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).
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.
Sponsors
The following is a list of sponsors that helped fund the event: