Saturday, September 17, 2016

"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016

I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by a number of my colleagues from Sparkhound. We're establishing a presence in Charlotte and already have a couple big clients in the area, so Sparkies from both Baton Rouge and Charlotte joined me this weekend.

My presentation slide deck and demo scripts can be downloaded via the SQLSaturday website here.

The session is a ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, contained databases, application roles and more. This class is perfect for DBA's, developers and system admins, and we'll cover security basics for Azure SQL Database as well.

As a SQLSat organizer in Baton Rouge myself, I know exactly how much work and sweat equity it takes to put on a SQLSaturday event. The Charlotte team knows what they're doing after five years or so, and did a great job in 2016. Excellent work by the entire organizing team!