 | Our offices will be closed on Monday, 1st June 2020 We'll be back as usual for you on Tuesday 2nd June |
IBExpert and Firebird Monday get-togethers online - participation free of charge!
Due to the current challenges caused by the COVID-19 virus we are doing our best to be there for you even in these difficult times. Let's stay in touch and use this time for your further education. Every Wednesday we offer you all a joint IBExpert and Firebird online get-together with Holger Klemt.
Every Monday, for the forseeable future, we would like to offer all English-speaking customers, whether currently working from their home office or still having to travel daily to their company premises, regular IBExpert and Firebird online get-togethers with Holger Klemt, totally free of charge!
Topics on Monday, 8 June 2020, 18:00-20:00 local German time:
Timezone EDT for example New York -6 hours : 12:00pm | Timezone PDT for example Los Angeles -9 hours : 09:00am
- Internal structure of a database, record versions, transactions etc.
- Data types, data model and physical effects
- Recommendations table design, blobs also for replication/branch office connections
- FK illustrations or alternatives using own tables
- Effect of blobs/CHAR/VARCHAR on the network
- SQL Design (parameterized or not, PREPARE)
Register by Smartphone or from your PC using the following link: https://www.gotomeet.me/ibexpert
Important: please register with your full name (rather than a nickname), and if you would like access to the video recording please also register your e-mail address.
With GoToMeeting you can follow on your monitor what Holger is currently showing on his screen, and ask questions, join in the conversation or make your own suggestions for topics in the chat room.
The online channel will be open from 17:50 for your registrations, at 18:00 we'll start.
We look forward to your registrations and please stay healthy!
New IBExpert Version 2020.05.12 available
New features include:
- Code Editor: Parameter hints for new Firebird 4 functions; highlighting of new Firebird 4 keywords and reserved words.
- Database Statistics: Improved statistics parsing, support of additional statistics data (Firebird 3, 4) in the table/index grids.
- Script Executive: SET DBTRIGGERS ON/OFF directive implemented.
- Event Blocks: Process the Code completion list event block implemented.
- IBEBlock: New options for ibec_CompareTables and ibec_CompareMetadata.
- New IBEBlock functions: ibec_psql_Analyze, ibec_psql_Format and ibec_PrepareStatement.
Fully automated update process
As long as you have IBExpert Direct activated in your IBExpert application, you will automatically be informed of all new updates, and automatically directed to the IBExpert Download Center, as soon as they are available. You can find out more about IBExpert Direct in our online documentation.
Subscribe to our newsletter
As part of our commitment to GDPR, we would like to ensure that your email subscription permissions are current, and we need to verify that you want to keep receiving this information.
Log into your IBExpert Download Center account, click My Account (top right) then Change and activate the I would like to receive the IBExpert newsletter checkbox to subscribe. You will then continue to receive:
- Information about new IBExpert product releases and product updates
- Latest Whitepapers and case studies
- Invitations to events
- Special pricing promotions for IBExpert products
Has your subscription expired?
- Purchase your IBExpert 12 month software subscription by mailing sales@ibexpert.biz.
- Is your software still valid for an IBExpert subscription? Check our software conditions here.
IBExpert Benchmark Tool - Free special version
Compare your computer performance and test the speed of your Firebird Windows server with the free IBExpert Benchmark Tool. ... continue reading.
New: Firebird IFS Basis Rack Server now also with Windows Server operating system
The newest generation of our Firebird IFS Rack Server 2020 can now be ordered as a basic version with Microsoft Windows 2019. We offer the server as follows: Firebird IFS2020MW with 500GB SSD storage space for databases and backups at a price of EUR 2,490 in a 1.5U rack case. The price includes a Firebird optimized Windows 2019 Essentials operating system installation. The server is designed for a maximum of 25 users. ...continue reading or download the PDF version.
New IBExpert Version 2019.11.13 available
The free IBExpert Personal Edition and the IBExpert Developer Studio full versions now include a free IBExpert Watchdog Version S in the Tools directory. The S version may also be distributed free of charge.
This year's Firebird Conference from October 17 - 19, 2019 in Berlin, will feature highly interesting topics dedicated to large Firebird databases.
Be sure to make a note: By Holger Klemt and Christian Diercks: Advanced IBExpert
 | Advanced IBExpert - See the possibilities in IBExpert for your daily administration work - IBExpert IDE features you might not know - Drag and drop - Debugging and logging, monitoring and trace API - Customizing the IDE, on connect scripting - The user database and what you can do with it - Interactive metadata and data comparer - Database inside, repair corrupt databases, when Gfix etc fails - Running scripts from IDE, command line or DLL - New product: IBExpert Watchdog |
Further top sessions from IBExpert
 | Advanced IBExpert Scripting - How to automate your daily tasks with IBExpert tools and IBEBlock scripting - Connect a script to ODBC and Firebird, switching between connections - Advanced exception handling in IBEBlock scripts - INSERTEX and EXPORT AS - Convert your database from any Charset to UTF8 or other using IBEBlock scripting - Load and save blobs and files - Load data from internet URLs and process - ibec_RecompileTrigger, ibec_RecompileProcedure, ibec_CompareMetadata, ibec_ExtractMetadata - ibec_CompareTables - OEM and IBExpert Server Tools licensing |
All IBExpert software products and software subscriptions will be offered at a 50% discount only at the Firebird Conference.
- You can order directly at our conference stand (offer also applies to early renewal of your software subscription) and pay cash or with your VISA/MC/EC card.
- If you are not allowed to place orders for your company yourself, you can obtain an order form at our stand to use for your purchase at our special prices until 30.10.2019.
- The order form may also be used to extend your current valid IBExpert Software subscription at the special rates.
(All prices are prepayment prices plus VAT. Please send your completed and legally signed order form by e-mail to the address given on the form.)
Register now so that you do not miss any of our top topics.
This year's Firebird Conference will focus on Firebird 4 and include a series of workshops: advanced presentations and practical exercises. We want to make it more educational, more practical, and less theoretical.
Direct links to the organizer’s sites:
FBCon 2019: Early Bird registration ends May 31, 2019
IBExpert is a silver sponsor of this year's FBCon 2019 in Berlin!
We look forward to seeing you October 17th to October 19th, in Berlin, Germany, at the hotel Holiday Inn Berlin City East - Landsberger Allee.
Find out more about the conference and book your place here: https://firebirdsql.org/en/firebird-conference-2019/
IBExpert and Firebird Workshop
Firebird Administrator intensive training focusing on speed, security and interfaces.
In our workshop we focus on the tasks an administrator needs to perform to effectively operate a Firebird server. The aim is to achieve the optimum speed for the hardware and software used, to guarantee maximum operational reliability, and to be optimally prepared for a breakdown by means of a suitable worst-case scenario. We will also concentrate on the independent implementation of simple requirements in the areas of import, export and reporting.
The workshop will also include the presentation of our new tool IBEGbak.exe. This tool can greatly speed up the runtimes of your backups and, in particular, the restore process to a backup server.
IBExpert und Firebird Power Workshop
16th-17th April 2019, 9am-5pm, language: German, Holiday Inn Express Frankfurt Airport, Germany
24th-25th April 2019, 9am-5pm, language: English, Holiday Inn Express Frankfurt Airport, Germany
10th-11th June 2019, 9am-5pm, language: Indiegrove, 121 Newark Ave 5th Floor, Jersey City, New Jersey 07302 United States
We are also happy to come to you! Our workshops can be booked as company training and all topics can be customized to fit your requirements. Too little time? All workshops are also possible as remote training!
Firebird 4.0 Beta 1 release is available for testing
The Firebird Project announces the first Beta release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing.
This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with countless bugfixes. ... continue reading on the firebirdnews.org website.
Please read the Firebird 4.0 Release Notes carefully before installing and testing this Beta release.
IBExpert and Firebird Power Workshops 2019
Firebird Administrator intensive training focusing on speed, security and interfaces.
In our Firebird Power Workshop we focus on the tasks an administrator needs to perform to effectively operate a Firebird server. The aim is to achieve the optimum speed for the hardware and software used, to guarantee maximum operational reliability, and to be optimally prepared for a breakdown by means of a suitable worst-case scenario. We will also concentrate on the independent implementation of simple requirements in the areas of import, export and reporting.
- 16th-17th April 2019, language: German, Holiday Inn Express Frankfurt Airport, Germany
- 24th-25th April 2019, language: English, Holiday Inn Express Frankfurt Airport, Germany
- 10th-11th June 2019, language: English, New Jersey City, NJ, USA
Registration by phone: +49 (0) 4407 3148770 or by e-mail to sales@ibexpert.biz. We are also happy to come to you! Our workshops can be booked as company training and all topics can be customized to fit your requirements. Too little time? All workshops are also possible as remote training!
Firebird 4.0 data types
TIME ZONE
Initial support in IBExpert since version 2018.12.15. Time zone support consists of TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE data types, expressions and statements to work with time zones and conversion between data types without/with time zones. Refer to TIME ZONE for details.
BINARY, VARBINARY, BINARY VARYING
IBExpert support since version 2018.12.15. Refer to BINARY, VARBINARY, BINARY VARYING (Firebird 4.0) for details.
DECFLOAT
Refer to DECFLOAT (Firebird 4.0) for further information.
Enhancement in precision of calculations with NUMERIC/DECIMAL (Firebird 4.0)
Since version 2017.12.03 IBExpert supports Firebird 4 NUMERIC/DECIMAL datatpes with a maximum precision fo 34 digits.
You can read the full Firebird 4.0 Release Notes for the Firebird 4.0 Alpha 1 Release here: Firebird 4.0 Release Notes.
The way to the Cloud and Firebird
A White Paper by Holger Klemt
The cloud does not mean loss of control, but can be a good addition to the existing infrastructure, or even a replacement, together with an independent, competent partner as consultant. Stay independent!
Read the full article here ...
IBExpert and Firebird News 01/2019
Our monthly newsletter was published earlier this week. If you haven't received it, please check your settings in your IBExpert Download Center account:
Log in to the IBExpert Download Center with your customer data, click on My Account (top right), then Change, and check the I would like to receive the IBExpert newsletter box to activate the free subscription. You will then receive our monthly IBExpert and Firebird news by e-mail, with information on new IBExpert product releases and updates, current white papers and case studies, information about our events, workshops and conferences and of course special IBExpert product promotions.
