Skip to content
Colorado State University
CODE
  • Home
  • Posts
    • All Posts
    • Posts by Categories
  • Contact
    • Question or Issue?
    • Contributors
    • Want to Contribute?

Refactoring MS SQL Tables To Enforce Referential Integrity

December 29, 2022 by Shaun Geisert
SQL

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:

Categories MSSQL
How to Fix A Corrupted Gravity Forms Field Using a SQL backup
Get iCal Feed Using Web Service and Adjust Event Times

Recent Posts

  • Enabling Text Message Reminders Using Modern Events Calendar by Webnus
  • Importing/Categorizing Multiple Google Calendars Using Modern Events Calendar by Webnus
  • Managing Your Site’s Media
  • Integrating FileBird Document Library with WordPress Search
  • Dealing with Caching/500 Errors/Other Page Weirdness

Categories

  • 3rd-Party Services (1)
  • Admin (1)
  • Agile (1)
  • ASP.NET (5)
  • Authorization (1)
  • Bash (2)
  • Cache (2)
  • Code Snippets (4)
  • Conferences (1)
  • CSS (1)
  • Documentation (7)
  • Elementor (9)
  • Errors (2)
  • Google Analytics (2)
  • jQuery (2)
  • MS Access (1)
  • MSSQL (2)
  • ODS (1)
  • Outlook (2)
  • PHP (7)
  • Power BI (2)
  • PowerShell (2)
  • Regular Expressions (1)
  • Responsive Sites (1)
  • Security (4)
  • SEO (1)
  • Uncategorized (6)
  • WordPress (38)
  • WordPress Plugins (23)
  • Contact CSU
  • Equal Opportunity
  • Privacy Statement
  • Disclaimer
  • Accessibility Statement
© Colorado State University
Colorado State University