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)
215 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
23 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,249 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
59 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)
117 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
133 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)
30 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)
675 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)
335 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
26 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers