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)
191 reads
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
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,228 reads
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
34 reads
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)
108 reads
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
123 reads
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)
14 reads
… 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)
661 reads
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)
317 reads
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
21 reads
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Hello, Getting an error only on occassion running a SQL Elastic job. From jobs.job_Executions:...
Hello, I have an Elastic Job that runs every 2 hours. Without going into...
Hello, I have an Elastic Job that runs every 2 hours. Without going into...
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers