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)
246 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)
716 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)
451 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,823 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
20 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,898 reads
In case you aren’t familiar, I would like to introduce you to the violin plot.
A violin plot is a...
2019-03-05 (first published: 2019-02-14)
2,821 reads
As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...
2019-02-28
30 reads
It’s not always obvious when you need a data gateway in Azure, and not all gateways are labeled as such....
2019-02-07
856 reads
I’m honored to have one of my PASS Summit sessions chosen to be part of the PASS Data Expert Series...
2019-02-06
137 reads
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
After an upgrade, sql server stopped sending emails. Problem is not solved but during...
Hi, We use office 365, and just recently received an email from them saying...
T has 57,000 distinct rows Z has over a million. I did row over...
Ask SSC