Erik Veerman's Blog

Retain your customers with AI

What is churn? Customer churn is a well known phenomenon in many businesses. In fact, in virtually every single one that you may imagine, since every business has customers and sells “stuff” to them. What is sold is irrelevant for the fact that the customer is always present. Even if the business is B2B, there […]

The post Retain your customers with AI appeared first on SolidQ Blogs.

Debugging applications against production data: obfuscation and GDPR

Organizations often need to debug production errors, which many times in the past has been done directly pointing development applications to the production database. This, which is in itself a malpractice, is one of the measures that comes to regulate the GPDR with force and is precisely one of the things we should never do.

The post Debugging applications against production data: obfuscation and GDPR appeared first on SolidQ Blogs.

GDPR implications and Database administration. Do you comply?

Do we need to hear more news of the fines, sentenced to those who do not apply GDPR regulations, in the media to take the necessary measures?

The post GDPR implications and Database administration. Do you comply? appeared first on SolidQ Blogs.

GDPR implications and Database administration, ¿do you comply?

Do we need to hear more news of the fines, sentenced to those who do not apply GDPR regulations, in the media to take the necessary measures?

The post GDPR implications and Database administration, ¿do you comply? appeared first on SolidQ Blogs.

Bloqueos Sch-S y Sch-M con tablas particionadas

En este post analizamos el impacto que lleva implícito el bloqueo Sch-S que se establece cuando lanzamos una select y a continuación, y de forma paralela, tratamos de lanzar alguna operación que lleve asociado un bloqueo de tipo Sch-M como puede ser un truncado a una partición de la tabla que se consulta. Supongamos el […]

The post Bloqueos Sch-S y Sch-M con tablas particionadas appeared first on SolidQ Blogs.

Not all virtual machines are the same

Lo que suele ocurrir es que cuando virtualizamos un SQL Server que teníamos en máquina física pasamos a disponer de una cantidad máxima o puntual de recursos (CPU/memoria/IO) sustancialmente distinta a las que teníamos en la máquina física.

The post Not all virtual machines are the same appeared first on SolidQ Blogs.

GPDR and HASH anonymisation

Before uploading all our data to the cloud, we must be well aware of GDPR (General Data Protection Regulation), a European regulation aiming to protect individuals in regards to how their personal details are processed and the free movement of data.

The post GPDR and HASH anonymisation appeared first on SolidQ Blogs.

GPDR and HASH anonymisation

RGPD Companies are increasingly choosing cloud services such as Azure or AWS that normally provide a flexible, profitable and scalable option to carry out their operations without the restrictions imposed by on-premise technologies. However, before uploading all our data to the cloud, we must be well aware of GDPR (General Data Protection Regulation), a European […]

The post GPDR and HASH anonymisation appeared first on SolidQ Blogs.

Network latencies over 1ms. Are they enough for a good SQL server performance?

Latencias de red < 1ms, ¿es suficiente para un buen rendimiento de SQL Server? oco a poco, a medida que el almacenamiento se vuelve más rápido, va popularizándose el almacenamiento SSD local, etc. los tiempos de acceso a disco van bajando sustancialmente.

The post Network latencies over 1ms. Are they enough for a good SQL server performance? appeared first on SolidQ Blogs.

Latency, the worst enemy for any Hybrid Cloud environment

In the last few years, we are increasingly finding more hybrid environments where some SQL Servers are being migrated to the Cloud. In these cases, other applications, services, ERPs or even SQL Server instances continue to be based OnPremise in the initial data center. This means that in the event of any connections between both environments, these will be restricted by bandwidth and higher latencies, as opposed to other connections that do not go across both environments.

The post Latency, the worst enemy for any Hybrid Cloud environment appeared first on SolidQ Blogs.