by Kate Loguteva | Dec 13, 2018 | Data Integration, Microsoft |
It is not uncommon for data warehousing to get the data from any possible source the organisation has. ETL developers like myself are enabling data collection from different database types, files and APIs. Recently I had to deal with something I haven’t came...
by Ben Lee | Sep 20, 2018 | Business Intelligence, Microsoft |
When you work with databases all day every day it’s easy to forget that many people new to the technology development space will not have used a relational database. Once I get over the moment of surprise, I think about the question if I wanted to learn now,...
by Kate Loguteva | Sep 11, 2018 | AgileBI, Analytics, Business Intelligence, Microsoft |
Microsoft has introduced a new feature of graph database in SQL Server 2017. This is not a new idea, graph platforms were on the market for a while now. I have decided to dive in to understand why graph databases are special and how they could be used in Business...
by Kate Loguteva | Aug 29, 2018 | Microsoft |
For the first time I am on the project that has big enough Data Warehouse tables that could be partitioned. While many data warehouses are big, in my previous projects a single table has rarely exceeded a few million rows, which means it is too early to think about...
by Kate Loguteva | Aug 2, 2018 | Business Intelligence, Microsoft |
Data Warehouse solutions often include several copies of the same structure, I mean Development, Production and often Test and Pre-Production environments. When the Data Warehousing team works on the new piece of requirements, they don’t want to put fully...
by Kate Loguteva | Jul 17, 2018 | CloudBI, Microsoft |
Azure has a Platform as a Service solution called Azure SQL Database, it’s when you have a database in a cloud and never worry about the infrastructure or anything else, almost like magic. But does it mean that database administrators have nothing to do anymore?...
