Welcome to the London PASS Chapter

We are an established PASS Chapter covering London. 

We look forward to meeting you! To contact us, please visit the About Us page. 

Please find details of the next meeting below.

Registration for the event via following links

http://www.meetup.com/London-SQL-Server-User-Group/

SQL London PASS Chapter Team

Next Meeting

Tuesday,

April

19

PASS SQL London Chapter (19th Apr 2016)

  • In-Person @ CodeNode (Skillsmatter) London, Greater London, United Kingdom (map)
  • 18:00 - 20:30 UTC
  • Language: English

We have our April 2016 event planned and have 2 well-known MVP's providing their expertise on this evening's programme

We request you RSVP via our MEETUP group
http://www.meetup.com/London-SQL-Server-User-Group/

IMPORTANT: Please ensure that you also REGISTER @ the following link, as we need to provide Skillsmatter details of who's attending to the SkillsMatter team https://skillsmatter.com/meetups/7882-pass-london-chapter-april-event

At our regular event home (Skillsmatter CodeNode) come and experience the sessions and then network afterwards in thier Escape Bar and breakout areas, grabing some food, games and networking.
The evening's program starts  @ 6:15 PM but, come and socialize from 6:00 PM @ CodeNode and we’ll  have 2 hours of the quality session's for you to learn from the leading experts in the industry followed by food, drink and networking and maybe even some SWAG.
Why not bring a friend or colleague as we will be having NEW members only raffle as well that evening, the 2 sessions at this meeting will be from 2 well-known MVP’s (Davide Mauri & Dejan Sarka

Identity Mapping
In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server 2014 work. We are going to use Soundex Transact-SQL function, four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services (DQS) help us here. We are also going to tackle the performance problems with string matching merging

Dejan Sarka
Dejan Sarka(@DejanSarka ), MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of thirteen books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

sqlblog.com/blogs/dejan_sarka/default.aspx

Data Warehouse Automation
A key point for being Agile and apply agile principle to Data Warehouse and BI is being able to automate all the low added value work, allowing iterations to be not only feasible but economically sustainable. In this session I’ll present the “Adaptive BI Framework”, a framework I’ve been working on in the last 10 years and that has a now a public version available on GitHub!

Davide Mauri
Davide(@mauridb ) is a SolidQ Mentor and part of the Leadership Team of SolidQ Italy. He works hand-in-hand with managers to build effective, tailor-made BI and big data solutions for customers, leveraging his expertise in business analysis, performance tuning and Agile data warehousing, to ensure that the solution is delivered on time and with measurable data quality. A Microsoft SQL Server MVP, Davide is a well-known speaker at international SQL Server conferences.                                                           
www.davidemauri.it 

We are looking forward to seeing you at the Chapter event

PASS London Chapter Team

Featured Presentation:

Identity Mapping

Dejan Sarka, Consultant Dejan Sarka s.p.

In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server 2014 work. We are going to use Soundex Transact-SQL function, four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services (DQS) help us here. We are also going to tackle the performance problems with string matching merging.

About Dejan:
Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of fifteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.

Data Warehouse Automation

Davide Mauri, Director Software Dev & Cloud Infrastructure Sensoria

A key point for being Agile and apply agile principle to Data Warehouse and BI is being able to automate all the low added value work, allowing iterations to be not only feasible but economically sustainable. In this session I’ll present the “Adaptive BI Framework”, a framework I’ve been working on in the last 10 years and that has a now a public version available on GitHub!

About Davide:
Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

cage-aids
cage-aids
cage-aids
cage-aids