Snowflake's lateral flatten function on variant data type

25. August 2017 22:20 by Jay Grossman in   //  Tags:   //   Comments (0)
Snowflake is a really interesting new data warehouse built on top of AWS. I like their architecture because they had the interesting idea to separate data storage (backed by small files on S3) and compute to run queries (EC2 instances running their API). I inherited a project where we would store complex JSON in a string in a field as varchar(64000). Then we would use regex patterns to get the values we wanted from them. Sometimes these regexes would get really involved, yuck. The Variant data... [More]

Using RunDeck to automatically version control RunDeck changes

15. September 2015 00:30 by Jay Grossman in   //  Tags: , ,   //   Comments (0)
I am big fan of the open source project RunDeck (a.k.a. My Cron Sprawl Killer). I use it on multiple personal projects and have put it in production at my day job (at Rent the Runway). Rundeck is great when you need something to centralize scheduled jobs, handle multi-step jobs across servers/platforms, or a way to expose common automation tasks. I have quite a bit of experience with Control-M (enterprise solution to solve same problems from BMC) and I prefer Rundeck ease of use/... [More]

Creating a Custom Jenkins Plugin with JRuby

13. January 2015 00:27 by Jay Grossman in   //  Tags: , , , ,   //   Comments (0)
I have seen scenarios where I would like to not have Jenkins not execute builds under certain circumstances. One common example is with the Maven Project Plugin, it will often update the .pom file and check it back into source control. When you have Jenkins jobs that poll source code repos for new commits, your builds will enter an endless cycle of triggering more builds.   It would be nice to have the ability to stop builds from executing when the commit contained a specified phrase... [More]

Continuous Deployment on SportCollectors.Net

4. August 2014 00:24 by Jay Grossman in   //  Tags: , , , ,   //   Comments (0)
I am the type of person who likes to build cool things that help solve some folks' problems, especially my own problems. With that said, I'm always going to look to minimize the amount of things I have to do over and over so I have more time to build cool stuff. Since I mainly create software applications, building/testing/deploying code are necessary activities - and they can be very painful. For far too long (2000-2012) I would code away on big new features on SportsCollectors.Net f... [More]

Measuring, Understanding, and Predicting Subscriber Value

16. June 2014 23:53 by Jay Grossman in   //  Tags: , , , , , ,   //   Comments (0)
The subscription business model is a business model where a customer must pay a subscription price to have access to the product/service. Below are some examples of some popular commercial subscription offerings: has built a popular brand offering CRM functions. Amazon, Microsoft, etc. offer hosting infrastructure.  WeightWatchers and eDiets offer access to their diet information, tools, and community. Getty offers download of stock photography. Netflix and H... [More]

Web Enable R models with Shiny

24. March 2014 00:19 by Jay Grossman in   //  Tags:   //   Comments (0)
Last September I was preparing for my fantasy football league and I found this really cool web app that suggested the optimal draft recommendations based on the rules of your league. I then found the associated article on r-bloggers that explained how it was done: Shiny is the secret sauce to make this possible: The Shiny package makes it super simple for R users like you to turn analyses into ... [More]

My Auction Framework MVP

4. March 2014 00:17 by Jay Grossman in   //  Tags: , , , ,   //   Comments (0)
I have been a huge fan of eBay since the moment I first found it (back in 1997 or so). It truly was the world changing marketplace because: It quickly gained critical mass with worldwide populations of buyers and sellers. The auction format is easy to understand and allowed the market to determine the prices.  It was an early web 1.0 company that thrived after the dotcom bust of 2001. Over the years, I have seen both start ups and established companies launch would be competitors to... [More]

Between the Numbers

21. November 2013 00:05 by Jay Grossman in   //  Tags:   //   Comments (0)
I am a huge baseball fan, and I am especially excited that my Boston Red Sox won the 2013 World Series. Part of my love for the game and math came from following the statistical performance of different players and comparing them. I can remember the endless debates with my friends as a kid about who was better, Wade Boggs or Don Mattingly. My dad and his friends debated their generation’s stars - Ted Williams vs. Joe Dimaggio vs. Mickey Mantle. Until the past 10-15 years, there was a stan... [More]

Adding Facebook Comments to BlogEngine.Net

15. November 2013 00:03 by Jay Grossman in   //  Tags: , ,   //   Comments (0)
This blog runs using the open source platform using ASP.Net 4.0. So far I have been pretty happy with the features provided overall, as it was pretty straight forward to set up and there are many themes/widgets. The issue I had with using the out of the box comments system was seeing about 15 spams comments posted a day. I've seen some of the bigger blogs use Facebook Comments and they had less of the spammy junk, like ESPN in the screenshot below:  ... [More]

Decorating sites with Browser Extensions

9. November 2013 23:57 by Jay Grossman in   //  Tags: , , , ,   //   Comments (0)
We’re big fans of internet grocer FreshDirect in my household. When we lived in Brooklyn and now in North Jersey, we place a delivery order about once a week. While there is a lot I like about the service offering, there are a few features that could improve the user experience. One of the big ones for me would be to associate WeightWatchers points values for each food on the site. It would save me a bunch of time and frustration if my wife and I would be able to see them while we were fi... [More]

About the author

Jay Grossman

techie / entrepreneur that enjoys:
 1) my kids + awesome wife
 2) building software projects/products
 3) digging for gold in data sets
 4) my various day jobs
 5) rooting for my Boston sports teams:
    New England PatriotsBoston Red SoxBoston CelticsBoston Bruins

Month List