Midlands PASS: SQL Server Security Basics

Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly user meeting. We’ve been on hiatus since the holidays but we should be meeting regularly again for the rest of the year. The typical schedule (all times are Eastern):

  • 5:30 – 6:00 PM: Meet and Greet / Networking
  • 6:00 – 7:15 PM: Main Talk
  • 7:15 – 7:30 PM: Prizes (if we have any) / Networking

RSVP Link for the March 2020 Meeting: https://www.eventbrite.com/e/sql-server-security-basics-tickets-97152292121

This month I’ll be speaking. Here’s the talk:

SQL Server Security Basics

What do you need to know to work with SQL Server security properly? In this talk, we’ll look at the must knows. We will start with how a person or application connects to SQL Server and the types of authentication SQL Server provides. We will then look at the hierarchical security model SQL Server implements and how this flows down from server all the way down to tables, views, and stored procedures. Afterwards, we will discuss particular security roles which allows access without explicit permissions. Finally, we will look at ownership chaining and how that can also allow a user access to an object because of a reference from a different object.

Renewed as a Friend of Red Gate

I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare first debuted. Tremendous tools are not the best asset, though. If you weren’t aware, the people are. Most folks are familiar with the more well known SQL luminaries like Grant Fritchey, Steve Jones, Kathi Kellenberger, and Kendra Little. However, everyone I’ve interacted with in the organization have been great.

 

SheLeadsTech Webinar: Braving the Wilderness of Cybersecurity

ISACA has a SheLeadsTech webinar for tomorrow, February 25, 2020 titled Braving the Wilderness of Cybersecurity.

Registration Link: https://www.isaca.org/education/online-events/lms_w022520

If you can’t make the talk, ISACA archives all webinars for one year.

Here’s the information on the talk:

Braving the Wilderness of Cybersecurity

Cybersecurity is one of the most exciting and most challenging career paths you can take. No matter your gender, your age or your experience, there will always be a time when you will feel like you don’t belong, and you are all alone in the middle of the wilderness.

In this webinar we will discuss how you can be brave through those times and what are the key values that will help you succeed and have a thriving cybersecurity career.

Speaker: Enkeleda Ibrahimi

Senior Security Consultant at KPMG, Founder & Community Architect at MeetCyber, IoT Security Enthusiast

Enkeleda is a senior cybersecurity consultant, with over 6 years of experience in different corporations like Vodafone, KPMG, PwC, and more. She is also the founder of MeetCyber, a global network of professionals who are passionate about cybersecurity. Enkeleda holds a master’s degree in Information Security from Stockholm University, is a certified ISO27001 lead implementer and co-author of several research papers in biometrics security and security governance. She was named one of top 50 European Women of Influence in Cybersecurity for 2019 by SC Media UK.