Scheduling dbt with GitHub Actions: Pros & Cons
20/02/2024 18:11
Scheduling dbt with GitHub Actions: Pros & Cons
A step-by-step illustration...
Articles
ETL vs ELT
06/08/2023 10:58
Extract, transform, and load (ETL)
Synapse Analytics
Data Factory
A common problem that organizations face is how to gather data from multiple sources, in multiple formats. Then you'd need to move it to one or more data stores. The destination might not be the same type of data...
Forbes - Single Version Of Truth: Why Your Company Must Speak The Same Data Language
11/07/2020 19:54
A group of executives came together to discuss important issues that were challenging their fast-growing organization but soon discovered they weren’t speaking the same language. While they could understand the words coming from each other’s lips, there was a problem with the foundation of their...
What's stopping cloud adoption?
23/09/2019 19:41
What's stopping cloud adoption?
Understand why companies are not adopting cloud as a solution and the recommendations
It’s going to the point I had spoken about reducing data architecture redesigned.
https://www.youtube.com/watch?v=I4ATzBFyyYs
What is Cloud...
Will Big Data Replace Data Warehouse?
23/09/2019 17:48
I have often come across this question – at times as a direct question from few of my colleague and also at times as a point of discussion while designing business intelligence system for the clients.
Data warehousing is the buzzword for the past two decades and big data is a hot...
Azure Data Box Edge Appliance Now Commercially Available
13/08/2019 20:48
Microsoft on Tuesday announced the general availability of Azure Data Box Edge and Azure Data Box Gateway.
Azure Data Box Edge is a "1U rack-mountable appliance" made by Microsoft that can be used to help with compute and storage tasks before transferring data to Azure datacenters. Azure...
SQLite - Small and Super Power
27/06/2019 19:38
It is easy to use, portable and integrates directly with applications. It is a serverless self-contained database engine and is great for development and testing so if you want a ‘lite’ solution for applications and just want something small scale then it is great. If you need a...
SQL 2016 - New Features
26/08/2018 13:08Microsoft - Azure Discovery Days
26/08/2018 12:59
Conclusion:
In my point of view, cloud, in general, it can significantly reduce the CAPEX, however, it depends on the projects. We should consider that solution for a new infrastructure/startup investment instead of in-premises or companies...
Set Up the Backup routine using the Windows Schedule Task - SQL Express
12/05/2017 16:48
1º - Prepare the database objects on Master DB
-------------------------------------------------------------------
USE [master]
GO
/****** Object: StoredProcedure [DBO].[spMaintenance] Script Date: 13/02/2017 11:16:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...