talk-data.com

*In Person Only MeetUp, Free To Attend*

Thank you to Accenture for sponsoring and hosting this event.

Join us for a In-Person User Group Meeting (LDPaC), where you can network, learn, ask a question, and meet other likeminded folks. These events are a really great opportunity to socialise in an informal learning setting.

Remember to tell your friends and the people you work with; make sure you register as soon as you can. We will need to provide a list of names to Accenture before the event, so to ensure there are no issues with access on the day please make sure you have registered.

17.45 - 18:00 Network 🤝

18.00 - 18:30 Drinks & Pizza 🍕

18:30 - 18:40 Intro🎙️

18:40 - 19:30 Getting Started With Index Maintenance - Liz Hardy This is a introductory session to provide you with some of the basics in terms of know how and tools to get you started with implementing index maintenance in your own environments.

Imagine we see a database for the first time and know nothing about this it. It You could either be going into a new client or discovering a database you’ve never know known about previously.

There are a lot of things you want to check over in this scenario, for example, are backups being taken, are integrity checks in place and is there any corruption in the database? Another key thing to check is whether there is any index maintenance currently in place.

In this session, we will first take a look at the basics of index maintenance:

• what it is? • why do we need it? • where do you start? • what solutions exist?

Then I'll provide a few quick and easy steps to get you started on implementing index maintenance in your own environments. We will consider the options for index maintenance and focus on the implementation of Ola Hallengren’s Maintenance Solution. This is such an impressive tool and it is open source and free for all to use and yet we still go into clients where no index maintenance is in place.

We’ll look at basic configuration of the indexing maintenance jobs from Ola's solution with some simple parameters. We will then uncover ways to deploy this and outline any gotchas to be aware of along the way. Either if you aren't using Ola's solution or if you weren't aware of some of the configurations, this session will empower you to think more on your index maintenance and improve your process.

19:30 - 19:40 10-min Break 🥤

19:40 - 20:30 Another Brick in the Firewall: How to Secure Your Azure Data Platform - Grace O'Halloran

These days, most people want their Azure Data Platforms to be deployed in a secure network topology. As Data Engineers, we are often the ones that have who make this happen. The cloud has made it easy for us to deploy a virtual network here and a private endpoint there, but what does a good, networked data platform actually look like, and how does it work? Simple things become complex: How will my ADF Integration Runtime talk to my data sources? How do I securely access my resources to do development?

In this session, we will look at some of the core network components which can be used to secure your data platform, what they are, and how to use them effectively. We will also look at some of the decisions that need to be made when moving your data platform inside a private network, which weren't a consideration previously. Some basic knowledge of what a virtual network is is required.

By the end of this session, you should feel more confident in working with network components in Azure and how you can use them to secure your Data Platform.

Come and join the Leeds Data Community and start learning and networking! All are welcome!

Microsoft Data Platform Group Birmingham

Thursday 5th June at 13:00 (BST - UK Time)

Speaker: Grace O'Halloran

Title: Another Brick in the Firewall: How to Secure Your Azure Data Platform

Description: These days, most people want their Azure Data Platforms to be deployed in a secure network topology. As Data Engineers, we are often the ones that have who make this happen. The cloud has made it easy for us to deploy a virtual network here and a private endpoint there, but what does a good, networked data platform actually look like, and how does it work? Simple things become complex: How will my ADF Integration Runtime talk to my data sources? How do I securely access my resources to do development?

In this session, we will look at some of the core network components which can be used to secure your data platform, what they are, and how to use them effectively. We will also look at some of the decisions that need to be made when moving your data platform inside a private network, which weren't a consideration previously. Some basic knowledge of what a virtual network is is required.

By the end of this session, you should feel more confident in working with network components in Azure and how you can use them to secure your Data Platform.

Agenda:

12.45 - 13:00 : Setup and Join

13:00 - 13:05 : Open Lobby and Introductions

13:05 - 14:00 : Another Brick in the Firewall: How to Secure your Azure Data Platform with Grace.

Venue: Wherever you have access to a computer or smart device! This session will be online only!

Other Details:

*** Please note registration on MeetUp is required to gain access to the Teams link!***

Please contact us on Twitter or via email if you are having any issues joining, and we'll do everything we can to help.

Event Organiser Contact Details:

If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.

Email: [email protected]

Twitter: @MSDataGroupBrum

Sponsors:

Purple Frog Systems

Power BI Sentinel

Link to the Teams Meeting: https://teams.microsoft.com/l/meetup-join/19%3ameeting_MTVmMzAyYTQtOWU3My00ZDI1LWEwMWMtZWQ4NWY1ODg0ODc4%40thread.v2/0?context=%7b%22Tid%22%3a%22ecbebdab-1287-47b8-8709-694ffe8697d1%22%2c%22Oid%22%3a%22a901008d-8ba1-459d-b8fa-3eccacfccadf%22%7d

Agenda

18:00 Welcome and Intros

18:10 🎦Another Brick in the Firewall: How to Secure your Azure Data Platform 🗣️Grace O'Halloran These days, most people want their Azure Data Platforms to be deployed in a secure a network topology. As Data Engineers, we are often the ones that have the make this happen. The cloud has made it easy for us to deploy a virtual network here and a private endpoint there, but what does a good, networked data platform actually look like, and how does it work? Simple things become complex: how will Fabric or ADF talk to my data sources? How do I securely access my resources to do development? In this session we will look at some of the core network components which can be used to secure your data platform; what they are, and how to use them effectively. We will also look at some of the decisions that need to be made when moving your data platform inside a private network, which weren't a consideration previously. Some basic knowledge of what a virtual network is is required. By the end of this session you should feel more confident in working with network components in Azure and how you can use them to secure your Data Platform.

*** A massive thanks to our sponsor Spectrum IT. Without them, we could not host this event for free. Spectrum IT kindly provided funding for the room and pizza for in-person attendees. ***

These days, most people want their Azure Data Platforms to be deployed in a secure a network topology. As Data Engineers, we are often the ones that have the make this happen. The cloud has made it easy for us to deploy a virtual network here and a private endpoint there, but what does a good, networked data platform actually look like, and how does it work? Simple things become complex: how will my ADF Integration Runtime talk to my data sources? How do I securely access my resources to do development?

In this session we will look at some of the core network components which can be used to secure your data platform; what they are, and how to use them effectively. We will also look at some of the decisions that need to be made when moving your data platform inside a private network, which weren't a consideration previously. Some basic knowledge of what a virtual network is is required.

By the end of this session you should feel more confident in working with network components in Azure and how you can use them to secure your Data Platform.

A little about Grace: I am a Principal Azure Data Engineering Consultant with over 7 years experience working with Azure Data Platforms. I have a passion for infrastructure, networking and security, and in my work I focus on Azure Databricks Lakehouse implementations. I am also a Microsoft Data Platform MVP, and I co-founded DevUp, a social mobility initiative for removing barriers to technology.