Configure SQL Server 2012 editor settings

SQL Server 2012 - Changing Font Size :

On the Tools menu, choose Options to open the Options window in SSMS and change the font size  for the text editor.

SQL Server 2012 - Copying TSQL Results with Column headers :

Enable the option to include column headers when copying the result from the grid.
Look under Query Results , SQL Server , Results to Grid for the check box Include column headers when copying or saving the results.

SQL Server Architecture

SQL Server Architecture :

• Services,
• Instances,
• Tools.

Services:

In Windows, services are applications that start without user interaction, typically at computer startup. When SQL Server is installed, multiple services are setup on the computer.

SQL Server Editions

SQL Server Editions :-

SQL Server ships in several editions that provide different feature sets targeting different business scenarios. In the SQL Server 2012 release, the number of editions has been streamlined from previous versions.

SQL Server Versions

SQL Server Versions :-

SQL Server's engine received a major rewrite for version 7.0, and subsequent versions have continued to improve and extend SQL Server's capabilities from the workgroup to the largest enterprises.

SQL Server Databases

SQL Server Databases :-

Databases in SQL Server are containers for data and objects, including tables, views, stored procedures, user accounts, and other management objects. A SQL Server database is always a single logical entity, backed by multiple physical files.

How to use SQL Server Management Studio

Getting Started with SQL Server Management Studio :-

     SSMS(SQL Server Management Studio) is an integrated management, development, and querying application with many features for exploring and working with your databases. 

SSMS is based on the Visual Studio shell.

Working with SQL Server 2012 Object Explorer

Use of Object Explorer :-

Object Explorer is a graphical tool for managing SQL Server instances and databases. It is one of several SSMS window panes available from the View menu.Object Explorer provides direct interaction with most SQL Server data objects, such as tables, views, and procedures.

Right-clicking an object, such as a table,will display context-sensitive commands, including query-generators and script generators for object definitions.

Working with SQL Server 2012 Script files and Projects

 SQL Server 2012 Script files and Projects :-

SSMS allows you to create and save T-SQL code in text files, typically given a .sql file extension. Like other Windows applications that open, edit, and save files, SSMS provides access to file management through the File menu and through standard toolbar buttons.