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.
-
46:53
Man in America
8 hours agoCan the UN Exploit an Election Crisis to SEIZE CONTROL of the USA? w/ Alex Newman
23.4K5 -
LIVE
tacetmort3m
10 hours ago🔴 LIVE - NOT ABANDONING THIS GAME LETS CONTINUE - GHOST OF TSUSHIMA - PART 5
860 watching -
1:47:06
Flyover Conservatives
23 hours agoBehind the Scenes with Eric Trump, Clay Clark on Elections, Alfie Oakes on America's Food Source, Alexandra Bougher on Parents’ Rights, and Ivan Raiklin on Nov 6! | FOC Show
32.1K2 -
1:31:19
Glenn Greenwald
7 hours agoMeltdown Over Non-Endorsements From WaPo & LA Times; Why Can't The U.S. Count Votes In One Night? Former Addict Saved By Mission To Rescue Street Dogs | SYSTEM UPDATE #358
89.2K66 -
2:22:09
Roseanne Barr
14 hours ago $50.90 earnedLara Logan is Fearless | The Roseanne Barr Podcast #71
109K117 -
4:32:34
Nerdrotic
9 hours ago $36.86 earnedRey Movie is TOAST! Blade Canceled, The End of Woke Hollywood! | Friday Night Tights 325
108K28 -
1:03:29
Talk Nerdy 2 Us
13 hours agoElection Hacks, Stolen Emails, & Government Crypto Heists: Political Cyber Wars Exposed!
36.6K -
1:00:03
The StoneZONE with Roger Stone
5 hours agoTrump SURGES With Hispanic Voters Just Days Before 2024 Election | The StoneZONE
39K9 -
48:09
Candace Show Podcast
8 hours agoKamala’s 23andMe Results: Everything BUT Black | Candace Ep 91
202K551 -
1:12:46
Edge of Wonder
8 hours agoMissing People Near Caves, Area 51 Whistleblower & Recent UFO Sightings
39.9K10