Converting an Existing SQL Server Temporal Table In my previous article on SQL Server Temporal Tables I showed how to create a Temporal Table in a SQL Server database and do time-based querying but what if you have an existing table loaded with data? Sure, creating a...
Introduction to SQL Server Temporal Tables On a recent project we needed to add the ability to track the history of changes to user records in an application. This application was already in maintenance mode, so we also wanted to minimize the number of code changes to...
Creating a Development Container for ASP.NET Core MVC with Entity Framework and SQL Server The purpose of this document is to describe the steps that can be used to create a Development Container for ASP.NET Core MVC with Entity Framework and SQL Server. Some...
In our consulting practice, we see a lot of companies using Microsoft products to deploy their applications. While open source technologies like PostgreSQL and MySQL are popular choices for databases, when companies use a Microsoft stack for their applications MS SQL...
From time to time, we like to share case studies of what weโve been working on here at Intertech. It gives insight into the type of work we do, what you can expect if you work with Intertech to solve your software needs, and what itโs like to work as a consultant for...
Case Study: Upgrading Decades-Old Databases & Reporting for a National Education Network From time to time, we like to share case studies of what weโve been working on here at Intertech. It gives insight into the type of work we do, what you can expect if you...
