Paul Myrick

Web Developer & Database Specialist

Welcome to Paul’s site featuring information about website development and database administration. The blog section also includes tips and techniques specifically for WordPress users.

The Latest Blog Entries


GUID On SQL Server Tables With An Auto-Generated Sequence

GUID On SQL Server Tables With An Auto-Generated Sequence

Since generated GUID (globally unique identifier) values are considered to be unique across all databases and servers, they are great for assigning row ids that will never be duplicated anywhere else.  However, the values generated for GUID are not user friendly, so...

Tableau Dashboard For Broadway Sales

Tableau Dashboard For Broadway Sales

A Tableau dashboard I created showing Broadway show sales (New York only) pre-covid.  Sales for the top five shows in 2017, 2018 and 2019 are also shown.  This embedded dashboard works best in full-screen mode.

Broadway Show Dashboard Created In Tableau Public

Broadway Show Dashboard Created In Tableau Public

Here's a Broadway show dashboard I built in Tableau Public with dummy data depicting percent sold out (ticket sales vs. capacity), revenue, holds and average ticket price.  All information shown here is completely fictitious and is for demonstration purposes only....