Skip to content

The Lars Breddemann Blog

Data, Process, Insights & things I write about
  • Consulting
  • Home
  • About
  • Resources

The Lars Breddemann Blog

Data, Process, Insights & things I write about
  • Consulting
  • Home
  • About
  • Resources

Write better SQL!

  • 03/04/202103/04/2021
  • miscellaneous, SAP HANA, SQL

When reading Some opinionated thoughts on SQL databases recently, I felt reminded of an observation that I have made in the past: the way SQL… Read More »Write better SQL!

SUDO grant – a compromise

  • 28/02/202128/02/2021
  • 3 Comments
  • SAP HANA

A long intro One of the defining characteristics of “enterprise” software is that these systems are used across many parts of organisations and sometimes across… Read More »SUDO grant – a compromise

Have yourself a good 🙂🕰! (😎)

  • 20/02/202120/02/2021
  • miscellaneous, SAP HANA

Ok, nothing complex, crazy, or high-concept today. Just a reminder that stuff like the following is possible without any effort with your database of choice… Read More »Have yourself a good 🙂🕰! (😎)

Separate business logic from tables and avoid dynamic SQL

  • 15/11/202028/11/2020
  • 2 Comments
  • SAP HANA, SQL

You want to apply your business logic to multiple tables in your DB but don’t want to use dynamic SQL? Good on you! Here’s how.

Case buttons including turbo button

Why are your scalar UDFs slow? (mine aren’t)

  • 09/11/202009/11/2020
  • SAP HANA

You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!

DBeaver log files: beware and free up disk space

  • 04/11/202005/11/2020
  • miscellaneous, SAP HANA

Learn something about DBeaver and get free disk space – for FREE!

macOS Excel – clear recently used files list

  • 15/10/202015/10/2020
  • miscellaneous

How to fix a major product flaw in MS Excel for macOS with a little bit of VBA.

How to engineer your DB code

  • 05/10/202006/10/2020
  • 2 Comments
  • miscellaneous, SAP HANA, SQL

See how to choose between different implementation options for your DB code like an engineer.
Also: JMeter, htop, and MapMerge programming.

What a 10x network speed difference looks like

  • 21/09/202021/09/2020
  • 1 Comment
  • miscellaneous

Get 10x better network speed improvement by using a crazy little piece of equipment. It looks like this…

Getting data into HANA – the easy way

  • 04/09/202004/11/2020
  • 2 Comments
  • miscellaneous, SAP HANA

Loading data into SAP HANA the super easy way. A click-through. How to use DBeaver to load huge CSV data files quick without any coding.

  • 1
  • 2
  • 3
  • …
  • 19
  • Next »

Data Process Insights logo banner

If you

  • are looking to get the most out of your SAP HANA, SAP BW, and analytics investment,
  • want to review your solution,
    and
  • learn about the better ways to develop solutions with your database,

then get in touch with me!

April 2021
MTWTFSS
 1234
567891011
12131415161718
19202122232425
2627282930 
« Feb    

Archives

© 2021 by Lars Breddemann