Oren Eini

CEO of RavenDB

a NoSQL Open Source Document Database

Get in touch with me:

oren@ravendb.net +972 52-548-6969

Posts: 7,597
|
Comments: 51,224
Privacy Policy · Terms
filter by tags archive
time to read 1 min | 157 words

If you haven't guess it by now, I am not fond of SSIS. The latest installment is probably a "feature". Assume the following, I develop an SSIS package on my local machine, testing it against a local database.

Now, I want to run the package against a remote database. I did the Right Thing and put the connection string in a data source, so I change that and run the package from Visual Studio. Imagine my surprise when Visual Studio does a full cycle, including reporting the number of rows that it copied. Everything seems to be fine, until I checked the database itself.

About half the tables where empty, and I am still not sure why. The best guess that I can make is that it is caching the previous database credentials, and writing to that, since I found the data in the local database. Argh!!

time to read 1 min | 126 words

Here is SSIS deciding that "No, you really don't need to move this data."

NoNeedForThatData.png

I really like the "smarts" that went into that engine. I make sure that I keep busy and don't move on to othe areas of the application, but dedicate my full an undivided attention to SSIS, as it is apperantly should be.

Would it be too hard to provide a deteministic engine? SSIS would run only (random) parts of the sequence container if I right click it and tell it to "Execute Container". Doing a full debug seems to work, but it execute stuff that I don't want to run right now. Urgh!

time to read 14 min | 2647 words

I am posting this because I am extremely annoyed. I moved from my previous host because of reliability issues, I had to do it fairly quickly, so I didn't have time to really ask around and find out the best host. I went to webhosting4life because it was fast to setup, and I believed that they were big enough to be competent.

(Image from clipboard).png

I do not have a very big site, or a very complex setup, I run two applications, one needing MySQL, the other needing SQL Server. Neither of which is particularily tasking on the server.

As you can see, I had 6 outages in the last 20 days, some of them lasting mutliply hours. In nearly all cases, the reason that I was given was:

There is a routing issue on that server. Our tech is working on it now.

I could accpet it once or twice, but when it go to this level... below is a chat transcript of me and a tech from webhosting4life. It is complete with spelling mistakes and everything. As a result of this, and the evasive answers that I got, I am now on the lookup for a new host.

Notice that the operator simply left the chat when I tried to get additional information about the root cause of the problem. The chat equilent of hanging in my face! They have "Email our CEO" link on the help desk page, which I used to send a question regarding the frequent outages, I never even got a "Thank you for email us".

Powered by SightMax
Welcome to sightmax2.webhost4life.com. alvin will be right with you.
alvin
hello
Ayende Rahien
my database is down
Ayende Rahien
http://www.ayende.com/Blog/
Ayende Rahien
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
alvin
could you please let me have a check.
Ayende Rahien
yes
alvin
There is a routing issue on that server. Our tech is working on it now.
alvin
Could you please check it out later? If it still have problem. please open a urgent ticket in our helpdesk system. Thanks.
Ayende Rahien
This is the 5th time that I heard about a routing issue with the servers.
Ayende Rahien
Each of those time, it was because I had noticed that my site was down!
Ayende Rahien
That is not an acceptable way of hosting.
alvin
I am sorry about this, we are working on the issue now. Thanks.
Ayende Rahien
How can I get an answer from an authorized source about this issues?
Ayende Rahien
I would like to know what it the underlying reason for the frequent outages and the actions taken to fix this.
alvin
Could you please open a ticket about this issue, and our senior tech will give more details to you. Thanks.
Ayende Rahien
304056
Ayende Rahien
I did
Ayende Rahien
How can I get guarantees about uptime?
Ayende Rahien
I am not expecting five nines, but I do expect more than 80%
Ayende Rahien
Hello??
alvin
Dear customer, it seems that there is a routing issue on the network that make the connection for your site can't connect to the database. Our technician are working on the issue now. Sorry for any inconveniences caused. If you want a quick fix, please change the connection string to IP first.
Ayende Rahien
Nice copy/past.
Ayende Rahien
Now, can you tell me why you are recommending that I would do something that you explicitly tell me NOT to do on your site?
Ayende Rahien
It concerns me that there is a canned response for this question.
alvin
As there a routing issue in the data center, and can let the web servers to reslove the domain name, and the quick fix is using IP to instead.
Ayende Rahien
And why does it occur every other day?
Ayende Rahien
I cam to you because you were supposed to be a proffesional hosting service, with good technicians that would NOT mess the routing in the data server every day
alvin was removed from the chat.
alvin has terminated the chat session.

 

time to read 1 min | 76 words

I am starting to get that C++ feeling back. Check this out:

(Image from clipboard).png

Valid, PEVerified, executing just fine. The fact that it is also very very wrong seems to go by the CLR without notice. In case you are wonderring, what the AddValue method gets is: 20872412, or maybe a better way to put it is: 0x13E7CDC

 

time to read 2 min | 343 words

I got a comment from Jonathan Wanagel on my CodePlex WTF. I complained that I couldn't get an access to source via Team System. I do not consider tarballs to be a good way of getting source for projects that I may be interested at. There is too much stuff that I cannot do that I should be able to (diff, reverts, easy update to new revision, patches, etc).

Here is the comment:

Unfortunately TFS isn't scalable enough to support all the anonymous users on CodePlex, so we restrict SCC access to project team members only. We're investigating ways to get around this.

I am not quite sure what I am supposed to think about this. The cheeky answer is: Well, Subversion can.

Note: It is probably a lot easier to scale a Subversion farm than a TFS farm, because of the wildly different architecture choices made. TFS depends on SQL Server, which is complex to setup for thousands of concurrent users, Subversion is much simpler in this regard.

Let me run by that again, CodePlex is supposed to be an Open Source hosting site, but it doesn't let me access the source in an acceptable way, it doesn't let me create patches easily, it doesn't work.

I have an OSS project on the side that I don't even try to gather community around (Rhino Tools), so far I have gotten several dozens patches (99% of them accepted), because the source was there, it was easy to access, it was easy to modify and then send the patch to me to merge it in. I seriously fail to see the value that CodePlex can provide an Open Source project.

You may think that this is a minor matter, but I consider this a make-or-break point.

time to read 1 min | 67 words

(Image from clipboard).png

I have no idea what happened, but I was working on an ASP.Net application (no un-managed code), hit the pause button in the debug menu, to see where the application is spending a lot of time, and I somehow ended up here. Hm... somehow I get the feeling that my team didn't write it...

FUTURE POSTS

  1. Goodbye Hibernating Rhinos, Hello RavenDB LTD - 4 minutes from now
  2. Replacing developers with GPUs - 2 days from now
  3. Memory optimizations to reduce CPU costs - 4 days from now
  4. AI's hidden state in the execution stack - 7 days from now

There are posts all the way to Aug 18, 2025

RECENT SERIES

  1. RavenDB 7.1 (7):
    11 Jul 2025 - The Gen AI release
  2. Production postmorterm (2):
    11 Jun 2025 - The rookie server's untimely promotion
  3. Webinar (7):
    05 Jun 2025 - Think inside the database
  4. Recording (16):
    29 May 2025 - RavenDB's Upcoming Optimizations Deep Dive
  5. RavenDB News (2):
    02 May 2025 - May 2025
View all series

Syndication

Main feed ... ...
Comments feed   ... ...
}