How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-03 (first published: 2022-09-29)
41 reads
Koen Verbeeck
- Website: https://sqlkover.com/
Power BI Desktop overwrites Authentication Settings in Similar Connections
Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL database, but with different SQL users (they have both...
2022-09-28 (first published: 2022-09-13)
144 reads
Speaking Engagements for Fall 2022
The summer holiday is almost over, and this means conference season will be back in full swing again. I’ll be speaking at a couple of events in the second...
2022-08-23
8 reads
Cool Stuff in SQL Server 2022 – IS DISTINCT FROM
I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was...
2022-08-17 (first published: 2022-08-04)
1,111 reads
Free Webinar – T-SQL Best Practices and Tuning for the BI/DWH Developer
I’m giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract: When building a data warehouse (DWH) in the Microsoft Data Platform stack, you typically have...
2022-08-02
20 reads
SharePoint List only returns 100 items in Azure Logic App
I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog...
2022-07-15 (first published: 2022-06-27)
102 reads
Power BI Field Parameters and Slowly Changing Dimensions
Power BI field parameters are a new feature in Power BI Desktop, and it’s one of the best of the past months. In short, Power BI field parameters allow...
2022-06-17
92 reads
Speaking at dataMinds Connect 2022
I’m very excited to announce I’ll be giving a session at the 15th edition of dataMinds Connect (in the beginning it was called SQL Server Day(s)). It will be...
2022-06-17 (first published: 2022-06-16)
11 reads
How you can save up to 80% on Azure Data Factory pricing
… with this one weird little trick 🙂 Sorry for the clickbait, but you can actually save a lot on ADF pricing if you design your pipelines carefully. And...
2022-06-01 (first published: 2022-05-11)
606 reads
Logic Apps and Source Control (with PowerShell)
At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
253 reads
Blogs
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Forums
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Referencing a SQLCMD variable in a Post Deployment script using SqlPackage
Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...
Calling stored procedure to bulk import from SSIS causes access denied
Hi, I'm working on building a data validation engine, which is supposed to check...
Ask SSC