• Skip to primary navigation
  • Skip to main content

Collin M. Barrett

Collin M. Barrett is a staff software engineer in Memphis, TN.

  • Start
  • Blog
  • Resume
    • Projects
    • References
  • Contact
Home ❭ Database

database

A collection of my blog posts tagged as being associated to databases such as SQL query design, database architecture, server tuning, etc.

Data CI: Entity Framework Core Migrations from Azure Pipelines to GitHub

Data CI: Entity Framework Core Migrations from Azure Pipelines to GitHub

Published: 3.15.20

I created an Azure Pipeline that automatically performs an Entity Framework Core migration on a GitHub pull request of modified JSON data files. [Read More]

Type Wrapping an Inconsistently Serialized Key-Value Store

Type Wrapping an Inconsistently Serialized Key-Value Store

Published: 7.30.18

Migrating CRUD operations of a key-value store with inconsistent serialization formats from the view layer to typed POCOs in the data layer. [Read More]

The Immortality of C# Static Fields

The Immortality of C# Static Fields

Published: 7.16.18

A tale of improperly using a static field, preventing a colleague from doing the same, and a primer on why static fields should be avoided. [Read More]

HttpContext.Cache Multi-tenant Leak

HttpContext.Cache Multi-tenant Leak

Published: 1.6.18

Our team misunderstood the scope of ASP.NET’s HttpContext.Cache. This mishap led to some cross-instance data leakage in our hosting environment. Keys must always have enough unique information to identify their respective cache value. [Read More]

Joining Shelby Systems

Joining Shelby Systems

Published: 8.21.17

I am excited to join the Financials product development team as a web developer at Shelby Systems today. [Read More]

Departing Fred’s

Departing Fred’s

Published: 8.11.17

Today is my last day as a software developer with Fred’s. I am very thankful for the experience and opportunities that this role has provided. [Read More]

Executing an SSIS Package from .NET

Executing an SSIS Package from .NET

Published: 6.28.17

Two methods for executing an SSIS package installed on a SQL Server instance from a C#/.NET application. [Read More]

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Collin M. Barrett © 2023

  • LinkedIn
  • GitHub
  • Stack Overflow
  • DEV
  • Twitter
  • Goodreads
  • Sitemap