Mark Verbaas

My adventures in IT.

Posts by Tag

Microsoft

Three is a charm

1 minute read

Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!

View column definition

3 minute read

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

2 minute read

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.

Check constraint is changed on creation

2 minute read

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...

Back to Top ↑

Development

Azure Data Factory column mapping

2 minute read

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.

Azure DevOps pipeline variable template

4 minute read

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...

Linting markdown

2 minute read

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

1 minute read

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

2 minute read

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...

Check constraint is changed on creation

2 minute read

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...

Back to Top ↑

Azure

Three is a charm

1 minute read

Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!

Implicit vs Explicit transactions

2 minute read

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.

Back to Top ↑

T-SQL

ServerName

2 minute read

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...

View column definition

3 minute read

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

2 minute read

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.

Check constraint is changed on creation

2 minute read

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...

Back to Top ↑

VSCode

Winget

4 minute read

Here a very small item for my own convenience, but I hope it is helpful to others too.

PowerShell Module Build in Dev Container

4 minute read

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...

PowerShell Module Build

5 minute read

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 1.68 Git Improvements

2 minute read

Recently Microsoft has released Visual Studio Code 1.68, and somethings in the release notes caught my eye:

Back to Top ↑

Coding

ServerName

2 minute read

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

4 minute read

Here a very small item for my own convenience, but I hope it is helpful to others too.

PowerShell Module Build in Dev Container

4 minute read

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...

PowerShell Module Build

5 minute read

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...

Back to Top ↑

Certification

Three is a charm

1 minute read

Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!

Back to Top ↑

SQL

View column definition

3 minute read

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

2 minute read

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.

Check constraint is changed on creation

2 minute read

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...

Back to Top ↑

Azure DevOps

Azure DevOps pipeline variable template

4 minute read

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...

Linting markdown

2 minute read

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

1 minute read

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...

Azure DevOps Pull Request Suggestions

1 minute read

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...

Back to Top ↑

PowerShell

Winget

4 minute read

Here a very small item for my own convenience, but I hope it is helpful to others too.

PowerShell Module Build in Dev Container

4 minute read

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...

PowerShell Module Build

5 minute read

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...

Back to Top ↑

DP-900

Back to Top ↑

Data

Back to Top ↑

Azure Data Factory

Azure Data Factory column mapping

2 minute read

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.

Back to Top ↑

Data Flows

Azure Data Factory column mapping

2 minute read

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.

Back to Top ↑

Copy Activity

Azure Data Factory column mapping

2 minute read

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.

Back to Top ↑

DP-300

Back to Top ↑

DACPAC

Check constraint is changed on creation

2 minute read

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...

Back to Top ↑

T-SQL Tuesday

Back to Top ↑

Pull Requests

Azure DevOps Pull Request Suggestions

1 minute read

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...

Back to Top ↑

git

VS Code 1.68 Git Improvements

2 minute read

Recently Microsoft has released Visual Studio Code 1.68, and somethings in the release notes caught my eye:

Back to Top ↑

branch

VS Code 1.68 Git Improvements

2 minute read

Recently Microsoft has released Visual Studio Code 1.68, and somethings in the release notes caught my eye:

Back to Top ↑

improvements

VS Code 1.68 Git Improvements

2 minute read

Recently Microsoft has released Visual Studio Code 1.68, and somethings in the release notes caught my eye:

Back to Top ↑

ScriptAnalyzer

Back to Top ↑

Static Analysis

Back to Top ↑

Build

PowerShell Module Build

5 minute read

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...

Back to Top ↑

Docker

PowerShell Module Build in Dev Container

4 minute read

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...

Back to Top ↑

Winget

Winget

4 minute read

Here a very small item for my own convenience, but I hope it is helpful to others too.

Back to Top ↑

SQL Server

ServerName

2 minute read

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...

Back to Top ↑

AZ-900

Three is a charm

1 minute read

Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!

Back to Top ↑

Fundamentals

Three is a charm

1 minute read

Today I passed my third exam in a row. I’m now Azure Fundamentals Certified!

Back to Top ↑

Database

Including tSQLt framework

2 minute read

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...

Back to Top ↑

tSQLt

Including tSQLt framework

2 minute read

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...

Back to Top ↑

Bicep

Bicep unique deployments

1 minute read

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...

Back to Top ↑

IaC

Bicep unique deployments

1 minute read

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...

Back to Top ↑

Infrastructure

Bicep unique deployments

1 minute read

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...

Back to Top ↑

markdown

Linting markdown

2 minute read

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...

Back to Top ↑

linting

Linting markdown

2 minute read

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...

Back to Top ↑

variables

Azure DevOps pipeline variable template

4 minute read

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...

Back to Top ↑

yaml

Azure DevOps pipeline variable template

4 minute read

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...

Back to Top ↑

Mapping

Azure Data Factory column mapping

2 minute read

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.

Back to Top ↑