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.
-
59:40
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Data Lake Design Patterns by Jason Horner | @Blackline Room
17 -
54:43
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Architecting SQL Server on VMware vSphere by Oleg Ulyanov | @VMware Room
36 -
1:13:06
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Loading SQL Server Data with PowerShell by Sean McCown | @SentryOne Room
73 -
52:38
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Build Your 1M Dollar SQL Practice by Adrian Sullivan | @PureStorage Room
21 -
53:41
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Synapse Analytics: Beyond the Basics by Dennes Torres | @PureStorage Room
36 -
58:07
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: SQL Server 2019 is not your dad's DBMS by Armando Lacerda | @Blackline Room
18 -
56:20
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA Presents: The Future of Containers Is Here! by Marsha Pierce | @PureStorage Room
22 -
1:23:35
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: DevOps for Azure SQL by Arvind Shyamsundar | @Microsoft Room
39 -
1:04:24
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Monitor SQL using Free solutions by Javier Villegas | @SentryOne Room
65 -
1:02:01
Data.SQL.Saturday.LA
4 years ago2020 @SQLSatLA presents: Azure SQL Hyperscale Deep Dive by Denzil Ribeiro | @Microsoft Room
26