sql server management studio tutorial 2014

We will be using the GUI way to create a database. The actions that we can do such as create databases and tables can be done with the GUI (graphical user interface) or SQL script. The interface also allows you also to run SQL scripts. Many of the tasks that you will do with SSMS are point and click. SQL Server Management Studio is a graphical user interface. Notice in the object explorer that it will display the Computer Name, SQL Server instance, and the logged-in person. The login name ‘sa’ system administrator is the default. SQL Server Authentication was set up during the server installation.Įnter the login name and password that was set during the installation process. You can use Windows Authentication or SQL Server Authentication. When SSMS starts you have two different ways to sign into the software. Open SQL Server 2014 Management Studio (SSMS) by clicking the SSMS icon or START | All Programs | Microsoft SQL Server 2014 | SQL Server 2014 Management Studio Starting SQL Server Management Studio (SSMS) Previously we installed SQL Server Express 2014. The SQL Server database will be created so we can connect to it for data acquisition (data logging) from our PLC applications. We will be using SQL Server 2014 Management Studio (SSMS) to create a database. SQL Server Express 2014 release includes the full version of SQL Server 2014 Management Studio. The database size can be 10 gigabytes in size. The bottom of the “New Query” window shows the status of the query execution along with other details like server name, database name, user name etc.Microsoft SQL Server Express 2014 is a free, edition of SQL Server this is ideal for learning and developing desktop, web, and small server applications. You will see that the new font style that you applied is the one that is used for the Query Window. Enter the below query in the “New Query” window and click the execute buttonĥ.

Open “New Query” window by clicking on the “New Query” button which is found just above the object explorer.Ĥ.

Select a different Font from the “Font” combo box and change the size of the font and click ok.ģ. Select “Fonts and Colors” in the Options dialog box. In the SQL Management studio 2014, navigate to Tools -> Options.Ģ. There are various personalization options available for the SQL Server users in the SQL Management Studio.įor example, if you want the Object explorer to be place on a different position instead of showing it in the left side of the SSMS, you can just move it by clicking it on the title bar of Object explorer.Īdditionally, you can change the Font styles and colors within the SQL Management Studio.ġ. You need to personalize SQL Server Management Studio.

Sql server management studio tutorial 2014