Among the activities I like in development is managing databases. My experience as a developer basically covers all banks, but my administration proficiency is only with Microsoft SQL Server, Sysbase and FirebirdSQL. When I say proficiency, I mean in-depth knowledge, risk management, performance tuning, baseline establishment, backup, disaster recovery, and unusual configurations. Lately I've been using the FirebirdSQL database a lot which is a feature-packed OpenSource database with a low learning curve. As it is a relatively unknown bank, I work in the community helping those who want to know it better. That's why I have this exclusive page that gathers information about what I think you might need.<\/p>\n\n\n\n
Before you ask me, why don't I do the same, that is, distribute knowledge about MSSQL and other databases? The answer is simple, proprietary databases like MSSQL, Oracle and DB2 you can buy for the knowledge and thanks to the certification it will be \u201cas good\u201d as the best certificate, on the other hand relational databases like FirebirdSQL and PostreSQL although there are courses and even certification, there is a very good, efficient collaboration ecosystem that more companies and developers are looking for solutions.<\/p>\n\n\n\n
Introducing the FirebirdSQL database<\/p>\n\n\n\n
Install on Windows<\/p>\n\n\n\n
Different versions of FirebirdSQL on the same Windows<\/a><\/p>\n\n\n\n Installation on Linux, is it better than Windows?<\/p>\n\n\n\n Charset and collate, what are they, what do they eat and where do they live?<\/p>\n\n\n\n Which charset should I use? ISO8859_1 WIN1252 or UTF8?<\/a><\/p>\n\n\n\n Creating a database, why bother with charset and page size?<\/p>\n\n\n\n What is the difference between a remote, local and embedded connection?<\/a><\/p>\n\n\n\n Using Zeos \u2013 ZQuery<\/a><\/p>\n\n\n\n Why should a DBA guide programmers to create parameterized queries?<\/a><\/p>\n\n\n\n Full backup and sweeping, which is the most efficient strategy?<\/p>\n\n\n\n Incremental backup, which is the most efficient strategy?<\/p>\n\n\n\n How to backup and\/or transfer user accounts<\/a><\/p>\n\n\n\n The data was written right in the bank, but why do others see wrong accents?<\/p>\n\n\n\n Debugging SQL Commands in FirebirdSQL<\/a><\/p>\n\n\n\n Using autocommit in my programs, is that good or bad?<\/a><\/p>\n\n\n\n Como extrair apenas o texto de um conte\u00fado RTF<\/a><\/p>\n\n\n\n Como extrair apenas o texto de um conte\u00fado HTML<\/a><\/p>\n\n\n\n Converter um texto em NUMERIC(18,2) ou NUMERIC(18,4) <\/a><\/p>\n\n\n\n Arredondamento do tipo ABNT em itens de servi\u00e7o NFs<\/a><\/p>\n\n\n\n Retornando apenas d\u00edgitos v\u00e1lidos de uma string<\/a><\/p>\n\n\n\n Colocando aspas simples numa string que talvez j\u00e1 tenha aspas tamb\u00e9m<\/a><\/p>\n\n\n\n Como converter um numero para texto formatado<\/a><\/p>\n\n\n\n Pegando o primeiro dia do m\u00eas de uma determinada data<\/a><\/p>\n\n\n\nFun\u00e7\u00f5es UDR ou PSQL para FirebirdSQL<\/h2>\n\n\n\n