Archive

2025

December 2025

30/12/2025 Advanced Database magic with Tableau
21/12/2025 Three small wins
10/12/2025 Tableau Loops

April 2025

10/04/2025 PostgreSQL DB restore lite

2024

March 2024

17/03/2024 Tying off a loose end in TRON

February 2024

18/02/2024 Moving Backups from AWS S3 to Backblaze

2023

August 2023

04/08/2023 Tableau repository schedules decoded

May 2023

04/05/2023 SAP Factory Calendar in Snowflake

2022

December 2022

19/12/2022 Answers Pinboard

October 2022

22/10/2022 Using a Mac still comes with some pleasant surprises

August 2022

14/08/2022 SAP HANA middle of the road for Big Data or just average?

2021

April 2021

03/04/2021 Write better SQL!

February 2021

28/02/2021 SUDO grant - a compromise
20/02/2021 Have yourself a good 🙂🕰! (😎)

2020

November 2020

15/11/2020 Separate business logic from tables and avoid dynamic SQL
09/11/2020 Why are your scalar UDFs slow? (mine aren't)
04/11/2020 DBeaver log files: beware and free up disk space

October 2020

15/10/2020 macOS Excel - clear recently used files list
05/10/2020 How to engineer your DB code

September 2020

21/09/2020 What a 10x network speed difference looks like
04/09/2020 Getting data into HANA - the easy way

August 2020

07/08/2020 What is CPB+-Tree in SAP HANA?

June 2020

02/06/2020 SAP Online Track 2020

April 2020

27/04/2020 Find the ONE ... or the other
04/04/2020 Using new features not supported?!

March 2020

26/03/2020 Matchmaker - quick quick?
26/03/2020 Matchmaker
05/03/2020 Be careful with dates and timestamps

February 2020

17/02/2020 SAP Inside Track #sitMEL – Full Day Event in Melbourne
08/02/2020 One in a Million

January 2020

28/01/2020 The time is now, isn't it?
15/01/2020 Machine learnings of hana, odbc, and macos
13/01/2020 Types of NULL

2019

November 2019

06/11/2019 [NTM] HANA STUDIO NoClassDefFoundError: javax/xml/soap/SOAPException

March 2019

22/03/2019 Conditionally unique

January 2019

08/01/2019 New year, same issues and some tips.

2018

December 2018

03/12/2018 SQL refactoring example

November 2018

28/11/2018 IF EXISTS would exist

October 2018

23/10/2018 How to know "all these things"
16/10/2018 A long comment

July 2018

30/07/2018 Finding answers on workdays

March 2018

27/03/2018 Trouble with time?
07/03/2018 How to give what you don't have

February 2018

09/02/2018 Maps and Paths
01/02/2018 Is SAP HANA SQL/SQLScript Turing complete?

January 2018

04/01/2018 Not a New Year's thing

2017

November 2017

15/11/2017 What's your number?
14/11/2017 HANA inverts the Thunderdome law

October 2017

14/10/2017 HANA backtrace 36/2017

September 2017

11/09/2017 HANA gets stripped
10/09/2017 A new feature! YAY!?

August 2017

15/08/2017 What HANA needs now is some...

July 2017

25/07/2017 SAP Community? Why?

June 2017

20/06/2017 HANA 2 and two riddle errors

April 2017

02/04/2017 Eco-friendly slide recycling with HANA

January 2017

19/01/2017 Make query hints great again...

2016

December 2016

19/12/2016 Merging right. Some tests with data loading in HANA from Down Under.

October 2016

02/10/2016 I’m done (apparently) – see y’all

July 2016

03/07/2016 HANA in a pocket, a skull and some dirty hands on Linux

June 2016

26/06/2016 SAP HANA community continues to grow and so does the moderator team
02/06/2016 On multiple mistakes with IN conditions

May 2016

29/05/2016 Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11

April 2016

24/04/2016 SAP HANA community alert 260416: new moderator aboard
13/04/2016 *click* – *click* – *doubleclick* and nothing happens

February 2016

16/02/2016 Things keep changing around here!

January 2016

06/01/2016 HANA dude analyses Python error and this happened next… (plus: something with Andy Warhol)

2015

October 2015

08/10/2015 Changes, News and Annoucement

August 2015

15/08/2015 Fiddle riddle – Amazing: stuff gets faster and takes less space!
15/08/2015 Quick notes during a fiddle-session

July 2015

26/07/2015 Doing the trick again

June 2015

05/06/2015 The 7th Niceness of new toys’n’tools

May 2015

26/05/2015 Get your data running simple
15/05/2015 The parameters you know
15/05/2015 Free stuff! From the SAP HANA book!! Awesome!!!

April 2015

20/04/2015 Community criss cross puzzle posting in multiple locales

March 2015

25/03/2015 Small surprises, well documented

2014

November 2014

23/11/2014 Something new, something old…
07/11/2014 SAP HANA DBA Ninja vs. GEIGOKAI

September 2014

16/09/2014 I specialise in everything
08/09/2014 Changes to technical properties row/column store
02/09/2014 Book Announcement: SAP HANA Administration
01/09/2014 This is not High Tech, this is not Innovation

August 2014

10/08/2014 Quantum mechanics in SAP HANA?
07/08/2014 Is this the gym you pay for but never actually show up?

June 2014

03/06/2014 Quick note on IDENTITY column in SAP HANA

May 2014

28/05/2014 Of groups of serial shoppers…

February 2014

18/02/2014 You got the time?

2013

December 2013

12/12/2013 SAP HANA double-0 revision in “A secret present"
02/12/2013 HANA SPS 7 first dazzling highlights

November 2013

18/11/2013 In the words of others…

October 2013

27/10/2013 Meet me at SAP TechEd in Amsterdam

September 2013

16/09/2013 Quick note on Plan Visualization in NetWeaver

August 2013

02/08/2013 Missing operations in PlanViz? Not for me! (or you)

June 2013

02/06/2013 Advertisment – Webinar “Performance in SAP HANA Databases” slide deck

May 2013

04/05/2013 A little SAP HANA DBA note on too many trace files...
04/05/2013 Back in the tar pit?
03/05/2013 SPS 6 ante portas – new features in SAP HANA Studio revision 55

January 2013

30/01/2013 Automatic testing of BW queries, anyone? Here you go!
22/01/2013 HANA quick note – checking my connections and using them securely …
22/01/2013 Running up that hill – a quick note on improving SAP HANA

2012

December 2012

19/12/2012 Show me the timelines, baby!
12/12/2012 SPS 5 quick note – on NULL values
10/12/2012 Say cheese… on taking snapshots with SAP HANA

November 2012

29/11/2012 Quick note on cleaning up the SAP HANA Studio folders after upgrade installations
21/11/2012 You got to fight for your right to … setup tracing
08/11/2012 Travelling on to new exciting places...

June 2012

19/06/2012 How to setup SAP HANA SQL reference web search with your browser
19/06/2012 Collecting HANA support information easily

May 2012

16/05/2012 Still no silver bullet

April 2012

11/04/2012 Freshly found HANA Studio (rev. 26) treat…

February 2012

04/02/2012 HANA backtrace 05/2012

2011

December 2011

29/12/2011 Courses, Workshops, Certifications and the Future…

November 2011

15/11/2011 HANA backtrace 45/2011
04/11/2011 HANA backtrace 44/2011

October 2011

21/10/2011 HANA backup script hint… a little bit more security, please!
21/10/2011 How most BW performance support messages are solved
11/10/2011 HANA operational concept released to customers

August 2011

12/08/2011 SAP Support case “FOR ALL ENTRIES disaster”

July 2011

19/07/2011 Partition count contest!

April 2011

March 2011

06/03/2011 “Things change for the better” or “How I enhanced the Oracle DBMS software”

February 2011

26/02/2011 BW/DB Support 101 – Get to know your failing SQL statement

January 2011

29/01/2011 Small changes with big effects
19/01/2011 BW on Oracle: a performance hunch I see more and more often…
05/01/2011 A first (BW) issue…
05/01/2011 New shores in sight…

2010

December 2010

28/12/2010 Quick help for ORA-60 deadlock in BW systems

November 2010

27/11/2010 Designed to dissappoint

October 2010

25/10/2010 Wait a minute – why don’t we have that?
21/10/2010 MaxDB weekend magic - save 50% total storage space!

September 2010

02/09/2010 Note 23345 revised – so what?

July 2010

03/07/2010 Oracle 11g training, Day #3 and #4 -FLASHBACK!

June 2010

28/06/2010 Oracle 11g training, Day #2 – Savepoint!
27/06/2010 Oracle 11g training, Day #1 – Savepoint!
15/06/2010 SAP Support Case “Why is Oracle writing out so many archivelogs in my BI recently?”

May 2010

26/05/2010 MaxDB Optimizer Statistics handling without NetWeaver

April 2010

28/04/2010 MaxDB ST05-trace fallacy - when sometimes the trace is wrong...
25/04/2010 ORA-01007 in ABAP stack and what to do about it.
15/04/2010 How to run a SAP landscape (or so)

January 2010

12/01/2010 MaxDB Event Dispatcher Intro

2009

October 2009

19/10/2009 MaxDB – On locking mechanisms and how we learn something new each day… Part II
13/10/2009 The others
13/10/2009 MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

September 2009

07/09/2009 A fix is not a solution!

August 2009

10/08/2009 Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”

June 2009

29/06/2009 Questions to SAP Support: “How to prevent MaxDB from creating backups to the RUNDIRECTORY?”

May 2009

15/05/2009 What a big impact a little money can have…
10/05/2009 ‘Mind the gap…’ (#4 – reading query execution plans)

April 2009

22/04/2009 SSH/VNC finally reached SAP Support

March 2009

07/03/2009 Now step back and start thinking!

February 2009

02/02/2009 MaxDB – Space oddities, take II

January 2009

27/01/2009 MaxDB: Space oddities
07/01/2009 Understanding database performance for developers

2008

November 2008

20/11/2008 MaxDB: Some notes on the INDEX_USED statistic

September 2008

20/09/2008 ‘Mind the gap…’ (#3 – Backup/Restore – Part 2)
10/09/2008 Questions to SAP Support: “How to move MaxDB volumes?”

August 2008

July 2008

15/07/2008 Oracle Patchset 10.2.0.4 is released – finally.
10/07/2008 Oracle Patchset 10.2.0.4 – neat DBMS_STATS enhancement

June 2008

23/06/2008 ‘Mind the gap…’ (#3 – Backup/Restore – Part 1)
10/06/2008 Questions to SAP Support: “Is my MaxDB recovery still running?”

May 2008

18/05/2008 Questions to SAP Support: Is ODBC access to the database a good idea?
07/05/2008 What you don’t know about MaxDB…

April 2008

13/04/2008 Some hints to make handling of oracle datablock corruptions more efficient

March 2008

12/03/2008 SDN Wiki Features – what features?
02/03/2008 Not my fault – whose then?

February 2008

20/02/2008 How to take care of index corruptions in primary key indexes.
12/02/2008 Point-in-time-recovery considered harmful
07/02/2008 Debugging the MaxDB Kernel – How to get a Call stack the easy way

January 2008

30/01/2008 How to “win” in SAP customer messages
22/01/2008 ‘Mind the gap…’ (#2 – Data storage)
15/01/2008 Parameters. parameters, parameters … the mantra of db performance troubleshooting

2007

December 2007

09/12/2007 Fragmentation in Oracle LMTS tablespace!
05/12/2007 ‘Mind the gap …’

November 2007

October 2007

20/10/2007 A dumb mistake … again and again …
14/10/2007 MaxDB Database Studio 7.7 is available!
09/10/2007 Stay up-to-date! How to keep up with the latest changes in SAP notes.

September 2007

24/09/2007 Something new is coming up…
03/09/2007 Blogging standard…

August 2007

June 2007

25/06/2007 Things that happen in support messages that I don’t like… Part II
24/06/2007 Things that happen in support messages that I don’t like…
17/06/2007 We all hate the BR*TOOLS, don't we?

April 2007

25/04/2007 A useful hint on notes
04/04/2007 Suck that data out! Connect from Oracle to MaxDB

March 2007

20/03/2007 I can repair your corrupt database!

February 2007

27/02/2007 A classic in disguise…
13/02/2007 Starting off with a classic…