Friday, May 15, 2020

TWID May 16, 2020: random potpourri of things

This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these

In last week's post I mentioned that the pepper and tomato plants were ready to be planted outside. This was done yesterday and the plants are outside now

In front of the house we have put them in pots

In the back of the house we have transferred the plants to a raised bed

It is over 80 degrees today, hopefully the plants will love this weather and grow big

For Mothers day... we didn't do much because we are still under lockdown.. my oldest son made this crumb cake.. it was delicious

This Week I Tweeted

US video game sales have record quarter, as consumers stay at home 

New numbers from NPD confirm what we’ve known for a while: The first quarter of 2020 was a very good one for gaming companies. The new report notes that sales hit a record $10.86 billion in the States between January and March of this year, marking a 9% increase over a year prior; $9.58 billion of that figure was from video game content.

The primary driver is, you guessed it, COVID-19. As stay at home orders have been enacted on the federal and state levels, people are coping with the ongoing daily horror that is life in 2020 by playing video games. Lots and lots of video games.

Some cool stuff you might enjoy

The Rijksmuseum is today publishing the largest and most detailed ever photograph of The Night Watch

Most detailed ever photograph of The Night Watch goes online  

The Rijksmuseum is today publishing the largest and most detailed ever photograph of The Night Watch on its website, making it possible to zoom in on individual brushstrokes and even particles of pigment in the painting. Work on Operation Night Watch will resume on Wednesday 13 May in the glass chamber in the museum.

I have seen this painting many times, the reason is because I grew up in Amsterdam and my neighbor worked for the Rijksmuseum. I always got complementary tickets. The interesting part is that I have been to the Rijksmuseum more times when moving to the US than I did when I lived in Amsterdam  :-(

This does looks pretty cool,  you can just keep zooming. Direct link

Why millennials have fallen in love with stamp collecting

Covid has increased the number of people getting interested in stamp collecting. Here are 3 articles I happen to see in the past couple of weeks

Hyperinflation stamps Weimar Germany

Post modern: why millennials have fallen in love with stamp collecting

Philately is gaining popularity with younger hobbyists, who are drawn to its vintage - and Instagram - appeal

It was once a byword for boring, but it seems stamp collecting is finding a new – young – audience, despite the fact that some hobbyists have never actually posted a letter.

Philately is gaining popularity among millennials, many of whom see the creative pursuit as an escape from their screen-based lives, says 37-year-old Suzanne Rae, from North Yorkshire.

“Philately is tangible: it’s relaxing and unplugged. It’s also very Instagrammable,” says Rae, who is only the second female chairman the Philatelic Traders Society has had in its 91-year history. “Twitter and Instagram enable young collectors to find people like them, and see that it’s not only a geeky old man’s pursuit.”

Covid-19 Virus Affect On The Stamp Market

The strong reaction of the US Government to the Covid pandemic has resulted in the self-isolation and self-quarantining of millions of Americans as well as people worldwide. While this is having a devastating effect on the economy, it has been a real boost to the stamp market. Stamp collectors around the world suddenly have many hours of time to fill since they can't go out, go to work or watch sporting events. Hence, they spend time buying stamps. The dealers I spoke with all report a surge in orders, many from customers they have never had before.

COVID-19 a shot in the arm for stamp collecting

Well, if you’d asked me a few months back what was needed to give stamp collecting a kick up the backside, my first answer would probably not have been “a global supervirus pandemic.”

But it sure feels like that’s what has happened. The enforced worldwide recreation break has existing collectors burying their heads into their albums, lapsed collectors dusting cobwebs off old shoeboxes, and curious novices taking their first tentative steps into a mysterious world.

New philatelic blogs and Instagram feeds are starting up, and online viewers are devouring YouTube clips. Philatelic magazines have even been offering free access to an edition or two.

Even the mainstream media have noticed. Stamp dealers report rising sales. Kids are writing letters. Even before the COVID-19 crisis kicked in, both the BBC and the Observer were reporting the growing popularity of stamp collecting among younger collectors.

Bavaria Ring Cancellations

Some Progress

Books finished so far/in progress

In progress

Done with these

Book Completed
Stealth War: How China Took Over While America's Elite Slept 01/04
Sandworm: A New Era of Cyberwar and the Hunt for the Kremlin's Most Dangerous Hackers 01/25
Alexander Hamilton 02/12
The Quick Python Book, 3rd Edition 02/13
The Gene: An intimate history 02/17
Moonwalking with Einstein 02/27
The Somme 02/25
The Art of Learning 02/16
Ready to Run: Unlocking Your Potential to Run Naturally 03/08
The Tudors, a very short introduction 03/17
South: The Illustrated Story of Shackleton's Last Expedition 1914-1917  03/18
The Body: A Guide for Occupants 03/30
The Great Sea: A Human History of the Mediterranean 04/07
Tiny Habits: The Small Changes That Change Everything 04/11
Lifespan: Why We Age – and Why We Don’t Have To 04/27
The Stand 04/30
Fellowship of the ring 05/07
The Two Towers 05/15

Books in the queue
These are next... in no specific order

Books to get
Here are the books I plan to get. These were either mentioned on more than one podcast, recommended by friends, or are new books from authors I like, for example Eric Larson's latest book about Churchill and the Blitz

Running progress
My goal is to run 800 miles this year, this means about 4 runs of about 4 miles per week

Miles        Percentage
296.81 37.10%

So far that burned a bit under 45,600 calories

Saturday, May 9, 2020

TWID May 9, 2020: Books and Plants

This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these

It has been a while since I posted here.. but I decided to bring back the TWID posts again

I have been reading a lot lately, since I am already home for 60 days, I decided to read some of the big books I own or re-read them.  I already finished the Stand, almost done with Gotham and I am 35% done with the Lord of The Rings book.

I read 10 pages per day of the Gotham book and then I usually have a book I read at home and one while I commute. Since I am home now, I read the commuting book in the morning

Here is a pic of the books I owe but never read (except for the Lord Of the Rings book)


At the end of this post, you can see all the books I finished, what I am reading now and also what is in my backlog/queue to read.

Here you can see some of the seeds my son and I purchased


That's right.. the second one from the left in the top is a ghost chile... not sure yet what I will do with those.  Maybe make pepper spray or some extremely hot sauce   :-)

This is what the plants looked like a couple of weeks ago


This is what it looks like today

As you can see they are ready to be planted outside. It still cold at night but after Wednesday May 12th, these should be fine to be transplanted

Here you can see what the plants look like 2-3 weeks ago with a fan blowing on them

The reason you use a fan inside is to strengthen the the plants, this way they don't break when you put them outside and it is a little windy on the first day

This Week I Tweeted

As a result, crude was actually trading at a negative $3.70 a barrel when Shah’s screen had it at 1 cent; the reason: Interactive Brokers never displayed a subzero price to him as oil kept diving to end the day at minus $37.63 a barrel.
At midnight, Shah some very bad news: he owed Interactive Brokers $9 million. He’d started the day with $77,000 in his account, expecting that his biggest possible loss was 100%, or $77,000.

Ouch that is so bad, who knew oil could go negative....

Can't quit Excel

This happened to me.. pasted a lot of data into Excel on a VM and then tried to cancel it and quit.... nope.  So I just used task manager to kill it


Some cool stuff you might enjoy

You know about waitfor delay but did you know there is a waitfor time?

You may or may not know that WAITFOR has TIME in addition to DELAY

When I sold kinderzegels as part of school (semipostal stamps that benefit child welfare)

Mindmap Diagram Codes

This is pretty cool, you can create a mindmap, code on left.. output on the right, you can share it as well

Looks like this

Some Progress

Books finished so far/in progress

In progress

The Two Towers 21% done

Done with these

Book Completed
Stealth War: How China Took Over While America's Elite Slept 01/04
Sandworm: A New Era of Cyberwar and the Hunt for the Kremlin's Most Dangerous Hackers 01/25
Alexander Hamilton 02/12
The Quick Python Book, 3rd Edition 02/13
The Gene: An intimate history 02/17
Moonwalking with Einstein 02/27
The Somme 02/25
The Art of Learning 02/16
Ready to Run: Unlocking Your Potential to Run Naturally 03/08
The Tudors, a very short introduction 03/17
South: The Illustrated Story of Shackleton's Last Expedition 1914-1917  03/18
The Body: A Guide for Occupants 03/30
The Great Sea: A Human History of the Mediterranean 04/07
Tiny Habits: The Small Changes That Change Everything 04/11
Lifespan: Why We Age – and Why We Don’t Have To 04/27
The Stand 04/30
Fellowship of the ring 05/07

Books in the queue
These are next... in no specific order

Books to get
Here are the books I plan to get. These were either mentioned on more than one podcast, recommended by friends or are new books from authors I like, for example Eric Larson's latest book about Churchill and the Blitz

Running progress
My goal is to run 800 miles this year, this means about 4 runs of about 4 miles per week

Miles        Percentage
279.57 34.95%

So far that burned a bit under 43 thousand calories

Interesting quote....heard it on a podcast... don't remember which one  .. sorry  :-(

A fool never learns
A smart man learns from his mistakes
A wise man learns from the mistakes of others

Tuesday, April 30, 2019

A quick and easy way to count the percentage of nulls without a where clause in PostgreSQL

This came up the other day, someone wanted to know the percentage of NULL values in a column

Then I said "I bet you I can run that query without using a NULL in the WHERE clause, as a matter of fact, I can run that query without a WHERE clause at all!!"

I created a SQL Server version of this post here: How to count NULLS without using IS NULL in a WHERE clause, this is the PostgreSQL version

To start, first create this table and verify you have 9 rows

CREATE TABLE foo(bar int);
INSERT INTO foo values(1),(null),(2),(3),(4),


Here is what the output should look like

To get the NULL values and NON NULL values, you can do something like this

SELECT COUNT(*) as CountAll FROM foo WHERE bar IS  NULL;

However, there is another way

Did you know that COUNT behaves differently if you use a column name compared to when you use *

Take a look

SELECT COUNT(*) as CountAll, 
  COUNT(bar) as CountColumn
FROM foo;

If you ran that query, the result is the following

CountAll    CountColumn
----------- -----------
9           7

Here is what it looks like in pgAdmin3

Let's see what the PostgreSQL documentation has to say

COUNT(*) number of input rows

COUNT(expression) number of input rows for which the value of expression is not null

This is thus indeed documented behavior, count(*) counts all rows, count(column) skips the rows with NULLS

So now, lets change our query to return the percentage of non null values in the column

Here is what the query looks like

SELECT COUNT(*) as CountAll, 
  COUNT(bar) as CountColumn, 
  (COUNT(bar)/COUNT(*))*100 as PercentageOfNonNullValues 
FROM foo;

Running that gives us this output

CountAll    CountColumn percentageOfNonNullValues
----------- ----------- ---------------------------------------
9           7                  0

Here is what it looks like in pgAdmin3

As you can see, we have a 0 in the percentage column. The reason is that if you do math with integers, you will get an integer back

We can fix this easy by multiplying one of the integers by 1.0, this will convert the integer to a numeric data type . So instead of this line

 (COUNT(bar)/COUNT(*))*100 as PercentageOfNonNullValues 

We will change it to be like this

(COUNT(bar)*1.0/COUNT(*))*100 as PercentageOfNonNullValues

Here is the changed query

SELECT COUNT(*) as CountAll, 
  COUNT(bar) as CountColumn, 
  (COUNT(bar)*1.0/COUNT(*))*100 as PercentageOfNonNullValues 
FROM foo;

Here is the output

CountAll    CountColumn percentageOfNonNullValues
----------- ----------- ---------------------------------------
9           7           77.7777777777800

Here is what it looks like in pgAdmin3

Instead of doing * 1.0, you can also explicitly cast the integer like this

(CAST (COUNT(bar) as numeric(20,10))/COUNT(*))*100 as PercentageOfNonNullValues

The query now looks like this

SELECT COUNT(*) as CountAll, 
  COUNT(bar) as CountColumn, 
  (CAST (COUNT(bar) as numeric(20,10))/COUNT(*))*100 as PercentageOfNonNullValues
FROM foo;

Here is what it looks like in pgAdmin3

That's it for this short post.. hopefully you knew this, if not, then you know it now  :-)

Wednesday, April 17, 2019

The Vessel, a honeycomb shaped structure that will be a great tourist destination at Hudson Yards in New York City

I took a stroll at the high-line in NYC yesterday and noticed that the Vessel was open to the public

The Vessel is a  copper-colored steel structure comprises 54 interconnecting flights of stairs, 2,500 steps, and 80 landings, it was designed by Heatherwick Studio's. The Vessel rises to a height of 150 ft (45 m) offering views of the city and the Hudson River.

Here is what it looks like

The Vessel From a distance

Here it is on the map, it's right at the end/start of the highline and also just a block or so from the Jacob K. Javits Convention Center. I think a lot of visitors to the Jacob Javits Center will stop by

The first thing you will notice is how shiny the Vessel is... in place when the sun hits's like hitting a mirror. I wonder how soon before it turns green because of oxidation. I wouldn't want to be the person who has to polish this copper behemoth

Shiny vessel

The second thing you need to know is that you can't go inside the Vessel without a ticket. Tickets are free, I picked one up in front of the Vessel near the building right in front of it. I did have to wait 30 minutes to get in, the tickets are only valid for 1 hour

The third thing you will notice once you enter the Vessel is a blue light and a crowd of people near it

You will see something like this

  Selfies at the Vessel

Or something like this

  Taking selfies at the vessel

That spot with the blue light is the selfie station, you put your phone down in the middle, then you stand there while a selfie is taken

I decided not to do that since I don't take selfies, but here is the view from the bottom when you take a normal shot

Looking Up From The Vessel

Here you can see all the stairs, it's nice to walk all over the structure, you get nice views of the city.

  The Vessel

If for some reason, you can't take the stairs, there is an elevator as well. The thing you see in the middle in the pic below is where the elevator travels

Here is a pic I took of people on the top of the Vessel, it was very windy yesterday, I stayed on the one below the top

On top of the Vessel

I took a picture of these path trains

  Trains as seen from the Vessel

Saturday, March 30, 2019

TWID March 30, 2019: Tsundoku, DevOps, robots, turing award,gps drifting

This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these

This Week I Learned

Tsundoku (積ん読) is acquiring reading materials but letting them pile up in one's home without reading them. The term originated in the Meiji era (1868–1912) as Japanese slang. It combines elements of tsunde-oku (積んでおく, to pile things up ready for later and leave) and dokusho (読書, reading books). It is also used to refer to books ready for reading later when they are on a bookshelf. As currently written, the word combines the characters for "pile up" (積) and the character for "read" (読).

OK, so I have a bunch of books that I bought years ago and never finished. Some of these I never started. So what I decided to do is take 1 hour each day before going to work, grab 3 books and read 20 minutes per book.  I also have some books in the office, I am reading 20 minutes each time when I go to the office, this is currently twice a week. The book I am reading in the office is Pragmatic Thinking and Learning, I am 40% done with that book

I already finished the book War Of Art, am 25% done with Tools of Titans and just started Python Tricks

Here is a pic of the books

Tsundoku (積ん読) is acquiring reading materials but letting them pile up in one's home without reading them

The books in that picture are the following

Tools of Titans: The Tactics, Routines, and Habits of Billionaires, Icons, and World-Class Performers (started)
Tribe of Mentors: Short Life Advice from the Best in the World
War Of Art  (finished)
Wired To Eat
Python Tricks the book: A Buffet of Awesome Python Features (started)
Fluent Python: Clear, Concise, and Effective Programming
Book of Five Rings
How Linux Works, 2nd Edition: What Every Superuser Should Know

I continued my DevOps training and like last week, I decided to put my note at the end of this post, this way I can easily look it up again

This Week I Tweeted

Three ‘Godfathers of Deep Learning’ Selected for Turing Award

Three computer scientists who laid the foundations for many of the recent advances in artificial intelligence are being honored with this year’s Turing Award, considered the field’s highest accolade.

Geoff Hinton, an emeritus professor at the University of Toronto and a senior researcher at Alphabet Inc.’s Google Brain, Yann LeCun, a professor at New York University and the chief AI scientist at Facebook Inc., and Yoshua Bengio, a professor at the University of Montreal as well as co-founder of AI company Element AI Inc., will share this year’s award, which is given annually by the Association for Computing Machinery.

The three winners will split a $1 million prize that comes with the award, which is currently underwritten by Google

For a list of previous winners see here:

Was MongoDB Ever the Right Choice?

I was reading a post recently about Red Hat removing MongoDB support from Satellite (and yes, some folks say it is because of the license changes). It made me think how often over the last few years I’ve seen post after angry post about how terrible MongoDB is and how no one should ever use. However, in all this time, MongoDB has become a much more mature product. So what happened? Did all of the hate truly come from mistakes made in the early implementation/marketing of MongoDB? Or is the problem that people are blaming MongoDB for their own lack of efforts when evaluating if it was a good fit?

Read and find out.....

Australia Is Drifting So Fast GPS Can't Keep Up

Australia is not quite where you think it is. The continent has shifted by 4.9 feet since the last adjustment was made to GPS coordinates in 1994, reports the New York Times.

A significant correction must be made by the end of the year for navigation technology to keep working smoothly.

This is interesting, I  about drift because undersea cables will break, but never had an idea that it was this fast that they have to adjust GPS

Boston Dynamics’ new robot stacks boxes 

It’s a “mobile manipulation robot” designed for the logistics sector. It can autonomously stack and unstack boxes onto and off pallets, and shift them onto conveyor belts. It uses an onboard vision system to track which objects go where, and to judge how to grasp and place each box. It uses a robotic technique called “force control” to nestle each box up against its neighbors. It can handle weights of up to 15 kilograms (33 pounds.)

And that is how it all starts... wondering when they will rename the company to SkyNet  :-)

Some cool stuff you might enjoy

Awesome Newsletters
A curated list of awesome newsletters.

Inspired by the awesome-* trend on GitHub.

There is something here for everyone

The most populous cities in the world from 1500 to 2018   

This is amazing, make sure to watch the whole's like a race....

Some DevOps notes

This is for me.. not for you.... but feel free to take a look...although it won't probably make a lot of sense if you see these terms for the first time

Top 10 books  from 10 to number 1
Visible Ops
Continuous Delivery: Reliable Software Releases through Build, Test, and Deployment Automation
Release It!: Design and Deploy Production-Ready Software
Effective DevOps: Building a Culture of Collaboration, Affinity, and Tooling at Scale
Lean Software Development: An Agile Toolkit 
Web Operations: Keeping the Data on Time
The Practice of Cloud System Administration: DevOps and SRE Practices for Web Services
The DevOps Handbook: How to Create World-Class Agility, Reliability, and Security in Technology Organizations
Leading the Transformation: Applying Agile and DevOps Principles at Scale
The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win mailinglist

Wall of Confusion
Impedance mismatch between teams

Blameless postmortems
It's a meeting
within 48 hours of incident
run by a 3rd party

Have everything in a timeline. Not here to blame a person but making sure this doesn't happen again

Trasnparent Uptime
Admit failure
Sound like a human.. no doublespeak
Have a communication channel
Be authentic

Trust blockers
Lack of Context
Conflicting goals

Open it Up
Chat rooms
Wiki pages
Source code (to read)
Monitoring Tools
Ticket Tracker

USe something like chat or teams instead of emails

Shared responsibility
Team culture
No Silos

Shadow IT/Bimodal IT
Groups deliberate bypassing processes to get things done

Devs responsibe for failed deployment after code checkin

Changing your ways of how you do work.... might be hard..but it will pay off

Conway's law
organizations which design systems ... are constrained to produce designs which are copies of the communication structures of these organizations.

Eric S. Raymond, an open-source advocate, restated Conway's law in The New Hacker's Dictionary
James O. Coplien and Neil B. Harrison stated:

If the parts of an organization (e.g., teams, departments, or subdivisions) do not closely reflect the essential parts of the product, or if the relationship between organizations do not reflect the relationships between product parts, then the project will be in trouble ... Therefore: Make sure the organization is compatible with the product architecture.

Westrum Model
Pathological (Power Oriented)
Bureaucratic (Rule Oriented)
Generative (Performance Oriented)

Management Best Practices
Independent, cross-functional teams
People first
Agile, lean processes

Small change  aka continues improvement
Good processes bring good results
Gemba (Go see for yourself).. (the real pace or Locus).. meaning look at the code or the system or factory floor
Speak with data, manage by facts  (scientific method)
Take action to contain and correct root causes (The 5 whys, people don't fail processes do)
Work as a team
Kaizen is everubody's business


Waterfall --> Iterative
DevOps has strong roots in Agile but is not just agile

Lean, 7 principles
1 Eliminate Waste
2 Amplify Learning
3 Decide as late as possible
4 Decide as fast as possible
5 Empower the team
6 Build in integrity
7 See the whole picture

Muda: work that absorbs resources but adds no value
Muri: Unreasonable work imposed on workers and machines
Mura: Work coming in unevenly instead of a constant or regular flow

The 7 Wastes Of Software
1 Partially work done
2 Extar features
3 Relearning
4 Handoffs
5 Delays
6 Task Switching
7 Defects

Build Measure Learn
Build minimum viable product
Measure the outcome and internal metrics
Learn about you problem and your solution
Repeat, go deep where it's needed

Concept to cash: from idea to it's realization, including everything needed to get it to customer

ITSM (Information Technology Service Management)

ITIL (Information Technology Infrastructure Library)
1 Service  Strategy
2 Service  Design
3 Service  Transition
4 Service  Operation

ITIL 2007... 2000 pages long...  The Visible OPS handbook (only 100 pages)

Use ITIL but make it lean


Infrastructure as code
Everything programmatically, no UI, same code runs on test, stage, UAT and production

Servers are cattle not pets.. deploy in mass, not handcrafted

Provisioning: Making a server ready for operation..including OS, network connectivity and system services
Deployment: Automatically deploying and upgrading applications on a server
Orchestration: Performing coordinated operations across multiple systems
Configuration Management: Management of change control after initial provision, maintaining and upgrading apps and app dependencies

Imperative/procedural: Commands necessary to produce a desired state are defined and executed
Declaritive/Functional: A desired state is defined, relying on the tool to configure a system to match that state
Idempotent: The ability to execute repeatedly, resulting in the same outcome
Self Service: The ability for an end user to initiate a process without having to go through other people

Canary (staged) Deployment Pattern
Upgrade 1 server, see how it works before upgrading the rest

Blue Green deployment
Two environment, code is pushed to one, then environments are swapped, variant like cluster immune system deployment

Containers making things easier to deploy, golden image is coming back now since you can just packe it up as a container.

Terraform.. used so that you can use setting across Azure and AWS


Continuous Deploy
Continuous Delivery
Continuous Integration

Time to market goes down... high performing IT orgs can deploy on demand, some 10 or 100 times a day

“Cease dependence on inspection to achieve quality. Eliminate the need for massive inspection by building quality into the product in the first place.” quote by W. Edwards Deming

With Continuous Delivery you can much easier see what change caused a degradation of an application, with a quarterly release there are so many changes, it is difficult to find out what caused the degradation

The goal of continuous integration is that working software is in a working state all the time quote by Jez Humble

6 practices
Builds should pass the coffee test (should be less than 5 minutes)
Commit really small bits
Don't leave the build broken
Use a trunk based development flow
No crappy tests, fix your tests
The build should return a status, a log and an artifact

Only build artifacts once..immutable, should not change... this creates trust.. underlying bits did not change
Stop deploy if a step fails, notify teams

Test Unit testing
Code hygiene  linters, formatters, banned functions check
Integration testing


State desired outcome as test
write code to pass test

Work with stakeholders
Describe business functionality
Tests are based on natutal language descriptions

ATDD (acceptance test driven development)
End user perpective
Use case automated testing
testing is continous during development

3 ways to get around slow tests... so you don't violate your coffee rule
use nonblocking tests
use time scheduled tests
use monitoring

Mean Time To Recovery

Cascading failure pattern: Cascading failure is number one threat to stability, one layer can choke out other layers
Circuit breaker pattern: If app see an issue with one specific set of calls redirect to other part.. minimizes outage risk

The twelve-factor methodology

I. Codebase
One codebase tracked in revision control, many deploys

II. Dependencies
Explicitly declare and isolate dependencies

III. Config
Store config in the environment

IV. Backing services
Treat backing services as attached resources

V. Build, release, run
Strictly separate build and run stages

VI. Processes
Execute the app as one or more stateless processes

VII. Port binding
Export services via port binding

VIII. Concurrency
Scale out via the process model

IX. Disposability
Maximize robustness with fast startup and graceful shutdown

X. Dev/prod parity
Keep development, staging, and production as similar as possible

XI. Logs
Treat logs as event streams

XII. Admin processes
Run admin/management tasks as one-off processes

If it hurts, do it more often. The best way to avoid failure is to fail constantly

Service performance/uptime
software component metrics
system metrics
app metrics

5 Principles of log data
Do not collect log data if you never plan to use it
Retain log data for as long as it can be used
Log all you can, alert only what you must respond to, define log levels
Don't make logging more available than production stack
Make log changes as needed

Containers and Serverless (serverless might only run 1 invocation)

100:10:1  (Dev:Ops:Sec)
100 developers, 10 Ops, 1 Security person

The Rugged Manifesto:

I am rugged and, more importantly, my code is rugged.
I recognize that software has become a foundation of our modern world.
I recognize the awesome responsibility that comes with this foundational role.
I recognize that my code will be used in ways I cannot anticipate, in ways it was not designed, and for longer than it was ever intended.
I recognize that my code will be attacked by talented and persistent adversaries who threaten our physical, economic, and national security.
I recognize these things - and I choose to be rugged.
I am rugged because I refuse to be a source of vulnerability or weakness.
I am rugged because I assure my code will support its mission.
I am rugged because my code can face these challenges and persist in spite of them.
I am rugged, not because it is easy, but because it is necessary and I am up for the challenge.

Sunday, March 24, 2019

TWID March 24, 2019: Gout, Music Biz, Space 2.0, Luke Starkiller, space angels, DevOps Notes

This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these

Didn't do a TWID post for a couple of weeks, will continue regularly from this week on. Had an issue with my foot... still not sure if I sprained my toe or if it was gout. Didn't run for 3 weeks but started to run again this week. It feels good to run again in nature. This morning I heard so many woodpeckers

This Week I Learned

Finished the book Space 2.0: How Private Spaceflight, a Resurgent NASA, and International Partners are Creating a New Space Age
Some interesting stuff, I like how the cost went down a lot after SpaceX, Blue Horizon and others made the government contractor

Started on  the book Loonshots: How to Nurture the Crazy Ideas That Win Wars, Cure Diseases, and Transform Industries

Listened to the Tim Ferriss podcast with Safi Bahcall and in that podcast Safi mentioned that the 1st draft of Star Wars was so bad, no studio wanted it
It had these characters: Luke and Windy Starkiller.  Lol can you imagine those names having made it into the movie

Summary of the Original Script of “The Star Wars”:

Listened tot the final episode of East Coast vs West Coats Business Wars

Learned some stuff about how it is changing how artists get paid in the music industry. Artists used to be paid by album, now they are paid by the song, 1500 streams is about $9, this is cut between label/produces/songwriter. Since artists are paid by song.. , songs are getting shorter and an album will have more songs. So if you listen through an album, you are listening to more songs.  Artist are also putting the chorus at the start of the song to hook you in, because if you skip before 30 seconds or so, the play doesn't count.

Gompertz function
The Gompertz curve or Gompertz function, is a type of mathematical model for a time series and is named after Benjamin Gompertz (1779-1865). It is a sigmoid function which describes growth as being slowest at the start and end of a given time period

One example: Mobile phone uptake, where costs were initially high (so uptake was slow), followed by a period of rapid growth, followed by a slowing of uptake as saturation was reached.

The Fertility Doctor’s Secret
Her husband had given her a DNA test for Christmas because she was interested in genealogy. Her heritage turned out to be exactly what she had thought—Scottish, with English, Irish, and Scandinavian mixed in—and she never bothered to click on the link that would show whether anyone on the site shared her DNA.

Apparently she did have relatives on—and not just distant cousins. The people now sending her messages said they were Cline’s secret biological children. They said their parents had also been treated by Cline. They said that decades ago, without ever telling his patients, Cline had used his own sperm to impregnate women who came to him for artificial insemination.

According to her DNA, Woock, too, was one of his children.

This so messed up, and with more and more people doing DNA testing, I think this will only increase. 

But there is a person who has 600 offspring, his name is Bertold_Wiesner

Space Angels

Space Angels is Venture Capital firm, they invest in SpaceX as well as the ones in the list below and more

Accion Systems
Accion Systems is developing revolutionary ion beam propulsion technologies for satellites, that are light, powerful, and affordable.

Analytical Space
Analytical Space is developing a cost-effective, high-throughput satellite data relay service using Cubesats with laser downlink capabilities.

Astrobotic Technology
Astrobotic will be the first private company to regularly deliver customer payloads and communication services to the Moon's surface.

Atlas Space Operations
ATLAS' network of RF satellite ground stations will offer reliable delivery of big data from LEO satellites at one-third of the cost of legacy providers.

Because Learning
Because Learning is an interactive STEM platform that enables any school to run experiments from Earth to space, through the Spire satellite network.

BridgeSat is developing an optical communications network that offers secure delivery of big data from LEO at low cost and high speeds.

NanoRacks is the leading commercial provider of hardware and services in low-Earth orbit for microgravity research and space station utilization.

Took some DevOps trainging this week... wanted to save the notes I took.. so I put them at the end of this post :-)

This Week I Tweeted

The lawyers who took on Big Tobacco are aiming at Realtors and their 6% fee 

Homeowners who are ready to sell their properties usually hire a real-estate agent to represent them by staging the home, photographing it, adding it to the MLS, marketing it, and showing it to prospective buyers. Sellers agree to pay that person a commission on the selling price of the home. That commission has traditionally been known as the “6%,” but it’s a little more complicated than that.

Sellers can really only negotiate with the agent they’ve hired, while agents representing buyers are generally assured of a standard 3% commission. That means that a seller’s agent who’s willing to negotiate, or one that works for a discount brokerage like Redfin RDFN, +2.93%  , will be paid less than a buyer’s agent.

Buyers can choose to be represented by an agent, or to go without one – but in any case, all commission money for both sides of the deal is always paid by the seller, thanks to a 1996 NAR rule known as the “Buyer Broker Commission Rule.”

I always thought it was strange that listing a 100K house and a 2 Million house would give you so much more money for essentially the same amount of work. Of course selling a million dollar home takes more time. Then there are people who will talk to an the house tours and not put a bid down with that agent.  If this prevails.. I wonder if the million dollar listing tv show will still be around?

Facebook Stored Hundreds of Millions of User Passwords in Plain Text for Years

Hundreds of millions of Facebook users had their account passwords stored in plain text and searchable by thousands of Facebook employees — in some cases going back to 2012, KrebsOnSecurity has learned. Facebook says an ongoing investigation has so far found no indication that employees have abused access to this data.

Facebook is probing a series of security failures in which employees built applications that logged unencrypted password data for Facebook users and stored it in plain text on internal company servers. That’s according to a senior Facebook employee who is familiar with the investigation and who spoke on condition of anonymity because they were not authorized to speak to the press.

This was maybe some logging, but still, this is bad

New Jersey becomes second state to ban cashless shops and restaurants

On Monday, New Jersey Governor Phil Murphy signed a bill banning cashless retail stores and restaurants in the Garden State. Murphy's signature makes New Jersey the second state in the US to ban cashless stores, after Massachusetts banned them in 1978.

More recently, New Jersey's move follows that of Philadelphia, which banned cashless stores earlier this month. Philadelphia's legislation was a reaction to a growing number of stores that only accept credit cards or require customers to pay with an app, like Amazon's new Amazon Go stores.

Ha, I ran into this the other day in Manhattan. Left the office with a $20 in my pocket, went to this place named Dos Torros with my co-worker, ordered a burrito and then couldn't pay, had to have my co-worker pay for me and then had to pay him back.  My main reason yo pay with cash in restaurants and smaller shops is that I don't want my credit card to be hacked, my next reason is privacy.

Also some people with bad credit might now have credit cards.. how would they pay?

I welcome this law.

Some cool stuff you might enjoy

Ten Lessons I Learned While Teaching Myself to Code

The following is a guest post by Clive Thompson (@pomeranian99), a journalist who’s written about technology and science for two decades. Clive is a longtime contributing writer for the New York Times Magazine and a columnist for Wired.

In his guest post, Clive outlines the most important lessons he learned teaching himself to code after interviewing 200+ programmers for his new book Coders: The Making of a New Tribe and the Remaking of the World.

So, you want to learn to code.

Join the club! We live in a time when, as the venture capitalist Marc Andreessen famously put it, “…software is eating the world.” So the people who know how to program are in a catalytic spot; they can make things happen. Maybe you’ve watched this from the sidelines and thought: Huh. Could I learn to do that? Perhaps you’re out of school; maybe you can’t afford either the money or the time to go back and do a four-year degree in computer science. You’ve seen a zillion of these online tutorials in coding. Could you just sort of, well, teach yourself?

The short answer is: Sure you can.

The longer answer is… the rest of this essay.

Some interesting tidbits

Some numbers that you will know by heart if you have been working with SQL Server for a while

I was troubleshooting a deadlock the other day and it got me thinking.... I know the number 1205 by heart and know it is associated to a deadlock.  What other numbers are there that you can associate to an event or object or limitation. For example 32767 will be known by a lot of people as the database id of the ResourceDb, master is 1, msdb is 4 etc etc.

A fun and quick posts with some numbers that most SQL Server peeps probably know

Some DevOps notes I took
Had some DevOps training, took some notes, didn't know where to save them, so put it here


DevOps Principles 3 ways
System Thinking  (concept to cash)  aka overall view
Amplified feedback loop  (later you find the bug.. the more it costs to fix)
Work culture to allow for learning and continues experimentation (fail fast, working code wins..sharing..)

Five Methodologies
People over process over tools
Continues Delivery
Lean management (small batches, progress limits, feedback loops, visualization)
Visible Ops Change Control (repeatable build process, manage dependencies, eliminate fragile artifacts, continues improvement)
Infrastrucure as code

10 practices for DevOps success
Incident command system
Developers on call
Status pages (transparent uptime)
Blameless postmortems
Embedded teams
The Cloud
Andon Cords (anyone can stop the release, this way something doesn't go to prod)
Dependency Injection (Inversion of Control)
Blue/Green deployment (2 system, 1 live, the other is not..deploy changes and shift traffic towards it, if problems shift back to prev version)
Chaos Monkey (trash servers occasional so that you can code for it and be prepared in case it happens out of your control.. came from Netflix)

DevOps Tools ... cart or horse?
Toolchain... that works together
Should be programmable.. no UI tools
Well behaved (from dev and operations point of view)
Write own tools if you need to....

Sunday, March 3, 2019

TWID March 3, 2019: Death by GPS, Python tool vs code, Alexa + Jenkins, Job Red Flags, Game of Thrones Fantasy League

This is a post detailing some stuff I did, learned, posted and tweeted this week, I call this TWID (This week in Denis). I am doing this mostly for myself... a kind of an online journal so that I can look back on this later on. Will use the label TWID for these

This Week I Learned

Finished the Pluralsight course Applying SQL Server 2016 Features to Real-world Data Problems by Ana Voicu

Death by GPS refers to the death of people attributable, in part, to following GPS directions or GPS maps. Death by GPS has been noted in several deaths in Death Valley, California; a lost hiker at Joshua Tree National Park in southeastern California; and incidents in Washington State, Australia, England, Italy and Brazil.

Got to the wikipedia entry after reading some comments on this link on hackernews: The Hunt for the Death Valley Germans

This Week I Tweeted

Python in Visual Studio Code – February 2019 Release

Test Explorer
This release includes the ability to visualize, navigate and run unit tests through a test explorer, a feature that is commonly requested by our users.

Validated breakpoints when debugging
This release also includes an enhancement to the debugger: validation of breakpoints targets. If a breakpoint is set on a line where breakpoints are invalid (e.g. blank lines, pass statement, lines in the middle of a multi-line statement), then it’s automatically moved to the nearest preceeding valid line

The team keeps cranking out more awesomeness every month

Jenkins + Alexa: Say Hello to Voice Controlled CI/CD 

Alexa (named after the ancient library of Alexandria) is Amazon’s Artificial Intelligence (AI) powered intelligent voice assistant that runs in the cloud. Software engineers make Alexa smarter by creating apps, called skills. From the time that I developed my first Alexa skill, I dreamed of deploying my Java projects to the cloud via voice. For me, telling Alexa to deploy my code is the ultimate level of cool! I recently made my dream a reality when I devoted a weekend to developing my newest Alexa skill, DevOps Pal. In this blog, I will show you how I developed DevOps Pal and hopefully inspire you to build your own version.

LOL, I have Alexa at home.. but I mostly use it to listen to Music. I am just wondering if they did this because they could and not because this is actually useful. Our builds build upon checkin (on dev, qa/test is scheduled), not sure why you would want to initiate it

Red Flags in Software Developer Job Descriptions

For some reason I’ve been reading a lot of job descriptions for junior devs lately and that has naturally left me with an inordinate number of opinions. I have, with great effort, condensed them here for you, dear reader.

The following aren’t pulled from any specific listings because these types of awfulness transcend the individual - and because that would be dickish. But their spirit should ring true to anyone in the trenches of the job search process.

“Technologies: Coldfusion + jQuery”
Your job search shouldn’t be driven by what’s fashionable in tech, but popularity and the market for a skill are important factors, since they influence a career track’s employability and profitability. The market for Coldfusion devs isn’t too hot (or even a thing) and jQuery simply doesn’t have the complexity or potential power of a full JS MVC. Companies advertising outdated stacks open you up to the risk of building the wrong sorts of skills, which can have far-reaching effects on your career.

One thing that caught my eye was  Coldfusion + jQuery, this is the stack that DJindexes website was built on so had to go and troll my ex co-workers  haha. One reply I got was: All of these jobs sound very interesting to me. Do they have any COBOL and JCL openings?

See also the comments on hackernews here:

By now, it's not much of a secret that Motorola is working on a folding phone of its own: A patent for such a device surfaced late last year, and a subsequent report in The Wall Street Journal basically confirmed the company's plans. Despite the ensuing hype, Motorola has mostly kept quiet about its progress, but in an interview with Engadget this week, Motorola VP of Global Product Dan Dery shed some additional light on the company's ambitions.

"We started to work on foldables a long time ago," Dery said. "And we have been doing a lot of iteration."

Oh man.. now everyone is jumping on this bandwagon??  What happens when you only crack one screen? This still seems idiotic to me, especially at that price point that Samsung has.

This CTP 2.3 preview brings the following new features and capabilities to SQL Server 2019:

Big data clusters
Submit Spark jobs on SQL Server big data clusters from IntelliJ
Application deployment and management experience for deploying a variety of data-related apps including operationalizing machine learning models using R and Python, running SQL Server Integration Services (SSIS) jobs, and more
Database engine
Accelerated database recovery to provide constant time recovery and instant rollback for long running transactions
Performance enhancements in query plan recompilations, transaction log management, and Query Store
SQL Graph enhancement to enable cascaded deletion of edges upon the deletion of nodes
SQL Server Analysis Services (SSAS)
Calculation groups in tabular models that reduce the number of measures by reusing calculation logic

Installed on Sunday morning..checking out what is new and shiny. One thing that Brent Ozar noticed was the is_result_set_caching_on as a new column in sys.databases. So far I haven't heard yet how to turn it on

Some cool stuff you might enjoy

Finished The Annotated Turing: A Guided Tour Through Alan Turing's Historic Paper on Computability and the Turing Machine by Charles Petzold. a little dry at times.. but if you like math or want to learn about Turing machines, this book is for you

There is a Game Of Thrones fantasy league? 

I signed up and created a league with a bunch of co-workers
Here is how some of the scoring works


10 Kill Random Character / White Walker / Wight (capped at 50pts)
15 Kill White Walker
25 Kill Known or Drafted Character
150 Kill Dragon
5 Incapacitate Random Character (not killed)
10 Incapacitate Known or Drafted Character (not killed)
25 Exit Bonus for Drafted Character Dying Memorably


200 Take the Iron Throne
25 Sack a City / Lead a Battle Victory (must be present at victory)
25 Get a Seat on the High Council
50 Magic Use (1x Episode / Character)
50 Gain ownership of Valyrian Steel (Must keep through end of episode)
20 Have a Vision/Prophecy (1x / Episode / Character)
15 Take up a Weird/New Religion
10 Get Engaged
20 Get Married
15 Get Pregnant/Get Someone Pregnant
-20 Lose a Baby
25 Official Promotion
-25 Official Demotion
50 Come Back from the Dead
15 Act of Betrayal
15 Form / Join existing alliance
20 Ride or Control Dragon (1x / Episode)
20 MVP of Episode (Scorekeeper's Choice)
50 Revealed as Azor Ahai

I just love Times Square, here is a panorama I took'

Times Square Panorama