Blog Archives - Page 4 of 8 - Gregory Brickner

SQL Previous Business Day Function

Written by Gregory on October 18, 2012. Posted in Binary, Financial Models.

This is a simple function for MS SQL that can make reporting so much easier by finding the previous business day. Setup the function: CREATE FUNCTION [dbo].[fn_prevbusday](@date DATETIME) RETURNSDATETIMEAS BEGIN DECLARE...

Edit a Magento Configurable Product

Written by Gregory on August 20, 2012. Posted in Binary.

Magento does not allow you to edit a configurable product once it has been created in order to add a new attribute to the product. This is quite annoying since ‘stuff comes up’ where this...

Say Hello to Cavanto (almost)

Written by Gregory on July 17, 2012. Posted in Business & Markets.

Say hello to Cavanto, this is a new Men’s shirt brand I’m launching as a grand experiment. Cavanto is a high quality dress shirt for the business executive. I know, I know. You are saying….”WTF...

Strategy Compass

Written by Gregory on May 15, 2012. Posted in Business & Markets.

Communicating the company’s strategy to the organization is a difficult thing to do. Everyone has to buy into the goal of where the company is headed and being able to clearly articulate the...

Searching within a Stored Procedure

Written by Gregory on May 15, 2012. Posted in Binary.

Handy bit of code to search all of the stored procedures at one time: SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%customer%’ GO This will return the stored...

Fixing Launchpad for Good

Written by Gregory on February 20, 2012. Posted in Binary.

I previously shared how to clean out the junk from Launchpad that is auto populated in one swoop – back to nothing. In the following months though, clutter has again entered the space and rapidly...