Author: Peter De Lange

Extract Load Transform SQL Server

Could not create DTS.Application because of error 0x80040154

By Peter De Lange | by Peter De Lange

If you encounter the following error: Could not create DTS.Application because of error 0x80040154 From calling DTEXEC.exe. For instance like so: It could well be the case that the DTEXEC that is being called is not compatible with the database server you want to run the SSIS package on. Particularly your development environment may be susceptible to this problem. To solve this, search for all the different DTEXEC.exe versions on your machine and find the…

Continue reading

Extract Load Transform

How fast can SQL Server write to disk, and why am I not reaching those speeds? Speed test results

By Peter De Lange | by Peter De Lange

In my previous blog post I set up an experiment to figure out what is the fastest setup for SQL Server and SSIS to extract and load a file into a table. In this post I will be discussing the results of this experiment. The experiment The experiment considered a simple two step ELT process: The different variables that were tested: Total performance Taking the best performing scenario it looks like we can extract and…

Continue reading

Extract Load Transform

How fast can SQL Server write to disk, and why am I not reaching those speeds?

By Peter De Lange | by Peter De Lange

A question that regularly comes up in ETL scenarios is whether SQL Server can read and write faster if you divide your tables and indexes over multiple filegroups and your filegroups over multiple files. My standard thinking on this was always as follows: Depending on whether you can write those files to different disks or not this will be the case. In a single disk scenario it should not matter at all. I started out…

Continue reading

Uncategorized

My first experience with Ethernet over power.

By Peter De Lange | by Peter De Lange

One of the rooms in our house is a Wi-Fi dead zone and after thinking about this for some years I finally decided to buy a Powerline adapter to solve this problem. I considered several alternatives which I will discuss below. Alternative solutions for Wi-Fi dead zone The solution space for solving the Wi-Fi dead zone problem was constrained by lack of power sockets at convenient locations that would enable implementing a mesh or repeater…

Continue reading

Uncategorized

Wipe and Secure Windows 11 Machine

By Peter De Lange | by Peter De Lange

Recently I bought a new laptop which came pre installed with Windows 11. I decided to wipe the laptop and reinstall a fresh copy of Windows 11 for the following reasons: Below you can find the steps I took to wipe, install and finally secure my laptop with Windows 11 Pro Edition. Step 1: Setting up the BIOS Step 2: Creating installation media This step needs to be executed on a computer you trust. Which…

Continue reading

Team process

Onboarding new team members

By Peter De Lange | by Peter De Lange

What is the first thing that happens when you add a new team member to a data team? Output of the team as a whole will decrease. This is is not a bad thing on it’s own. However it may be an unexpected outcome for the person who sees the increase in costs that come with hiring extra people. Why does this happen? While no output is coming from the team member being onboarded, the…

Continue reading

Uncategorized

Basic PowerShell commands explained

By Peter De Lange | by Peter De Lange

I have created two heavily commented PowerShell scripts that explain the usage of basic PowerShell commands. This may come in handy when you are handed over an existing PowerShell script but you yourself have no experience with the PowerShell language. This is meant as a fast explainer of existing code. Copy the two powershell scripts from the GitHub link below, place them together in any directory. In both files the code is explained through comments.…

Continue reading

Hardware

Saving space on your desktop / workstation

By Peter De Lange | by Peter De Lange

I have saved some space on my desktop by getting a keyboard without numeral pad. These keyboards are called tenkeyless or tkl. The tkl keyboard allows me to keep the mouse better aligned to my body. I first tried a 75% keyboard but it was too much of a change and I found I used the navigational keys and direction keys more than I was aware off before. If you find that you sometimes do…

Continue reading