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.
Speakers
Dan Mallott's other proposed sessions for 2026
ORMs and the DBA: How to Make Both Happy - 2026
Testing! We're Talking About (Unit) Testing...Your Database! - 2026
The Field Guide For the Accidental Manager - 2026
Why Am I Always Late? Or Is It Early? Why Are Dates So Hard? - 2026
Zero to Hero: Surviving the Transaction Process Like a Pro - 2026
Dan Mallott's previous sessions
Testing! We're Talking About (Unit) Testing!
Is the business logic in your database tested? It should be, and in this talk, we'll talk about how.
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.