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]
database
A collection of my blog posts tagged as being associated to databases such as SQL query design, database architecture, server tuning, etc.
The Immortality of C# Static Fields
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
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
I am excited to join the Financials product development team as a web developer at Shelby Systems today. [Read More]
Departing Fred’s
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
Two methods for executing an SSIS package installed on a SQL Server instance from a C#/.NET application. [Read More]
UNPIVOTing Data with T-SQL
An example of how to use the T-SQL UNPIVOT operator to transform columns to rows. [Read More]