by Paul Myrick | Jun 28, 2024 | Database, SQL
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 invoices needed to show assigned seats in an easy to read format for the customer that...
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 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...