1407, 2020

Azure Data Migration

By |July 14th, 2020|Categories: Database|

Azure Data Migration Service Azure has an amazing migration service which is easy to use and is suitable for various data migration needs. The service has the capability to do offline and online migration (i.e. migrate data without any downtime to the source database). Note: Online migration is available in premium pricing tier The complete list of source and target database supported for offline and online migration is available in the below link: https://docs.microsoft.com/en-us/azure/dms/resource-scenario-status Steps involved in migration Create Azure Database Migration Service in Azure portal. Create a new migration project and enter the source and the target database credentials. Note that ADMS requires TLS 1.2. Check the ‘Common Errors’ section on how to resolve this. Choose

1505, 2020

Microsoft Teams vs Zoom – Which is Better for Your Business?

By |May 15th, 2020|Categories: Uncategorized|

With companies working remotely and people around the world trying to keep in touch with family and friends during these uncertain times, demands for tools such as Microsoft Teams and Zoom are at an all-time high. These tools allow users to attend virtual meetings, message other users and groups, and even host and share files for work collaboration. There are a few differences between Microsoft Teams and Zoom, though, so which one should you choose? Which one is right for you and your business? Features: At a high level, both Microsoft Teams and Zoom offer similar features. Let’s dive into some of the them that set each of the two apart. Microsoft Teams is an all-in-one workstream collaboration service

1005, 2020

MySQL Load balancing

By |May 10th, 2020|Categories: Database|

MySQL load balancing Load balancing is essential when 1 database cannot sufficiently process the requests and we want to distribute the load across multiple databases that are part of group replication. MySQL on Azure VMs This option falls into the industry category of IaaS. With this service, you can run MySQL Server inside a fully managed virtual machine on the Azure cloud platform. The load balancing and high availability must be designed and maintained by us. Enable group replication. Assume - member 1 =IP1 and member 2=IP2 Changes to the config file: [mysqld]# General replication settingsgtid_mode = ONenforce_gtid_consistency = ONmaster_info_repository = TABLE relay_log_info_repository = TABLE binlog_checksum = NONE log_slave_updates = ON log_bin = binlog binlog_format

1005, 2020

HA in Azure DB

By |May 10th, 2020|Categories: Database, High Availability|

High availability in Azure databases Azure has multiple database services for different user scenarios. Each of them has a unique architecture and follows different storage and retrieval mechanism. Let’s go through each of these options and see how high availability is achieved. Azure SQL DB Basic, Standard, and General Purpose Premium and Business Critical service tier availability Hyperscale service tier availability The stateless compute and stateful storage layers are present separately. The compute layer has the sqlserver.exe The data/storage layer has the actual data (.mdf/.ldf files) stored in Azure BLOB storage. Since the data is present in Azure BLOB storage, it follows the same redundancy and availability policy of BLOB storage (i.e.

102, 2020

Overview Of Function as a Service (FaaS)

By |February 1st, 2020|Categories: Azure, Design|

In this post, we are going to look at the overview of Function as a Service, a concept of serverless computing. One of the key services provided by cloud computing is Function as a Service (FaaS). Cloud computing is an on-demand availability of data storage, servers, databases, networking, and other computer system resources without human intervention. These services are provided to customers through the internet. As the resources are not tightly coupled and communication between different components happens over the network, hence network latencies and network reliability play a key role. Cloud computing provides high availability, elasticity, performance and ease of use. It follows a distributed architecture and helps customers build a highly available and reliable solution that can

102, 2020

Microsoft Azure FarmBeats

By |February 1st, 2020|Categories: Agriculture, Azure, Azure Networking, IoT, Machine Learning|

To be predictable, precise and to align our actions with insights gathered from agricultural data, we have Microsoft Azure FarmBeats. Microsoft FarmBeats is a data-driven solution for agriculture. It combines the benefit of AI and the Internet of Things (IoT) to provide customized data based on geographic location by leveraging the cloud computing benefit of Microsoft Azure. FarmBeats allows farmers to build digital agricultural solutions. This digital solution needs lots of input data for providing a good agricultural solution. Some of the key data come by analyzing the key driving factors of productivity in farming like soil type, soil moisture, wind speed, wind direction, temperature, rainfall, atmospheric pressure, and sunlight. These data need to be collected and sent to

1401, 2020

Understanding Azure Policy

By |January 14th, 2020|Categories: Azure, Governance|

Azure Policy is a service in Azure which has been designed to help you to enforce different rules and to act based on the rule effect on your Azure resources. It ensures that your azure resource stay compliant with the corporate standards and Service Level Agreement. Azure policy evaluates your resources for non-compliance with assigned policies and perform the assigned effect.  For example, you can have a policy to allow only managed disk should be created in Prod environment. Once this policy is implemented, new and existing resources are evaluated for compliance. With the right type of policy, existing resources can be brought into compliance. There are multiple built-in policies and, we can create our own custom policies. Later

2012, 2019

Azure Enterprise Usage API

By |December 20th, 2019|Categories: Azure Enterprise API|Tags: , , |

As an Azure Enterprise customer, you get to see our entire organizations billing data at ea.azure.com. One can log into the portal and after selecting the appropriate enrollment number, view the billing summary information across months and also download detailed usage report. The detailed usage report is really detailed to the level of individual billing records for each resource. One can see the cost data in portal.azure.com also, but this is limited to the subscriptions one has access to and also one really needs to look at each subscription individually. For our work we were extracting the usage data from the EA portal, using the usage API as described on this page. There are multiple different formats of

1912, 2019

Azure EA Price API

By |December 19th, 2019|Categories: API Management, Azure Enterprise API, Governance|Tags: , , |

If you are an Enterprise Azure customer, then it is likely that you are using the Enterprise APIs as well. We have been using them for past many months. Recently we had a need to use the following price sheet API https://consumption.azure.com/v3/enrollments/{enrollmentNumber}/billingPeriods/{billingPeriod}/pricesheet To our surprise the API returns duplicate records so if the price sheet is to have 1000 records, we were getting back 2000. This can be easily be verified by downloading the Price Sheet XLS from the 'Download Reports' section of the portal. Interestingly the v2 version of the API works fine. We are working with Microsoft to get this addressed. If you are facing similar issues, please stand by. We will shortly update all about the

612, 2019

How AzCOP Fits in Microsoft’s Cloud Adoption Framework

By |December 6th, 2019|Categories: Azure, Datacenter Migration, Governance|

Overview: Cloud Adoption Framework and Governance With the advent of the Cloud, businesses have been steadily moving infrastructure and applications from on-premise datacenters to the Cloud. There is a myriad of reasons to move to the cloud - from liability, cost savings, and scaling, but with cloud migration comes a much-needed change of mindset. Businesses must harness a more flexible mindset in their approach to leverage the benefits Cloud has to offer. Microsoft has created the Cloud Adoption Framework to help businesses more easily migrate to the cloud. What is the Cloud Adoption Framework (CAF)? Microsoft’s CAF is a mixture of guidelines, tools, and best practices to make it easier to move to the cloud. Its key steps are