Scattered Data

April 09, 2008
I know someone right now who is splitting a database into separate instances for performance purposes. Now, this happens to be a SQL Server specific installation, but the concept holds true for all the vendors. The problem is they're putting the 2nd instance on the same box, and leaving the DBs on the same disks. And not only that, they're doing double writes on some of their busiest tables (without using 2PC) t
DBMS
Read more »

Generating data

April 07, 2008
OK, I found a couple things this weekend that were pretty cool. First, Red-Gate has a new data generator. It's been a long time since a standalone data generator has hit the market. I'm not sure why, but so many think that they can get away with testing their apps without data to back it up. This becomes particularly important in fields like healthcare and insurance where you've got a lot of privacy issues. It's
DBMS
Read more »

He gets me every year.

April 01, 2008
Every year April 1st sneaks up on me and Steve Jones gets me with his fake SQL Server newsletter article. This year is no different. As I read his article a lot of things went through my mind. First and foremost, how the hell did he trump me on such big news? Then it was, wow, that's cool... I'm glad they finally listened. Because a lot of the stuff he talked about, I've been talking about recently both with MS
DBMS
Read more »

Doctored photos

March 27, 2008
OK, at long last, the MS guys have sent me a photo that they doctored. You can see the original in this post. And since I told them that I'd post it, here it is. This is the 2nd time that I've seen Oracle park taxis with their logo outside a SQL launch event, so what do they expect MS to do? And if MS ever does the same thing outside an Oracle launch event I'd be happy to post any pics they want me to post as we
DBMS
Read more »

Oracle vs SQL Server

March 25, 2008
OK, while I'm really bad about approving comments (mostly because the platform makes it so painful), I do want to answer a few of them here real quick. First and foremost because this is bothering me. I've been in DBs for 15yrs now. It's not all I do, but it's certainly what I do best. So you guys don't have to remind me again and again that there's a difference between 'SQL' and 'SQL Server'. I'm fully aware of
DBMS
Read more »

Protect you server against unwanted deletes

March 24, 2008
I'm going to take a short break from the Oracle/SQL Server controversy to talk about file recovery. This doesn't necessarily apply to DBs, but then again, it can under the right circumstances. I was writing a process to ship trace files to another server for analyzing and I had the line commented out that actually inserts them into the table and all I did was delete them. OK, fine. So what to do. Well, not long
DBMS
Read more »

Oracle's community: part 2

March 20, 2008
Well, it seems as though I may have struck a nerve yesterday. And I'm always surprised to see the people who are reading me. I got a lot of comments, but even more emails, and the results are mixed. I haven't added it up but the count is pretty close to have that agree with me. And that's fine. One thing I'm finding out is how passionate the Oracle people are about their DB. One thing I thought was really funny
DBMS
Read more »

The real difference between SQL Server and Oracle

March 19, 2008
For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real importance lies. Sure, functionality is a part of it because your database should be able to do what you need it to do. However, do you want to know what the real difference between the two companies is and why Microsoft
DBMS
Read more »

Katmai's backup compression

March 07, 2008
I remember a conversation I had at the Redmond campus with the program manager (at that time it was Paul Randall... now I think he goes by Paul Tripp, but all the same he's not a MS anymore.). Anyway though, he was asking me about my favorite Katmai features and I listed 2 or 3, and he was astounded that my favorite feature wasn't backup compression. They were particularly proud of that one. It turns out the SQL
DBMS
Read more »

L.A. SQL Server 2008 launch pics

March 05, 2008
Well, as usual I'm a few days behind getting my launch pics posted. There weren't any really interesting things to snap this time, but as usual, Oracle parked taxis outside with their logo on them. Personally, I think it's funny. So here's me at the cabs with a couple of the Microsoft guys. They said they were going to Photoshop the pics and I said if they did that I'd post them. So let's hope they actually do i
DBMS
Read more »
©1994-2014 Infoworld, Inc.