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.