Re: why>?

there's a big difference between an obscure database.. and one that
leads the market

www.olapreport.com - it is obvious that IBM and ESSBASE and ORACLE are
all a waste of friggin time.

SQL Server friggin rocks; most of the components you need come included
with windows...

The really big databases still run on mainframes, e.g., banks with
millions of transactions per week if not per day. And trying to find
DBMS market share information on the web isn't easy. But if Microsoft
were so successful with SQL Server, how can Oracle have such a high
market capitalization. Another case of Aaron is right and the rest of
humanity wrong?



Hey man I have stock in the market; and I'm selling Oracle short.

until they start getting serious-- having a complete stack-- they're
roadkill.

if Oracle merges with either IBM, Sun, Redhat, Novell-- then maybe they
will be around in a dozen years.

As it is right now; they're stock is tanked.

Microsoft could buy them without even going to the bank.

Microsoft should be allowed to buy Oracle. It would be nice if
Microsoft had 2 competing enterprise level database systems

because from where i'm standing; oracle and Ibm aren't even playing in
the game any longer.

the only threat to MS SQL Server is called mySql.

And I tell you... sitting around making spreadsheets doesn't help you
to become a database stud.

And you're kidding yourself when you say 'I dont need to be a db stud'

Your companies are limping along; paying way too much for db services.
And in general; companies spend there database dollars in the wrong
place.

Firing a dozen beancounters and hiring a couple of database people is
always a smart move.

Helping a spread*** dork grow into SQL Server-- and really know how
to design a database-- is priceless.

What I was trying to say-- reading between the lines about WinFS and
'user instances'

I was expecting WinFS to make it so that we would each have a database
on every single desktop at your company-- the way that things should
be.

But it's happened sooner than WinFS; it is here today.

User Instances-- in SQL Server 2005 Express--- is absolutely priceless.
I mean; you can open a MDF -- SQL Server Database-- Without doing
anything-- you open it just like a word document.

I think that it's the greatest thing since sliced bread.

I think that it would be great if Oracle allowed their database to
write MDF formats.
It would be totally awesome.

It would be awesome if they both had the same formats; but they had
different internals for running the same format.

I can't wait for when there is a linux db vendor that is smart enough
to make MDF/LDF compatble database server.

I mean; clone the ***-- down to the slightest detail-- of SQL Server.

sniff packets; reverse engineer it.

and make it happen. it's entirely possible... might not be easy.

I just think that it's a shame that you guys don't use ANY desktop
reporting tool. You sit around; in lalaland-- copying and pasting the
same formula.. i mean; I just flat out out-produce you.

nice sharp data entry, reporting applications

don't sit there and think 'oh but i wouldn't use a data entry app'

yeah; you would.. if you knew how to make a simple app-- to make it
easier to manage customers-- in your own style--

there isnt' a person in the world that shouldn't be learning databases.

our country should have a fucking draft-- instead of sending people to
the army or iraq for 2 years; we should sit them down and teach them
real programming.. teach them real database SKILLZ.

i mean-- it's only drag and drop.

but if you deal with information; if you deal with customers; if you
deal with inventory-- there is a better application imaginable.

and if you can imagine it; it's easy to build.

it's just exponentially more powerful.. keeping your data in one place.

you can't build drill-down applications in excel.. it's just not
feasible.

databases are what makes drill down possible.

you have all the tools you need to build your own drilldown-capable
tools..

i know you guys love drilldown.. it's the greatest thing ever.

excel doesn't make it possible to drilldown... i mean; your pivotTables
are handicapped compared to my olapPivotTables.

-Aaron


-AAMFK


Harlan Grove wrote:
dbahooker@xxxxxxxxxxx wrote...
a) if you keep your data in different databae; i could give a rats ass.
we can use ODBC for anything we need.

So no SQL Server but DB2. And what OLAP facilities there are are
provided by Essbase. And that configuration still allows for full use
of ADP and OLAP just as you'd use them with SQL Server? I honestly
don't know.

b) when you sit around and wonder 'what if people dont have permissions
to write to sql'
i just think that you miss the point.

Do you know what NTFS is?

NTFS is going to be replaced by.. uh.. get this-- SQL Server
this is called 'WinFS' and it has been in the works for 15 years in
redmond.

And it'll still depend on who gets permissions/rights to what, but good
ol' Microsoft OS's will likely default to everyone has unlimited
permissions/rights.

Database as file system ain't new. It was one of the key features of
BeOS.

it has previously been called 'Cairo'

I think you mean Longhorn. Cairo became Windows 2000, which predated
talk of WinFS by years.

On your desktop-- you'll be running SQL Server behind the scenes.
this means that you can toss around sql server databases just like
they're documents.

Yup, database as storage subsystem. And hierarchical organization using
parent fields in the WinFS database. In case you can't tell, I'm not
sold on the benefits of WinFS.

it isn't risky to allow end users to create databases. create tables;
create views and sprocs.
...

Maybe not, but most IT shops give most users minimal (read only) if any
access to company databases. You may really, really believe it should
be otherwise, but all your wishing means squat.

WinFS-- when it ever shows up-- it SHOULD **SHOULD** allow all end
users to have their own playground for SQL Server.
...

You're confusing database as storage subsystem for WinFS with a DBMS
with which users can create tables, views, forms, reports, etc. WinFS
is more likely to be a database runtime, like Access runtime, that
provides database functionality for packaged systems (in the case of
WinFS, the OS's file system), but it's unlikely to provide users the
ability to create their own databases. I could be wrong.

you go to open the MDF 'file' and you've got a SQL Server database;
just as if it were a document.

MDF? That's SQL Server's database file format? How does one create MDF
files if one uses Oracle, DB2 or mySQL?

but even today-- in more rational terms-- i reccomend that every person
in the world have a SQL Server 2005 Express or MSDE installed on their
desktop.
...

You need to convince IT departments. Good luck!

I'm just blown away-- the free enterprise-level database offerings..
IBM and Oracle finally woke up to the reality that MS was kicking their
ass in the db market..
...

The really big databases still run on mainframes, e.g., banks with
millions of transactions per week if not per day. And trying to find
DBMS market share information on the web isn't easy. But if Microsoft
were so successful with SQL Server, how can Oracle have such a high
market capitalization. Another case of Aaron is right and the rest of
humanity wrong?

Oracle won't ever be a threat to Microsoft because Oracle is a
one-trick pony.
they don't have an office suite.
...

They don't need one apparently.

I just dont' like the idea of having mixed environments... having 3 or
4 different flavors of databases-- it's not the most efficient way to
do things.
...

That's likely true. However, companies with decades' worth of mainframe
data and serviceable mainframe systems aren't going to drop them just
for the heck of it. There will be heterogenous environments as long as
there's heterogenous hardware.

but the bottom line is that excel is inherently a single-user
interface; a single-user database.

Single-user interface? Correct. Single-user database? Nope. It's not a
database. It could be misused as a database. So could Word. You keep
trying to force-fit it into an inappropriate category, making it seem
like you can't understand anything that isn't a database - probably an
accurate assessment of your 'thought' process.

.