BlogCoward

SQL

RethinkDB : Another challenge to NoSql Orthodoxy: Take a look at RethinkDB, a drop-in replacement for the MySql orthodoxy. A central theme of NoSql orthodoxy is that ACID can’t scale. The fact that companies like Amazon and Google (you may have heard of them) have ‘abandoned’ ACID is, in my mind, enough proof anyone needs that the NoSql is a valid option that anyone who needs to consider data storage options (what an ugly sentence….but I digress). What I like about things like VoltDB and RethinkDB is that they are attempting to rise to the challenge. Can you have your ACID cake and eat it...; posted @ Thursday, July 01, 2010 6:36 PM | Feedback (0)

NoSQL and the Six SQL Urban Myths: A very interesting article from the Hot Scalability site about VOLTDB, a next-generation RDBMS that is purported to scale beyond NoSQL implementations without giving up ACID. It targets both the NoSQL style databases (listing the six SQL urban myths that its makers think NoSQL advocates fall prey to) as well as the ‘dinosaur’ traditional RDBMS’ like Oracle and SQL Server. The article is a very interesting read, giving a lot of pros and cons about VOLTDB, but if databases are your cup of tea, it’s definitely worth looking into. Check it out.; posted @ Monday, June 28, 2010 5:13 PM | Feedback (0)

RavenDB, and a brief design philosophy discussion with Ayende: Suppose you design a system that is chock full of interfaces, specifically things like some version of IRepository, where you have the ability to change out your backing store/database more easily. A common criticism of this sort of design is that it is unrealistic to think you actually will change your main backing store/database in a production system. My own experience is that while it does happen (a current client project I am working on involves changing the backing database for a set of applications from SQL Server to Oracle, for instance), it doesn’t happen often, and you often...; posted @ Friday, May 21, 2010 7:44 PM | Feedback (0)

NoSQL in the Wild: Rob Conery has a post about how they run Tekpub using NoSQL that’s a great read. I’m not qualified to talk about Ruby code but that part is kind of irrelevant. He hits all the right notes in talking about why they did the things they did (I could quibble about the cost ‘criticism’ of BizSpark, but that’s a business decision), especially in terms of separating reporting. It’s a good read, check it out.; posted @ Wednesday, May 19, 2010 8:20 PM | Feedback (0)

NoSQL links of interest: As I’ve mentioned before, one of the great things (at least in terms of how it relates to software development) about the Internet in general, and the blogosphere in particular, is that it offers a tremendous opportunity for someone to ‘fast-forward’ their skills if they know where to look (being vaguely intelligent and able to read quickly also helps). This definitely applies when it comes to NoSQL. Beyond the mindless advocacy of some folks that think NoSQL applies everywhere, and before I have to create a system that needs to deal with the scalability issues of Amazon, I want...; posted @ Sunday, April 25, 2010 10:30 PM | Feedback (0)

Hello SSIS My Old Friend: A few years ago, Ayende had a post about why he hated SSIS, which brought about some responses (here and here and here) from some other folks. It was a lot of fun had by all (sarcasm). I happened to be doing some work prototyping SSIS and whether it could be used to replace some of the Perl-based implementations we had in place. After only a little bit of effort, we clearly determined that SSIS couldn’t hack it (which is ironic, since getting SSIS to do many common tasks required a lot of hacking, but I digress). digression: I...; posted @ Tuesday, April 13, 2010 12:08 AM | Feedback (0)

NoSQL is the new Black: No one really talks about alt.net anymore. In my mind, that’s a good thing. Though some people apparently had different goals for all of that (setting up a foundation or some other silly thing), for other people, it was about taking the things that a small subset of .NET developers were doing and making them more mainstream (whatever that means). Though (again) it is hardly a definitive sign of anything, the fact that people like Jeremy and Ayende have been publishing articles in MSDN (and no one thinks this is odd) is a good thing. That Asp.NET MVC has unit...; posted @ Tuesday, March 30, 2010 10:19 PM | Feedback (2)

It’s OK to do Reporting off of a RDBMS: Well, that’s a little misleading. It’s OK to do Reporting off of a RDBMS as long as you do it right, and you should consider other options before committing to it. note: I’m using “Reporting” here in the traditional sense, not in the cqrs sense where pretty much anything that doesn’t involve a command is called “Reporting.” Also, since I mostly know SQL Server, that’s what I’m going to be discussing here. Also, yes, I know I’m glossing over a hell of a lot of stuff here. The ‘Problem’ Suppose you have your traditional transactional system...; posted @ Sunday, February 07, 2010 4:20 PM | Feedback (0)

Remote connection to a SQL Server 2005/2008 instance: If you’re like me, you might have had an occasion or two where you needed to connect to an instance of SQL Server from a workstation or server that wasn’t where the SQL Server was actually located. Because of the gosh darn important security measures that have been implemented in more recent editions of Windows Server and SQL Server itself, this might not work well by default (not to be critical of gosh darn important security measures, as they are gosh darn important). As a note to myself, if you need to do this, there are a couple of...; posted @ Monday, December 14, 2009 9:28 PM | Feedback (0)

Linq to SQL Not Totally Dead, but it’s not at all well: Jim Wooley has a post that makes what I think is a really good analogy: Linq to SQL is to Entity Framework as Winforms is to WPF. That is to say, Microsoft isn’t pulling either Linq to SQL or Winforms from the framework, but isn’t really adding new features to them, just making bug fixes. Makes sense to me.; posted @ Thursday, June 04, 2009 6:09 PM | Feedback (0)

Archives

Post Categories

Stuff