SESSION Details

Embedding SQL security practices in your pipelines

With our development pipelines we automate our SQL Server deployments and testing, but rarely do we automate checking our database security.

Are all object owned by the right principal? Are permissions only granted to roles or groups? Have any accounts moved between roles during testing? How can you check?

dbaSecurityScan is an Open Source Powershell module that lets you extract and source control your database's security, then test against it to ensure nothing has changed. It can even apply corrective measures to bring your database back in line with your policies.

In this session we'll look at why and what you'd want to be checking during your deployments or database's life. How dbaSecurityScan lets you create a security baseline to check against, how to update that baseline to meet new criteria, how to monitor when your database moves away from that baseline and how it can be used to bring it back into compliance.

Feedback link: https://sqlb.it/?6980

Starts: 12:00 11th Mar 2022
Ends: 12:50 11th Mar 2022

Q&As

Short Description
- Automate checking your database security model
Other technologies
- Any version of SQL Server

Slidedeck Link

dbaSecurityScan-bits2022.pptx

Speakers

Stuart Moore

Tags

AWSAzureOn PremisesIAAS VM BasedDataOpsOperational DatabasesSecure and GovernDeploymentDevelopingMonitoringSecuritySuccessful DeliveryTestingPowerShellSQL 2022SQL LinuxIntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.