Azure
Always Encrypted feature in SQL Server
Category: Azure,Azure SQL,Encryption,SQL,SQL Server Author: Nishant Rana Date: 4 weeks ago Comments: 0

Always Encrypted is used for encryption at the column level rather than the entire database. It provides both data at rest as well in memory (in flight). It is different from column (cell-level) and Transparent Data Encryption (TDE) which uses keys and certificates, which are stored in the database. In the case of Always Encrypted, … Continue reading “Always Encrypted feature in SQL Server”
Source: Nishant Rana


Dynamic Data Masking (DDM) in SQL Server
Category: Azure,Azure SQL,DDM,Masking,SQL,SQL Server Author: Nishant Rana Date: 4 weeks ago Comments: 0

Through the Dynamic Data Masking feature in SQL Server, we can hide the sensitive data by masking the data from the user who does not have permissions. (Here the data in the database is not changed). There are 4 different functions to do that – default – Entire column is masked. partial – only works … Continue reading “Dynamic Data Masking (DDM) in SQL Server”
Source: Nishant Rana


Azure Architecture and Management – Introduction
Category: Azure Author: Nishant Rana Date: 1 month ago Comments: 0

Below are few key points on Azure architecture and management Check availability of Azure products region-wise https://azure.microsoft.com/en-us/global-infrastructure/services/ Below we have filtered it to see products available in UAE We can also filter it further if we are looking for a specific product or service. We can refer to the Data residency document to see where … Continue reading “Azure Architecture and Management – Introduction”
Source: Nishant Rana


Microsoft Azure / Cloud Computing – Introduction
Category: Azure Author: Nishant Rana Date: 1 month ago Comments: 0

Cloud Computing enables companies to consume a complete resource – such as virtual machine, storage, or an application as a utility – just like electricity – rather than having to build and maintain computing infrastructure in-house. Cloud provider provides the cloud infrastructure which is shared across multiple clients. Clients can select which service to use … Continue reading “Microsoft Azure / Cloud Computing – Introduction”
Source: Nishant Rana


Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)
Category: Azure,Azure Data Factory,Dynamics 365,kingswaysoft,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 2 months ago Comments: 0

In the previous post, we saw how to deploy and run SSIS packages on the cloud. Here we take it one step further and will deploy and run the SSIS packages that use KingswaySoft’ s SSIS Integration Toolkit components. Here we will need an Azure Subscription, where we will host the SSISDB, followed by provisioning … Continue reading “Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)”
Source: Nishant Rana


Deploy and run SSIS package in Azure Data Factory
Category: Azure,Azure Data Factory,Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 2 months ago Comments: 0

Before the SSIS package can be deployed to Azure Data Factory we need to provision Azure-SQL Server Integration Service (SSIS) runtime (IR) in Azure Data Factory. In the previous posts, we had created an Azure data factory instance had used Azure SQL Database as the source. Within Azure Data Factory in the Let’s get started … Continue reading “Deploy and run SSIS package in Azure Data Factory”
Source: Nishant Rana


Use Azure Data Factory V2 to load data into Dynamics 365
Category: Azure,Azure Data Factory,Dynamics 365,Microsoft Dynamics 365 Author: Nishant Rana Date: 2 months ago Comments: 0

Let us take a simple example where we will set up an Azure Data Factory instance and use Copy data activity to move data from the Azure SQL database to Dynamics 365. Login to Azure Portal. https://portal.azure.com Search for Data factories Create a new data factory instance Once the deployment is successful, click on Go … Continue reading “Use Azure Data Factory V2 to load data into Dynamics 365”
Source: Nishant Rana


1 2 3