Glocer's Blog

Qlik Sense Data Model 0

Qlik Sense – note 1

Data Model The Data Model in Qlik Sense is very much similar to traditional data model in DW practice.  It is recommended to use Star or Snowflake schema. In either case, getting Data Model...

SQL-2 0

T-SQL Wildcard

T-SQL provides a LIKE predicate. When using it, we often use some Wildcard signs in our query. The % Wildcard The percent sign represents any string, including empty ones. The _ Wildcard The underscore...

SQL-0 0

COALESCE and CONCAT

COALESCE Function The Coalesce function takes a list of input values and returns the first that is not NULL. For Example, SELECT A, B, C, D, B + COALESCE( N ‘,’ + C, N”)...

DSC01904 0

Making Japanese Miso

I had this post for years in my previous website. now I decided to add it back. I hope it will provide some tips for people who want to make their own miso. Step...

SQL-1 0

T-SQL Joins

I just had a idea to posted some T-SQL tips online, as I don’t want to flip my note book again and again looking for answers. Inner Joins It applies a product between two...

on the way to St George 0

The Nevada Trip

This Amazing trip starts with this map at back of our T-shirts.  Aug. 31, 2013 – Williams, AZ We arrived at Las Vegas at the afternoon of Aug 31. The weather was extremely hot,...