preloader

VENDOR RELATIONSHIPS

FROM THE DESK OF THE MD

From Complexity to Clarity – Why Microsoft Fabric Matters Now

From Complexity to Clarity – Why Microsoft Fabric Matters Now

Discover why Microsoft Fabric is central to Microsoft’s Data & AI strategy, and how Ascent Technology helps organisations unify data, simplify operations, and achieve AI-driven success. Key Takeways Microsoft Fabric unifies data on a single platform, eliminating silos...

Building the Microsoft Cloud Foundation for AI Success

Discover how Ascent Technology’s Modernise–Optimise–Protect framework, powered by Microsoft Fabric, OneLake, and Copilot, builds secure, AI-ready platforms that unlock business value. Key Takeways AI success starts with a modern, unified foundation – Microsoft Fabric...

Transitioning from Microsoft EA to CSP

Explore why Microsoft is moving Enterprise Agreement (EA) clients to the Microsoft Cloud Solution Provider (CSP) model, and how Ascent Technology ensures a smooth, strategic transition. Key Takeaways Microsoft is shifting Enterprise Agreement (EA) customers toward the...

CAMPAIGNS

Azure by Credit Card vs CSP: Why Finance & IT Prefer CSP

Azure by Credit Card vs CSP: Why Finance & IT Prefer CSP

Still paying Microsoft for Azure by credit card? Discover why finance and IT leaders prefer the CSP model for predictable billing, built-in partner support, cost optimisation, and long-term value. Key Takeways Credit card billing creates risk - Failed or expired...

Prepare for SQL Server 2014 End of Support

On July 9, 2024, support for SQL Server 2014 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and innovation....

Prepare for SQL Server 2012 End of Support

On July 12, 2022, support for SQL Server 2012 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and innovation....

NEWSFLASHES

Microsoft Tiered EA/MPSA Pricing Ends – Explore the CSP Advantage

Microsoft Tiered EA/MPSA Pricing Ends – Explore the CSP Advantage

Standardised pricing will replace Microsoft’s long-standing tiered discount model - prompting many organisations to review the CSP programme for its cost savings, licensing flexibility, and simplified management. Microsoft Tiered EA/MPSA Pricing Ends Microsoft will...

Ascent Technology’s clients benefit from Data Platform Modernisation

Facing platform ‘end of life’ issues together with increasing pressures to digitise processes, increase profitability and innovate on product and service, organisations are finding Data Platform Modernisation projects can deliver significant value by enabling IT cost...

CLIENT CASE STUDIES

DB Administration, Security and Compliance for First Distribution

DB Administration, Security and Compliance for First Distribution

First Distribution’s Database Administration, Security and Compliance needs lead it to trusted advisor, Ascent Technology. For any large organisation, Database Administration (DBA) is a vital part of maintaining their Data Platform Operations effectively. As it has...

Ascent Technology helps Bidfood SA migrate to Microsoft Azure

When Bidfood SA chose to modernise and migrate its data platform to Microsoft Azure, it turned to Ascent Technology for help. In a world that is digitally transforming, it is more vital than ever to an organisation’s success to utilise the latest platforms to drive...

Ascent Technology helps migrate Phumelela Gaming to Azure

A Windows Server and SQL Server consolidation, optimisation and migration to Microsoft Azure enables the company to reduce costs, modernise its data platform and boost its innovation capabilities. As an operator running two distinct betting businesses, Phumelela...

AWARDS AND ACCOLADES

Microsoft Data and Analytics Partner of the Year Finalist

Microsoft Data and Analytics Partner of the Year Finalist

Ascent Technology continues its strong showing in the Microsoft Partner of the Year awards, as a finalist in the Data and Analytics Partner of the Year award. Finalist Data and Analytics Partner of the Year "It is always gratifying to be recognised by Microsoft as one...

PostgreSQL

PostgreSQL, now supported by Ascent Technology

15 Jun 2017

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.

It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting.

It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

For more information visit PostgreSQL.org