Category Archives: Uncategorized

This week, the replication of the subscription of one of our most important databases stopped working. The distribution agent job stopped. In the job history, it had logged the following error: The distribution agent failed to create temporary files in … Continue reading →

This week, I passed my first Azure exam: AZ-900 Microsoft Azure Fundamentals. As the name suggests, this is the most basic Azure exam, and therefore a nice place to start if you want to get certified in one of the … Continue reading →

My attempt to make a dynamic PIVOT statement. The table used is the same as the example in my 70-761 book. First, the @list_of_columns parameter is filled to create a list of columns, using COALESCE. Next a common table expression is … Continue reading →

This script will get the job history for a particular job. The start time will be converted from integer to datetime. Works for job duration under 1000 hours. Since I’ve still got clients on SQL 2008, I can’t use the … Continue reading →

Lately, I’ve been creating, deleting and recreating a lot of virtual machines with Oracle VirtualBox. So today, when I needed to start with a clean environment, I decided to create a virtual machine using the command line instead of the … Continue reading →