Database Continuous Integration & Advanced Data Security

Agenda:

• 17:30-18:00 - Gathering, Networking, Hugs and Kisses

• 18:00-18:15 - Opening, Announcements, and More...

• 18:15-19:15 - First Session (CI and CD with SSDT – Part 1: Development Lifecycle Basics for DBAs)

• 19:15-19:30 - Break (More Networking)

• 19:30-20:15 - Second Session (Use ADS to Classify Your Data, Prevent Vulnerabilities and Protect Against Threats)

Sessions:

1. CI and CD with SSDT – Part 1: Development Lifecycle Basics for DBAs – Eitan Blumin (60 Minutes, Hebrew)

Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing and CI/CD: SSDT comes with an answer for all. This session is based on Eitan's real-world experience of implementing source control methodologies and CI/CD for SQL Server databases, using the Microsoft SSDT environment.
Before we can dive into SSDT, we must all be on the same page and understand the terms and methodologies used in the world of software development lifecycles. After all, with the power of SSDT, we the DBAs also become a part of this world!
In this session, the first of a 2-part series, we will learn: What is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that DBAs must familiarize themselves with before integrating with the software development lifecycle.
We all know the database is a critical element of your software product. It’s high time for that fact to be reflected in your database development lifecycle!

2. Use ADS to Classify Your Data, Prevent Vulnerabilities and Protect Against Threats – David Trigano and Michael Makhlevich (45 Minutes, Hebrew)

Advanced data security is a unified package for advanced SQL security capabilities. It includes functionality for discovering and classifying sensitive data, surfacing and mitigating potential database vulnerabilities, and detecting anomalous activities that could indicate a threat to your database. It provides a single go-to location for enabling and managing these capabilities.

Important: In order to attend this meetup, you must RSVP. If your name does not appear on the list of attendees, you won't be able to enter the venue. So please RSVP. Registration will be closed two days before the event, on 01/02. Thank you!