Season’s Greetings from the Ascent Technology Team
Table of Contents
VENDOR RELATIONSHIPS
FROM THE DESK OF THE MD
Microsoft Tiered EA/MPSA Pricing Ends – Explore the CSP Advantage
Standardised pricing replaces tiered discounts — many organisations are reviewing CSP for cost and flexibility benefits. Microsoft Tiered EA/MPSA Pricing Ends Microsoft will remove tiered discounts for Online Services under Enterprise Agreement (EA) and Microsoft...
Why Database Auditing Is No Longer Optional
In an era defined by relentless cyber threats and tightening regulatory demands, organisations can no longer afford to treat database auditing as optional. From sensitive customer records to financial data and IP, databases are prime targets - and without proper...
Why Database Auditing Is No Longer Optional
In an era defined by relentless cyber threats and tightening regulatory demands, organisations can no longer afford to treat database auditing as optional. From sensitive customer records to financial data and IP, databases are prime targets - and without proper...
CAMPAIGNS
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....
Prepare for Windows Server 2012 End of Support
On October 10, 2023, support for Windows Server 2012 and 2012 R2 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...
NEWSFLASHES
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...
Ascent Technology’s clients benefit from Database Administration Outsourcing
Ascent Technology's proven database services model enables clients to Co/Outsource the daily maintenance, management and support of their database environments on a 24/7 basis. The active monitoring, preventative maintenance and management ensures optimal performance....
CLIENT CASE STUDIES
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
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, 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.