SQLBits 2020

Secure SQL Server Database Design: Tactics and Technology

When you design and build an application, do you think about security first or is it an afterthought? In this talk, you will learn strategies for designing and securing your data layer.

When you design and build an application, do you think about security first or is it an afterthought? Design for an application often starts with the database layer. In this talk, you will learn strategies for designing a more secure database. These strategies include simple design decisions for table, views, stored procedures, and data access roles. You will also learn about basic security features of several popular database platforms, including SQL Server and PostgreSQL and how these features apply in the cloud. Lastly, you will learn tips on how to retrofit security features on existing databases and look at how data access from the application may need to change.