January 29, 2004 at 9:10 am
I have no formal training on servers or networks. I have developed an Access database to hold training, vendor and other information, and am now trying to make it accessible over the LAN to supervisors and workers. For various reasons, I must set up my PC as a server and create a client/server situation for the database. I have purchased "Special Edition Using Access 2000" by Roger Jennings, and have ordered "MS SQL Server 2000 Pocket Reference" and "MS SQL Server 2000 Weekend Crash Course". I am flailing here people, and need to get up to speed fast. Does anyone have any other suggestions for reference materials for beginning and/or novice DBAs?
January 29, 2004 at 10:13 am
try to get hold of sams publication of sql 7 or 2000 "unleashed". its got lot of info and examples.
January 29, 2004 at 11:32 am
It depends on what your database really is. You say it's Access, well then Microsoft SQL Server tutorials won't help.
If you really are going to use MS SQL Server, you need to have a real server. That means the operating system you use has to be a Windows Server operating system (Windows NT Server, Windows 2000 Server, Windows 2000 Advanced Server, etc). Then you need to buy the proper version of SQL Server and that's the Standard or Enterprise edition. They are expensive. But, the Personal edition, Developer Edition etc can't be used in Production. You could check out the MSDE version, which is free-ware, but it's not 'powerful'. Check out the different versions on Microsoft's web site. Go to http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc
For SQL Server, there are books that claim you can learn it in 24hours (the SAMS books, I believe). I don't know what's available for MSDE.
-SQLBill
February 3, 2004 at 8:27 am
Thank you for your time and attention. I appreciate any help given.
February 3, 2004 at 11:14 am
February 3, 2004 at 12:41 pm
Apart from the other suggestions being made, when you got stuck with a problem, don't spent too much time figuring out by yourself. Come back here and ask. Should save lots of precious time.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply