Category: Programming
-
[Solved] Entity framework – Violation of PRIMARY KEY constraint ‘…’. Cannot insert duplicate key in object ‘dbo…’ the duplicate key value is (…). The statement has been terminated.
If you are struggling to create a new record in a sql db when using entity framework and you are ending up with an error that looks like…
-
String Literal Cheat Sheet (Python, C#, JS)
Python Python uses f-strings for string interpolation. Here’s an example: In this code, the variables name and age are inserted into the string using curly braces {}. C# C# uses string interpolation with…
-
How to Push Your Git Repository to TFS
In this guide, we’ll walk through the steps of pushing your Git repository to Team Foundation Server (TFS). This guide assumes that you’re working with a Git repository.…
-
Fixing inconsistently formatted Australian mobile numbers… in excel! 😎
Here is the excel formula: This formula checks if the first character of cell M2 is 0. If it is, it concatenates “+61” with the rest of the…
-
How to add a remote folder share as a remote git repository in vs code?
In some cases, you might just wanna push your code to a network folder and use that as your remote. This will also work without vscode as long…
-
Simple way to sort dates in any format with jquery.datatables
Initially, I was formatting the date in my table using any format I liked. However, I soon realized that this would ruin sorting. For example, if you have…
-
Converting from DOCX to PDF for thumbnails
I recently needed to show some thumbnails of docx files online. Here is what I came up with. Please note that this will not create a perfect thumbnail.…
-
🌎💻 Converting Lat Lng to XY Coordinates: A Guide
As someone who works with geographic data, I often need to manipulate latitudes and longitudes. Recently, a researcher requested that I convert a list of latitudes and longitudes…
-
📅 How to Format and order dd-mm-yyyy Dates in jQuery DataTables 📅
If you’ve ever worked with DataTables, you may have encountered issues with how dates are displayed. By default, DataTables will display dates in a format that may not…
-
Title: How to Add a Windows 10 Machine as a Backup Repository in Veeam Backup & Replication
As an IT administrator, one of your top priorities is to ensure that your organization’s data is properly backed up and protected against data loss. Veeam Backup &…