| SQL Server Services Posted: 18 Apr 2021 09:22 AM PDT - SQL Server supports 4 services
- Database Server
- SQL Server (DB Engine)
- SQL Server Agent (Automation)
- SQL Full-text Filter Daemon Launcher
- Report Server
- SQL Server Reporting Services
- Integration Server
- SQL Server Integration Services
- Analysis Server
- SQL Server Analysis Services
 |
| Introduction to SQL Server Posted: 18 Apr 2021 09:08 AM PDT - 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
- 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
- To execute SP, triggers etc, written with .Net languages
- We have to enable car FEATURE
sp_configure 'car enabled',1
reconfigure
 |
| SQL Server Environments Posted: 18 Apr 2021 08:34 AM PDT SQL Server supports 2 types of environments - Stand Alone Environment
- For small scale applications
- Only ONE production server
- Cluster based Environment
- For medium to large scale applications
- Min two production servers
- Banking, telecom, online application need cluster based environment
 |
Post a Comment
Thank U For ur Comments