I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating...
2019-12-19 (first published: 2019-12-05)
474 reads
DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for teaching technical concepts, delivering sales and marketing presentations, and more. One thing I love about...
2019-10-28 (first published: 2019-10-16)
750 reads
I’m happy to be speaking at Microsoft Ignite this year. I have an unconference session and a regular session, both focused on accessibility in the Power Platform. The regular...
2019-10-09
25 reads
We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I...
2019-10-08 (first published: 2019-09-26)
503 reads
Yesterday, some new views were made available in the Azure portal that will be helpful to those of us who create or manage Azure SQL resources. First, a new...
2019-09-03 (first published: 2019-08-22)
279 reads
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)
211 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,031 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)
563 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
700 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)
274 reads
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
How to update status with conflict data where chemical temp table have same chemical...
I'm reading file from BLOB through ADF and I would like to pass the...
Hi. I'm working through the official exam reference book for 70-764 by Isakov and...
Ask SSC