SAP: MaxDB Password re-set procedure [version 7.6, 7.7, 7.8]

The original reference to the procedure can be found at Matt Bartlett’s website [very useful guide]. The Issue I ran in to an issue where the database log has reached the capacity and required a backup. To accomplish this I needed access to the installed MaxDB instance. I was wo
Continue Reading →

SQL: SELECT random number of rows

Here’s a quick way of requesting a random number of rows from a MySQL database: SELECT * FROM <'table'> ORDER BY rand() limit <'n'>; tablename: is the name of the table you wish to access n: is thenumber of rows you wish to return Be careful thoug
Continue Reading →