Introduction to SQL Server

• SQL Server is an RDBMS product, developed by Microsoft
• With SQL Server
• We can create and manage databases 
• It supports BI features (SSIS, SSRS, SSAS)
• SQL Server is a collection of 4 servers
• Databases Server
• To work with databases
• It works using SQL command
• Report Server
• To generate report
• To implement export and import activities.
• Analysis Server
• To build data ware house
• SQL Server supports a language - SQL (Structured Query Language)
• IBM product
• Non procedural language 
• Common database language used by every RDBMS product
• Case insensitive language

• We can say that every server has their own services where database server has 3 main services.

• SQL Server                (Database Engine)
• SQL Server Agent     (For automation)
• SQL Full-text Filter Daemon Launcher

• For programming SQL Server supports

• T-SQL          (Transact-SQL)

• SQL
• Programming part

• CLR Integration

• To execute SP, triggers etc, written with .Net languages
• We have to enable car FEATURE

sp_configure 'car enabled',1
reconfigure