Other articles


  1. Predicting the TN Cash 3 Lottery

    Published: Sat 21 February 2015
    By Cory

    In Python.

    I've always wanted to try my hand at at breaking a PRNG. (Pseudorandom number generators) Since I'm far from an advanced data scientist or mathematician, I figured the best way to start might be with a small keyspace like 000 through 999, what better fit than the TN ...

    read more
  2. Import text files easily using oldschool MS DOS + BCP.

    Published: Fri 16 January 2015
    By Cory

    In T-SQL.

    Data analysts are often asked to compile together datasets from text or log files for analysis. In the past, using the import/export tool in SSMS or the data flow task tool within SSIS packages have served well for this purpose. Today, I wanted to share an alternate method that ...

    read more
  3. NULL as [FIELDNAME] for quick dataset builds.

    Published: Tue 13 January 2015
    By Cory

    In T-SQL.

    Often times I find myself needing to fit 1 dataset into another or start one from scratch. To be a tad less daunting, try this trick.

    Format with excel to build your base fields:

    Populate each field 1 at a time using FROM or JOIN techniques. Alias in alphabetical order ...

    read more

blogroll

social