MS SQL Server 2005

Im trying to get started on MS SQL Server 2005 Express Edition (http://www.microsoft.com/sql/editions/express/default.mspx) - is there any interface where I can create databases, tables etc ? Im used to MySQL and phpMyAdmin.

I cant get to decide between Windows authentication and SQL Server authentication when logging in - is there no root kinda login ?

ThanksDownload Management Studio Express:
http://msdn.microsoft.com/vstudio/express/sql/download/

Use Windows Authentication unless you have a reason to use mixed (SQL Server + Windows). Admins on the local computer will be members of the sysadmin role - can perform any operation (e.g. root access).
There is also a sa SQL Server logon that is a member of the sysadmin role - this is created regardless of the authentication type, but you can only use it if mixed mode authentication is enabled.

Windows - You are authenticated automatically based on your Windows/Domain user account.
SQL Server - You have to supply a username and password.|||Sorry, forgot to mention - it's possible to change the authentication mode after you have installed SQL Server. If you use mixed, be sure to use a strong password for the sa account - if you are developing applications, don't use the sa account in you application. Create another account with just enough permissions to perform its functions.|||Oh..it seems a new version of SQL Exp 2005 is out - with SP1 and with advanced services.

Im going to uninstall the current MS SQL Server 2005 Exp and install the one with advanced services.

Will SQL Server Management Studio Express work with the Advanced Services version ?|||I've not tried the advanced services version, but the management studio express is almost certain to work with it. Also, I suspect the install might include managment studio express rather than a seperate install - just a speculation...