What we're about

About Us:

This is a group that has been going since 2014 and meets every two months on a Wednesday for anyone interested in Microsoft Data & AI. We have two talks and pizza from our sponsor Coeo Ltd.

Everyone from beginners to experts is welcome and although it was originally focused just on SQL Server we now have a wide range of topics which have included

• Machine Learning

• Power BI

• SQL Data Warehouse

• DevOps

• Security in Azure

• Cognitive Services

• Azure Data Factory

All members should read and adhere to our Code of Conduct (https://www.meetup.com/Reading-Microsoft-Data-Platform-User-Group/pages/31260807/Code_of_Conduct/)

Logistics:

/******** Currently being held online***************/

Held at our sponsor Coeo Ltd's offices we have plenty of parking around the back of the building.

The meeting is on the 1st Floor but there is usually someone at reception to direct you. Help yourself to coffee and soft drinks in the kitchen while you network.

If you arrive after 6.30pm and the door is locked then please call/text the phone number posted on the door and someone will come and let you in. Space is limited in the room so please let us know if you can't make it so others can.

Pizza is provided and we always order a number of vegetarian items. We can also order gluten free if we know in advance.

Speaking:

If you are interested in speaking at one of the events then please let one of the team know we are always happy to hear from new and established speakers. If you'd like to give speaking a try but don't want to do a full hour we also welcome two 30min slots and can work to pair you up with someone with a relevant topic.

Upcoming events (3)

August 2021 Meetup

Online event

We will be teaming up with Southampton User Group for our meetup. As we won't be seeing each other in person it allows us to join the communities and host a joint user group.

Agenda

18:15: Welcome and Intros
18:30: Jeff Moden - “Black Arts” Index Maintenance – GUIDs vs
Fragmentation - ​They’re not the problem… WE ARE!
20:00: Kevin Chant and Sander Stad - GitHub DevOps Duet - Reading
and Southampton Edition
21:00: Finish

----------------
18:30: Jeff Moden
“Black Arts” Index Maintenance – GUIDs vs Fragmentation - They’re not the problem… WE ARE!

"This is NOT your typical presentation on the fragmentation problems of Random GUIDs.

No… Instead we’re going to destroy the myth of GUID fragmentation and identify the real problem and the two fixes for it. We’ll prove that Random GUIDs actually behave in manner like most people expect a good index to behave especially when it comes to OLTP performance. In one of the most ironic/heterodoxical turns of knowledge you’re likely to come across, we’ll see how you can use GUIDs to actually prevent fragmentation of your clustered indexes! In the end, you’ll witness the results of some simple testing that demonstrate that you can easily insert literally MILLIONs of rows into a Random GUID clustered index with almost no page splits (not even supposed “good” ones) and LESS THAN 1% Logical fragmentation!

In the process, we’ll explore what people are currently calling “Best Practice” index maintenance and we’ll prove that the use of REORGANIZE is one of the very worst things you can do to your Random GUID indexes even if you’re limited to the Standard Edition of SQL Server. As an interesting sidebar, we'll demonstrate that the use of ever-increasing index keys could be a major source of many of your fragmentation problems.

We’ll also learn how to use a new tool that I created to actually see what an index looks like at the page level for all pages in a single graph."

About the Speaker: I am also a frequent writer/blogger/speaker and technical reviewer for subjects based on MS SQL Server and Microsoft Azure – Data Platform.

20:00 Kevin Chant and Sander Stad
GitHub DevOps Duet - Reading and Southampton Edition

Welcome to GitHub DevOps Duet, a scenario where two teams (dev and ops) are going to start using GitHub Actions for Data Platform deployments.

They need to figure out how to implement their processes within GitHub and make it work for all parties.

We will discuss:

- the challenges of implementing DevOps
- setting up a database solution project
- testing your database releases using tSQLt
- setting up your GitHub Actions workflows
- deploy database artifacts to multiple Data Platform solutions

As part of the session we will cover the GitHub services you get including:
- Actions
- Projects
- Security

The session will cover how to setup projects for your tasks, set up workflows in Github Actions, security and so much more.

If you want to find out more about how Github can be implemented for your DevOps process than come to our session

21:00 Finish

October 2021 Meetup

Online event

We will be teaming up with Southampton User Group for our meetup. As we won't be seeing each other in person it allows us to join the communities and host a joint user group.

December 2021 Meetup

Online event

We will be teaming up with Southampton User Group for our meetup. As we won't be seeing each other in person it allows us to join the communities and host a joint user group.

Past events (10)

April 2021 Meetup

Online event

Photos (1)