Ardent Insights

Data Warehousing Architecture: Azure SQL vs Redshift

There are quite a few different data warehouse technologies to choose from, and knowing where to start, what to look for, and what data warehouse service is going to be best for your business is key. Deciding on a data warehousing technology that is suitable to your business needs, goals and objective is essential as […]

Data Warehouse vs Database: The key differences

Cloud technology and advances in hybrid-storage technologies have meant that data storage is no longer left entirely to internal equipment and a single company-owned server. Finding a database management solution that works with the size and scale of your needs is not a task to be overlooked. […]

Building data pipelines – a starting guide

Data visibility can be a huge driving factor for organisation growth. Poor data visibility can lead to a lack of compliance with data security, difficulty in understanding business performance and increased complexity in dealing with system performance issues. Developing secure, robust and scalable data pipelines can empower businesses to gain data visibility by connecting the […]

Optimising SQL server schema – what you need to know

SQL Database is a collection of tables that stores a specific set of structured data. A database schema is a blueprint of the database, it essentially lays out and describes the relation of the data to other tables or data models and how it is organised. […]

Meet the team: Deepa Mhatre – Senior Software Developer

In our ‘Meet the team’ series we give you an insider’s outlook on life at Ardent. Today, we speak to Deepa, a brilliant Senior Software Developer who has been part of the Ardent family for almost eight years. Deepa as a woman in tech is an inspiration to us here at Ardent and to many […]

What is schema optimisation and why do you need to optimise your schema

When utilising cloud services and data warehouses, the relationships of your data forms will lead to the creation of a database schema. Simply put, a schema is an abstract design which represents the storage of the data in the database – the term applies to both the organisation of the data and how the tables […]