Re: Prevent Viewing on work***


I really honestly think that every desktop in the world should have
msde..

but a much much simple explanation?

people run out and buy another $400 3 ghz machine; throw a copy of
Windows Home on it.. and run MSDE as a server.

I think that it's a fabulous strategy.. it's a LOT cheaper than a real
database server.. and if you use ADO connection sharing.. and say ASP?
MSDE could push probably 100 consecutve web users.

not bad for free and stable and reliable. and fast as ***.. not bad
at all for a 200 in software and 400 in hardware.

does DB2 and Oracle _EVEN_RUN_ on intel boxes? (you wouldn't know by
their market share lol)

get a decent dual core box for 500 bucks and it's a pretty deadly
performance solution.. or ***.. a dualie dual core

IBM and Oracle sure don't support multiple processors on their freeware
solution..

***.. IBM and Oracle _DIDNT HAVE_ freeware solutions until MSDE had
been on the market for what.. 7 years?

SEVEN YEARS?

an awful lot of freeware MS SQL Servers out there in seven years lol

i've got to warn you.. the free ware price point isn't where the action
is.. a 5-cal copy of windows 2003 and sql standard.. especially now
it's 2005????

a $3000 machine-- hardware and software-- with sql 2005 standard and a
little bit of analysis services?

OMFG

it outperforms many $20,000-$50,000 machines from oracle and ibm.

MSDE changed the friggin database market... on the low end. they
invented the market.
it's a component of office; i dont know if it's on the office standard
disk.

but i've got good news for you
if you're so desperate to see it?

www.microsoft.com/sql

look for 'sql server 2000 sp4' and from there go to download the 3rd
ordinal zip file-- i think... 4 readme files.. and then 4 zips.. not
the AS or the SP4 you want the one called MSDE... it's a little bit of
a bitch to setup..

stick this into a batch file.. i think that you've got to navigate to
the folder where you have the setup.exe from the MSDE install.. then
you can fire this

setup INSTANCENAME="MSDE" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL
SAPWD="harlan_LOVES_AOL" /L*v C:\MSDELog.log

i really reccomend using sql authentication.. it's a much better
development dynamic.. sure i'm lazy.. sure it's a risk.. but it's just
a LOT better and easier than anything else on the market.

I mean.. TOAD???

Is there anything else on the market where you can view a subquery in
design view? i've never seen it anywhere; i've used a couple of crappy
sql tools over the past couple of years and i sure haven't seen
anything else that can compete.

MSDE can be a destination for real SQL Server replication.
i am pretty sure it can do log replication.. I think that it's a lot
more powerful than SQL Server 2005 express in that it comes with

sqlagent
multiple procs
2gb ram
better replication support

if it gave you trouble i could write a custom log shipping app in just
a few minutes.. i mean ***.. backup a tran log and restore it on
another box? I would do i in a wsh file in about 2 minutes

open up access

in 2000.. hit file, new and then on the 'other' tab i think that it's
called.. i think that it's called a project there..

on 2003 the smart pane.. if you go file, new and then in the smart pane
you get

'new database'
'new data accss page'
'project - existing data'
'project - new data'

hit project existing data; enter your server or server\instancename

and then choose either windows or sql authentication.. go for sql
authentication for dev..

a) user = 'sa'
b) password = 'harlanLOVESAOL'

choose an existing database; *** tempDb if you must.. or pubs it might
come with.. or do a find file for northwindCS.adp; execute it and it
will install all the sql scripts necessary.. full functional example..
orders; orderDetails.. you get the idea

I mean-- especially for laptops?? it's insane the power I can put in
a laptop


and then?? you take your copy of Access..

Olap in the mid market; it cleans up the competition.
and throw in freeware office web components?

I mean seriously here. Microsoft is dominating the database arena in
ways that are completely.. i mean..

it just blows my mind sometimes; it's an unbeatable stack that they've
got

It's on the office disk.. I dont care if you have to lie or cheat and
steal to get an office disk.. it's on the access disk for chris
sakes.. access costs $120 a seat or something? maybe $199 full edition?
you spend that much a month on mochas (but i dont anymore lol)

or download msde for free from microsoft.com/sql
and go get some mroe memory..

call your IT department and say 'I make fucked up gb spreadsheets give
me another gb of ram'

and flutter your eyelashes

tell your boss that your company needs to spend another $100 on
memory..
you spend that much a month on mochas
and freeware sql server and office front end

not 100,000 database

can your company make a 5000 _SINGLE_ database?


it's crazy friggin product man.. how about i use excel for a month..
nothing but excel.. and you use access for a month and we'll trade
notes when we're done



Harlan Grove wrote:
aaron.kempf@xxxxxxxxx wrote...
...
Install the component; build departmental apps and then when it's
mission critical; move it to a high-end server.
...

A few small details. In most large companies with volume licensing
plans, no department has any Office CDs. Also, many large companies
have their networks set up to prevent users from downloading files from
the Internet. Where would anyone get the component in order to install
it?

But let's assume they've installed MSDE. All they have to manage then
is building some mythical mission-critical application before IT
notices what they've installed and they get fired for violating the
company's security policy.

Yeah, lots of people would follow you down that path. You have a lot of
experience about getting canned, don't you?

No. If everyone had MSDE on their desktop; it wouldn't be a DATA
ISLAND.

And there'd be no problem with network traffic with users accessing
each others' PCs. And no one would mind if their own PCs performance
becomes noticeably slower when coworkers run large queries against
databases on their data sandbar.

you could stick a database server on the south pole for all I fucking
...

As long as you go with it.

Companies don't 'SAVE' money by skimping on Office.

Most normal companies by Office Pro.

There's no available market share data on this. All either of us has is
anecdotal evidence of what we've seen ourselves, or you could have
internal Microsoft data that'd land you in a civil lawsuit if you
admitted you had it.

Where I work, where my best friend works and where my brother-in-law
works most users have Standard. If it's different where you've worked,
fine.

I don't need full Access on everyones machine.

I need full Access on the developers machine; the data entry monkeys?
...

Which gets to the core reason why the lucky people with only runtime
would continue to use Excel: they'd have nothing else they THEMSELVES
could use to automate what THEY need to do as THEY see it as opposed to
how the few developers might see it.

PCs became so widespread because the MIS/DP departments of old didn't
meet their internal customers' demand for applications. The software
most often used were BASIC dialects, TurboPascal, small non-SQL
databases and spreadsheets. Recentralizing application development may
happen for larger ones, but it won't happen for a great many used by
individuals.

But you're clueless about what anyone does outside of your own
restricted function, so you just can't understand this.

Nobody DICTATES what's on my machines.
...

Possibly, but most business PC users using PCs that are the property of
their employers and software that was licensed to their employers have
no choice what's put on their PCs for them to use.

Most business PC users are neither developers not merely data entry
types. The vast majority are hired to do things like sell or service
their companies' products. PC use may be frequent, but it's incidental
to their jobs, not the central focus of their jobs. Many of those
people have need from time to time to perform ad hoc calculations.
Nearly all of them would find spreadsheets easier to use for that
purpose than databases. And few of them would be as productive if all
they had were a few canned Access applications running under the Access
runtime since they wouldn't be able to create any new applications,
even simple ones like comparing present values of installment payment
plan.

But this is all over your head.

.