» » Unlabelled » BI Developer

A+ A-

BI Developer

SQL Server Services

Posted: 18 Apr 2021 09:22 AM PDT

  •  SQL Server supports 4 services
    1. Database Server 
      • SQL Server (DB Engine)
      • SQL Server Agent (Automation)
      • SQL Full-text Filter Daemon Launcher
    2. Report Server
      • SQL Server Reporting Services
    3. Integration Server
      • SQL Server Integration Services
    4. 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
      • 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

SQL Server Environments

Posted: 18 Apr 2021 08:34 AM PDT

 SQL Server supports 2 types of environments

  1. Stand Alone Environment
    • For small scale applications
    • Only ONE production server
  2. Cluster based Environment
  • For medium to large scale applications
  • Min two production servers
  • Banking, telecom, online application need cluster based environment
12:26:00 AM
Thirmal

Post a Comment

Thank U For ur Comments

Emoticon
:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.

Subscribe to: Post Comments (Atom)
 
Information © 2013. All Rights Reserved. Powered by Thirmal
Top