Published on August 20, 2021 at 05:37AM
ERROR: duplicate key value violates unique constraint
Published on May 24, 2021 at 03:57AM
You want to send raw sql from Power Query to your SQL Server database so you can do better query folding than Excel.
Published on August 21, 2020 at 01:27AM
CONVERT_TZ() makes you happy to keep your server on UTC while you sit in Brisbane eating Yatala Pie
Published on August 19, 2020 at 01:02AM
SAP Product Hierarchy 0101010101 maps to Level 1 **01**, Level 2 **0101**, Level 3 **010101** Level 4 **01010101** and Level 5 **01010101**
Published on August 18, 2020 at 11:59PM
Taking a Date (ie 1st July 2020) and converting it to Financial Period Key (ie 202001). Built for Australia style Financial Year
Published on June 15, 2020 at 01:23AM
You want to send raw sql from Power Query to your database because you're better at query folding than Excel.
Published on December 12, 2018 at 04:14AM
I always forget my last process for starting a greenfield rails app
Published on February 07, 2018 at 12:21AM
This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query
Published on February 07, 2018 at 12:01AM
Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.
Published on May 03, 2017 at 04:33AM
This was useful when building a subsequent M Query and needed to know all available table column, types and keys
Published on April 06, 2017 at 02:41AM
I am using psql to interact with a PostgreSQL database from the command line and I don't know what I am doing :P