February 2021 Virtual Meeting Information

RSVP at https://www.meetup.com/salem-data-community/events/276035184/

Featured Presentation: Angela Henry - Intro to the Azure Data Catalog

Bio:

Angela is a Solution Architect, living in High Point, NC and loves what she does.
She’s worked with all versions of SQL Server & worn all the hats that come with
dealing with SQL Server throughout the years: developer, administrator,
data architect and BI developer. She has her MSCE in Data and Analytics
(f.k.a., Business Intelligence),
is a Data Platform MVP, and a Microsoft Certified Trainer (MCT).
She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC.
In her spare time you can probably find her in or at the pool,
she’s an avid US Masters Swimmer, Coach and Instructor.

Abstract:

Intro to Azure Data Catalog

Your company has amassed more data than it can possibly use,
yet no one can find the data they need. This is more common than you think.
With Azure Data Catalog, anyone can find the data they are looking for, no
matter the data source. This session will introduce you to Azure Data
Catalog, what it is, how you can use it and why everyone should be using it.

We are now using Teams!

In order to encourage questions during the presentation, we want people to use the raise hands option in Teams and not talk over each other. Please be mindful of the other attendees!

We will be starting at 4:00 PM

Schedule (may be fluid):
4:00 - 4:15 PM - Announcements and introduction to the new Leadership Team for 2021
4:15 PM - 1st Presentation


Our wonderful sponsors are providing gifts each month!

January 2021 Virtual Meeting Information:

Wednesday, January 13th, 2021, Meeting begins at 6:30 PM PST

RSVP at: https://www.eventbrite.com/e/january-2021-virtual-meeting-tickets-135602585985

Logins, Users & Roles: SQL Security 101

There are a lot of options for controlling user access inside a SQL Server instance and the granularity offered can be confusing to everyone (including database administrators). In this session we’ll break down permissions from the instance level down, to understand the difference between server and database principals, how server and database roles work, and how to use custom roles and object-level permissions to grant just the right amount of access to our applications and end users. Filled with practical demonstrations this session is geared for developers, junior and accidental DBAs, and system administrators looking to understand how best to implement SQL Server security.

Josh Smith is a production database administrator (going on seven years) as well as a community organizer. They are currently the president of the Inland Northwest Data Professionals Association and helped to organize SQL Saturday Spokane. Josh is perhaps too excited by documentation and cataloging but makes up for it with equal amounts of enthusiasm for automation and database deployment pipelines. When not working or sheltering in place during a global pandemic they are also an Aikido instructor in the Aikido World Alliance.