Microsoft SQL Server Standard Edition has a great feature present in this basic license: Database Replication in Synchronous mode. To activate the database replication of a database from Primary Site (PR) to Disaster Recovery Site (DR) where the database to be replicated is called myDB the following simple steps must be performed: On PR site… Read More »
Snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database. The transaction itself will successfully commit only if no updates it has made, conflicts with any concurrent updates made since that snapshot. By using it, deadlock situations when a read operation (intense resource consuming operation)… Read More »
I got my EdgeRouter POE from UbiQuiti EdgeRouter, 5-port Router POE and came with the 24VAC power supply. Because the Ubiquity devices are all using the strange low power POE for which 24VAC is enough they ship the EdgeRouter POE with the 24VAC power supply. As a result the device is useless in powering “normal”… Read More »
Sometimes you discover that you forgot to tag on CVS a test release that made it on the production system. The issue starts when you discovered that in the mean time you or someone else already added new functionality on the development branch. In the following I will create a tag only based on the… Read More »
After an OwnCloud upgrade I was getting complains from my users that WebDav and OwnCloud windows client were no longer able to upload files. By looking into owncloud.log the following was the repeated error: {“app”:”remote”,”message”:”An exception occurred while executing ‘SELECT * FROM `oc_locks` WHERE `userid` = ? AND (`created` + `timeout`) > 1456517102 AND ((… Read More »
Yes our friends from China invented a new type of DDOS attack. The great firewall changed unencrypted traffic that contained 3rd party javascript libraries to DDOS GitHub. There is already a testing tool SRI Test developed and deployed by Gabor Szathmari see for more details his blog To protect my blog I found out that… Read More »
Working with Enterprise applications deployed on Websphere Application Server ND and having to determine some issues from the logs sometimes can be a handful. The sheer amount of information that is spilled by the container in the logs is overwhelming. Usually I end up having to find the needle in the haystack looking into 5… Read More »
On my servers I want to completely get read of graphical boot. I do not like fancy graphics that are not compatible with my basic Matrox integrated card and I do not want my system to start directly in X and load the server with unwanted stuff. STEP 1: Remove graphical boot Completely un-install the… Read More »
I had a situation when from a strange reason a default grub setup as a result of a system recovery was missing the lvm and raid modules so I was not able to boot. I have the following setup on the server: – my boot partition is in fact an ext4 partition over a mdraid… Read More »
There are times when even experimented sysadmins do stupid things. One of that moments happened to me when I tried some speed tests on my ssd RAID1. The result was not so satisfactory. Corrupted /boot partition with missing files and orphan inodes. To make things more complicated I have the following constraints that make this… Read More »