New to SQL server

[ironwood9 via AccessMonster.com]

I am just learning SQL server - I'm going through these videos from a company
called Learn Key - 18 videos - it's the most , comprehensive, educational,
interactive, user friendly learning materials I've ever seen. A-nyway, what
is the big advantage with SQL server ? MS Access alone has always met my
needs, but everyone makes such a big deal about SQL server. I'm not trying
to be negative, I really want to know.

Any input would be greatly appreciated - SQL server dba's are in HUGE demand -

 

[aaron.kempf]

yeah I definitely agree.

Access Data Projects are a great learning tool.. I really reccomend
them.

SQL Server is bigger; faster; more scalable-- more stable, more
reliable and more secure.

MDB is flakey and stupid and slow and lame and not extensible.

Do I need to continue?

-Aaron

 

[Douglas J. Steele]

First of all, remember that Access is a full development environment: forms,
reports, code, etc. plus a database. SQL Server is only a database. However,
as a database, it has far greater capabilities than Access. It can hold far
more data than an MDB file, it has logs and the like to ensure
recoverability in case of a problem and it has far better security than
Access. Even if you move your data into SQL Server, Access is still an ideal
client for your application.

 

[aaron.kempf]

Doug;

SQL Server is the best flavor of Access. It is called 'Access Data
Projects' or the ADP format.

Learn it, love it.. laugh at people that still use MDB

-Aaron

 

[Kevin3NF]

In addition to Doug's comments, the SQL Server database engine is far
stronger and more efficient for handlind larger data than Access' Jet
engine.

It is less susceptible to corruption (network gltches can trash an Access
db) than SQL Server.

It can be backed up without having to get all the users out.

Other stuff as well, but those are my biggies.

Access is a fantastic desktop database, SQL Server is great for large
numbers of users or web apps.

Access is more affordable than most editions of SQL Server.

Hope that helps a bit.

Kevin3NF

http://www.3nf-inc.com

http://kevin3nf.blogspot.com

First of all, remember that Access is a full development environment:
forms, reports, code, etc. plus a database. SQL Server is only a database.
However, as a database, it has far greater capabilities than Access. It
can hold far more data than an MDB file, it has logs and the like to
ensure recoverability in case of a problem and it has far better security
than Access. Even if you move your data into SQL Server, Access is still
an ideal client for your application.

 

[Klaus Oberdalhoff]

Hi,

In addition to Doug's comments, the SQL Server database engine is far
stronger and more efficient for handlind larger data than Access' Jet
engine.

It is less susceptible to corruption (network gltches can trash an
Access db) than SQL Server.

It can be backed up without having to get all the users out.

Other stuff as well, but those are my biggies.

Access is a fantastic desktop database, SQL Server is great for large
numbers of users or web apps.

Access is more affordable than most editions of SQL Server.

i'd say that if you want to compare Access with SQL Server you need to add
any front-end (like Visual Studio or so) to the comparison. Beside Reporting
Services - the SQL Server itself just has no front-end creation system.

To be fair you'd need to compare JET and SQL Server but NOT Access and SQL
Server.

You may compare

Access SQL Server
------------------------------------------------------
JET <--> SQL Server (partially)
Forms <--> -- (Infopath / Visual Studio <Express>)
Reporting <--> Reporting Services (partially)
SQL <--> T-SQL ? (partially)
VBA <--> Extended Stored Procedures (2000) / CLR support (2005)
-- <--> Enterprise Manager
-- <--> Backup
-- <--> Analysis Olap etc.
-- <--> other SQL Server tools like Messaging, DTS/SSIS

mfg

Klaus

 

[aaron.kempf]

Access SQL Server
------------------------------------------------------
JET <--> SQL Server (partially)
Forms <--> Access Data Projects
Reporting <--> Access Data Projects
SQL <--> T-SQL ? (partially)
VBA <--> Stored Procedures
-- <--> ADP, Enterprise Manager
-- <--> Backup
-- <--> Analysis Olap etc.
-- <--> other SQL Server tools like Messaging, DTS/SSIS

 

[aaron.kempf]

I disagree; Access is not cheaper than SQL Server.

how can you compete with FREE??

SQL Server 2005 Express rocks.
Once we get Access 2007; this is going to be my preferred environment;
for sure.

MDB needs MORE development time and MORE administration.

-Aaron

In addition to Doug's comments, the SQL Server database engine is far
stronger and more efficient for handlind larger data than Access' Jet
engine.

It is less susceptible to corruption (network gltches can trash an Access
db) than SQL Server.

It can be backed up without having to get all the users out.

Other stuff as well, but those are my biggies.

Access is a fantastic desktop database, SQL Server is great for large
numbers of users or web apps.

Access is more affordable than most editions of SQL Server.

Hope that helps a bit.

Kevin3NF

http://www.3nf-inc.com

http://kevin3nf.blogspot.com

 

[Master Programmer]

WRONG ! WRONG ! WRONG ! WRONG !

Dont listen to this fool, these idiots never learn. MS SQL 2005 is
completely free and a real database. MS Access can be compared to
using an excel spreadsheet.

The Grand Master

In addition to Doug's comments, the SQL Server database engine is far
stronger and more efficient for handlind larger data than Access' Jet
engine.

It is less susceptible to corruption (network gltches can trash an Access
db) than SQL Server.

It can be backed up without having to get all the users out.

Other stuff as well, but those are my biggies.

Access is a fantastic desktop database, SQL Server is great for large
numbers of users or web apps.

Access is more affordable than most editions of SQL Server.

Hope that helps a bit.

Kevin3NF

http://www.3nf-inc.com

http://kevin3nf.blogspot.com

 

[Kevin3NF]

LOL....yeah...I worked two stints at Microsoft doing SQL support and don't
know the difference between SQL Server, Access and Excel...

<plonk> welcome to the block list, and have a nice day

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

 

[aaron.kempf]

Master;

I don't support normal Access work; I hate MDB format

but Access Data Projects?

how can anyone compete with <INSERT><AUTOFORM>?
binding a sproc to a form without even trying?

-Aaron

 

[aaron.kempf]

my SQL Server FRONTEND is free.. just like yours jackass.

It's called 'Access Data Projects'

when you make a new file; you have more options for Project then you do
for Application so thus ADP is the 'default format' in Access 2002/2003

Lose the training wheels kids; SQL Server is FREE; and it's bigger,
better and faster

-Aaron

 

[Robert Morley]

MS Access can be compared to

using an excel spreadsheet.

Only if you don't know what you're doing.

As the tone of his message implies, this poster is simply trying to start
yet another SQL Server/Access flame war because, like aaron (or maybe he IS
aaron by any other name), in his mind, one of them is a god and the other is
a toy. As Kevin3NF said, they each have their uses. I wouldn't go to the
trouble of using SQL Server for a strictly local database, nor would I even
remotely consider using Access as the back end to a web page. Access also
makes an excellent front end to SQL Server, though it's certainly not the
only possibility.


Rob

 

[aaron.kempf]

Robert

you wouldn't use SQL Server for a strictly local database?

can you read the future?

do you have a PhD in 'I can forecast who can use my COMPANIES data and
WHERE THEY WILL USE IT'?


build everything in SQL Server; mdb is obsolete; eat shit mdb script
kids


-Aaron

 

[Master Programmer]

Access is for babies. Grow up.

The Grand Master

 

[Robert Morley]

Access is for babies. Grow up.

I did, a long time ago, which is why you're now on my blocked senders list
as well. I'm not going to be party to yet another x is better than y
debate; they're pointless. Bye bye.



Rob

 

[aaron.kempf]

they may be pointless TO YOU because YOU ARE ON THE LOSING SIDE OF THE
ARGUMENT

MDB IS FOR LEPERS AND RETARDS

'oh if this posting doesnt go my way then i'll take my ball and go
home'

-Aaron

 

[Bill Edwards]

Somewhat old, but it hits the high points:

http://support.microsoft.com/kb/168549

 

[aaron.kempf]

you're kidding me right?

this was pre-ADP and thus it didn't really evaluate all of the options

-Aaron

 

[aaron.kempf]

I disagree with this:

Microsoft Access has changed the image of desktop databases from
specialist applications used by dedicated professionals to standard
business productivity applications used by a wide range of users.

when every web developer in the world got pissed off about MDB
scalability problems; Access caught this little marketing problem