corpus.blog
41554 blogs · [ { "id": "01a087d8-46e3-71af-ba6c-74ab34cad9bf", "title": "DuckDb Performance: min, max, and median vs quantile", "url": "https://rpbouman.blogspot.com/2026/08/duckdb-performance-min-max-and-median.html", "published_at": "2026-08-06T14:09:29+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5e81b6fda", "title": "DataZen winter meetup 2025", "url": "https://rpbouman.blogspot.com/2025/01/datazen-winter-meetup-2025.html", "published_at": "2025-01-22T10:30:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5e8dfe2fb", "title": "DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performance", "url": "https://rpbouman.blogspot.com/2024/12/duckdb-bag-of-tricks-reading-json-data.html", "published_at": "2024-12-19T00:38:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5e975bbbf", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - Rolling up each game's lines into a single game row (6/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn6.html.html", "published_at": "2024-07-11T23:06:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ea246294", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - Extracting Tagpairs with Regular Expressions (5/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn5.html.html", "published_at": "2024-07-11T23:05:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5eaad7a5f", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - Keeping the lines of a game together (4/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn4.html.html", "published_at": "2024-07-11T23:04:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ead127f4", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - Distinguishing the Line Type (3/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn3.html.html", "published_at": "2024-07-11T23:02:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5eb59395a", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - Ingesting raw text with the CSV Reader (2/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn2.html.html", "published_at": "2024-07-11T23:01:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ebfc371e", "title": "DuckDB bag of tricks: Processing PGN chess games with DuckDB - An Introduction to PGN (1/6)", "url": "https://rpbouman.blogspot.com/2024/07/httpsrpbouman.blogspot.com202407duckdb-bag-of-tricks-pgn1.html.html", "published_at": "2024-07-11T23:00:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ec71367e", "title": "DuckDB Bag of Tricks: First Splash", "url": "https://rpbouman.blogspot.com/2024/07/duckdb-bag-of-tricks-first-splash.html", "published_at": "2024-07-11T19:20:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ec7d7b53", "title": "SAP HANA Trick: DISTINCT STRING_AGG", "url": "https://rpbouman.blogspot.com/2024/03/sap-hana-trick-distinct-stringagg.html", "published_at": "2024-03-26T13:46:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ed570f2c", "title": "UI5 Tips: Persistent UI State", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-persistent-ui-state.html", "published_at": "2024-01-03T11:29:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5edea03b2", "title": "UI5 Tips: Persisting JSONModel data using browser Storage", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-persisting-jsonmodel-data.html", "published_at": "2024-01-03T11:29:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5eedf3456", "title": "UI5 Tips: Change expand/collapse icons for Tree, Panel and TreeTable using only CSS", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-change-expandcollapse-icons_3.html", "published_at": "2024-01-03T11:28:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5ef4e10a2", "title": "UI5 Tips: Buffering Events to avoid a request-storm", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-buffering-events-to-avoid.html", "published_at": "2024-01-03T11:18:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f00ce0f5", "title": "UI5 Tips: Manipulating the sap.m.TabContainer close buttons with custom CSS", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-change-expandcollapse-icons.html", "published_at": "2024-01-03T11:17:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f027e2d0", "title": "UI5 Tips: Adding a Splash-Screen / Loading indicator", "url": "https://rpbouman.blogspot.com/2024/01/ui5-tips-adding-splash-screen-loading.html", "published_at": "2024-01-03T11:15:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f0c3b6f3", "title": "Year-to-Date on Synapse Analytics 5: Using Window Functions", "url": "https://rpbouman.blogspot.com/2021/02/year-to-date-on-synapse-analytics-5.html", "published_at": "2021-02-22T01:49:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f1492969", "title": "Year-to-Date on Synapse Analytics 4: Using UNION and GROUP BY", "url": "https://rpbouman.blogspot.com/2021/02/year-to-date-on-synapse-analytics-4.html", "published_at": "2021-02-22T01:36:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f1ee01eb", "title": "Year-to-Date on Synapse Analytics 3: Using a Subquery", "url": "https://rpbouman.blogspot.com/2021/02/year-to-date-on-synapse-analytics-3.html", "published_at": "2021-02-22T01:25:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f213faa7", "title": "Year-to-Date on Synapse Analytics 2: Using a self-JOIN and GROUP BY", "url": "https://rpbouman.blogspot.com/2021/02/year-to-date-on-synapse-analytics-2.html", "published_at": "2021-02-22T01:13:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f24d4c5f", "title": "Year-to-Date on Synapse Analytics 1: Background", "url": "https://rpbouman.blogspot.com/2021/02/year-to-date-on-synapse-analytics-1.html", "published_at": "2021-02-22T01:03:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f2c361a6", "title": "Building a UI5 Demo for SAP HANA Text Analysis: Part 4", "url": "https://rpbouman.blogspot.com/2019/12/building-ui5-demo-for-sap-hana-text_2.html", "published_at": "2019-12-01T23:32:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f38ce488", "title": "Building a UI5 Demo for SAP HANA Text Analysis: Part 3", "url": "https://rpbouman.blogspot.com/2019/12/building-ui5-demo-for-sap-hana-text_28.html", "published_at": "2019-12-01T00:37:00+00:00" }, { "id": "01a087d8-46e4-7096-947d-68e5f3ede740", "title": "Building a UI5 Demo for SAP HANA Text Analysis: Part 2", "url": "https://rpbouman.blogspot.com/2019/12/building-ui5-demo-for-sap-hana-text_1.html", "published_at": "2019-11-30T23:44:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc06365364", "title": "Building a UI5 Demo for SAP HANA Text Analysis: Part 1", "url": "https://rpbouman.blogspot.com/2019/12/building-ui5-demo-for-sap-hana-text.html", "published_at": "2019-11-30T23:18:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc064185e4", "title": "A Tale of a JavaScript Memory Leak", "url": "https://rpbouman.blogspot.com/2018/03/a-tale-of-javascript-memory-leak.html", "published_at": "2018-03-18T00:10:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0661b9c8", "title": "UI5: per-view Internationalization - What about inheritance?", "url": "https://rpbouman.blogspot.com/2017/06/ui5-per-view-internationalization-what.html", "published_at": "2017-06-18T12:59:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc074e9c1c", "title": "Team Just-BI wins 2nd Prize at Dutch Accountability Hack 2017!", "url": "https://rpbouman.blogspot.com/2017/06/team-just-bi-wins-2nd-prize-at-dutch.html", "published_at": "2017-06-17T10:48:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0810e039", "title": "Do we still need to talk about Data Vault 2.0 Hash keys?", "url": "https://rpbouman.blogspot.com/2017/05/do-we-still-need-to-talk-about-data.html", "published_at": "2017-05-12T15:53:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0874f34c", "title": "Announcing Shivers - Visualizing SAP/HANA Information View Dependencies", "url": "https://rpbouman.blogspot.com/2017/03/announcing-shivers-visualizing-saphana.html", "published_at": "2017-03-29T22:52:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0888f500", "title": "SAP HANA: On which base columns do my information views depend?", "url": "https://rpbouman.blogspot.com/2016/10/sap-hana-on-which-base-columns-do-my.html", "published_at": "2016-10-24T20:30:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0904bc29", "title": "SAP UI5: Internationalization for each view - Addendum for Nested Views", "url": "https://rpbouman.blogspot.com/2016/09/sap-ui5-internationalization-for-each.html", "published_at": "2016-09-22T08:55:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0988a569", "title": "SAP UI5: Per-view Internationalization", "url": "https://rpbouman.blogspot.com/2016/09/sap-ui5-per-view-internationalization.html", "published_at": "2016-09-17T23:03:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0a608dbb", "title": "ODXL - A generic Data Export Layer for SAP/HANA based on OData", "url": "https://rpbouman.blogspot.com/2016/05/odxl-generic-data-export-layer-for.html", "published_at": "2016-05-03T22:35:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0b438834", "title": "Installing the Open Source Xavier XML/A client on the Jedox Premium OLAP Suite", "url": "https://rpbouman.blogspot.com/2016/03/installing-open-source-xavier-xmla_20.html", "published_at": "2016-03-20T22:51:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0c1a2357", "title": "Installing the Open Source Xavier XML/A client on icCube OLAP suite", "url": "https://rpbouman.blogspot.com/2016/03/installing-open-source-xavier-xmla.html", "published_at": "2016-03-19T22:52:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0cc4f93b", "title": "Need a Mondrian .WAR? Check out XMondrian.", "url": "https://rpbouman.blogspot.com/2016/03/need-mondrian-war-checkout-xmondrian.html", "published_at": "2016-03-19T21:33:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0da3391c", "title": "jjsml: a Module Loader for the Nashorn JavaScript Shell", "url": "https://rpbouman.blogspot.com/2015/12/jjsml-module-loader-for-nashorn.html", "published_at": "2015-12-29T21:59:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0e95c704", "title": "MySQL: a few observations on the JSON type", "url": "https://rpbouman.blogspot.com/2015/11/mysql-few-observations-on-json-type.html", "published_at": "2015-11-01T22:33:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc0f8c1a85", "title": "Loading Arbitary XML documents into MySQL tables with p_load_xml", "url": "https://rpbouman.blogspot.com/2015/10/loading-arbitary-xml-documents-into.html", "published_at": "2015-10-22T00:02:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc103ea1eb", "title": "MDX: \"Show Parents\" - Redux: A generic and systematic MDX query transformation to obtain the lineage of each member", "url": "https://rpbouman.blogspot.com/2015/08/mdx-show-parents-redux.html", "published_at": "2015-08-30T22:25:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc1132c024", "title": "Using REST services to work with the Pentaho BI Server repository", "url": "https://rpbouman.blogspot.com/2015/07/using-rest-services-to-work-with.html", "published_at": "2015-07-26T22:36:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc11a18483", "title": "MDX: Grouping on non-unique levels", "url": "https://rpbouman.blogspot.com/2015/04/mdx-grouping-on-non-unique-levels.html", "published_at": "2015-04-24T20:31:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc11d8ba3f", "title": "MDX: retrieving the entire hierarchy path with Ancestors()", "url": "https://rpbouman.blogspot.com/2015/04/mdx-retrieving-entire-hierarchy-path.html", "published_at": "2015-04-15T21:38:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc1250a70d", "title": "Retrieving denormalized tabular results with MDX", "url": "https://rpbouman.blogspot.com/2015/04/retrieving-denormalized-tabular-results.html", "published_at": "2015-04-12T21:10:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc13422e94", "title": "CSS tricks for (conditional) formatting of numbers and dates", "url": "https://rpbouman.blogspot.com/2015/04/css-tricks-for-conditional-formatting.html", "published_at": "2015-04-08T00:53:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc14386170", "title": "A Generic Normalizer for Pentaho Data integration - Revisited", "url": "https://rpbouman.blogspot.com/2015/03/a-generic-normalizer-for-pentaho-data.html", "published_at": "2015-03-25T20:55:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc14e09f14", "title": "Performing administrative tasks on Pentaho 5.x Business Analytics Server using RESTful webservices and PHP/cURL", "url": "https://rpbouman.blogspot.com/2014/10/performing-administrative-tasks-on.html", "published_at": "2014-10-17T22:30:00+00:00" }, { "id": "01a0be05-3362-7216-a77b-1cbc15a54e0d", "title": "MySQL 5.7.5: GROUP BY respects functional dependencies!", "url": "https://rpbouman.blogspot.com/2014/09/mysql-575-group-by-respects-functional.html", "published_at": "2014-09-25T23:26:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a769aa83a3", "title": "MySQL: Extracting timstamp and MAC address from UUIDs", "url": "https://rpbouman.blogspot.com/2014/06/mysql-extracting-timstamp-and-mac.html", "published_at": "2014-06-13T12:40:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a769b5e4d4", "title": "When kettle's \"Get data From XML\" is bombed by the BOM", "url": "https://rpbouman.blogspot.com/2014/06/when-kettles-get-data-from-xml-is.html", "published_at": "2014-06-11T13:00:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a769d627ee", "title": "A Generic Normalizer step for Kettle", "url": "https://rpbouman.blogspot.com/2012/03/generic-normalizer-step-for-kettle.html", "published_at": "2012-03-20T20:15:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76a048e19", "title": "Running Pentaho BI Server behind a proxy", "url": "https://rpbouman.blogspot.com/2012/03/running-pentaho-bi-server-behind-proxy_20.html", "published_at": "2012-03-20T08:45:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76ad0f687", "title": "Common Schema: dependencies routines", "url": "https://rpbouman.blogspot.com/2011/12/common-schema-dependencies-routines.html", "published_at": "2011-12-01T19:17:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76b8d6534", "title": "MySQL Hacks: Preventing deletion of specific rows", "url": "https://rpbouman.blogspot.com/2011/10/mysql-hacks-preventing-deletion-of.html", "published_at": "2011-10-21T13:00:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76bd87589", "title": "Fighting Spam: Word Verification", "url": "https://rpbouman.blogspot.com/2011/10/fighting-spam-word-verification.html", "published_at": "2011-10-07T06:50:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76c231fed", "title": "Re-implementing udf_init_error in MySQL 5.5 and up", "url": "https://rpbouman.blogspot.com/2011/08/re-implementing-udfiniterror-in-mysql.html", "published_at": "2011-08-24T20:40:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76c2d6370", "title": "Proposals for Codebits.EU", "url": "https://rpbouman.blogspot.com/2011/08/proposals-for-codebitseu.html", "published_at": "2011-08-15T07:45:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76c61a0a9", "title": "Regarding the MySQL Conference and Expo 2012", "url": "https://rpbouman.blogspot.com/2011/08/regarding-mysql-conference-and-expo.html", "published_at": "2011-08-12T09:59:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76d4c2538", "title": "Working with namespaces and namespace prefixes in XSLT 1.0", "url": "https://rpbouman.blogspot.com/2011/06/working-with-namespaces-and-namespace.html", "published_at": "2011-06-21T22:13:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76e455b04", "title": "HPCC vs Hadoop at a glance", "url": "https://rpbouman.blogspot.com/2011/06/hpcc-vs-hadoop-at-glance.html", "published_at": "2011-06-18T08:22:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76ebc37d3", "title": "Cleaning webpages with Pentaho Data Integration and JTidy", "url": "https://rpbouman.blogspot.com/2011/05/using-tidy-to-clean-webpages-with.html", "published_at": "2011-05-30T15:50:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76f83b43c", "title": "Check out this excellent article by Shlomi Noach!!", "url": "https://rpbouman.blogspot.com/2011/05/check-out-this-excellent-article-by.html", "published_at": "2011-05-18T12:05:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76fecb363", "title": "Managing kettle job configuration", "url": "https://rpbouman.blogspot.com/2011/05/managing-kettle-job-configuration.html", "published_at": "2011-05-10T08:55:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a76ff836b8", "title": "NoSQL support lands in JasperSoft", "url": "https://rpbouman.blogspot.com/2011/01/nosql-support-lands-in-jaspersoft.html", "published_at": "2011-01-26T10:40:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a7704a0c1b", "title": "MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part III", "url": "https://rpbouman.blogspot.com/2011/01/mql-to-sql-json-based-query-language_4061.html", "published_at": "2011-01-07T01:30:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a77108fbb2", "title": "MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part II", "url": "https://rpbouman.blogspot.com/2011/01/mql-to-sql-json-based-query-language_07.html", "published_at": "2011-01-06T23:40:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a771addf24", "title": "MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part I", "url": "https://rpbouman.blogspot.com/2011/01/mql-to-sql-json-based-query-language.html", "published_at": "2011-01-06T21:10:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a772606933", "title": "Speaking at the MySQL conference 2011", "url": "https://rpbouman.blogspot.com/2011/01/speaking-at-mysql-conference-2011.html", "published_at": "2011-01-06T00:43:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a772aad07c", "title": "Substituting variables in Kettle Parameter values", "url": "https://rpbouman.blogspot.com/2010/12/substituting-variables-in-kettle.html", "published_at": "2010-12-18T01:43:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a772e80afe", "title": "Parameterizing SQL statements in the Kettle Table Input step: Variables vs Parameters", "url": "https://rpbouman.blogspot.com/2010/12/parameterizing-sql-statements-in-kettle.html", "published_at": "2010-12-09T08:25:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a773043f6f", "title": "Back to blogging....", "url": "https://rpbouman.blogspot.com/2010/08/back-to-blogging.html", "published_at": "2010-08-10T23:05:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a7736a8b31", "title": "A small issue of SQL standards", "url": "https://rpbouman.blogspot.com/2010/05/small-issue-of-sql-standards.html", "published_at": "2010-05-26T19:45:00+00:00" }, { "id": "01a0be0b-befe-72cc-9464-39a77427a9cc", "title": "MySQL, Oracle and NoSQL: In the grand scheme...", "url": "https://rpbouman.blogspot.com/2010/05/mysql-oracle-and-nosql-in-grand-scheme.html", "published_at": "2010-05-25T09:00:00+00:00" } ] posts Claim your blog
Back to rpbouman.blogspot.com
Blog · corpus.blog/blogs/rpbouman.blogspot.com/posts

rpbouman.blogspot.com

rpbouman.blogspot.com

2026

DuckDb Performance: min, max, and median vs quantileoriginal ↗
6 Aug 2026

2025

DataZen winter meetup 2025original ↗
22 Jan 2025

2024

DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performanceoriginal ↗
19 Dec 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - Rolling up each game's lines into a single game row (6/6)original ↗
11 Jul 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - Extracting Tagpairs with Regular Expressions (5/6)original ↗
11 Jul 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - Keeping the lines of a game together (4/6)original ↗
11 Jul 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - Distinguishing the Line Type (3/6)original ↗
11 Jul 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - Ingesting raw text with the CSV Reader (2/6)original ↗
11 Jul 2024
DuckDB bag of tricks: Processing PGN chess games with DuckDB - An Introduction to PGN (1/6)original ↗
11 Jul 2024
DuckDB Bag of Tricks: First Splashoriginal ↗
11 Jul 2024
SAP HANA Trick: DISTINCT STRING_AGGoriginal ↗
26 Mar 2024
UI5 Tips: Persistent UI Stateoriginal ↗
3 Jan 2024
UI5 Tips: Persisting JSONModel data using browser Storageoriginal ↗
3 Jan 2024
UI5 Tips: Change expand/collapse icons for Tree, Panel and TreeTable using only CSSoriginal ↗
3 Jan 2024
UI5 Tips: Buffering Events to avoid a request-stormoriginal ↗
3 Jan 2024
UI5 Tips: Manipulating the sap.m.TabContainer close buttons with custom CSSoriginal ↗
3 Jan 2024
UI5 Tips: Adding a Splash-Screen / Loading indicatororiginal ↗
3 Jan 2024

2021

Year-to-Date on Synapse Analytics 5: Using Window Functionsoriginal ↗
22 Feb 2021
Year-to-Date on Synapse Analytics 4: Using UNION and GROUP BYoriginal ↗
22 Feb 2021
Year-to-Date on Synapse Analytics 3: Using a Subqueryoriginal ↗
22 Feb 2021
Year-to-Date on Synapse Analytics 2: Using a self-JOIN and GROUP BYoriginal ↗
22 Feb 2021
Year-to-Date on Synapse Analytics 1: Backgroundoriginal ↗
22 Feb 2021

2019

Building a UI5 Demo for SAP HANA Text Analysis: Part 4original ↗
1 Dec 2019
Building a UI5 Demo for SAP HANA Text Analysis: Part 3original ↗
1 Dec 2019
Building a UI5 Demo for SAP HANA Text Analysis: Part 2original ↗
30 Nov 2019
Building a UI5 Demo for SAP HANA Text Analysis: Part 1original ↗
30 Nov 2019

2018

A Tale of a JavaScript Memory Leakoriginal ↗
18 Mar 2018

2017

UI5: per-view Internationalization - What about inheritance?original ↗
18 Jun 2017
Team Just-BI wins 2nd Prize at Dutch Accountability Hack 2017!original ↗
17 Jun 2017
Do we still need to talk about Data Vault 2.0 Hash keys?original ↗
12 May 2017
Announcing Shivers - Visualizing SAP/HANA Information View Dependenciesoriginal ↗
29 Mar 2017

2016

SAP HANA: On which base columns do my information views depend?original ↗
24 Oct 2016
SAP UI5: Internationalization for each view - Addendum for Nested Viewsoriginal ↗
22 Sept 2016
SAP UI5: Per-view Internationalizationoriginal ↗
17 Sept 2016
ODXL - A generic Data Export Layer for SAP/HANA based on ODataoriginal ↗
3 May 2016
Installing the Open Source Xavier XML/A client on the Jedox Premium OLAP Suiteoriginal ↗
20 Mar 2016
Installing the Open Source Xavier XML/A client on icCube OLAP suiteoriginal ↗
19 Mar 2016
Need a Mondrian .WAR? Check out XMondrian.original ↗
19 Mar 2016

2015

jjsml: a Module Loader for the Nashorn JavaScript Shelloriginal ↗
29 Dec 2015
MySQL: a few observations on the JSON typeoriginal ↗
1 Nov 2015
Loading Arbitary XML documents into MySQL tables with p_load_xmloriginal ↗
22 Oct 2015
MDX: "Show Parents" - Redux: A generic and systematic MDX query transformation to obtain the lineage of each memberoriginal ↗
30 Aug 2015
Using REST services to work with the Pentaho BI Server repositoryoriginal ↗
26 Jul 2015
MDX: Grouping on non-unique levelsoriginal ↗
24 Apr 2015
MDX: retrieving the entire hierarchy path with Ancestors()original ↗
15 Apr 2015
Retrieving denormalized tabular results with MDXoriginal ↗
12 Apr 2015
CSS tricks for (conditional) formatting of numbers and datesoriginal ↗
8 Apr 2015
A Generic Normalizer for Pentaho Data integration - Revisitedoriginal ↗
25 Mar 2015

2014

Performing administrative tasks on Pentaho 5.x Business Analytics Server using RESTful webservices and PHP/cURLoriginal ↗
17 Oct 2014
MySQL 5.7.5: GROUP BY respects functional dependencies!original ↗
25 Sept 2014
MySQL: Extracting timstamp and MAC address from UUIDsoriginal ↗
13 Jun 2014
When kettle's "Get data From XML" is bombed by the BOMoriginal ↗
11 Jun 2014

2012

A Generic Normalizer step for Kettleoriginal ↗
20 Mar 2012
Running Pentaho BI Server behind a proxyoriginal ↗
20 Mar 2012

2011

Common Schema: dependencies routinesoriginal ↗
1 Dec 2011
MySQL Hacks: Preventing deletion of specific rowsoriginal ↗
21 Oct 2011
Fighting Spam: Word Verificationoriginal ↗
7 Oct 2011
Re-implementing udf_init_error in MySQL 5.5 and uporiginal ↗
24 Aug 2011
Proposals for Codebits.EUoriginal ↗
15 Aug 2011
Regarding the MySQL Conference and Expo 2012original ↗
12 Aug 2011
Working with namespaces and namespace prefixes in XSLT 1.0original ↗
21 Jun 2011
HPCC vs Hadoop at a glanceoriginal ↗
18 Jun 2011
Cleaning webpages with Pentaho Data Integration and JTidyoriginal ↗
30 May 2011
Check out this excellent article by Shlomi Noach!!original ↗
18 May 2011
Managing kettle job configurationoriginal ↗
10 May 2011
NoSQL support lands in JasperSoftoriginal ↗
26 Jan 2011
MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part IIIoriginal ↗
7 Jan 2011
MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part IIoriginal ↗
6 Jan 2011
MQL-to-SQL: A JSON-based query language for your favorite RDBMS - Part Ioriginal ↗
6 Jan 2011
Speaking at the MySQL conference 2011original ↗
6 Jan 2011

2010

Substituting variables in Kettle Parameter valuesoriginal ↗
18 Dec 2010
Parameterizing SQL statements in the Kettle Table Input step: Variables vs Parametersoriginal ↗
9 Dec 2010
Back to blogging....original ↗
10 Aug 2010
A small issue of SQL standardsoriginal ↗
26 May 2010
MySQL, Oracle and NoSQL: In the grand scheme...original ↗
25 May 2010