Journal
Notes from the work.
Project write-ups, SQL tips and honest lessons about websites, data and marketing.
Creating a SQL Query to Group and Format Seat Data
At one point in my career, I needed to create invoices with dynamic data from a live event ticketing system which contained Broadway season subscription data. Specifically, the...
Facebook Ads Just Don’t Work For Me
Over the past few weeks, I’ve been running Facebook ads for my children’s book and print-on-demand...
New Website For Author D.J. Ciccarello
I'm excited to share my recent website project for D.J. Ciccarello, a talented author based in...
Divi Blog Module – How to change the Older / Next Entries Navigation Link Text
UPDATE! Divi has addressed this issue, so this post has been updated to reflect new...
Using Figma To Design A New Website Wireframe
A new jam, pickle and relish business recently asked me to design and develop a website to...
GUID On SQL Server Tables – Auto-Generated Sequence
Since generated GUID (globally unique identifier) values are considered to be unique across all...
Tableau Dashboard For Broadway Sales
A Tableau dashboard I created showing Broadway show sales (New York only) pre-covid. Sales for...
Broadway Show Dashboard Created In Tableau Public
Here's a Broadway show dashboard I built in Tableau Public with dummy data depicting percent sold...
PostgreSQL Database Time Zones and Timestamp Time Zone Conversion in SQL
PostgreSQL stores timestamps with time zones in Greenwich Mean Time (GMT); however, the database...