A feature of Azure SQL Data Warehouse is the ability to scale (and pay for) compute resources as needed. This is...
Tips for Migrating Data Warehouse Workloads to Azure
Do you want to learn how to migrate your workloads to Azure? In a recent webinar, Practice Manager and BI Architect, Bob...
Best Practice for Your Power BI Data Sources
We all know there are lots of data sources; flat files like Excel files, CSVs that you import from another data source,...
On-premise vs Cloud Modern Data Warehouse - Which is Right for You?
Many people ask the question, which is right for my company, on-premise or cloud modern data warehouse? In a recent webinar,...
Do I Need a Star Schema?
As we’re building a data warehouse for clients, sometimes we’re asked about the need to build a star schema. With all the great...
Azure Data Lake vs Azure Blob Storage in Data Warehousing
In today’s post I’ll look at some considerations for choosing to use Azure Blob Storage or Azure Data Lake Store when...
5 Components of a Data Strategy
Businesses run on data – and the best organizations have a strong data strategy in place. We have consistent conversations with...
Do You Need a Relational Data Warehouse?
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come about that are...
Azure Data Warehouse and 60 Servers
In today’s segment of Azure Every Day, I’d like to talk about Azure Data Warehouse and to help you understand some of the...
Diffusing BI Time Bombs with Azure
In this Azure Every Day installment, I’d like to tell you how you can diffuse some time bombs that exist in your BI and Data...
What Should I Move to the Cloud?
There are many organizations like yours that are trying to figure out how to take that first step into the cloud this year....
SQL Data Warehouse - External Tables
Are you interested in learning how to load external files into SQL Data Warehouse? In a recent webinar taught by Pragmatic...
Arrange, Act, Assert - The Strategy for BI and Data Warehouse Testing
Are you incorporating BI and data warehouse testing into your data world? If not, it’s time to give this more thought. The...
How to Implement Successful BI Solutions
Maybe you’re in the process of creating a BI, data warehouse or data platform solution for your business. Or maybe you’ve hit a...
Walk Around and Be Nosy
Many years ago when I was a team lead in a Finance IT shop I got into the habit of walking around to check on my clients. I...
Patterns and Practices: Creating a Date Table
There may be a time when you will need to create a table containing a series of dates. Perhaps you want a date table for a data...
Azure ML, SSIS and the Modern Data Warehouse
Recently I was afforded the opportunity to speak at several different events, all of which I thoroughly enjoyed. I was able to...
What is a Modern Data Warehouse?
As I was honored enough to be selected to give a PreCon on the Internals of the Modern Data Warehouse at SQLSaturday Huntington...
Leave a comment