January 13th, 2021: Logins, Users & Roles: SQL Security 101 (oh my!) – Meeting starts at 6:30 PM PST

Microsoft Teams meeting
Join on your computer or mobile app
Click here to join the meeting

Or call in (audio only) (phone number and conference ID followed by # sign)
+1 872-239-6107  United States,
Chicago
Phone Conference ID: 144 786 870#

Meeting begins at 6:30 PM PST

We will begin with a discussion of the state of the union followed by a possible short session and then our main presentation as listed below.

Note – we will be using Teams.  No one will be muted.  Please use the RAISE HANDS feature during the meeting.

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.

Microsoft Teams meeting
Join on your computer or mobile app
Click here to join the meeting

Or call in (audio only) (phone number and conference ID followed by # sign)
+1 872-239-6107  United States,
Chicago
Phone Conference ID: 144 786 870#

Posted in Announcements | Leave a comment