Using SQL Server Management Studio

[pedie]

Hi, I heard that "Using SQL Server Management Studio" is easy to use...I just it today and 'm downloading one...
Can someone please tell me in laymans langauge what this does and how usefull is this? I did read things here and there however I would like to hear from experts and seniors/expirienced users....


Thanks in advance.
And this question is connected to "SQL SERVER" that i can see in access 2007; LINK; that tells me how to upgrade db to sql server....

 

[xenou]

That's taking on a lot - but if you want to go the SQL server route its not uncommon to use Access as the interface (forms, reports, and queries) and SQL server as the back end database (tables).

SQL server is a server-based platform so it doesn't (by itself) have much to "see". You can use SQL server management studio to manage SQL Server. That means things like creating databases, running commands against the server, creating database indexes, stored procedures, adding users, view table information, etc. etc. etc.

Typically SQL server is used with other software - a website, a custom application, an accounting system, and ERP, or what have you. That might be really simple (a VB.Net application you created yesterday) or complex (a customized software package for a company that costs millions and took two years to develop).

 

[HiTechCoach]

Hi, I heard that "Using SQL Server Management Studio" is easy to use...

If you are already really good with Micorsoft's SQL Server then the SQL Server Management Studio (SSMS) provides a GUI interface to make things easier.


If you are looking for an upsizing tool then you may wan to look at the SQL Server Migration Assistant (SSMA) for Access.

 

[pedie]

Thanks Xen, thanks Boyd!

I have seen few videos and trying to understand what it can do....and how it connects to database/web sites etc...
for now i just want to pratice in personal computer and then go along learning more...

Thanks for the advice.

What is .Net anyway?
and GUI interface...now i have sql server express 2008 running in my system not really knowing what it does.


Thanks again.

 

[HiTechCoach]

Thanks Xen, thanks Boyd!

I have seen few videos and trying to understand what it can do....and how it connects to database/web sites etc...
for now i just want to pratice in personal computer and then go along learning more...

Thanks for the advice.

What is .Net anyway?
and GUI interface...now i have sql server express 2008 running in my system not really knowing what it does.


Thanks again.

GUI stand for Graphic User Interface.

Did you know that Access is NOT a database or database engine?

SSMS is a front end to help manager an SQL Server. SSMS can connect to any SQL serer you can access. This can be the SQL server on your local machine, on the LAN or over a WAN/Internet.

 

[Norie]

Pedie

What exactly are you trying to learn?

 

[james_lankford]

if you don't know SQL then you shouldn't even bother with SQL Server or SQL Server Management Studio

 

[xenou]

If you have SQL Server Express running then you might as well have SQL Server Management Studio - you can use it to run your queries and so on (you'd actually be able to "see" your database this way). But it's not as user-friendly as Access (to my way of thinking, anyway). Access makes it really easy to create forms to work with your database, and SQL Server on it's own doesn't have anything like that - SQL Server is the DB engine and provides management tools and so on, but it doesn't give you much in the way of a user interface. VB.NET would be one way to build a forms-based application - something other people could use -- definitely don't bother with that now. You've got too much on your plate already. Either stick with just Access, or if you really want to, create your SQL Server DB but connect to it from Access so you have all the Access tools for running queries and building forms. And keep plugging away at SQL - its the foundation for everything you are doing with databases.

 

[pedie]

Thanks again everyone for learning....!
Well, Norie, i cant say I've learn anything at all yet..i watched some videos and thought it would be good to learn some one it even if i dont expertize on it...
For now, i would like to learn what this SQL SERVER can do or is capable of.

I really havent worked on SQl, except on MS Access SQl...

Xen, what is .NET it that something like vba?

[/FONT]
[FONT=Courier New] Either stick with just Access, or if you really want to, create your SQL Server DB but connect to it from Access so you have all the Access tools for running queries and building forms. And keep plugging away at SQL - its the foundation for everything you are doing with databases. [/FONT]
[FONT=Courier New]

yes..i would like to stick to Access, however just wanted to know what SQl is actually for and what it is capable of doing it....

Thanks again everyone!

 

[Norie]

What's SQL?

SQL - Structured Query Language, a 'programming' language used to managing data in an Relational Database management system

That's very brief, probably somewhat inaccurate description but it should give you the general idea.

What can SQL do?

A lot of things, too many to go through but the obvious one I suppose is query tables/data.

You can also use SQL to create, delete, alter tables and add/delete/update data in tables.

There's plenty of other things, and there are different versions of SQL.

In Access SQL there are some things you won't find in 'standard' SQL and vice versa.

I think you should probably concentrate on Access and SQL in general before moving to SQL Server.