Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,717 reads
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,717 reads
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
607 reads
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
744 reads
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...
2016-10-21 (first published: 2016-10-14)
4,583 reads
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,076 reads
This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...
2016-09-21
458 reads
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
620 reads
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,394 reads
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,130 reads
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
789 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers