ms-sql-server

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 fix a weird situation where your .NET application utilizing EF (Entity Framework or Entity Framework Core) simply crashes without any way to recover or catch the Exception....

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

Every now and then you run into a situation, where you really need to run some SQL against your local development database. That database, at least in my case, is hosted on your local SQL Server Express....

Quite often you get the need to simply quickly query all the database sizes on MS SQL Server....