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]
fred's
A collection of my blog posts tagged as being related to my career at fred's, Inc. including announcements, achievements, current projects, etc.
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]
First Impressions of a Standing Desk
After my first week using a standing desk, here are some quick first impressions on the resulting physical and mental effects. [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]
Example of Big-O Notation Inspired by The West Wing
A practical, real-world example of Big-O Notation inspired by Joey Lucas and Josh Lyman’s polling in The West Wing. [Read More]