Size does matter As you use a database, the log files increase in size. When you back up your database, SQL frees the space in the log file - it…
Shrink an SQL database
Fix a SQL Database
A true story Several years ago, before we moved our Production and Development systems over to Kubernetes running on Azure, we used a well-known hosting provider in the UK. Initially,…
Enable SQL Database Diagrams
The Code SQL Database Diagrams are invaluable in understanding the schema. I use them all of the time. Occasionally, I create the database tables and relationships from the diagram designer…
Update SQL Statistics on things
Background As our customer base has grown, so has the size of those customers and, with them, the amount of data we hold within our databases. We have a solution…
Another way in SQL to Delete Duplicate Records
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…
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…
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…