Oh wait, I've read the entire thing now. Yes, it's that time of the year again π
Oh wait, I've read the entire thing now. Yes, it's that time of the year again π
Nope, we change on the 29th of March.
Iβm Not Gonna Waste Time Debunking Crap onΒ LinkedIn.
LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting inβ¦
There are so many of these crap posts nowadays in my feed. "SQL Logical query order" "Why you should use CTEs" "How to remove duplicate rows" and so on. @drsql.bsky.social has apparently the patience of an angel to comment on them to point out mistakes :)
New blog post: #Azure Data Factory Pipeline Debugging Fails with #BadRequest β The Sequel sqlkover.com/adf-pipeline...
New article: Whatβs New in #SSIS2025? (TL;DR not much :)
www.mssqltips.com/sqlservertip... #ssis #sqlserver
What's the point of having a database if the data can't go out? π€ͺ
#MicrosoftFabric community down?
New blog post:
How to Parameterize #MicrosoftFabric Linked Services in #Azure Data Factory for #AzureDevops Deployment sqlkover.com/how-to-param...
Ooo take care. I had kidney stones and I do wish them upon my worst enemies π
It might be my background as an SSIS developer, but I like the clicky-draggy-droppy development in the browser :D
It's not permissions, as it works perfectly fine if I define the git integration manually. The git integration is obviously only for the development environment. ADF code is pushed to the other envs using ARM.
Devops.I specified a custom collaboration branch (adf_main), publish branch is adf_publish, root folder is /adf. All through bicep. When I disconnect to git integration and re-connect, it does work.
I get this nasty error in #Azure Data Factory. Any ideas?
Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.
Article + video available!
#powerbi #dax
https://www.sqlbi.com/articles/debugging-dax-variables-using-tojson-and-tocsv/
New article: Develop #SSIS Packages with #sqlserver2025 www.mssqltips.com/sqlservertip... > another SSIS article in my series :)
I did some testing with data clustering in the #MicrosoftFabric warehouse and damn, that database is quite fast on an F2.
Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell
Introduction If you have been following this blog for a while, you will know that I am a huge fan of using PowerShell to manage and automate things. SQL Server, dbatools, dbachecks β auto
blog.robsewell.com/blog/introdu...
Two questions:
1. Can you also use it for Power BI Pro stuff? (I assume yes)
2. If used in Azure Devops, can I use it with a service connection with federated identity, and don't have the need for a secret that expires?
So. Annoying.
Blog alert!
I've revisited my loadtests in Fabric and wrote them down. Enjoy!
#MicrosoftFabric
#LoadTesting
#Lakehouse
#Warehouse
#Eventhouse
#FabricSQL
Strong Snowflake knowledge required, so cutting edge technology indeed ;)
Recruiter: We have an exciting opportunity for you. 5 days per week in the office.
Me: ...
OK, the query insights table in #MicrosoftFabric warehouse is amazing. I wish we had something as user-friendly in #SQLServer itself.
I think I broke #PowerBI. The relationships are going AWOL.
What? An article about #SSIS? Yessir! SSIS 2025 Download, Install and Configure www.mssqltips.com/sqlservertip... #sqlserver2025
ah yes I did notice that. Thanks!
Any feedback?