<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">
bg-img11.jpg

Stay Up-to-Date on All Things SQL Server, Business Intelligence and Cloud

Power BI Dataflows vs Shared Datasets

Now that Power BI has released dataflows and with the ability to share datasets across reports in Power BI, we’ve been...

Creating New Azure Data Factory Data Flow File Data Sets

Are you looking to reuse file connections you have set up in Azure Data Factory prior to using Data Flows? Maybe you have a...

Disaster Recovery in Azure SQL Data Warehouse

What is your disaster recovery plan for your Azure SQL Data Warehouse? Today I’d like to talk about disaster recovery in...

Visual Studio 2019 BI Design Tool Extensions

As you may know, Microsoft recently released Visual Studio 2019. Today I want to talk about how to install the Business...

Comparing Azure SQL Data Warehouse to the Competition

Interested in learning how Azure SQL Data Warehouse compares to the competition? Today I’d like to share some research...

Easily Load Free Sample Data for Azure SQL Data Warehouse

Today I’d like to share a great resource that I found when setting up a demonstration of Azure SQL Data Warehouse. It’s a...

How Azure SQL Data Warehouse Gen2 Achieves Higher Performance

Looking for faster query performance? A while back, Microsoft introduced Azure SQL Data Warehouse Gen2 with five times the...

Using Stored Procedure in Azure Data Factory

In recent posts I’ve been focusing on Azure Data Factory. Today I’d like to talk about using a Stored Procedure as a sink or...

Azure Data Factory Event Triggers

If you’re still triggering your ETL processes on a schedule (maybe once an hour or at a set time each night), I want to...

Azure Data Factory Pipeline Templates

If you’re new to Azure Data Factory and unsure what you can do with it, I want to tell you about a new option within Data...

Database Properties in Visual Studio Database Projects

Do you work in Visual Studio for development of SQL Server databases? At Pragmatic Works, we’re big fans using SQL Server...

What is Microsoft Graph?

In today’s post, I’d like to introduce you to Microsoft Graph. Microsoft Graph is an API that you can use to connect to...

The Difference Between Elastic Pools and Elastic Queries

Do you get elastic pools and elastic queries confused within Azure SQL Database? Many people do, probably because of the...

Using Databricks in Azure Data Factory for ETL

A common discussion we’ve had lately is about using Azure Databricks within Azure Data Factory for ETL.

ETL in Power BI with Dataflow

In this post, I want to tell you about a feature of Power BI that is in preview called Dataflow and how we can use that to...

Using ORC, Parquet and Avro Files in Azure Data Lake

In today’s post I’d like to review some information about using ORC, Parquet and Avro files in Azure Data Lake, in...

Intro to Azure Data Lake Store Gen 2

I’m excited to tell you more about the preview of the second generation of Azure Data Lake Store. One reason I’m excited...

bg-img14.jpg

Join Our Blog

Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles