Using a CTE to delete duplicates Some of my other posts show how to find and delete duplicate records from SQL Server. This is another way to delete duplicate records…
Another way in SQL to Delete Duplicate Records
SQL Records Per Table
Why you need to know There are lots of reasons why you might want to know the number of records in your tables. Database maintenance is one; user and business…
Delete a constraint on a table / field combination without knowing the name of the constraint
Overview In database management, especially when dealing with SQL Server, modifying or removing default constraints is a common task. This blog post will delve into a specific SQL script designed…
SQL Indexes and Check if One Exists
Managing a database efficiently often requires a deep understanding of its structure and components, particularly indexes. In SQL Server, indexes are crucial in optimizing query performance and ensuring data integrity.…
How to duplicate SQL Rows
In the world of database management, efficiency and precision are key. With its versatile commands, SQL offers a wide range of functionalities for handling data. One such functionality is the…
Restore a SQL database
In the realm of database administration, one of the most critical tasks is the ability to restore databases efficiently and accurately. This blog post will delve into an essential aspect…
Debugging Dot Net Core applications on a Raspberry Pi with Visual Studio
I have a great post here that details how to install the Visual Studio debugger on a Raspberry Pi. That, together with the Dot Net Core libraries, gives you everything…
TFT Display on a Raspberry Pi
Many different TFT screens are available for Raspberry Pi's and other microcontrollers such as the ESP32. Most smaller screens cost under £10 and are available from many suppliers. I typically…
C# and Rebooting a Raspberry Pi
Every now and again, you need to restart a Raspberry Pi from within your application. This is typically done after making changes to the Pi configuration, issuing commands to enable…
Proxmox Tag Colours
Each VM and Container in Proxmox can be defined with one or more Tags. The search bar in Proxmox allows you to search for a tag and have it list…