I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that...
2019-08-27 (first published: 2019-08-15)
245 reads
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...
2019-08-20 (first published: 2019-08-08)
1,163 reads
I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released...
2019-08-13 (first published: 2019-08-01)
810 reads
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While...
2019-07-25
809 reads
Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level....
2019-06-18 (first published: 2019-05-30)
422 reads
Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are designed...
2019-06-03 (first published: 2019-05-16)
1,402 reads
There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)....
2019-04-23 (first published: 2019-04-11)
502 reads
When you start a Power BI project, you need to decide how and where you should store the data in your dataset. There are three “traditional” options: Imported Model:...
2019-03-28
31 reads
The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...
2019-04-10 (first published: 2019-03-21)
1,873 reads
Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...
2019-03-21 (first published: 2019-03-07)
1,907 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers