I have been working with Oracle for last two years, it’s sometimes found myself struggling with SQL server syntax and other functionalities. So I decided to brush up all my skills and blog about them so that anyone can access the learning. I hope you enjoy all the blogs as I do writing them.
SQL server is a Relational database management system developed by Microsoft which primary function is to store relational information and retrieving those data from the software application.
Connecting to SQL Server Management Studio
In order to start working with SQL server, we need to either install the full SQL server or install SQL server management studio in order to work with SQL server database.
Open SSMS and connect to the desired database you want to connect as shown below:
While connecting to SSMS you will get a popup window to enter your configuration as shown in figure 1:
- Server Type
- Server Name
Server type specifies the Database engine.
Server Name specifies the database name or IpAddress eg. (local),127.0.0
Authentication specifies the mode of Authentication Windows or SQL server Authentication. The organization uses both Windows Authentication and SQL server authentication.
Basically, in an organization, they may have more than one SQL server but talking in terms of one application it has one SQL server installed in Windows server and all the developers connect to that SQL server using client application SSMS(SQL SERVER MANAGMENT STUDIO) to query the database.
SSMS doesn’t have the whole power as compared to SQL Server, so it’s just a client tool normally when I used to use SSMS I thought it looks like an SQL server only but when I went deep down I figured out it’s just a client I cannot work on all the features which SQL server is capable of doing.
Once we are connected the DB server we need to select the DB to which we want to query. In order to execute our query we need to select the database and click on the new query as shown below: