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.
-
2:06
Gamazda
1 hour ago $0.72 earnedBlack Sabbath - Paranoid (Piano)
7.64K15 -
1:00:04
Russell Brand
5 hours agoDr. Oz and the War for Your Health - SF618
149K31 -
LIVE
Viss
4 hours ago🔴LIVE - Your Helping Hand to Winning In PUBG!
248 watching -
1:12:08
Sean Unpaved
4 hours agoJerry's Soundbites, Bengals' Hopes, & Mike Brown's Bold Take
41.4K2 -
41:58
LadyDesireeMusic
2 hours ago $0.84 earnedLive Piano Renditions | Make Ladies Great Again | Live Piano Requests TONS to choose from
19.5K2 -
1:04:17
Timcast
5 hours agoGOP SHUTS House Votes BLOCKING Massie/Khanna Epstein Files Release
167K150 -
11:57
Michael Button
6 hours ago $0.55 earnedAre We Missing an Ancient Sea-Faring Culture?
14.7K19 -
1:43:50
The Confessionals
4 hours agoNavy Pilot’s Drug Bust Mission Turns UFO Chase Over Open Ocean (Then It Went Underwater)
13.1K1 -
LIVE
StoneMountain64
3 hours agoBattlefield 6 CONFIRMED + Delta Force Escaping PRISON with PROS
76 watching -
17:22
ROSE UNPLUGGED
18 hours agoInside Trump’s Game-Changing Law
6.15K