🍪 Privacy & Transparency

We and our partners use cookies to Store and/or access information on a device. We and our partners use data for Personalised ads and content, ad and content measurement, audience insights and product development. An example of data being processed may be a unique identifier stored in a cookie. Some of our partners may process your data as a part of their legitimate business interest without asking for consent. To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. The consent submitted will only be used for data processing originating from this website. If you would like to change your settings or withdraw consent at any time, the link to do so is in our privacy policy accessible from our home page..

Vendor List | Privacy Policy
Home Tags Privacy About

Peter Daugaard Rasmussen

A personal blog on thoughts, ideas and solutions in the world of software development, programming, web development and software architecture.

← Newer Posts Page 3 of 39 Older Posts →

Visual Studio Code - How to easily diff and compare two files

In this post I will share four ways to diff and compare files in Visual Studio Code. All of them are built-in and require no extensions. »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Tips and tricks 16 December 2022

Goal met! 25.000 organic and referral traffic in November!

Last month - November - I had 25.066 organic and referral traffic, that is everything that is no direct traffic. In November 2021 this number »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Blogging 03 December 2022

C# - Convert DateTime or DateTimeOffset to and from unix timestamp

In C# you can easily convert a DateTimeOffset to Unix time in seconds or miliseconds using the built-in methods ToUnixTimeSeconds or ToUnixTimeMilliseconds: var dateTimeOffset = DateTimeOffset.Now; »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on C# 26 November 2022

Google sheets - Conditions using IF THEN ELSE formula

The basic structure of the IF THEN ELSE formula in Google sheets is an IF formula with parameters, it looks like the following: =IF(logical_expression; »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 17 November 2022

MSSQL - Create a stored procedure with parameters

This post describes how to create a stored procedure in MSSQL that takes parameters. For this we will use the simple table below: CREATE TABLE SomeTable( »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 14 November 2022

MSSQL - How to use variables in SQL statements

This post will demonstrate how to SELECT from a MSSQL table using a variable. There will be three examples: * Simple select statement * Setting a variable from »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 14 November 2022

Google sheets - How to create a drop-down list in a cell

You can easily create in-cell drop-downs in Google sheets using the "Data validation" menu point. It can be found under: * Data * Data Validation Located right here »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on Google sheets 09 November 2022

MSSQL - Creating a table with an auto increment Primary key or adding it later

In MSSQL you can set auto increment for a column using the IDENTITY property. This will often be used on the primary key column, but it »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 30 October 2022

MSSQL - SELECT Date in a specific format (yyyy-MM-dd, MM/dd/yy, MM-dd/yyyy etc.)

In MSSQL you can easily format datetime strings using the FORMAT function. For the examples in this post we will use a simple table like the »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 30 October 2022

MSSQL - Having a SELECT statement in a WHERE clause or part of SELECT statement (using subqueries)

For this blog post we will use the following two tables as examples, the scripts are written in SQL for MSSQL but it should be transferable »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 29 October 2022
← Newer Posts Page 3 of 39 Older Posts →
  • Rss
  • Twitter
  • LinkedIn
  • profile for Peter Rasmussen at Stack Overflow, Q&A for professional and enthusiast programmers
Peter Daugaard Rasmussen - developer, Consultant, Blogger © 2023 Privacy policy