Popular Quotes by Ronald Bradford

If you have ever met me personally at a presentation, or during consulting, or have read some of my blogs, publications or books the following statements are things I have been known to say.

“You cannot outscale bad design.”

“I focus on delivering a consistent and rewarding consumer relationship.”

“Do Less Work”.  
(blank stares)  
“Let me explain with more detail. Efficiency — Doing less repetitive work.”

“Disaster is inevitable. Total failure is avoidable”.

The first sentence of this I have stated for many years. While mentioning this in discussion about my third book with my editor Paul Carlstroem, he helped me to realize and therefore refine this quote with the second sentence.

Question:  “What is Testing?”
Answer: “Testing is not about seeing if your software works; testing is all about trying to break your software.”

“When reviewing the performance of a piece of code (or SQL statement); the first objective should not be to make it better; the first objective should be to eliminate it.”

“No one cares about your backup; they only care if you can restore.”

Adapated from W. Curtis Preston – Backup & Recovery (O’Reilly, 2009)

“Work towards being proactive, rather than reactive.”

“Frameworks generally suck.
They CLAIM to improve speed of development and abstract the need to know SQL.
The REALITY is the undocumented cost to sub-optimal performance, especially with data persistence.”

“The greatest performance overhead in MySQL systems today is the lack of SQL skills and general development skills by the software creators.”

“There is a time you have to call a spade a spade (i.e. a blunt object), when what you require is a scalpel (i.e. a fine precision object).

You have two choices. You can continue to dig an ever bigger hole for which there will never will be a solution to your problem, or you accept you need to learn how to build scalpels and you just start [painfully] at the beginning.”

Tagged with:

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.