MSSQL

  • MS SQL Server is a relational database management system (RDBMS) developed by Microsoft.
  • This product is built for the basic function of storing retrieving data as required by other applications.
  • It can be run either on the same computer or on another across a network.
  • This tutorial explains some basic and advanced concepts of SQL Server such as how to create and
  • restore data, create login and backup, assign permissions, etc.
  • Each topic is explained using examples for easy understanding.
  • MSSQL is a scalable data platform which includes several ETL (Extract, Transform and Load) tools and reporting services where data can be added, modified and queried using a standardized structured query language (SQL).
  • MSSQL is an evolving data platform used for mission critical business and data solutions on premise,
  •  the cloud and on hybrid platforms.Data storage is a database, which is a collection of tables with typed columns.
  • SQL Server supports different data types, including primitive types such as IntegerFloatDecimalChar (including character strings), Varchar (variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others. 
Posted on by