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.
-
29:38
Uncommon Sense In Current Times
13 hours agoIs Doubt a Sin? Wrestling with Faith & Belief (Part 1) | Dr. Randal Rauser
5.97K2 -
8:29
The Art of Improvement
19 hours ago4 Strategies To Accelerate Your Personal Growth By 200%
631 -
LIVE
The Bubba Army
21 hours agoTrump Pardoning Diddy? - Bubba the Love Sponge® Show | 7/30/25
3,583 watching -
10:53
Nikko Ortiz
1 day agoWORST Clips On The Internet
58.1K21 -
27:44
DeVory Darkins
16 hours ago $4.62 earnedCHILLING update regarding NYC shooter Lefties LOSING IT over Sydney Sweeney
11.1K82 -
10:05
MattMorseTV
14 hours ago $10.65 earnedHe actually did it...
76.5K36 -
LIVE
Midnight In The Mountains
1 hour agoMorning Coffee w/ Midnight & The Early Birds of Rumble | Tsunami's Railing Cali ...
92 watching -
2:20:02
Side Scrollers Podcast
19 hours agoSYDNEY SWEENEY JEANS CONTROVERSY BREAKS THE INTERNET + TWITCH APOCALYPSE + MORE | SIDE SCROLLERS
77.6K15 -
3:10:02
Price of Reason
14 hours agoTrump Tariffs Are GOOD? Syndey Sweeney Faces WOKE Backlash! Fantastic Four FLOPS! Mouthwashing BAN!
5.83K6 -
2:04:55
svgames
2 hours ago🟢LIVE - TRIVIAA
4.3K1