The South Atlantic Magnetic Anomaly


I cannot stop thinking… how does this affect us?

This is an area where Earth‘s inner Van Allen radiation belt comes closest to Earth’s surface, dipping down to an altitude of 200 kilometres (120 mi).

This leads to an increased flux of energetic particles in this region and exposes orbiting satellites to higher-than-usual levels of ionizing radiation.

Source: https://en.wikipedia.org/wiki/South_Atlantic_Anomaly

La Anomalia Magnetica del Atlantico Sur


No puedo dejar de pensar en… como nos afecta esto?

This image has an empty alt attribute; its file name is thesouthatlanticmagneticanomaly.jpg

Esta es un área donde el cinturón de radiación interior de Van Allen de la Tierra se acerca más a la superficie de la Tierra, descendiendo a una altitud de 200 kilómetros (120 mi).

Esto conduce a un aumento del flujo de partículas energéticas en esta región y expone a los satélites en órbita a niveles de radiación ionizante más altos de lo habitual.

Fuente: https://es.wikipedia.org/wiki/Anomal%C3%ADa_del_Atl%C3%A1ntico_Sur

SQL: How to combine multiple rows into one string


For some reason this is one of my most visited posts…

hvivani's avatarHernan Vivani's Blog

Spanish Version

The problem:

We may have several records belonging to a column or field that we want to concatenate and display in a single string. Something like this:

description
===========
value1
value2
value3

and we want to get something like this:

value1, value2, value3

that is, as if we had to transpose the column, but without complicating ourselves.

The solution is:

DECLARE @values VARCHAR(1000)
SELECT @values= COALESCE(@values + ', ', '') + description FROM folders
select @values as values

The magic is done by the COALESCE command that returns the expression that does not contain the NULL value among its arguments.

NOTE: This solution is valid only if no row is NULL.

View original post