A Bit of Troubleshooting

A client recently asked me for help with their SQL Server environment. It seems that replication was running slowly and was getting further and further behind – replication had been turned off during heavy data modification and was turned on after several days. Protip: This is why it’s important to have a full checklist for…
Read More

Open Sourcing Sawzall – What Does It Mean?

While perusing twitter, I saw that Google has open sourced Sawzall, one of their internal tools for data processing. WTF does this mean? Sawzall, WTF? For Data Analytics or automotive modification, you will find no finer tool. Apart from a tool that I once used to cut the muffler off of my car (true story),…
Read More

T-SQL Tuesday – Why Are DBA Skills Necessary?

They aren’t. 99% of what you do could be replicated by a fairly stupid shell script. When I started as a DBA, I didn’t have practical experience as a DBA. I had Books Online and google. What’s necessary as a DBA has nothing to do with your knowledge of T-SQL or SQL Server’s internal fiddly…
Read More

Testing for Performance

You know that you should be testing your code. You even know that you should be testing your SQL. But why? We need to make sure that changes to our code are safe, prevent regressions, and that we catch edge cases. But are you testing your code for performance? Changes to code can make your…
Read More

Foursquare and MongoDB: What If

People have chimed in and talked about the Foursquare outage. The nice part about these discussions is that they’re focusing on the technical problems with the current set up and Foursquare. They’re picking it apart and looking at what is right, what went wrong, and what needs to be done differently in MongoDB to prevent…
Read More

Thoughts on Free Amazon Web Services

Last week, Amazon announced that we could all get some free AWS if we signed up for a new account. Just what do you get for signing up? Take a look. What you get with the AWS Free Usage Bundle The First Catch First off, this is only free for the first 12 months. After…
Read More

What I’m Reading 2010-10-22

Free Amazon Web Services for new customers. Amazon are giving away 12 months (from the date of your sign up) of a bunch of Amazon services. If you want to try to start up a business, now is the time to try! IronRuby is alive! There was some conjecture about the life of IronRuby after…
Read More

Hadoop World Follow Up

I should have written this right when I got back from Hadoop World, instead of a week or so later, but things don’t always happen the way you plan. Before I left to go to Hadoop World (and points in between), I put up a blog post asking forquestions about Hadoop. You guys responded with…
Read More

What I’m Reading 2010-10-08

Cassandra: RandomPartitioner vs OrderPreservingPartitioner Data order is important in relational databases and it’s something that you need to be aware of with a non-relational database, too. Improperly ordered data can put a huge load on a few nodes in a cluster. This article goes over the trade-offs in Cassandra of using a random data order…
Read More

I’m Going to Hadoop World

Sounds like I’m bragging, right? There is a free book involved. Or maybe you don’t care because it’s all NoSQLs and stuff and you’re a SQL Server DBA. And that’s where we differ. When I first heard about NoSQL databases, I had the same reaction that a lot of people are having right now: disbelief…
Read More
Menu