ms sql database

hi,

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
LVL 7
gudii9Asked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Eyeballeth thy article SQL Server Training for multiple answers to your question.
0
 
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.


1.JPG
0
 
Bill PrewCommented:
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
pcelbaCommented:
You should start with queries and commands which are common to all SQL engines. Look at the tutorials available on the net (e.g. https://www.w3schools.com/sql/) 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: https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode
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: https://mva.microsoft.com/ebooks# or here: https://info.microsoft.com/Introducing-SQL-Server-2016-eBook.html
0
 
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 https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/, 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 https://msbiskills.com/t-sql/

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 - https://msbiskills.com/sql-performance-tuning/

I am providing you a good page where you will links of websites world class SQL SERVER authors -  https://msbiskills.com/sql-server-resources/

Good luck with your learning.
0
 
Eugene ZCommented:
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
https://www.mssqltips.com/sqlservertip/1996/registering-sql-server-instances-for-easier-management/
more:
https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-a-connected-server-sql-server-management-studio
--

Sql education:
Free Microsoft training
https://mva.microsoft.com/

--free reading "the source"
SQL Server Books Online
https://technet.microsoft.com/en-us/library/ms130214(v=sql.105).aspx
0
 
Pawan KumarDatabase ExpertCommented:
Question abandoned
Valid suggestions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.