Reporting and analytics computations are usually very resource-consuming, therefore they are never executed on the same server where the crucial business application is running. Instead, data is copied into dedicated servers to be dissected and studied for insights....
After a bit of inventive adjective use the other day I found out that the way you create new database tables in Sparx Enterprise Architect database models has an impact on whether or not you can specify an Identity column for a SQL Server database table. ...
My second full-time job was a data quality one back in 1989 (yep I am that old). Timberland the footwear company had massively diversified in the 80's adding clothing lines and opening their first branded store outside the USA - in London on Bond Street. The UK...
We live in the age of big data, we produce and collect more data then ever. Surely, just hoarding it doesn't make much sense, but a lot of valuable information could be extracted from it and used, for example, in the decision making process. Every organisation I...
I am currently working on a project that has chosen to use Varigence BimlFlex as the preferred tool to create and manage the data warehouse. BimlFlex is a data warehouse framework that allows you to model and build an end to end data warehouse solution using a...
Have you heard about the full stack web developers? Unlike those developers who are specialised in front-end or back-end, a full stack developer can do all of that alone. My area is databases. I'm quite confident in calling myself a relational databases specialist....
Whilst waiting for an invite to play with the preview version of AWS Data Lake formation I thought that I would get started with seeing how I could consume the data from a data lake and play with the Redshift Spectrum product from Amazon Web Services. Redshift...
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 across...
When it comes to the data storage in Business Intelligence, you have options of having an Operational Data Store (ODS), a Persistent Stage (PSA) and a Data Warehouse (DW); all of them are just databases though. I have noticed that sometimes these terms are used...
Imagine for a minute, a conversation between a database administrator and a data warehouse developer. DBA asks: "I could never understand what you folks actually do..?" - "Well, we create a single database called a data warehouse where the data from multiple other...