I was recently working with an EF Core entity which contained a C# Point property representing a geolocation. This was stored in a single column in a SQL Server database. (I think this uses NetTopolog
Background I recently wrote an EF Core migration which included dropping an index. This index was somewhat unusual, as it didn’t follow our naming conventions and we didn’t know how it had been added. The disparity in naming suggested it may have bee...
If you want to modify a column in an existing SQL Server database, but there is a View using that column, you will find you are unable to modify the column. You will have to drop the view, modify the column, then recreate the view. That's fine in pri...
The problem I was solving I recently did some work to update the structure of some JSON stored in a SQL Server database. The JSON started out as a flat list of properties, and I wanted to add some structure by moving the properties into nested JSON o...
A colleague recently showed me the OUTPUT clause in SQL Server, which I wasn't familiar with. It allows you to view the data which has been changed by a query as part of that query. For example, to view the data inserted by an INSERT statement, you c...
