All Questions(server)

This is a canonical question about capacity planning

Related:

• How do you do load testing and capacity planning for web sites?
• How do you do load testing and capacity planning for databases?

I have a question regarding capacity planning. Can the Server Fault community please help with the following:

• What kind of server do I need to handle some number of users?
• How many users can a server with some specifications handle?
• Will some server configuration be fast enough for my use case?
• I'm building a social networking site: what kind of hardware do I need?
• How much bandwidth do I need for some project?
• How much bandwidth will some number of users use in some application?

Is there any way to export a Microsoft SQL Server database to an sql script?

I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script which will recreate all the tables, stored procedures, reinsert all the data etc.

I've seen http://vyaskn.tripod.com/code.htm#inserts, but I ideally want something to recreate everything (not just the data) which works in a single step to produce the final script.

Say that I setup a symbolic link:

ln -s /root/Public/mytextfile.txt /root/Public/myothertextfile.txt

is there a way to see what the target of myothertextfile.txt is using the command line?

Is there a one-liner that grants the SELECT permissions to a new user postgresql?

Something that would implement the following pseudo-code:

GRANT SELECT ON TABLE * TO my_new_user;

What port(s) should I open/NAT to allow me to use Remote Desktop?