Event Location:
Mechanics Institute,
103 Princess Street, Manchester,
Manchester, England, United Kingdom
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,
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,
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,
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,
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:
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,
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,
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,
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,
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,
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:
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,
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:
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,
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,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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://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 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 SQL Saturday.
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 :-)
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.
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.
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: https://uk.linkedin.com/in/rainerunwin
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.
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://nl.linkedin.com/in/hugokornelis
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.
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
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
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://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...
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.
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.
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.
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
LinkedIn: https://uk.linkedin.com/in/robin-lester-626b338
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.
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.
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
LinkedIn: https://www.linkedin.com/in/percyreyes
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.
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: 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://nl.linkedin.com/in/hugokornelis
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.
LinkedIn: https://uk.linkedin.com/in/robin-lester-626b338
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.
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/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.
The following is a list of sponsors that helped fund the event.