JAN 2023 - SQL Server Security by Kenneth Fisqher (@sqlstudent144)
Abstract
I end up answering a lot of security questions in the DBA portion of my job, and because of that I've developed a few interesting tricks, and written some handy scripts to work through them. By the end of this presentation, you'll be able to generate a quick and easy entitlement report, tell what active directory groups an individual is using to connect to a given database, check to make sure that the service account can execute that stored procedure, and more.
Speaker Bio
Kenneth Fisher has worked as a database administrator and/or database developer for his entire career of over thirty years. He enjoys writing and his writing credits include a number of technical articles and SQL Server-related crossword puzzles. He also blogs incessantly at www.sqlstudies.com and is honored to be a Data Platform MVP
Session Materials
https://github.com/sqlstudent144/Session-Scripts/tree/main/Security%20Headaches
-
9:07
shaneyyricch
1 day agoAddressing my beef with Harry Sisson
62K98 -
1:52:46
Game On!
19 hours agoBoston Celtics Can't Win Game 2! | Sports Morning Espresso Shot
49.8K33 -
1:00:01
Trumpet Daily
1 day agoMarxist Left Continues to Imprison Trump’s Inner Circle - Trumpet Daily | June 7, 2024
46.3K58 -
DVR
The Amber May Show
12 hours agoReAwaken America Tour Detroit, MI - DAY 2 | Join General Flynn, Eric Trump, Kash Patel, Mayor Giuliani & Team America + Request Tickets for October 18-19 Selma, NC At: TimeToFreeAmerica.com
75.8K27 -
12:23
Freakin' Reviews
1 day agoRice Robot Review: One-Touch Rice Cooker? | As Seen on TV
80.3K30 -
5:45
Game Developer
1 day agoHow To Become A Game Dev (While Working A Full Time Job)
71.8K15 -
4:16
ryanhoguepassiveincome
1 day agoElevate Amazon Ads brand content with your Brand Store
70.4K6 -
16:19
RealReaper
1 day agoThe Acolyte Is Unwatchable
62.9K53 -
11:29
Ethical Preparedness
22 hours ago2 EASY Ways: Make Insect Bite & Sting Medicine - Medical Prepping for SHTF - Natural Medicine
69.1K13 -
15:52
JoBlo Horror Originals
1 day agoThe Watchers Review: Shyamalans Sure Do Love Their Twists
67.4K7