August 14, 2024 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

Securing your Azure SQL Database using TDE, Always Encrypted and more

Protecting the data is one of the prime responsibilities of the DBA. During this session we will cover some of the features of Azure and Azure SQL Database that will help make our data more secure. We will cover how to implement TDE, Always Encrypted, Always Encrypted with Secure Enclaves, Azure Locks and a brief introduction to firewalls.

Dave Bland

Manager of Database Administrators, Stericycle

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET.  Dave currently is the Manager of the DBA team at Stericycle.  Dave is a Friend of Red-Gate for 2019.  He is a frequent presenter at SQL Saturday events and user groups around the country.  Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL.  Current certifications include: Microsoft Certified Trainer; MCTS: SQL Server 2008, Implementation and Maintenance; MCTS: SQL Server 2008, BI Development and Maintenance; MCSA: SQL Server 2008; MCSA: SQL Server 2016; MCSE: SQL Server 2016 – BI; MCDBA: SQL Server 2000; MCSD; MCSE: Data Management and Analytics.


July 10, 2024 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

How database security changes when moving to the cloud

The cloud is secure, right? So if we move our data to the cloud, we don’t need to worry about security, right?

WRONG.

No matter where your data is housed, security needs to be a top concern. Cloud providers like Azure and AWS provide security to a point, but it’s not complete. There’s still a lot that you, as a developer or DBA, must do. In this session, we’ll discuss the security concepts that apply to all database systems, and we’ll dive into how those concepts apply specifically to the cloud.

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.