Quad Cities Data Professionals - April 16, 2025 Meeting

5:30 Networking
6:00 Presentation

Security Compliance and Auditing for SQL Server and the Azure Data Platform (Part 1 of 2)

As security and privacy requirements increase, DBAs are being tasked with providing detailed information about the architecture and activity on their databases, both for governance and compliance. However, the regulations are many and complex, and they are often written generically so they can be applied to many different industries. How do you interpret the regulations? What do you actually need for proof? And how do you get that information out of SQL Server and Azure?

In this session, we'll explore some of the most common cybersecurity frameworks for regulations and cyber insurance, and we'll break them down to understand how to architect your data platform for compliance. We'll also look at how to use the tools available from Microsoft to get the proof you need. By the end of the day, you'll have a plan for compliance that you can start implementing.

Ed Leighton-Dick

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.