Premium Only Content

2020 @SQLSatLA presents: Secure SQL Server Database Design by Dan Mallott | @PureStorage Room
Secure SQL Server Database Design: Tactics and Technology by Dan Mallott (@DanielMallott)
When we design and build an application, do we think about security first or is it an afterthought? As we read about more and more data breaches, it is clear that we need to think security-first when designing and building our applications.
Where does design start for an application? It starts with the database layer. In this talk, we will discuss strategies for designing a more secure SQL Server database. We will start with simple design decisions for tables, views, stored procedures, and database roles that can improve security before moving on to talk about built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. Lastly, we will finish up with some tips on how to retrofit security features onto existing databases and look at how data access from the application may need to change.
Prerequisites: Basic knowledge of database design. Knowledge of Tables, Views, Stored Procedures. Familiarity with Database and Server Roles.
-
6:35:59
SpartakusLIVE
10 hours ago#1 Monday MOTIVATOR || Charity Stream Wednesday, The Gauntlet SOON, and 2v2s RETURN?!?!
58.3K -
2:58:23
TimcastIRL
9 hours agoBiden Pardons WERE FAKE, NYT Report PROVES Trump WAS RIGHT, Fauci Faces Charges | Timcast IRL
276K103 -
8:01
MattMorseTV
14 hours ago $9.22 earnedTrump just DROPPED a BOMBSHELL.
56.5K65 -
6:53:27
Cancel This Podcast
9 hours ago $3.75 earnedROLE-PLAYING GRINDS: FINAL FANTASY XIV, DRAGON QUEST X & OCTOPATH COTC - CTP GAMING MONDAYS!
33K1 -
7:25:37
FoeDubb
10 hours ago🏰KINGDOM MENU :🎮LATE NITE PUBG 🤣MOST LIKELY A BAD IDEA DILLY DILLY!!!
21.5K -
1:34:52
Glenn Greenwald
12 hours agoIs There Evidence of Epstein's Ties to Israel? Yes: Ample. Brazil's Chief Censor Orders Rumble to Ban US Citizen and Turn Over Data | SYSTEM UPDATE #486
169K135 -
2:20:40
GamerGril
6 hours agoMarvel Rivals Monday | Battle Of The Bronze
20.9K5 -
46:08
FanatikGaming
5 hours ago $3.99 earned💪Monday Motivation🦾 - Legends Never DIE!💯💯 ATWU - BTTB!☝️🔥
27.2K2 -
5:11:24
WolfLinksShadow
6 hours agoMario Kart Monday & More!
21.9K -
58:16
Redacted News
14 hours agoThe Secret Space Program IS REAL and this Whistleblower is EXPOSING all of it
87.8K279