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.
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!
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…
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…
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…