I will be speaking at the upcoming SQL Saturday Louisville on August 3, 2019 on secure SQL Server design.
The abstract is as follows:
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.
Come join me at SQL Saturday Louisville on August 3 to hear both my talk and all of the other great speakers and topics!
SQL Saturday is a day of free training that can help you learn more about SQL Server and its associated technologies. SQL Saturdays are held around the globe by SQL Server User Groups. Speakers donate their time to help attendees expand their SQL Server knowledge.
SQL Saturday Louisville will be held at the University of Louisville, Founders Union, ShelbyHurst Campus, 450 N Whittington Pkwy, Louisville, Kentucky, 40222 on August 3, 2019 from 8:00AM ET to 5:00PM ET. Register here for this excellent FREE day of training.