Kilt and Code
Kilt and Code

I'm a Scottish software developer based in Stratford, Ontario. I enjoy writing about the things I learn, primarily on the languages and frameworks I use on a daily basis. You can also read about my journey to becoming a full stack developer, immigrating to Toronto as a .NET developer and more in the archives.

Kilt and Code

Latest Articles

Auto-Generate Insert Statements With Data Using SQL Server Management Studio

Auto-Generate Insert Statements With Data Using SQL Server Management Studio

By Steven McLintock on

If you are working with a database in SQL Server Management Studio (SSMS), you may find you need a way to auto-generate INSERT statements with the data from a table. This might be for inserting the data into a different database for testing purposes, or simply as a backup. Read more

Creating a Web API Using Only the .NET CLI and Visual Studio Code

Creating a Web API Using Only the .NET CLI and Visual Studio Code

By Steven McLintock on

Have you ever wondered if you could use the .NET CLI and Visual Studio Code to build a new .NET application, instead of relying on Visual Studio to do all of the heavy lifting? Read more

Using MERGE in SQL Server to do an INSERT or UPDATE on a Table

Using MERGE in SQL Server to do an INSERT or UPDATE on a Table

By Steven McLintock on

I’ve never really made much use of the MERGE statement in SQL Server, but the other day I wanted to do either an INSERT or an UPDATE on a table, depending on if there’s a match on a particular column. Read more

View all articles