Azure Data Factory column mapping
This is a follow up to my earlier post. It goes into the mapping issue that I encountered when using a newly created linked service.
Posts by Year
2024
Azure Data Factory data flow to copy activity
Recently I worked on a fun and challenging task to replace data flows in our Azure Data Factory (ADF) pipeline(s) with copy activities.
Azure DevOps pipeline variable template
This post is about using pipeline variables by using a yml file, knows as a variable template. This is a third method of using variables besides inline or va...
2023
Linting markdown
Recently I was reviewing a pull request from a co-worker and I noticed that the markdown documents included were violating the markdown rules. Me, being a fa...
Bicep unique deployments
This is just a short post to document some knowledge that I gained this week, and I don’t want to loose. Maybe someone else on the big bad Internet will also...
Including tSQLt framework
In this post I want to go over a small improvement which I learned recently. This includes creating a reference to a dacpac instead of including all the code...
Three is a charm
Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!
2022
Microsoft Certified: Azure Data Engineer Associate
With some pride I can announce that Today I passed the DP203 Exam and became a Microsoft Certified Azure Data Engineer Associate!
ServerName
I often use the @@SERVERNAME function to get the ServerInstance that I’m working on in t-SQL queries. Although I have read the warnings from Microsoft many t...
Winget
Here a very small item for my own convenience, but I hope it is helpful to others too.
PowerShell Module Build in Dev Container
In my earlier post I already mentioned that a next step I want to take is to have the module run in a Dev Container. For the official documentation on what a...
Microsoft Certified: Azure Data Fundamentals
Yesterday I took and passed Exam DP-900: Microsoft Azure Data Fundamentals. ✅
PowerShell Module Build
The last couple of weeks if been playing around with creating a PowerShell module with the goal of automating a build, with the lack of fantasy I called it P...
VS Code and PSScriptAnalyzer
People that know me, know that I love following coding rules and standards.
VS Code 1.68 Git Improvements
Recently Microsoft has released Visual Studio Code 1.68, and somethings in the release notes caught my eye:
Azure DevOps Pull Request Suggestions
This week I finally found out how to do suggestions in Azure DevOps Repos Pull Requests. After using Azure DevOps for the last year and only now founding out...
2021
View column definition
This week I was discussing a pull request from my co-worker Arthur (T), and I was nitpicking on something that probably has to with personal preference of wr...
Implicit vs Explicit transactions
Recently I was reminded about a query tuning technique that I have learned some time ago. I would to share it with everyone so it can also benefit you.
T-SQL Tuesday 138: Managing Technology Changes
This is my first contribution to T-SQL Tuesday. It is about how I manage technology changes. As this is the question from this months host, Andy Leonard. Tha...
Check constraint is changed on creation
Today I performed a schema compare between my SQL Database Project and the deployed version of that project. I expected some differences because of various r...
Microsoft Certified: Azure Database Administrator Associate
Today I passed the Exam DP-300: Administering Relational Databases on Microsoft Azure to become an “Microsoft Certified: Azure Database Administrator Associa...