Databases

November 8th, 2023, by
Processing and Analysing real time transactional data in AWS using API, DynamoDB and Glue

This blog talks about how data can be processed in AWS using some of its serverless and API services.

Read more
September 7th, 2023, by
Merging Worlds: How Integration Developers and Data Engineers are Unifying in Enterprise Architecture

In the ever-changing world of architecture, it's becoming increasingly apparent that traditional roles and responsibilities are starting to merge.

Read more
June 24th, 2022, by
Create a dacpac for SQL Server 2022 databases using SQL package

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.

Read more
June 23rd, 2022, by
Azure Synapse Pathway or how to easily migrate your Data Warehouse

Here's a preview solution that comes to make life easier for organizations that want to modernize their data warehouses by moving them to the Microsoft Cloud.

Read more
June 20th, 2022, by
Azure Table Storage or Azure CosmosDB Table Storage

The title presents two components that sound very similar, although each one has certain unique characteristics and it is thanks to them that they allow a very wide scope of use cases to be covered. 

Read more
February 21st, 2022, by
Whitepaper – Choosing your data service in cloud for migrating datasets

In this whitepaper, we present some best practices that can be applied to various Data Migration scenarios to avoid some common pitfalls.

Read more
October 15th, 2021, by
Extract nested JSON data from an API and load into Azure Synapse Analytics using Azure Data Factory

In this blog, I will show you step-by-step of extracting nested JSON data from REST API and loading into Azure Synapse Analytics using Azure Data Factory.

Read more
May 7th, 2021, by
Top 5 SogetiLabs blogs from April 2021

Take a look at our most read and shared blog posts from April 2021.

Read more
May 5th, 2021, by
Azure IoT Hub DPS or how to automate the subscription of your IoT devices in Azure

During the last few months I have completed a couple of posts about Azure IoT, and as the saying goes: " no two without three ". So, here comes the third!

Read more
April 28th, 2021, by
Do we automate for the right reasons? – How to make your employees feel super-empowered

the ones that are focused on implementing automation because they want to make their employees empowered are the ones that succeed.

Read more
April 27th, 2021, by
Azure IoT Hub, continuing the adventure

A few days ago I finished the first Azure IoT Hub practice, and the next step I commented was to collect all the raw data in an Azure Data Lake Gen2.

Read more
April 20th, 2021, by
Microservices: Code for resilience, design for failure

One of the biggest challenges to overcome is the extra complexity in both infrastructure and application logic.

Read more