Info on SQL Server

[doctorgonzo]

Anybody know of a good website that contains some general intro info on SQL Server?

[Justin26k]

SQL Server From Microsoft or MYSQL?

[doctorgonzo]

SQL Server. I will be moving a database from M$ Access to SQL Server and I hope to have as much control over it as possible.

[Justin26k]

I have a few ebooks on SQL Server should tell you everything you wanna know if you want them

btw whats wrong with mysql?

[doctorgonzo]

Nothing is wrong with MySQL as far as I know. But the product our organization has is SQL Server, and that's what we are going to use. I don't make the software decisions where I work, unfortunately.

I am looking for something quicker than a book, just a website detailing the basics (I will probably get some books along the way anyway).

[mosquito]

Migrate ms access to SQL Server
http://www.microsoft.com/sql/techinf...smigration.asp

Quick overview
http://databases.about.com/cs/sqlserver/

Much info:
http://msdn.microsoft.com/sqlserver


If you have questions, feel free to ask

[doctorgonzo]

Thanks, mosquito, those links were informative.

[mosquito]

The best source of information is still the books on line delivered with SQL Server though.

You can download it here. It's one of those nifty chm files.

http://www.microsoft.com/sql/techinf...2000/books.asp

[beden]

Thank you all. We're implementing a Help Desk program (Ambercat) with an SQL backend. I have experience with Access, and VB, but not that much at all with SQL.

Because of our company's policies, we have to buy a Dell Server to load this - I'm looking at a PowerEdge 4600 (512MB or 1GB memory, 73GB hard drive), single processor, single hard drive machine.

We'll be loading W2K Server (standard), SQL Server 2000 Standard, and Ambercat. Additionally, we will implement a very small version of Domino server with Lotus Notes for 2 of our users (for testing purposes) through this server.

I just wanted to know what pitfalls I should watch out for with Dell equipment, and SQL in a Win2K environment. I'll only have up to 15 users logging into the server, and only really the Admin hitting the database to generate reports. The rest of the users will be able to generate and edit tickets which I guess will hit the SQL database since that's the back end.

Also, does anyone have experience with Ambercat? I like the product - it's less bloated than many of the other out-of-the-box stuff we looked at, and the price is definitely right. The headache is that every screen will require customization, but that is also one of the attractions.

My 15 users will be logging in with everything including Win 95, 98, ME, XP, NT 4.0 and W2K - any snags to anticipate there? (via a common network connection).

Thanks for any help - and thank you all for the great sites you've already shared.

[doctorgonzo]

If you have experience with Access, a really good book is the Microsoft Access Developer's Guide to SQL Server. It tells you what is the same, what is different, and what you should do to take full advantage of SQL Server's capabilities. When I had to move a customer database from Access to SQL Server it was very helpful.