Posted on September 20, 2019 by mellerbeck
There is a concept of ‘code smells’
any characteristic in the source code of a program that possibly indicates a deeper problem. https://en.wikipedia.org/wiki/Code_smell
I think there are some good smells for packaged software. Like fresh chocolate chip cookies.
The first and greatest is a great big button that says download to try it out, bonus points if I don’t have to register.
Letting you run the full suite for two hours at a time is also nice.
The nice fresh smell is to know how much the software costs without requesting a quote.
Bonus points, an active forum
Filed under: Uncategorized | Leave a comment »
Posted on September 10, 2019 by mellerbeck
https://forums.aws.amazon.com/ann.jspa?annID=6954
Greengrass currently doesn’t support Raspbian Buster or the latest kernel update for Raspbian Stretch, kernel 4.19.57. The Greengrass team is investigating what it will take to support kernel 4.19.57.
Before running apt-get upgrade be sure to block the latest kernel:
sudo apt-mark hold raspberrypi-bootloader
sudo apt-mark hold raspberrypi-kernel
Filed under: AWS, GreenGrass, Uncategorized | Leave a comment »
Posted on August 2, 2019 by mellerbeck
https://boristyukin.com/qlikview-and-oracle-database-tips-for-performance/
Normally Oracle query hints will be written using /*+ ... */syntax. One day I spent many hours trying to figure out why one of my queries took forever to finish if I ran it from QlikView and took only a minute if I ran it from Oracle SQL Developer. Turned out that QlikView by default would strip out comments from SQL statement and treat /*+ ... */ as a comment.
This “feature” is discussed here.
Solution is easy – just use –+ syntax instead if you need to pass a query hint. Of course it is a very easy thing to forget!
Filed under: Uncategorized | Leave a comment »
Posted on May 7, 2018 by mellerbeck
Posted on April 27, 2018 by mellerbeck
The trick is in the *
You can add reducing fields after the NTNAME
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME
ADMIN, ADMIN, welcome, *
USER, *, *, DOMAIN\USERNAME
];
Section Application;
From https://community.qlik.com/thread/29846
Filed under: Uncategorized | Leave a comment »
Posted on April 26, 2018 by mellerbeck
Posted on April 26, 2018 by mellerbeck
This was an annoying one for a bit.
Say you have this Qlikview script
LOAD
Sales_Order
;
Select ORDER_NUMBER as Sales_Order from…. ;
Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?
Anyways, to make it work
LOAD
SALES_ORDER
Filed under: Uncategorized | Leave a comment »
