Kevin,

Is that referenced somwhere?

For now, you've ot 4GB or so not being used on the server. Maybe you want to set it up to do other tasks as well to use some resources.

Amit...

Yo need CALs whenever you have authenticated users, usually people on your domain accessing the SQL Server. If you have unuthenticated users, i.e. the Internet, then you need a per...

What do you mean by dynamically assign roles. Do you mean someone picks a role in a program and then you assign it?

It's no different between Java/VB/etc. You would...

They don't get full. They grow with disk space.

You just install SQL again and in setup, specify an instance name. As far as architecture decisions, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp

You lost your connection to the server.

Is SubjectID an identity field? If so, don't put it in the insert statement.

I haven't seen anything else, but I did some searching and it looks like the Gaylord is a mile or so from the DFW airport. You can try this for...

Getting preped for tech ed

Chris has great advice. Be sure that you test under loads to be sure which one might run better.

You'd probably need to do this from the OS itself and get the notification when services shut down. In W2K you can run a command when a service shuts down...

Use the Server Network Utility.

Don,

Best of luck with Oracle. It will surely be interesting and you'll learn quite a bit.

As to your question. I've had that one before and last year when I managed...

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp