Jaimin Bhavsar

Jaimin Bhavsar


Interview with Acuutech on Azure Arc Enabled Servers

Matt McSpirit, Senior Program Manager with Microsoft is joined by Terry Storey, Chief Cloud Office with Acuutech to discuss Azure Arc enabled servers.

Microsoft Learn collection – Windows Server: https://aka.ms/Ignite2020-122

#azure #cloud #developer

What is GEEK

Buddha Community

Interview with Acuutech on Azure Arc Enabled Servers
Ruthie  Bugala

Ruthie Bugala


How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

In this article, you will see:

  • Overview of Azure SQL Data Sync feature
  • Discuss key components
  • Comparison between Azure SQL Data sync with the other Azure Data option
  • Setup Azure SQL Data Sync
  • More…

Azure Data Sync

Azure Data Sync —a synchronization service set up on an Azure SQL Database. This service synchronizes the data across multiple SQL databases. You can set up bi-directional data synchronization where data ingest and egest process happens between the SQL databases—It can be between Azure SQL database and on-premises and/or within the cloud Azure SQL database. At this moment, the only limitation is that it will not support Azure SQL Managed Instance.

#azure #sql azure #azure sql #azure data sync #azure sql #sql server

Azure Series #2: Single Server Deployment (Input)

In the previous article, we discussed the Gateway to your single server deployment (example: webserver). In this section, we shall continue with Input and Core Infrastructure.

Input for single-server deployment

When you talk about Data for your organization, it covers all three things, “People, Process, and Technology”. More details for the “Streaming and Sourcing Layer” can be found in a separate section (will update the link soon).

**_People: The Who. _**Producers and Consumers of data.

**_Process: The How. _**How the data is curated and put to use.

**_Technology: The What: _**What technologies are used to fetch, process, pass on and store.

Data: While People, Process and Technology is the golden triangle, if you think about it, the very reason the entire state-of-the-art ecosystem exists is merely to get the raw data to a usable form.

1. Data catalog

Any great state-of-art ecosystem is a waste if the data in need for consumers cannot be discovered and from the Producers side, if data cannot be documented/tagged properly that makes it useable for the consumers or end-users. Azure Data Catalog helps to bridge this gap of making the data correctly discoverable by fixing the traditional problems for both consumers and producers and also helps organizations to get the best value out of their existing information assets.

2. Streaming

While we will discuss more as part of the sourcing section, we shall cover the basics of streaming.

1/ Queue Storage

2/ Service Bus

3/ Event Hubs

4/ Event Grid

#azure-interview #azure-event-grid #azure-event-hub #azure #azure-service-bus

Preview of Azure Arc enabled SQL Server is now available

We are making available the private preview of Azure Arc enabled SQL Server. The preview includes the following features:

  • Use the Azure Portal to register and track the inventory of your SQL Server instances across on-premises, edge sites, and multi-cloud in a single view.
  • Use Azure Security Center to produce a comprehensive report of vulnerabilities in SQL Servers and get advanced, real time security alerts for threats to SQL Servers and the OS.
  • Investigate threats in SQL Servers using Azure Sentinel.

Image Azure Arc Diagram 061620 750

You can register any Windows or Linux based SQL Server to track your inventory. Azure Security Center’s advanced data security works on Windows-based SQL Server version 2012 or higher, running on physical or virtual machines and hosted on any infrastructure outside of Azure.

Here’s a video of the Arc enabled SQL Server experience with Azure Security Center.

If you are interested in participating in this preview, please fill out the sign-up form and select the option Server Management (SQL Server).

#azure sql #azure #sql #azure-arc

Azure Series #2: Single Server Deployment (Core Infrastructure — II)

4. Virtual Machines

Virtual machines are the computers you can hire on the Azure cloud. You can choose any OS including but not limited to Windows, Linux image, etc. You can choose the CPU, Memory, Network Interface Card (NIC), and Storage based on the workloads that you want to migrate or create new workloads in your virtual machines. A firm can have as many Virtual machines as you may see in the server rooms across regions in the organizations. If you want to deploy advanced solutions such as Big data or voluminous data processing, then you can choose an optimal server configuration. Virtual Machine is part of Virtual Network and Subnet. Whether or not you want to expose the VM publicly depends on which tier of the architecture your VM is going to sit.

Why use Virtual Machine:

Virtual Machines are nothing different from the Application Servers, Database Servers, Web Servers, Phone servers, etc. that are part of your primary and secondary site on-premise. Instead of these servers managed and maintained by the Infra team, the servers will be deployed by the cloud management team but will be managed by the Infra team of your organization and you shall deploy workloads on it. As per the shared security model, whatever that goes into the Virtual Machine, you are responsible to maintain, manage upgrades and ensure security. Whatever is deployed by Aure such as Linux VM, Windows VM, etc., upgrades and next versions will be automatic and downtime will be managed by Azure and will be notified to you. If you are procuring VM and deploying Database on it, then it becomes your responsibility to upgrade the database as it is not managed by Azure. Knowing this difference between unmanaged and managed is critical.

Types of Virtual Machine:

  • **Linux Virtual Machine: **Azure endorsed distribution has Linux on Azure includes SUSE, Redhat, Debian, etc., and Docker, Jenkins from the marketplace.
  • Windows Virtual Machine
  • SQL Server on Virtual Machine
  • **Data Science Virtual Machine **(Discussed in a later section)
  • **Virtual Machine Scaling Sets **(Discussed as part of Multi Scaleable server deployment)
  • Azure Bastion

These Virtual Machines are available in various sizes. We can logically group these sizes based on the key characteristics of the VM

  • Based on CPU: General Purpose or Compute Optimized with very good computing power. Balanced memory to CPU ratio. Advanced options include GPU (special machines) or HPC (for Big data or ML).
  • Based on Storage: Storage optimized with high disk throughput and space.
  • Based on Memory: Memory-optimized with high memory to CPU ratio.

#azure-batch #azure-interview #azure #azure

Creating and Cataloging SQL pools in Azure SQL Server

This article will walk you through creating a new SQL pool within an existing Azure SQL Server as well as catalog the same using the Azure Purview service.


Data is generated by transactional systems and typically stored in relational data repositories. This data is generally used by live applications and for operational reporting. As this data volume grows, this data is often required by other analytical repositories and data warehouses where it can be used for referential purposes and adding more context to other data from across the organization. Transactional systems (also known as Online Transaction Processing (OLTP) systems) usually need a relational database engine, while analytical systems (also known as Online Analytical Processing (OLAP) systems) usually need analytical data processing engines. On Azure cloud, it is usually known that for OLTP requirements, SQL Server or Azure SQL Database can be employed, and for analytical data processing needs, Azure Synapse and other similar services can be employed. SQL Pools in Azure Synapse host the data on an SQL Server environment that can process the data in a massively parallel processing model, and the address of this environment is generally the name of the Azure Synapse workspace environment. At times, when one has already an Azure SQL Server in production or in use, the need is to have these SQL Pools on an existing Azure SQL Server instance, so data in these SQL pools can be processed per the requirements on an OLAP system as well as the data can be co-located with data generated by OLTP systems. This can be done by creating SQL Pools within the Azure SQL Server instance itself. In this article, we will learn to create a new SQL Pool within an existing Azure SQL Server followed by cataloging the same using the Azure Purview service.


As we intend to create a new SQL Pool in an existing Azure SQL Server instance, we need to have an instance of Azure SQL in place. Navigate to Azure Portal, search for Azure SQL and create a new instance of it. We can create an instance with the most basic configuration for demonstration purposes. Once the instance is created, we can navigate to the dashboard page of the instance and it would look as shown below.

As we are going to catalog the data in the dedicated SQL Pool hosted on Azure SQL instance, we also need to create an instance of Azure Purview. We would be using the Azure Purview studio from the dashboard of this instance, tonregister this SQL Pool as the source and catalog the instance.

#azure #sql azure #azure sql server #sql #sql #azure