Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
610 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
610 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
746 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,707 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,228 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
466 reads
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
626 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,414 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
793 reads
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
461 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers