Podcast Episode: Microsoft Fabric Deployment Pipelines — A Complete Deep Dive
Pip: If you have ever manually copied a report from a dev workspace to production and immediately regretted it, Praveen
Category: Azure
Azure Storage Account – Disaster Recovery: Planned Failover
Disaster recovery (DR) is a crucial aspect of cloud storage, ensuring business continuity during outages. Azure Storage provides built-in geo-redundancy to protect against regional failures.
Microsoft has introduced Planned Failover, currently in preview, to allow seamless failover without data loss
Azure – Assign API Permissions to Managed Identity using PowerShell
In this article, we will learn the basics of how to create the Managed Identity, different types of MI, how to assign them to Azure resources and then learnt what Microsoft Graph is, Install it and then develop PowerShell code to grant API permissions to the Manage Identity as the Portal doesn’t support this yet as of this writing.
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.
Create Database-Scoped Users for Microsoft Entra Security Groups
In modern cloud environments, managing access to databases at scale can be challenging. By integrating Azure SQL with Microsoft Entra (formerly Azure Active Directory) Security Groups, you can streamline access control while ensuring secure and efficient database operations.
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 Bicep Understanding Export and Import Attributes for Reusability
In this article, we are going to learn about the new feature of bicep called export and import attributes. Using this feature, we can reuse variables, types and functions.
Let’s get started learning about import and export attributes, it’s advantages with examples
Introducing az.deployer().objectId in Bicep: Track object/principle id of user / Managed Identity
With the release of Bicep v0.32, a feature has been introduced: the ability to retrieve the principal ID of the user or identity executing the Bicep deployment, using the az.deployer().objectId function.
This feature enhances visibility and traceability in deployment operations, making it easier to implement governance and compliance practices.
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.
Praveen Kumar Sreeram's Blog 