Sanjeev Baranwal

Some interesting questions about Azure SQL DBA and MS SQL DBA. 1.     What is the best way to migrate the On prim database to Azure cloud. 2.     Do you have experience on deploying the iaas, paas services. 3.     Have you knowledge on Azure storage options. 4.     Can we replicate the databases into azure cloud. 5.     Do you have experience on log shipping, mirroring and replication on hybrid cloud method. 6.     How can we move the 2TB database from on prim to azure cloud. 7.     Can we migrate windows and SQL logins to azure SQL VM. 8.     Cluster rebalancing. 9.     How can we move the TDE enabled database into cloud. 10.  They are asking need some experience and knowledge about azure administration. Thanks for reading the artical.

94

8 Comments

Postgres 17 Highlights as shared by ENTERPRISEDB SOFTWARE INDIA PRIVATE LIMITED > Performance enhancements (improved btree and vacuum memory management) > New JSON capabilities (including the long-awaited JSON_TABLE() function!) > Logical replication improvements > Support for block-level incremental backups in pg_basebackups (Barman's ready to roll with this!) > COPY command now has an "ON ERROR ignore" option (data importers, rejoice!) > Enhanced MERGE capabilities Check out these resources to deepen your Postgres 17 knowledge: > Official Postgres 17 release notes ( https://lnkd.in/g7keM2Gc ) > EDB's Postgres 17 communication ( https://lnkd.in/gpcZ-4J6 ) > General overview from Tom Kincaid, SVP Engineering Servers & Tools ( https://lnkd.in/gERsjZUp ) > Detailed insights from major contributor Amit Kapila (https://lnkd.in/gi7_q9s8) > New MERGE capabilities explained by SQL expert Markus Winand (https://lnkd.in/gnreUGwW) > Logical replication enhancements breakdown by Amit Kapila (https://lnkd.in/gtvKJKQD) > Performance benchmarks by Crunchy Data (https://lnkd.in/gNxnpN6g) > Seven-part blog series on Postgres 17 features by Deepak Mahto pl/pgsql new features (https://lnkd.in/g6Ad_kAY nulls constraint (https://lnkd.in/guM7NCwq) > COPY (https://lnkd.in/gWPQf4Br) > MERGE (https://lnkd.in/gYTsU6Bf) > Correlated queries (https://lnkd.in/gKqjCE6X) > Loggin event triggers (https://lnkd.in/g8etWeuu) (I know some customers asked for this feature) > pg_maintain (https://lnkd.in/gF2uwGsk)

15

Manage your Azure cloud resources effectively with our latest release, "Azure FinOps Essentials" by Parag Bhardwaj and Arun Samayam. Uncover the secrets of optimizing cloud costs, ensuring governance, and maximizing the value of your Azure investments. From fundamental concepts to advanced techniques, this book is your ultimate guide to mastering Azure FinOps. Grab your copy now! https://rebrand.ly/kvyq50n https://rebrand.ly/npik7ol #AzureFinOps #CloudCostOptimization #Azure #CloudComputing #FinOps #CloudFinance #AzureCostManagement #CloudGovernance #CloudSecurity #TechBook #bpbpublications #newrelease

15

Some interesting interview questions from Z£n$°® 1.Basic question but important What are the requirements to build SQL servers from scratch in onprim and azure. 2.How we build HA and DR concepts in azure environment. 3.How u monitor the servers in azure Performance related issues in onprim. 4.How will dead locks happen and how do you resolve issues. 5.Do you knowledge about incident management and change management 6.Log shipping architect in azure. 7.What is the Difference between active active and active passive clusters . 8.Difference between AG and FCI. 9.As a DBA how you protect the data and Database. 10.Have you worked on P1 tickets. Thanks for your time to read the article.

22

How to get all the Azure vm sizes along with their rates? Use https://lnkd.in/gR7cZ2Sz to get info about all the vm sizes present in every location. 1. The rates are provided for Reservations (1 & 3 years), Savings plan (1 & 3 years) and for on demand usage. 2. Compare rates for a vm across different regions, with similar vm cpu and memory, across linux and windows OS 3. Get rates for Spot instances 4. Get info on types of Storage supported 5. It exposes api to get the data programatically If you want to construct your own vm rates database, use https://lnkd.in/gstHqxWi (does not require azure authorization) to get all the vm skus along with rates and lookup the vm size info from https://lnkd.in/guA29mhf (requires authorization) #azure #finops #cognizant

2

🚀 Embrace Microservices on Azure Kubernetes Service (AKS) 🌐 Looking to harness the power of microservices in the cloud? Azure Kubernetes Service (AKS) offers an ideal platform. Here's a snapshot of this architecture: 🎯AKS: Managed Kubernetes cluster hosted in Azure. Focus on agent nodes while Azure handles the Kubernetes API service. 🎯Virtual Network: AKS sets up a virtual network for agent nodes. For advanced scenarios, set up your own network with control over subnet config and more. 🎯Ingress: Exposes HTTP(S) routes to services within the cluster, acting as an API Gateway. 🎯Azure Load Balancer: Routes internet traffic to the ingress controller, ensuring scalability and reliability. 🎯External Data Stores: Microservices often use external data stores like Azure SQL Database or Azure Cosmos DB for stateful operations. 🎯 Microsoft Entra ID: Used for creating and managing Azure resources and recommended for user authentication in client apps. 🎯Azure Container Registry: Store private Docker images for deployment. AKS can authenticate using its Microsoft Entra identity. 🎯Azure Pipelines: Part of Azure DevOps, automates builds, tests, and deployments. Also compatible with third-party CI/CD tools. 🎯Helm: A Kubernetes package manager that simplifies managing and deploying applications. 🎯Azure Monitor: Collects and stores metrics, logs, and telemetry data for monitoring, alerting, and root cause analysis. 🎯 Cost Optimization: Use the Azure pricing calculator to estimate costs, and refer to the Azure Well-Architected Framework for further insights. 🆘 Cost Considerations: ✔️ AKS: No direct cost, but you pay for underlying resources. ✔️ Azure Load Balancer: Charges for configured load-balancing rules. ✔️ Azure Pipelines: Free options with charges for extra jobs. ✔️ Azure Monitor: Costs based on data ingestion and retention. Seize the potential of microservices on AKS, backed by the Azure cloud's robust infrastructure. #azure #aks #devops #microservices

24

Like 👍 Share 🤝 ✳️ What is Azure Storage Replication? ✳️ ✅ To maintain data availability and durability, Azure Storage creates and stores copies of data across multiple locations. This process is called storage replication. The goal is to provide redundancy to protect data against hardware failures, power or network outages. 🔥 Availability Zone Summary 🔥 ✳️ Azure Availability Zones is a high-availability service that protects applications and data from datacenter failures. ✳️ These are unique physical locations within an Azure region. Each zone is made up of one or more data centers equipped with its own power, cooling, and networking. ✳️ The physical isolation of Availability Zones within a region protects applications and data from datacenter failures. ✳️ Zone-redundant offerings replicate applications and data across Azure Zones to protect from single-points-of-failure. ✳️ Not every region has support for Availability Zones. ✳️ Availability Zones offer industry best 99.99 percent VM uptime Service Level Agreement Protects against datacenter-level failures ✳️ Microsoft Azure Blob storage /ADLS Gen2 offers the following replication options: ✅ Locally Redundant Storage (LRS): Data is replicated within a single storage scale unit. Offers high durability (99.999999999% or 11 nines) but is vulnerable to regional outages. ✅ Zone-Redundant Storage (ZRS): Data is replicated across multiple storage scale units within a single region. Offers even higher durability (99.9999999999% or 12 nines) and ensures data accessibility during zone outages. ✅ Geo-Redundant Storage (GRS): Data is replicated across two regions, with storage in a primary region and a secondary region. GRS offers durability for storage resources of at least 99.99999999999999% (16 9's) over a given year. ✅ Read-access geo-redundant storage (RA-GRS): Data is replicated across two regions, with read-only access available in the secondary region in case of an outage in the primary region. ✅ Geo-zone-redundant storage (GZRS): Data is replicated across multiple zones within a region and multiple regions. GZRS is designed to provide at least 99.99999999999999% (16 9's) durability of objects over a given year. ✅ Azure Fundamentals part 1: what is datalake https://lnkd.in/gxSDM3s9 ✅ azure fundamentals part 2 : What is data center , type of cloud services https://lnkd.in/gp_zpkiu ✅ azure fundamentals part 3 : types of cloud service models #cloudservices #cloudservicemodels https://lnkd.in/gfaQnESc Difference between DataLake and Blob Storage. ✅ https://lnkd.in/g-cGAf3x 📕 Learn , Lead and Make Leaders 🚀. Happy Learning 📖 Follow 👉  TR Raveendra for #DataEngineering Content #databricks #lakehouse #spark #sql #sparksql #azuredataengineer #azuredatabricks #pyspark #learnwithravi

67

Title :How to Automate Deployment in Azure? Automating deployments in Azure streamlines the process of delivering applications and services, ensuring consistency, reducing manual errors, and improving efficiency. Here’s a step-by-step guide to automating deployment in Azure: . Infrastructure as Code (IaC) with Azure Resource Manager (ARM) Templates ARM Templates: ARM templates are JSON files that define the resources needed for your application. You can automate the deployment of your entire Azure infrastructure using these templates. Steps: Create an ARM template that describes the resources (e.g., virtual machines, databases, networks). Use the Azure portal, Azure CLI, or Azure PowerShell to deploy the ARM template. Continuous Integration and Continuous Deployment (CI/CD) with Azure DevOps Azure DevOps: Azure DevOps provides a comprehensive suite of tools for CI/CD pipelines. Steps: Set Up Repositories: Use Azure Repos to host your code. Build Pipelines: Create a build pipeline to compile your code, run tests, and produce build artifacts. Release Pipelines: Create a release pipeline to deploy your application to Azure Example Workflow: Commit code to the Azure Repos repository. The build pipeline triggers automatically, builds the application, and runs tests. If the build is successful, the release pipeline deploys the application to Azure resources (e.g., App Services, VMs). 3. Azure CLI and Azure PowerShell Azure CLI: A command-line tool for managing Azure resources. Use scripts to automate resource provisioning and deployment tasks. 4. GitHub Actions GitHub Actions: Automate workflows directly from your GitHub repository. Integrate with Azure to deploy applications. Steps: Create workflows using YAML files in your GitHub repository. Define actions to build, test, and deploy your application to Azure. 5. Terraform Terraform: An open-source IaC tool that allows you to define and provision infrastructure using a high-level configuration language. Steps: Write Terraform configuration files defining the desired state of your infrastructure. Use Terraform CLI to apply the configurations. In summary, automating deployments in Azure can be achieved using various tools and services like ARM templates, Azure DevOps, Azure CLI, Azure PowerShell, GitHub Actions, and Terraform. Each tool provides unique features that can help streamline and manage the deployment process efficiently.

2

ON Premise DC to AZURE Migration :- As an AZURE Architect , Here I present a Solution - a Quick Short solution. Migration Success is dependent on Sound Assessment ( identifying what is to be migrated) and Sound Planning ( How to Migrate), Use AZURE MIGRATE and /or APP /DB Migration tools that could help. What should be provisioned in AZURE - my brief paragraph below covers that. #azuremigrate #onpremise #datamigration #firewalls #NSG #Trafficmanager #loadbalancer #frontdoor #Bastion #azureBLOB #Fileshare #azure #azuremigrate #Azurefileshare #Sharepoint. Plan your Virtual Network topology – ensure Multiple subnets are planned to group logical resources and Vm’s together. Create separate subnets for each webapp and databases. Bastion is a wise selection to cover for RDP & SSH to VM’s without exposing their PUBLIC IP’s. you definitely want to protect your Prod Application server from Black hat hackers. Connectivity between ON Premise DC to Azure DC- Use Express route & VPN Gateway. Provide dedicated, secure, high speed Private link and VPN Gateway can be used for redundant connectivity for HA (High availability). Implement Azure Firewall and NSG’s to create a Wall of fire and filter traffic , block all traffic except what is permitted. Use NSG’s to allow/block inbound/outbound traffic at subnet or NIC level. Scalability- Use Azure VWAN for global Connectivity, Use Load Balancer. Use Traffic Manager for global load balancing. Use Application Gateways for application routing & load balancing. High Availability- Use Availability Sets across zones for increased fault tolerance, use traffic Manager for cross region traffic Management. Performance Optimization- Use VPN Peering , Use Content delivery Network for content caching. Use Front door for enhanced Security and global load balancing. Implement Monitoring & Log Management- Implement Azure Monitor and MS Defender for CLOUD. Ensure to enable Diagnostic LOGS to capture detailed troubleshooting actions done on the VM. Compliance and Governance- Implement azure Policies. BackUP – Create Azure Back Up windows and Snapshots. AZURE FILE SHARE may be required , Implement SharePOINT on azure and SharePoint migration from ON-Prem to Azure.

130

9 Comments

How to configure Site.Selected API permissions – SharePoint Online / PnP PowerShell

15

Overview of Microsoft Purview(Data Governance Tool) In Hindi

2

Finally, I have created a highly reusable CI-CD approach for API Proxy deployment in Azure API Management using #AzureBicep & #AzureDevOpsPipelines. This has been long pending. While I've always appreciated the declarative approach of #AzureARMTemplates, I find #AzureBicep much simpler and more efficient. #azureBicep is a blend of goodness of Terraform like features with native ARM support. In my journey, I explored various alternatives like #APIOps, but I believe its better suited for organizations or teams heavily invested in GitOps or those starting from scratch. #ChatGPT was also helped me with handling bash for creating dynamic json which have api operation and it's related policies. Moreover, in the past too I have successfully implemented similar CI-CD automation for #BizTalk using #Powershell and #AzureDevOpsPipelines, utilizing both Classic and YAML pipelines. It's fulfilling to see the impact of streamlined processes in enhancing efficiency and productivity. #Azure #AzureAPIManagement #DevOps #Automation #CloudComputing #APIs

69

4 Comments

🎥 Watch to learn, all about 𝐡𝐨𝐰 𝐭𝐨 𝐛𝐨𝐨𝐬𝐭 𝐲𝐨𝐮𝐫 𝐆𝐞𝐧𝐀𝐈 𝐑𝐀𝐆 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬 𝐮𝐬𝐢𝐧𝐠 𝐆𝐫𝐚𝐩𝐡𝐑𝐀𝐆! Speaker- 🎙Osama Shaikh - Solution Architect at Microsoft Presented at #BuildwithGenAI webinar series hosted by Dear Azure - Azure INDIA (az-india) Watch here - https://lnkd.in/gjca2-FB #dearazure #rag #graphrag #build #genai #mvp #ai

7

azure-spotter Happy to announce that I have created https://lnkd.in/gs3X83ze and Open Sourced it. azure-spotter works within a Azure Subscription and replaces OnDemand VMs with Spot VMs for all the Azure Virtual Machine Scalesets. Please DM me if you require help in reducing Azure Cloud costs associated with Azure Virtual Machine Scaleset. This project is inspired from https://lnkd.in/gHmwXBWt and is built on top of https://stackql.io/, the IaC tool that only needs SQL. Cristian Măgherușan-Stanciu Jeffrey Aven #stackql

20

3 Comments