Azure SQL Database – Configure Job using Elastic Agents

Azure SQL Database Elastic Jobs enable users to automate and schedule administrative tasks across multiple Azure SQL Databases. Tasks such as schema updates, and user management can be efficiently handled. Elastic Jobs provides a centralized mechanism for workload management, ensuring consistency and reducing manual effort.

Implementing Inheritance in Azure Bicep: A Workaround Using Global and Module-Specific Tags

Inheritance is not natively supported in Azure Bicep, but with a creative use of modules and functions like union, we can implement a similar behavior.

This article demonstrates a practical workaround to manage global tags and extend them with module-specific tags dynamically.

The example includes creating two modules: (1) Storage Account and (2) Log Analytics Workspace. These modules receive and process tags via a centralized Tags module.

Azure Storage Account Vs Azure Data Lake Service Gen 2

Azure Data Lake Storage Gen2 (ADLS Gen2) is a highly scalable and analytics-optimized storage solution in Azure, offering hierarchical namespace, big data processing capabilities, and Secure File Transfer Protocol (SFTP) support. ADLS Gen2 is ideal for managing large datasets for analytics, machine learning, and file transfer workflows. With granular Access Control Lists (ACLs) and seamless integration with tools like Azure Synapse Analytics, it empowers users to handle complex data workloads efficiently.

Azure SQL Database – View/Update Roles assigned to Users & Groups with Azure Data Studio

Azure SQL Database is a managed cloud database service that allows you to build secure, scalable applications on a fully managed SQL database.
Often, database administrators need to view and manage user roles and permissions. For this, you might have used SSMS which shows in the UI itself for SQL Server. Unfortunately, SSMS doesn’t show the same for Azure SQL Database.
In this article, we are going to learn how to view the list of roles assigned to Users and Groups using Azure Data Studio.

Azure SQL and Synapse Dedicated Pool – Configuring Git using Azure Data Studio

In this blog post, we’ll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.

We’ll walk through the necessary steps to seamlessly integrate Git version control into your development workflow, allowing for efficient collaboration and tracking of changes across database objects like Tables, Stored Procedures, View and any other SQL objects.

By leveraging the powerful capabilities of Azure Data Studio and Git, you can streamline development processes, ensure version consistency, and enhance team productivity within your Synapse Dedicated Pool (and Azure SQL Database) environment. It’s also very important that the Database objects are integrated with Git in order to implement Data Ops.

Common Man Tips for Power Platform, Dynamics CRM,Azure

Venkata Subbarao Polisetty - Microsoft MVP,C# Corner MVP

Thomas Thornton Blog

Empowering Developers with Azure, Azure DevOps, GitHub & Terraform Insights

Praveen Kumar Sreeram's Blog

Azure for developers

Big Data Analytics

Occasional observations from a vet of many database, Big Data and BI battles

Cloud and DevOps Space

This website contains blogs about Microsoft Cloud i.e Azure and DevOps concepts.

Exercising Sitecore

Sitecore, Sitecore Personalization, Sitecore Analytics, xDB, WFFM - Sitecore MVP & .NET Developer Blog

salt and sitecore

Don't give up on your dreams.......keep sleeping.

Sitecore Architecture

Grant's Sitecore Rants

Srikaracharya's blog

It is not about being best.. It is about being better than yesterday.

Sravani Reddy's Blog

It's all about sharing knowlege

ADITYA CIVIL WORKS

Help you in finding

Karim Vaes

The insights of a Quirky Tech Enthousiast on his journey through the fast paced IT landscape.

Build5Nines

Cloud, DevOps & SRE Guidance