Daily Shaarli

All links of one day in a single page.

January 5, 2022

Drop and Re-Create All Foreign Key Constraints in SQL Server

I will be the first to admit: the script is a lot to digest. However, before trying to completely reverse engineer all of the logic on first glance, I urge you to try this code (with the EXEC lines still commented out of course) in your hairiest, most complex schemas. Please let me know if you have a scenario where you find any discrepancies in the comments section below.

https://vldb.org/pvldb/vol15/p21-skiadopoulos.pdf
Convert DataTable to List In C#

Convert DataTable to List using a Generic Method

Mapping DataTables and DataRows to Objects in C# and .NET
Converting a List to Datatable
The Never Ending Journey: Implementing a Treemap in C#
phonetonote | my personal note taking journey

My quick capture tool is now more interoperable than before, but I have done nothing to solve my own syncing issues. First, I am transitioning from Roam to Logseq. Logseq is mostly at feature parity with Roam, but allows you to store your notes as local markdown files. This is similar to how Obsidian works, but to my knowledge Logseq is the first block-based tool for thought to consume regular markdown files. Roam allows offline graphs, but the data is not stored in readable markdown files.