Getting the Most Out of Entity Framework Core (Part 2) with Query Tags

“Experts often possess more data than judgment.” Colin Powell “It is a capital mistake to theorize before one has data.” Arthur Conan Doyle This is the second post in the series. To read the first episode go to Getting the Most Out of Entity Framework Core – Part 1. I love databases! […]

How to find MSSQL Database Table Columns that look like Foreign Keys but have no Constraints

After asking around and getting a few suggestions on how to do an automated search for SQL Server tables that have columns that look like foreign keys but do not have constraints on the columns. Here is the SQL statement for this search: