Databusters - The Database Busters
  • About
  • Blog
    • Oracle
    • SQL Server
    • PostgreSQL
    • EU GDPR

Monthly Archives: January 2017

Home » Archives for January 2017

PostgreSQL upgrades – Methodology

  • January 25, 2017
  • vventirozos
  • PostgreSQL
  • 0 Comments

 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…

Read More→

How to open a huge sql file

  • January 24, 2017
  • Konstantinos Katsoridis
  • Blog
  • 0 Comments

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…

Read More→

SQL Server COPY_ONLY backup – Don’t be confused!

  • January 10, 2017
  • Konstantinos Katsoridis
  • SQL Server
  • 0 Comments

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…

Read More→

Practical advises for Transactional Replication

  • January 2, 2017
  • Konstantinos Katsoridis
  • Blog, SQL Server
  • 0 Comments

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…

Read More→

Find several user defined objects inside your database

  • January 2, 2017
  • Konstantinos Katsoridis
  • SQL Server
  • 0 Comments

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…

Read More→

Support for ORACLE Databases running on Docker

  • January 2, 2017
  • Theodore
  • Blog, Oracle
  • 0 Comments
Until recently Docker was not an officially supported visualization platform by ORACLE.
Read More→
Recent Posts
  • Tuning checkpoints
  • Comparing pg 9.4 with pg 12, CTE edition
  • Accessing PostgreSQL data from AWS Lambda
  • CVE-2019-10164 Who’s affected and how to protect your systems.
  • Managing xid wraparound without looking like a (mail) chimp
Recent Comments
    Archives
    • October 2019
    • July 2019
    • June 2019
    • February 2019
    • January 2019
    • November 2018
    • September 2018
    • May 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • March 2017
    • January 2017
    • December 2016
    • May 2016
    Categories
    • Blog
    • Docker
    • Hints & Tips
    • Oracle
    • PostgreSQL
    • SQL Server
    • Useful stuff
    Meta
    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    Do you have a question?

    Your Name (required)

    Your Email (required)

    Subject

    Your Message