SQL Repository

Welcome to the SQL repository! This repository contains SQL scripts and queries related to my everyday work with Azure SQL Database, SQL Server, and database administration. Some of the code is associated with blog posts on my blog: SQL Blog Posts.

Table of Contents

Azure SQL Database Permissions

• AssignDatabasePermissionstoADDGroups.sql
  • Complete script to grant database permissions to Microsoft Entra ID groups
• CreateUserOnMaster.sql
  • Create login grant user in master database
• VerifyEntraIDPermissions.sql
  • Verify Microsoft Entra ID users and groups with their role memberships

Microsoft Entra Service Principals

• AddServicePrincipalToAzureSQLDatabase.sql
  • Add Microsoft Entra service principal to Azure SQL Database with db_owner permissions

Sample Data Scripts

• CreateAndInsertData-API-Driven-Sample.SQL
• CreateSampleTable.sql
• CreateTableForAPI-Driven.sql

Database Security

• AddSecGroupToDB.sql

Disclaimer

The code and documentation in this repository are provided "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Use at your own risk.

Contact

For any questions or feedback, feel free to reach out via LinkedIn.