We are glad to release the new major version of advanced Firebird (2.5 and 3.0) distribution: HQbird 2018. The key new features are the following:
- Online initialization of asynchronous replication (in the Enterprise edition). Now it is possible to initialize and re-initialize database replicas with zero downtime of the master server.
- Automatic performance monitoring (in all editions), with the performance reports which show the slowest and the most frequent SQL queries, and with the advanced monitoring of long-running active transactions.
- Pool of connections for external statements (for version 2.5) which greatly increases the performance of Execute On External statements
- Pool of prepared statements (for version 3.0) which greatly improves the performance in case of frequent parametrized queries
- New version of Firebird SQL Studio, now with the support of encrypted databases
Please refer to HQbird User Guide for more details!
For those, who downloaded trials of previous HQbird versions: we have reset all previous trial registrations to the end of December 2017.
All registered users of HQbird 2015, HQbird 2016 and HQbird 2017 will receive the free upgrade to HQbird 2018!
For Windows users – it is possible to install HQbird 2018 over the existing installation and keep the configuration.
HQbird 2018 comes in 3 editions:
- Standard ($399): automatic backups, automatic maintenance, and automatic performance monitoring
- Professional ($599): Standard + Recovery tools (FirstAID Tech Support) + SQL Studio.
- Enterprise ($799): Professional+ replication (asynchronous and synchronous)
More details here: https://ib-aid.com/en/hqbird-features
Please feel free to ask any questions through email email@example.com
It is easy to get a powerful server if you are ready to spend many $$$: there are leading vendors like Dell, HP, and many less known hardware companies, they will be happy to sell you a powerful machine.
However, money is always a problem, especially for small businesses and start-ups, so there is a great demand for «good-enough» cheap solutions.
The new article from IBSurgeon describes the practical approach for building «good-enough» database server with the sufficient performance for small business. It also contains calculations and links to the specific products we recommend.
As you know, recently several crypto viruses have attacked many companies – most well-known are Wannacry and Petya. Usually, as reported by many companies, it is necessary to pay a ransom, or, in the case of Petya, all encrypted files will be lost.
Read how we can defeat Petya:
HQbird 2017R2 is a major upgrade of advanced Firebird distributive (versions 2.5 and 3.0) with high-availability, replication, optimization, monitoring and recovery tools. Please upgrade the previous version of HQbird with 2017R2 (this upgrade is free for all users of HQbird).
This release includes a lot of improvements in replication, monitoring, and optimization, as well as many bugfixes. Windows installer now supports an automatic upgrade of the existing HQbird installation, Linux support for auto-upgrade will be released later.
The main goal of HQbird 2017R2 is to provide administrators and developers of big Firebird databases with effective management, maintenance, recovery, and optimization tools, in order to keep databases always healthy and available.
More details about HQbird: https://ib-aid.com/hqbird
We are proud to present IBSurgeon FirstAID 5.0 – the new version of the recovery software with the highest rate of successful repairs. FirstAID 5.0 is a major improvement: now it supports Firebird 3.0, InterBase XE7, and big databases (100Gb+).
Download IBSurgeon FirstAID 5.0
If you are a user of FirstAID version 3.x or 4.x, you can log into IBSurgeon Deploy Center and see that you were automatically upgraded to version 5.0. All your licenses were transferred to 5.0.
-50% upgrade offer till May 15
If you have the license for FirstAID version 1.x or 2.x (including Pack 3.x), or if you have used all licenses for 3.x/4.x, we would like to offer you 50% discount to upgrade to FirstAID 5.0 Tech Support (for 50 databases) for the special price: USD$99. This is a limited offer till May 15 only!
IBSurgeon has released the complete trial kit for Firebird encryption, which includes fully functional time-limited AES256 encryption plugin and demo application (in Delphi) to demonstrate how to connect to the encrypted database.
The trial kit is designed for the following:
1) Easy performance testing of the existing databases with the encryption: you can encrypt database on the server and test your existing applications without changing them.
2) Implement client-side security: there is a simple example of Delphi application (sources included) which demonstrates how to send the key from the client to the server.
Download Firebird encryption plugin and example of a client application.
Ransomware attacks became the serious problem for many companies: during the last week, we had 3 incidents from different customers which had their Firebird databases encrypted by ransomware viruses. Luckily we were able to help all of them, but the scale of the problem definitely increases.
Read new article: https://ib-aid.com/en/articles/how-to-protect-firebird-databases-from-ransomware/
New article from IBSurgeon: All Firebird and InterBase On-Disk-Structure (ODS) versions
It contains the list of ODS versions of all Firebird and InterBase releases, and describes their compatibility.
You can often see the following question in Firebird technical support groups: “What is the hardware of choice for the Firebird DBMS?”. This topic remains permanently popular because hardware requirements differ by tasks and hardware itself changes with time.
We in IBSurgeon decided to write Firebird Hardware guide in order to provide the necessary knowledge to anyone who wants to choose truly effective hardware for their Firebird database. To do it, you will have to learn some basic details on how Firebird, the operating system and, of course, hardware functions.