VIRTUAL - Southampton Data Platform and Cloud - 14th December - Tracy & Scott

Welcome to Southampton Data Platform and Cloud Group.

This is the meetup for the VIRTUAL event.

The link to the Microsoft Teams meeting will be sent on the day of the meeting.

https://teams.microsoft.com/l/meetup-join/19:meeting_YmM2NjNmOGYtZjk3OC00ZjA4LWIyMmItOGUxOTExZDdhOGNi@thread.v2/0?context=%7B%22Tid%22:%228f5c8fb3-b610-4233-8284-63a7254f4029%22,%22Oid%22:%22e5090dc5-0a93-4cc1-a473-a9c4dc8c18b2%22%7D

Agenda
18:00: Welcome and Intros

18:15: Tracy Boggiano - Using dbachecks to Validate your SQL Server Estate

19:30: Scott Bell - Cosmos 101

20:30: Finish

Session details:
1. Tracy Boggiano - Using dbachecks to Validate your SQL Server Estate
Checking that all your SQL server instances are in compliance with your standards can be a tedious task if you have to do it manually. Well, that is where dbachecks comes in. This open-source PowerShell community written module makes this task easy. It can be ran across your entire estate to check your instances are meeting all your standards. It has several built-in tests for things such as how long ago was CHECKDB run, how long ago were backups run, are your SQL Agent operators correct, is Query Store configured properly, is DAC allowed, is the instance CIS compliant, are your autogrowth settings correct, do you have too many VLFs in your log file, and many more. You can even write your own if they don’t exist in the module. The results can be displayed in a PowerBI report that is easy for managers to understand and saved to a database for historical reporting. Come to this session to learn how to leverage this PowerShell module to make sure your environment is meeting your standards everywhere without having to write your own solution.

2. Scott Bell - Cosmos 101
Find out everything you need to know to get started with Azure Cosmos DB in 50 minutes or less.
What's partitioning?
What's consistency?
What does multi modal really mean?
What's a change feed?
Can I leverage Cosmos in my data platform?

About Tracy Boggiano:
Tracy is the Database Superhero for DocuSign. Tracy does things in the Microsoft Data Platform Community and is Microsoft Data Platform MVP. Tracy has volunteered through the NC Guardian ad Litem program since 2003 being the voice for abused and neglected foster children in the court system. This is her passion outside of SQL Server and favorite, most important job. When Tracy isn't volunteering in the Microsoft Data Platform community she likes to be making a difference somewhere.

About Scott Bell:
Scott is currently a senior consultant with Avanade focusing on the Azure Data Platform, Integration Engineering and Analytics. Previously, he was a data scientist at the biggest education software company in the UK. He has a master degree in Computer Science with a specialism on Secure Machine Learning in the Cloud.
He is passionate about all things data, Rugby League, Beer, R, Azure and Power BI.

A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees.
***