Where to start with MSSQL?

Question

I'm currently coding an AJAX blog system in ASP.net. My database of choice is going to have to be MSSQL, which I have never used before.

I'm currently being trained in MS Access and I've been using MySQL for years, so I don't think learning the query's should be difficult, however, I have no clue where I go to make databases or run queries at! Right now, I have no server and have been debugging my ASP.net applications via Visual Web Developer. I have both MSSQL 2005 and 2008 installed on my PC, but I have no clue how to use them.
How can I create a database using my PC as the web server? Is there a program I can use to create databases, users, and tables? Lastly, on an actual web server, what is used to maintain a database? I use PHPmyAdmin for MySQL, what is the MSSQL alternative?

Some help would be appreciated and I will pick the best answer!

Answer 1

If you've used MySql for years, you'll catch on pretty quickly to MSSQL. There are a few syntax differences, but for the most part, it's all the same.



The standard equivalent to PHPMyAdmin is Server Management Studio in 2005+, and Enterprise Manager in 2000. Management Studio is a very comprehensive system, it blows PHPMyAdmin out of the water. There are also several other tools to use with MSSQL such as Query Analyzer (for a low-overhead querying tool) and Profiler (awesome for watching what's hitting your DB and how).



Using your PC as the server, you simply load up Management Studio, it sounds like you have the developer version so you should have no problem just creating the DB locally. You'll want to adjust your connection strings before you put it on a server, obviously...



As far as users and all that, look into the ASP.NET membership features...that'll take a lot of legwork away from you.

Answer 2

"How can I create a database using my PC as the web server?" T-SQL.



"Is there a program I can use to create databases, users, and tables?" Unfortunately, there's no phpMyMSSQL.



For MSSQL you write your own maintenance routines. Which is one reason (of many) why it's better to use MySQL.

Answer 3

the needed language (sq.) of both is an same. in case you comprehend tables and a thanks to question records then you actually do not have any problem with both. inspite of the indisputable fact that, even inspite of the truth that some the following ought to favor to believe MySQL is basically as quick and effective as MS sq. Server, it really is basically no longer actual. MySQL did not even provide saved approaches until eventually at present. MS sq. Server has been round for a lengthy time period and maintains to augment as an magnificent database option. With saved approaches, applications, the means to dice and ROLLUP records, it truly, IMHO, blows MySQL out of the water. MySQL is if truth be told a step up from MS get entry to, perhaps.