ms sql database

gudii9
gudii9 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Eyeballeth thy article SQL Server Training for multiple answers to your question.
ITSysTechSenior Systems Administrator

Commented:
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
Bill PrewTest your restores, not your backups...
Top Expert 2016
Commented:
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

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
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016
Commented:
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.
Commented:
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
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Question abandoned
Valid suggestions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial