Developing Azure DevOps Extension

Total: 3 Average: 5

Introduction

Azure DevOps Services provides a lot of space for importing your custom extension. Work items, pipeline tasks, dashboard widgets, and other options can serve this purpose.

This article will be about developing extensions for pipeline tasks – I will describe how to create the easiest sample extension that will help organize your own continuous integration.

But first, let’s describe the whole process of hosting the extension on Azure DevOps and how it works. Then we will discuss its detailed development route. Read More

How to install SQL Server vNext and Azure data studio on Ubuntu 18.04

Total: 1 Average: 5

Azure data studio is a cross-platform database management tool. This tool is used to connect, configure, and administrate SQL Server instances installed locally or in the cloud. This tool can be installed on the following operating systems:

  1. Microsoft Windows
  2. Linux
    • Redgate
    • Debian
    • Ubuntu
  3. macOS

Initially, Microsoft introduced this tool as the “SQL Server operations studio.” Later they renamed it Azure Data Studio. You can get more information about it here.

In this article, I am going to explain the step-by-step installation process of SQL Server 2017 and Azure data studio on Ubuntu. I have divided the article into two parts. Firstly, we will install SQL Server 2017, and later I will explain the process of installing Azure Data Studio. For demonstration purposes, I have created a virtual machine and installed Ubuntu 18.04 on it. You can download Ubuntu here. Read More

Applying SQL Transformations and Handling Missing Values in Azure ML

Total: 1 Average: 5

In this article, we will introduce SQL transformations in action. We will also see how to handle missing values in our dataset.

Consider a scenario of a movie rating dataset containing records of different movies along with the average user ratings associated with each movie. The ratings are in numeric form ranging from 1 to 10 with 1 as the lowest rating and, respectively, 10 as the highest rating (though no movie in the history has achieved 10 rating:). Suppose that we want to convert the numeric ratings into categorical ratings. For instance, we want to replace ratings of 1-3 with the categorical value “poor”, of 4-6 with “average” while ratings of 7-10 will have the value “good”. We can accomplish it with SQL transformation in Azure ML Studio. Read More

Microsoft Azure Vs Amazon Web Services: What’s your Ultimate Choice?

Total: 1 Average: 5

Have you heard the term cloud computing? Do you wish to try your hands on cloud platforms? Well, if you seem to be a newbie to this new world of cloud computing, then set back as we are going to discuss the cloud platforms that are beneficial for generating more business. It’s vital for an individual to get themselves familiarize with different leading cloud service providers before selecting the best cloud network to begin their business or career with cloud computing.

Read More

Microsoft Graph or Azure Active Directory Graph API: Which is better?

Total: 1 Average: 4

Are you a .NET developer who is stuck in great confusion when it comes to choosing Azure Active Directory or Microsoft Graph?

We all have look at those multiple posts on which you can choose for better web development. In this article, we will be providing some guidance along with a bit of roadmap to clarify things for all of the existing and new developers who want to access directory-based features. Let us begin. Read More

How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio

Total: 28 Average: 4.2

Before deploying your application into production, doing a performance load test is imperative for measuring future performance and ensure that your application is production-ready.

Testing is essential for every application to make sure that any application works and performs according to the desired requirements. During the application testing process, we can attempt and find out if any imperfections are remaining in the application. There are numerous sorts of testing like functional testing, unit testing, acceptance testing, and integration testing. We compose Functional and UI tests to see whether the application is working as per the requirements. Read More

Migrating SQL Server Database to Azure SQL (PaaS)

Total: 9 Average: 4.4

In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS).  You can find different approaches for this migration process because SQL Server offers different types of tools and features for this migration. Some of these are:

These migration approaches have some pros and cons. But if you ask my opinion, Data Migration Assistant is better than others because, in this migration process, you will face fewer migration problems or issues. Data Migration Assistant will be more helpful to handle these issues.

In this article, we will specifically mention Database Migration Assistant, also known as DMA. At the same time, we will make a small demo of SQL Server Management Studio Deployment Wizard.

Read More

Azure Cosmos DB Analysis

Total: 4 Average: 3.3

Azure Cosmos DB is the first globally distributed, multi-model database service for building world-scale applications. Over the years, it has been providing momentum for Microsoft’s Internet-scale services, which are now available to all Azure developers. The service is designed to allow customers to flexibly and horizontally scale throughput and storage across any number of geographic regions. Read More

Choosing Azure SQL Purchase Model and Service Tier

Total: 7 Average: 3.9

When we are beginning to think of migrating our on-premises databases to Azure SQL, we have to decide on a proper purchase model, a service tier, and a performance level. Before starting the Azure SQL migration process, we have to find logical and provable answers to the following questions:

  • Which purchase model is suitable for my apps and business requirements?
  • How much budget do I need?
  • Which performance level meets my requirements?
  • Can I achieve the acceptable performance of my apps?

Read More

Configuring Azure SQL Long-term Backup Retention

Total: 5 Average: 3.4

Backup is the most important case for database administration because it provides business continuity solutions for high availability and disaster recovery. For this reason, Azure SQL database (PaaS: platform as a service) can make a backup automatically and restore it at a point in time. However, the retention period of backup files changes according to the service tiers.

Read More