Yesterday, i came across a conversation in postgres slack channel, someone was interested in upgrading his database and i realised that there is a pattern i see all the time. Those who are interested in upgrading major postgres versions, only…
Ever wondered what program to use to open a huge sql (or any other text) file, when everything else fails (including Notepad++)? I recently had to review a 4.7GB sql dump file (mysqldump output) before trying to import it to…
Let's talk about an option that often confuses DBAs around the world. At least it confused me for almost a decade... COPY_ONLY backups and what you should know about them. There are numerous sources online for the various backup types that…
Transactional replication (as well as Replication in general) is still quit famous among SQL Server customers. The borderline, though, from becoming infamous is very thin... If you are the short-story type of reader, then you can skip the following paragraphs and go…
Sometimes we need to find all tables that match a name pattern, or all stored procedures/functions/views. Or even types. Unfortunately there is no single View that includes all of them together. We have to search through several system tables to…