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

Monthly Archives: June 2017

Home » Archives for June 2017

Transactional Replication – Follow the Data

  • June 23, 2017
  • Konstantinos Katsoridis
  • Useful stuff
  • 0 Comments

I have just come accross a very well-written paper about SQL Server Transactional Replication. More specifically about how data travel from one end to the other. I highly recommend it to anyone intrested. Just follow the link below.

Read More→

two-way replication in SQL Server? Piece of cake

  • June 22, 2017
  • Konstantinos Katsoridis
  • Blog, SQL Server
  • 0 Comments

Two-way replication, bi-directional replication -call it anything you like- is a very nice feature of SQL Server that allows you to take full advantage of SQL Server’s Transactional replication. And in both directions!

Read More→

PostgreSQL on ZFS with BPF tracing on top.

  • June 16, 2017
  • vventirozos
  • PostgreSQL
  • 0 Comments

At OmniTI we love solaris, my personal favourite features are ZFS and DTrace. Unfortunately not many run postgres on solaris so i have decided to implement similar features in linux. Instead of Dtrace i'll install BPF, in-kernel bytecode that can…

Read More→

An unusual upgrade

  • June 10, 2017
  • vventirozos
  • PostgreSQL
  • 0 Comments

I have mentioned in previous posts that in my 4 years with OmniTI, we've tackled a lot of migrations. Most of them are usually the "typical" procedure. The methodology we use is more or less explained here. Last week we…

Read More→

Tip for faster wal replay on a slave

  • June 9, 2017
  • vventirozos
  • PostgreSQL
  • 0 Comments

I've been in situations where i need a slave db to replay a lot of wal files fast, and by a lot i mean tens of thousands. This could happen because of a reporting database refreshing or simply because a…

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