by Paul Myrick | Sep 6, 2023 | Database, SQL Server
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...
by Paul Myrick | Aug 26, 2023 | Tableau
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...
by Paul Myrick | Aug 16, 2023 | Data Analysis, Reporting, Tableau
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...
by Paul Myrick | Aug 12, 2023 | Database, PostgreSQL
PostgreSQL stores timestamps with time zones in Greenwich Mean Time (GMT); however, the database can be configured to return timestamps in a different time zone. To set the default time zone for a database, use the ALTER DATABASE command. For example, the following...
by Paul Myrick | Jan 15, 2017 | Social Media, Web Development
Facebook will occasionally decide to flag links to your website with a warning about malware, spam or other supposed problems when it is simply not true. On two occasions, for two separate websites I run, Facebook has flagged my links this way. In the first instance,...