Re: New to SQL server



i disagree with this:

· Engine-level referential integrity and data validation. Microsoft
Jet has built-in support for primary and foreign keys,
database-specific rules, and cascading updates and deletes. This means
that a developer is freed from having to create rules using procedural
code to implement data integrity. Also, the engine itself consistently
enforces these rules, so they are available to all application
programs.


RI is not practical in MDB in any way shape or form.

and for the record; SQL Server also 'means that a developer is freed
from having to create rules using procedural code to implement data
integrity'





aaron.kempf@xxxxxxxxx wrote:
you're kidding me right?

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

-Aaron



Bill Edwards wrote:
Somewhat old, but it hits the high points:

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

"ironwood9 via AccessMonster.com" <u12024@uwe> wrote in message
news:69714c57b5170@xxxxxx
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 -


--
Message posted via http://www.accessmonster.com


.



Relevant Pages

  • Available dotnet Consultants : 217-241-2015
    ... Microsoft Technologies and SQL Server 2005. ... Senior .NET Developer ... Server 2000, IIS, and Windows 2000. ...
    (microsoft.public.dotnet.languages.csharp)
  • ANN: San Diego .NET Technical Summit, May 21 2005, brought to you by SanDiegoDotNet.com
    ... Conference Date ... The San Diego Technical Summit will be held Saturday May ... SQL Server 2005 for Developers ... productivity enhancements for the database developer. ...
    (microsoft.public.dotnet.general)
  • Re: New SQL Book Scam or Not?
    ... Mike Epprecht, Microsoft SQL Server MVP ... Specialist SQL Server Solutions and Consulting ... >> If you are a SQL Server developer, a .NET developer, or a Development ...
    (microsoft.public.sqlserver.server)
  • .NET Programmers
    ... Microsoft .Net, SQL Server, business intelligence, full life ... Java Programmer, J2EE Developer, C# Developer, .Net Developer, VB.Net ...
    (comp.lang.javascript)
  • .Net Programmer Multiple Vacancies
    ... Microsoft .Net, SQL Server, business intelligence, full life ... Java Programmer, J2EE Developer, C# Developer, .Net Developer, VB.Net ...
    (comp.lang.java.programmer)

Quantcast