Tag Archives: SQL Server

Overview of Data Migration Assistant (DMA)

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility

11
Oct
An Introduction to ApexSQL Complete – Integration with SSMS

We all know that the idea of add-ins is to make our lives easier. In

09
Dec
A Cost Comparison between PaaS and IaaS Cloud Architectures

Introduction This aim of this blog is to do a cost comparison between two cloud

20
Nov
Extract, Transform & Load REST API responses in Azure SQLDB – Part 2 Data Extraction

Data Extraction Objectives Provision Azure resources based on our reference architecture diagram. Create and configure

3 Comments

06
Nov
Modern Data Warehouse Solution in a Week

In this blog, we attempt to create an Azure data warehouse solution in a week.

21
Feb
Direct Query vs. Live Connection in Power BI – Part 1

There are lots articles out there that compare Import Mode vs.Direct Query, but people rarely

18
Jul
Optimising Lookups with Caching

One of, if not the most, used transformations in SQL Server Integration Services (SSIS) must

12
Apr
Introduction to Azure Key Vault for SQL Server

What is it Azure Key Vault is a feature available in Microsoft Azure which can

22
Nov
Managing msdb in SQL Server

In the world of BI, the SQL Server system databases (with the exception of tembdb)

28
Oct
Introduction to Dynamic Data Masking

What is it SQL Server Dynamic Data Masking is a new feature which has been

06
Jul