What I'm Reading - 2010-09-24

Where Good Ideas Come From It’s more watching than reading, but whatever. There are words in there! Storyselling 101 It’s a marketing piece, sure, but it applies to everything you do. The most compelling way to educate is to do it with a story. People identify with and engage in stories. Ever watch a good movie and end up on the edge of your seat for most of the movie? That’s engagement.

Talking is Good, Where Can I Do More?

We can’t all just pick a street corner and start spouting off about whatever strikes our fancy. That’s not how things work, unless you’re a crazy street preacher. Very few people down at the local university will appreciate you getting on a soap box with a megaphone and ranting about normalization. Trust me on this one. A few days ago, Jen McCown (blog | twitter) put up a blog post aboutBreaking Into SQL Showbiz.

What I'm Reading 2010-09-17

Facebook Privacy Settings for Bigamists The Texas Sharpshooter Fallacy Your brain plays tricks on you and looks for patterns everywhere. Don’t be that guy. Cognitive Load A world with more heads up displays and instantly available information carries a lot of distraction. I don’t want more information constantly streaming into my brain. I want the right information instantly available, when I choose it. Peak MHz Scale out, young man. Scale out.

Top 5 Reasons to Use NoSQL

You’re not using a NoSQL database right now? I’m not all that surprised. Many IT shops are still evaluating moving from SQL Server 2000 to SQL Server 2005, much less these non-relational databases. A lot of people don’t even know what they would use a NoSQL database for. Does it replace the RDBMS? Work alongside it? Do something else? 1) Analytics One reason to consider adding a NoSQL database to your corporate infrastructure is that many NoSQL databases are well suited to performing analytical queries.

T-SQL Tuesday – Indexes

When Michael J Swart asked me to take part in T-SQL Tuesday #10 – Indexes, I was incredibly flattered. Nobody’s ever asked me to do anything since a cop asked me to stop doing that one thing (speeding). I had to say yes. Here’s my contribution to T-SQL Tuesday #10. [caption id="" align=“alignright” width=“241”] An index is a horological lever-like something or other.[/caption] WTF is an index? My 1967 Children’s World Book Encyclopedia doesn’t provide a definition for an index.

What I’m Reading – 2010-09-10 Edition

ISO Time Formatting Standards Read it. Love it. Use it. Reducing Bloat Without Locking Just in case you wanted to know all about ghost record clean up in PostgreSQL land. Links and Link Walking Links are crazy awesome fun and make riak a wonderful thing to behold. BEHOLD THE LINKS! Cassandra Data Model Cheat Sheet New terminology is confusing. Pictures are helpful. Setting the record straight – “So, What is an MVP Anyway?

Three Things to Watch with NoSQL

Last week I painted a rosy picture of NoSQL databases. Before you deploy any kind of NoSQL database, you need to be aware of the potential pitfalls of NoSQL databases. 1) Architecture NoSQL databases have different architectural concerns than traditional RDMBSes. If you’re wokring with a BigTable or Dynamo database, your network backbone will need to be able to handle the increased traffic from replication and materializing MapReduce data. Dynamo databases are very chatty – reads and writes are only guaranteed when a specific number of servers respond to a query.

Moving Away From Relational Storage

Don’t. Fooled you, didn’t I? If you’re already using a relational database, keep using it. If it’s scaling just fine with your hardware and workload, keep using it. If you aren’t running into any complexity problems, keep using it. There’s no reason to change the way you’re storing your data just because you read an article about how BrandNewStartup.com was able to increase uptime and throughput eleventy-four percent by utilizing a new key-value storage solution.

…And This Is Why I Love Open Source Software

From the daily Riak Recap: So check this out: At 17:40 yesterday, solidsnack asked, “Does Riak support HTTPS?” At 22:28, benblack made it work —> https://gist.github.com/4413fafc14fc18696643 The repo for his branch is here —> http://github.com/b/riak/tree/https A user requested SSL support. 4 hours and 40 minutes later, it was implemented and checked in to source control. It will probably be available to the public in a short period of time.

Chalk Talk 2010 – It’s not your Senior DBA’s Chalk Talk

I don’t know if you’re familiar with the Chalk Talk sessions at the PASS Community Summit. These sessions are shorter, 40 minute sessions, and they happen in the vendor expo hall at the Summit. In the past, this has been a Microsoft sponsored event with Microsoft sponsored speakers. These were discussion focused sessions – a combination of presentation and Q&A session. Guess what? It is a Microsoft exclusive event no longer!