ms sql database


i am new to ms sql database.

where i have to start reading learning more about this database and stored proce, funtions rules, syntax etc.
i connected usning microsoft sql server management studio to 3 environments like ST, INT, PT etc .

how to save sessions so that next time when i open microsoft sql server management studio i do not have to click again connect then datanase engine then give password etc.

please advise
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornSQL Server Data DudeCommented:
Eyeballeth thy article SQL Server Training for multiple answers to your question.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ITSysTechSenior Systems AdministratorCommented:
If you chose under Authentication "Windows Authentication" and you have admin rights on the MSSQL server then you will be able to quickly log in to any server you have.

Bill PrewIT / Software Engineering ConsultantCommented:
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

You should start with queries and commands which are common to all SQL engines. Look at the tutorials available on the net (e.g. and then you may continue with the more specific features which have syntax slightly different.

You have to always connect to SQL Server when starting SSMS. You may make it easier by setting up Windows authentication in SQL Server. Look here how to do it:
You don't need to provide any passwords in such case.

When yo start a new query window in SSMS you may save its content into a text file and read it again next time.

To study MS SQL you may search for free ebooks, e.g. here: or here:
Pawan KumarDatabase ExpertCommented:
My Myntra is - > Learn Concepts , Write more and more queries and more queries , Solve SQL Puzzles and win it.

I suggest you to start writing queries. The more your write the more you learn and understand how things works in SQL Server. A good place to start writing queries is, here you will get almost 300 puzzles you can solve by writing queries. You can also get multiple solution which is another way to learn things.

You also need to understand the SQL Server concepts. A good place to start is

Once you learn all the above things then you need to go deep into the system and understand how we can improve the performance of the queries and the entire SQL Server.  For that you can refer -

I am providing you a good page where you will links of websites world class SQL SERVER authors -

Good luck with your learning.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
Q: <how to save sessions so that next time when i open microsoft sql server management studio i do not have to click again connect then datanase engine then give password etc.>

A: try to register your sql server
Registering SQL Server instances for easier management

Sql education:
Free Microsoft training

--free reading "the source"
SQL Server Books Online
Pawan KumarDatabase ExpertCommented:
Question abandoned
Valid suggestions.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.