MSSQL – Code

Refactoring MS SQL Tables To Enforce Referential Integrity

December 29, 2022 by Shaun Geisert

Over the break I was tasked with refactoring an old MVC 2 system for the Educational Opportunity Center. I didn’t build the original system, and this is what their underlying schema looked like:

Syncing an Access DB to MS SQL

December 23, 2020December 21, 2020 by Shaun Geisert

MS Access has fallen out of favor many years ago, especially for use on the web, but it’s still being used by offices to capture data internally. When recently asked whether that data could be exposed on a website, I thought I’d put together the following ASP.NET code to be able to do so relatively … Read more