Dinesh Asanka

Elastic Jobs in Azure SQL Database

February 18, 2021 by

Introduction

I have dedicated this article to the topic of Elastic Jobs in Azure SQL Database which is in Public Review. This feature allows you to run scheduled tasks in your Azure SQL Databases. This is similar to SQL Server Agent you have in the On-prem SQL Server versions. However, in Elastic Jobs, you can execute the scheduled tasks in multiple Azure SQL Servers and multiple Databases which is an added advantage when considering the features of SQL Server Agent. Further, this execution performs parallelly.

Read more »
Aveek Das
Stored Procedure for moving data

Advanced usages of Data-Tier applications

February 12, 2021 by

In this article, I am going to explain some of the advanced usages of data-tier applications in Visual Studio. In my previous article, Working with Database Projects, I have explained how you can start building your database applications for SQL Server and Azure SQL Database using Visual Studio. This article will specifically focus on using SQLCMD variables and Publish Profiles of the Data-Tier Application development. For a better understanding, I would recommend reading the previous article and it will help to clear the basic concepts.

Read more »
Nisarg Upadhyay
Drag and drop Backup database task

Automate SQL database backups using Maintenance Plans

February 12, 2021 by

In this article, we are going to learn how we can automate the backup of the SQL database using database maintenance plans. Data is one of the most important assets of any organization, and as a database administrator, it is our prime responsibility to protect it. There are various tools available that can be used to back up the data. These tools use state of the art technology to protect the data, and some of them are very costly. Instead of using these costly tools, some organizations prefer to use SQL native backups. These backups of SQL database can be automated by SQL Server Agent Jobs or Windows’ task scheduler.

Read more »
Aveek Das
PEP Workflow - Programming in Python

Best practices to follow while programming in Python

February 9, 2021 by

In this article, I am going to discuss some of the best practices that a programmer must follow while programming in python. Python as a language has evolved to a great extent over the last few decades and has gained popularity amongst a lot of software programmers, data enthusiasts, and system administrators. This is because of the ease of writing code in python and the large community behind it.

Read more »
Nisarg Upadhyay
MySQL logs are enable

Learn MySQL: An overview of MySQL Binary Logs

February 9, 2021 by

In this article, we are going to learn about the concept of MySQL Binary Logs and their architecture. I am covering the following details in this article:

  1. An overview of MySQL binary logs and their architecture
  2. How to enable and disable binary logging
  3. View and change the location of the binary logs
Read more »
Esat Erkec
Making practice is always important to learn SQL

Getting started with SQL Programming

February 3, 2021 by

Learning SQL programming is valuable for our career and might help to increase our incomes but most importantly it will be the best investment you will make for yourself. However, beginners don’t know the exact starting point to begin learning the SQL language. Learning SQL depends entirely on your effort and desire, and other things are just details. This article will give some tips on how to learn SQL without going into technical details so that so you can get started in learning SQL right now.

Read more »
Aveek Das
Cloud Market Google Trend

Understanding AWS Billing services and concepts

February 3, 2021 by

In this article, I am going to explain AWS Billing services and the underlying concepts that one should be aware of while working with AWS. As you know, more and more companies are taking the essential step to migrate their existing applications to the cloud, it has become important for engineers to keep up the pace and learn the technologies of the cloud. In today’s market, AWS and Azure are two of the major cloud providers which are being used mostly. Also, Google Cloud Platform (GCP) is becoming popular, however, the demand for AWS is the highest.

Read more »
Dinesh Asanka
Default Data Masking Option Azure SQL.

Dynamic Data Masking in SQL Server

February 2, 2021 by

Introduction

In this article, we will be looking at how to perform and access Dynamic Data Masking in SQL Server. Data Masking is the process of hiding data with different rules. One of the main reasons to apply data masking is to protect Personal Identifiable Information (PII) and sensitive data from unauthorized access. Even when unauthorized users access these data, they will not be able to view the actual values. This article will look at the possibilities of applying Dynamic Data Masking in SQL Server and we will look at how Dynamic Data masking can be applied to the Azure SQL Databases as well.

Read more »