Bob Rubocki

PowerBIDataflowVsSharedDataset_03

Power BI, Azure Every Day, Power BI Dataflow, Power BI Datasets

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 [...]

Bob Rubocki

Bob Rubocki October 18, 2019

Choosing to Model in Power BI vs SSAS Tabular

Power BI, SSAS, Azure Every Day, Analysis Services, Tabular Models

Choosing to Model in Power BI vs SSAS Tabular

Bob Rubocki

Bob Rubocki October 9, 2019

ADFDataFlowFileSource_02

Azure Data Factory, Azure Every Day, Azure Data Factory Data Flow

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 [...]

Bob Rubocki

Bob Rubocki August 15, 2019

Disaster Recovery in Azure SQL Data Warehouse (1)

Azure, Disaster Recovery, Azure Every Day, Azure SQL Data Warehouse Gen 2, Geo-backup Policy

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 [...]

Bob Rubocki

Bob Rubocki May 9, 2019

Visual Studio 2019 BI Design Tool Extensions (1)

Azure, Azure Every Day, Visual Studio 2019

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 [...]

Bob Rubocki

Bob Rubocki April 26, 2019

AzureSQLDWvsCompetition_01

Azure, Azure Every Day, Azure SQL Data Warehouse

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 about [...]

Bob Rubocki

Bob Rubocki April 9, 2019

SampleData_02

Azure, Azure Every Day, Azure SQL Data Warehouse, PolyBase

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 [...]

Bob Rubocki

Bob Rubocki April 2, 2019

AzureSQLDWHighPerformance_02

Azure, Azure Every Day, Azure SQL Data Warehouse Gen 2

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 [...]

Bob Rubocki

Bob Rubocki March 28, 2019

StoredProcedureInADFCopy_01

Azure, Azure Data Factory, Azure Every Day, Stored Procedure

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 [...]

Bob Rubocki

Bob Rubocki March 8, 2019

Image Recognition with Azure Computer Vision API (1)

Azure, Azure Every Day, PowerApps, Azure Computer Vision API

Image Recognition with Azure Computer Vision API

Bob Rubocki

Bob Rubocki February 28, 2019

Azure Pricing Calculator

Azure, Azure Every Day, Azure Pricing Calculator

Azure Pricing Calculator

Bob Rubocki

Bob Rubocki February 27, 2019

ADFEventTriggers_02

Azure, Azure Data Factory, Azure Every Day, Azure Event Grid, Event Triggers

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 tell [...]

Bob Rubocki

Bob Rubocki February 20, 2019

5 Ways Azure Makes Your Enterprise More Secure (2)

Azure, Azure Data Factory, Azure Every Day, Pipeline Templates

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 [...]

Bob Rubocki

Bob Rubocki February 19, 2019

AzureSQLDBVersion_01

Azure, Azure Every Day, Azure SQL Database, Visual Studio

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 [...]

Bob Rubocki

Bob Rubocki February 14, 2019

MicrosoftGraph_03

Azure, Azure Every Day, Azure Active Directory, PowerApps, Microsoft Graph

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 [...]

Bob Rubocki

Bob Rubocki February 12, 2019

ElasticPoolsVsElasticQueries_04

Azure, Azure Every Day, Azure SQL Database, Elastic Query, Elastic Pool

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 [...]

Bob Rubocki

Bob Rubocki February 11, 2019

DatabricksInADF_04

ETL, Azure Data Factory, Azure Every Day, Azure Databricks, Azure Blob Storage, Azure Data Lake, Machine Learning

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.

Bob Rubocki

Bob Rubocki February 4, 2019

ETL in Power BI with Dataflow

Azure, Power BI, ETL, Azure Every Day, Power BI Dataflow

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 [...]

Bob Rubocki

Bob Rubocki December 13, 2018

Using ORC, Parquet and Avro Files in Azure Data Lake

Azure, Azure Data Factory, Azure Every Day, Azure Data Lake

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 [...]

Bob Rubocki

Bob Rubocki December 10, 2018

DataLakeGen2_01

Azure, Azure Every Day, Azure Blob Storage, Azure Data Lake Store Gen 2

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 [...]

Bob Rubocki

Bob Rubocki December 8, 2018

8860e555-b413-4feb-99b7-320c0e09f43e-removebg 1

Vector20

free events

Learn With The Nerds

A free virtual series bringing thousands of tech professionals together for a few hours covering an array of data analytics and cloud topics.

Join Now!