Re: Among available RDBMS. When to use ...


Please don't top post.

On Aug 14, 1:25 am, Rohit <rpk.gene...@xxxxxxxxx> wrote:
Does DB2 not support Multi-versioning? Now SQL Server 2005 also has
Snapshot Isolation.
See

http://technet.microsoft.com/en-us/library/ms345124.aspx

Something new has been added I see. So SQL Server finally has "row
versioning".
That's good. Though I note that they claim:

"When these new options are not set, SQL Server 2005 default database
behavior works as in earlier versions. This default behavior will
continue to be the preferred behavior in many systems in which
transaction processing throughput and performance are the highest
goals."

Given that Oracle's multiversioning has long outperformed SQL Server,
this claim seems stretching things a bit. Though with applications
tuned to using locking, switching to multiversioning could cause those
applications to use the database poorly (ig, slower).

I haven't used DB/2 in a long time. It did not have multiversioning
when I used it.


For startups or mISVs, is it possible to keep DBA?

for startups, if you can't aford a DBA (even on contract) then can you
afford programmers?

The point is if you want to go cheap, you will get cheap results.
Remember the old ad:
pay me now, or PAY me later.


... What Oracle claims
in Oracle Magazine that it is suitable for small-large businesses? In
small organizations, you can't afford a DBA from start.

You need someone to take the DBA role. They need data modelling skills
and Admin skills. Specific experience in Oracle helps because of the
different processing model (multiversioning versus locking). If you
can get someone that can also work as a developer, you will be in good
shape.

I would think an ISV needs a DBA more, since the products sold might
be installed in different environments and platforms. A programmer may
not realize the different requirements that result in different
configurations in the database.

[NOTE: part of the conversation is vague because we haven't agreed on
what is a small business. What resources are available for the
startup? an ISV is an ortogonal concept. ISVs can range from small to
very large.]

it comes down to what do you really need. here's an analogy:
Would you try to start a world-class restaurant without a chef?
would you hire a cook from McDonalds instead?

ed

.

Relevant Pages

  • Re: sql transactions per second
    ... good sense of app server and web server hit counts and capacity needs, ... SQL Server to the max, and what their SQL transaction per second count is. ... before all other hardware constrains growth). ... Be prepared to hire a really good DBA who knows how ...
    (microsoft.public.sqlserver.server)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... now the SQL injection attacks and/or crash the service attacks need ... to be address separately (no real DBA options here). ... The proper way to secure this though isn't in SQL Server per se. ... Microsoft's putting a lot of effort into security. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL DBA per Server
    ... Sounds like you need a development data architect, not a production DBA. ... Microsoft SQL Server MVP ... 60 systems is a lot of servers to handle without some type of automation. ...
    (microsoft.public.sqlserver.server)
  • Re: DBA Access to SQL Server
    ... > look at the qualifications or trust of your sql dba ... > rather than his/her permissions. ... > 99.9% of the time i hear this question it's a control ... if your support model includes the DBA folks doing the SQL Server ...
    (microsoft.public.sqlserver.security)