Azure Heroes User Group and Trainings

Learn from Azure Heroes, Network and be part of a community.

Click Here for Azure Heroes Training

Inspiration

Empowering possibilities through innovation: Let's build the future today!

Network

Connections spark breakthroughs—let's ignite our potential together.

Innovation

Innovation thrives where ideas meet possibilities—unleash yours with Azure.

About Azure Heroes

Welcome to the Azure Heroes Community, a vibrant space for Azure enthusiasts to connect, share knowledge, and grow together! Whether you're a seasoned cloud professional or just starting your Azure journey, our community is here to support you. We host regular meetups, webinars, and discussions around the latest Azure innovations, best practices, and real-world experiences. Join us to collaborate with fellow cloud enthusiasts, gain valuable insights, and earn your Azure Hero badges along the way. Let's learn, share, and build the future of cloud technology together!

Azure Heroes Training Coming soon....

Did you miss Global Azure Heroes?

Aftermovie below

Free Stuff

SQL Server Permission Scripting

Automated Scripting of Permissions

What is it?

In the below button you can access all the code. i ran this against StackOverflow2010 from Brent Ozar, It will not only script all permissions but generate the correct SQL Statement so you can recreate them if needed. This allows for Audit and traceability of all SQL permissions and a source of truth. It will script :

Sever Roles Server Level Permissions

Logins to be created

Role Level Permissions

Users per DB

User Level Permissions

Object Level Permissions

How to install?

Easy copy and paste the script into a per SQL Instance basis or via Central Management Servers to install on multiple. Hit f5 or Execute and its done. If you do not want or have a DBA DB then open the code within notepad for example and search and replace all DBA to what ever you like.

Demo?

watch the video below, it was recorded for Data Popkorn, a 5 min video which shows you a quick insight how to use the scripts.

Click here github.com/MrKruge/SqlServerScriptPermissions