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]
database
A collection of my blog posts tagged as being associated to databases such as SQL query design, database architecture, server tuning, etc.
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]
SELECT All HAVING Non-Distinct Composite Column with T-SQL
A T-SQL solution using HAVING and COUNT for selecting all records with a non-distinct composite column. [Read More]
SELECT Most Recent for Each Distinct Column Composite with T-SQL RANK()
A T-SQL solution using the RANK() function for selecting the most recent record for each distinct composite of multiple columns. [Read More]