Posts Categorized: Pythian

SQL 2012: Path to Easier Data Cleanup with Try_Convert

A new feature in SQL 2012 that I am very excited about is TRY_CONVERT which makes data conversion much easier. When you pair TRY_CONVERT with some Case statements, you can easily pipe the inconvertible data to other columns, which can then be reviewed and (hopefully) fixed prior to cutting over your data. I’ve mocked up a quick demo so you can see how powerful this new feature is.

Yarnline (a Ravelry Mashup)

A while ago, I spotted TimelineJS, a JavaScript library to create gorgeous timelines, and earmarked it to a future app. Last week, I finally got to play with it by creating Yarnline, an itsy-bitsy mashup app that takes the projects of a Ravelry user and displays them in a chronological manner, like so…

Benchmarking NDB Against InnoDB on a Write-Intensive Workload

Last month, we evaluated Amazon’s new SSD offerings with an extensive series of performance benchmarks. As a followup, we’ve prepared a second series of benchmarks that specifically explore performance issues with a write-intensive workload on both NDB and InnoDB storage engines. Download a free PDF of our findings, and as always, we welcome your feedback,…

Cascade Replication and Delayed servers on PostgreSQL 9.2

Postgresql 9.2 will be released with a new replication feature: Cascade Replication. It will improve streaming between wide networks, shortening distances between the servers. For example: a master server in San Francisco, a slave in Chicago and a cascade server in Barcelona. But it has other benefit, e.g. when you need to add nodes to…

Log Buffer #279, A Carnival of the Vanities for DBAs

In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about databases. This Log Buffer Edition appeases their appetites. Enjoy!

Basho Technologies and PalominoDB Partner to Offer Enhanced Support and Monitoring Services for Riak Installation and Management

LAS VEGAS, NV and CAMBRIDGE, MA – July 25, 2012 – PalominoDB, the boutique database operations and engineering consultancy, announced a strategic partnership with Basho Technologies, creators of Riak, the widely-used open-source, distributed database and Riak CS, multi-tenant, cloud storage software, in order to provide enhanced operational support for customers managing Riak clusters. “Our partnership…

Pythian at HOPE Volleyball Summerfest – Highlights

HOPE Volleyball Summerfest (Helping Other People Everywhere, Ottawa-Carleton Inc.) celebrated 30 years of fun for a cause this year. The charity has donated more than $3.5 million to over 110 charities since it began. Here are a few highlights from Team Pythian at HOPE on July 14th. It was a great day!

Page 60 of 230« First...102030...5859606162...708090...Last »