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 showcase and sell their products online. Previously, I had done wireframes with paper and pencil but decided to give Figma a try. At first, the really simple interface didn't...
GUID On SQL Server Tables – 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
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
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....
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 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...
Resolving The Dreaded Facebook Malicious Link Warning
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,...
WORKSHOP: How To Build Your Photography Website
On February 25, 2017, Robin Davis and Paul Myrick will host a three hour workshop featuring information and tips on building websites to showcase and sell photography online. In addition to technical aspects, there will be guidance on curation, design, color and...
WordPress — How To Add A New Featured Image Post
Here's a short video on how to add a new featured image post to a website running on Wordpress. The Wordpress theme in use is called "Water Lily".
Use A Workflow For Website, Blogging, Social Media Posting
Keep content fresh and publication on track by using a workflow for website, blogging and social media posting. Create And Maintain An Editorial Calendar An editorial calendar can be a simple as a target publication date and a subject — or it can be quite elaborate...