Awesome Northwind
Whenever I give a talk at a meetup or teach at a course or just want to try a demo about a data driven technology, my biggest problem (and the biggest nag) is always to…
Posts tagged with SQL Server
StackOverflow adventures: Don't create non-clustered index for foreign keys with Entity Framework Code First
I found an interesting question on stackoverflow: https://stackoverflow.com/questions/46212828/ef6-preventing-not-to-create-index-on-foreign-key OP wanted to find a way to disable index creation for foreign keys. I don't believe there is an easy way to…
Restoring from BACPAC times out in SSMS
When moving databases from the cloud to on-premise (usually for some advanced 'hacking', performance-tuning or just experimenting), I often use the BACPAC format. It is basically a zip file that encapsulates the schema and the…
Entity Framework Logical Delete Part Seven: Filtering deleted records using Row-Level Security
So in the previous post, I gave some solutions that can be used for filtering the soft deleted entities. The EF Core solution is kinda neat, but the others' have at least one problem: you…
Entity Framework Logical Delete Part Six: Filtering deleted records the naive way
OK, so we've got to the point where we have a good solution for flagging deleted entities. But we still have to find a way to filter out the flagged records from query results. Just…