Microsecond Precision with MySQL on Amazon RDS

Running MySQL in the cloud offers many benefits, including extremely fast provisioning and deployment, managed security, and (mostly) easy operations. But nothing comes for free, and as with all things on this wonderful planet, those benefits come with certain limitations.

List of SQL Server Databases in an Availability Group

After migrating some databases to SQL Server 2012 and creating Availability Groups for some databases, we have noticed that some of our maintenance scripts were failing with the following error: The target database (‘MyDB1′) is in an availability group and is currently accessible for connections when the application intent is set to read only. For…

Life at Pythian as a MySQL DBA

Several people have asked me in the last year what it is like to work for Pythian. There are many reasons for a question like this, depending on who is asking.   Some people are concerned about the fact I am working for a Canadian-based company. This typically comes from some of my xenophobic North…

Everyone Should Have Firefighter Mentality

Australia, being the most arid country in the world is known for its bushfires. The part of Australia where I live in doesn’t have many bushfires, but we do have several building fires, like any other part of the world. Firefighter is one occupation which many kids want to be when they grow up. Kids…

Oracle Passwords: How to Use Punctuation Symbols

You can’t make a password strong enough. But at least you can try. Having at least one upper case character, one lower case character, one number, one punctuation mark or symbol, and greater than 8 characters, you can have a password which can be considered something decently safe, probably.

The Hadoop and the Hare

I speak to a lot of people who are terribly concerned with “real-time”. Can data get into the warehouse in real-time? Can we record everything the user does on the site in real-time? Real-time is a magic phrase, because it really means “so fast that nobody cares”. In a business sense, it usually means that…

Page 19 of 277« First...10...1718192021...304050...Last »