Re: why>?


a) if you keep your data in different databae; i could give a rats ass.
we can use ODBC for anything we need.

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.

it has previously been called 'Cairo'

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.

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

these premonitions that you have-- obviously a nazi taught you
databases back in college or something.

I'm not that inflexible.
it is no more risky than giving you the ability to create spreadsheets.

if i had my way; i would yank your permissions to create new
spreadsheets lol-- see how you felt.

but seriously

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

As it is right now; with 'user instances' and SQL Server 2005 and .NET
2005; you can have a 'user instance' of a SQL Server database that is
completely and utterly portable.

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

it's new technology; a simple slight of hand.. and SQL Server databases
are portable.

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.

i mean-- job scheduling; notification; sandbox for scratchpad / data

everyone person in every company should have thier own copy of SQL
Server on their desktop.

why?

BECAUSE THEY CAN. because it is better for companies to invest in
databases than spreadsheets.

because you don't use memory. I use memory. you don't.
Memory is the greatest asset on the 1,000s of desktops on people's
machines.

memory is 10,000 times faster than disk.

who knows? your workers might invent a couple applications that save
countless hours.
what would happen if presto-changeo-- instead of bringing in
developers; and teaching them about your business.

what would happen if the subject masters-- the people that know the
business rules-- could write their own databases?

because they should automate the *** out of everything they do; and
the best way to do that is with SQL Server. It's free, it's fast. It's
lean.


Imagine a company without beancounters; a company where people get
things done.
a company, re-designed from the ground up-- to utilize these gigantic
robots that we all can have for free.

do you know the robots of lore; in old sci-fi movies?

have you ever wondered when they're going to get here?

the answer is that they're already here-- they've been here for years.

BUT NOBODY KNOWS HOW TO USE THEM.
these 'robot's are called databases.

Not Xml... not spreadsheets that break the 2gb limit.
i mean; they have excel-- why not SQL?

MSDE = SQL Server Desktop Engine.

there are pros and cons to choosing MSDE over SQL Server express.

MSDE works for dual processors and 2 gb ram; it has an event scheduler.
this has a query governor / connection governor.
SQL Server Express has single proc, 1gb ram; it doesn't have an event
scheduler.

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..

I'm not saying that Oracle and IBM are going away.

I'm just saying that if your companies love OFFICE-- you shoud be using
SQL Server. Office works better with SQL Server than Oracle does.

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

they can't offer a stack from the frontroom to the backroom to every
cubicle in between.

MS has really forced the other vendors in the market to start being
more competitive.

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.

i just claim that there are better, easier-- more long term solutions
out there.. as it is; the usage of XLS anywhere is a travesty. i mean--
what percentage of your fileservers and email servers are spent dealing
with XLS files?

i keep all my data in one place; i just don't need to email
spreadsheets and reports around.

my email is faster; my outlook ins't a bear.
i can SHARE reports through my webpages.

it's all about collaboration.

microsoft is trying to make excel look like it has some collaboration
features.

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

and i laugh at that. it's friggin hilarious.

excel can only handle 1 user??

hahahahahahahahaha






Harlan Grove wrote:
dbahoo...@xxxxxxxxxxx wrote...
...
but newbies shouldn't have to do that since ADP has such a nice
interface for writing sprocs and views.
...

But if the average business user can't create tables or views or modify
anything in SQL Server because they lack the necessary
permissions/rights, how would ADP help them?

i wish i could spend more time teaching people Accesss.
...

If you spent less time whining about Excel . . .

Excel 2007 has some really really exciting technologies.. the ability
to import olap data as either a table or a pivotTable-- that's going to
revolutionize the way that we do business.
...

Not really. Aside from some reports (I didn't make 'em, and I' not
responsible for 'em), none of the spread*** models in widespread use
where I work involve pivot tables. Pivot tables may have their uses in
reporting, but much less so in analysis.

And all you need is

a) SQL Server Standard Edition
b) office license.
...

And if your company's databases are all in Oracle or DB2 or (who knows)
mySQL? And you need to set up the OLAP cubes, but I'll stipulate that
may not be difficult if there's someone who knows how to do it. All I
can say is that there are lots of companies either without (a) or who
don't provide most users with access to it.

.