U-Dubominator

Hey guys,

So I'm just starting to teach myself SQL Server 2008. I've looked for some good tutorials but can't really seem to find one. I'm still stuck on the main server console window trying to create a database to start messing around with.

If anyone has a good suggestion for online tutorials (even books would work I guess) that would be great. Or if anyone has some tips for me that would be good.

I have MS SQL Server (Dev) x64 (installed everything ) and Visual Studio Pro installed. Let me know if I need any other software too!

Thanks,
Udub.

reezin14

nThis might help you out,it's virtual labs with a pdf download of the lab included so you can practice on your setup.
http://www.microsoft.com/sqlserver/2...tual-labs.aspx

__________________
Q6600@3.9
http://valid.x86-secret.com/show_oc.php?id=383427

U-Dubominator

sweet find! I'll go fiddle around with it and see what I can come up with.

DuckieHo

Well... do you know SQL yet?

__________________
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it should work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single-Rail/Non-Modular PSUs are not always better than Multi-Rail/Modular

U-Dubominator

i downloaded the files for the virtual lab (adventurebox database i believe?) and installed them last night - I then fell asleep while installing Visual Studio 08 haha. When I get out of my Combinatorics class ill get started learning again.

Off topic: combinatorics ... sucks.

U-Dubominator

So I finally got the code window up so I can create databases:



But where do the databases get created? I thought they show up in the left column in sort of a file tree type thing. (And i need to move databases to a specific hdd)



EDIT: wrong screenshot

EDIT NUMBER 2 I think I got it running! I restarted SQLserver08 and now I have everything on the left!

DuckieHo

Well, do you know SQL already? If not, you might want to start with something easier like Access.

__________________
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it should work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single-Rail/Non-Modular PSUs are not always better than Multi-Rail/Modular

U-Dubominator

I edited the above and got it to show up and such. Now I can make queries and the like.
Thanks!