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]
A collection of my blog posts tagged as being associated to databases such as SQL query design, database architecture, server tuning, etc.
I am excited to join the Financials product development team as a web developer at Shelby Systems today. [Read More]
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]
Two methods for executing an SSIS package installed on a SQL Server instance from a C#/.NET application. [Read More]
An example of how to use the T-SQL UNPIVOT operator to transform columns to rows. [Read More]
A T-SQL solution using HAVING and COUNT for selecting all records with a non-distinct composite column. [Read More]
A T-SQL solution using the RANK() function for selecting the most recent record for each distinct composite of multiple columns. [Read More]