sql

This article explains how to carefully limit your Home Assistant database growth without losing data you actually care about for analysis and automations.

Oof. What even is this title? Descriptive - sure, maybe - but also kinda long. Ah, okay. This article explains how to map complex data types to a SQL database when using Entity Framework. This time, I'm using Fluent API to do this.

So one day, I needed to quickly check if an identity field in a view in a Microsoft SQL Server was actually unique or not.

This article explains how to perform a very simple and lightweight database connection test for an existing database context.

This article explains how to query and remove duplicate entries from a Microsoft SQL database using T-SQL.

This post describes the fix to THE " No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.

This page describes multiple ways to fix the ' Spatial types and functions are not available for this provider because the assembly ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found.

While using Entity Framework and code-first migrations, Entity Framework (EF) creates the indexes for you - but what if you need to create a custom one, explicitly based on a certain field/column?

This article explains how to work your way around the exception 'Cannot open server - requested by login...