Skip to main content

Introduction to Microsoft SQL Server

Microsoft SQL Server is a Relational Database Management System(RDBMS) developed by Microsoft. It is one of the most popular RDBMS. SQL server has evolved from sql 1.0 in 1989  to the latest release of SQL Server 2019 (preview) to become one of the best enterprise level database server's.
SQL server is released with different editions.

  • Express: Free to use entry level database which can use 1 core cpu, 1 GB ram and have maximum size of 10GB.
  • Compact : Free embedded database for mobile app development and can have maximum size of 4GB.
  • Enterprise : Full featured top end edition.
  • Standard : Have less features than enterprise.
  • WorkGroup: suitable for a company to use among the group.
  • Developer: Same features like enterprise but is licensed to one user only.
  • Web: Specially targeted for web application
There are some other editions like Datacenter, Enterprise evaluation and Business Intelligence.
These all editions are not available on all version of SQL Server.

Now: For learning purpose i will recommend you to download express edition 
you can download 2017 express edition by visiting this link  click here
RDBMS
RDBMS is a database management system that is based on the relational model introduced by Edgar F. Codd .It has been a widely used option for storage of information in a database.It is the basis for SQL, and most of the modern database systems like MS SQL,IBM. 

SSMS(Sql Serever Management Studio)It is a software application that is used to   configure, manage, and administer all components within the SQL Server.
SSMS was a part of the SQL server during installation in older version of SQL Server( before Sql Server 2014) but later SSMS is a separate installation.Download SSMS 2017 by visiting this link click here



Labels:

Comments

Post a Comment

Popular posts from this blog

Using SqlDataAdapter to fill DataTable in c#

public DataTable List(string sql)         {             SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);             SqlCommand cmd = new SqlCommand(sql, con);             DataTable dt = new DataTable();             SqlDataAdapter da = new SqlDataAdapter(cmd);             try             {                              con.Open();                 da.Fill(dt);             }             finally             {                 con.Close();             }             return dt;         }
Post a Comment
Read more

Pivot in Oracle for Dynamic Columns

Pivot in SQL refers to the change of rows into columns based on specific constraints. An example of pivot could be the transpose of matrix. Example: a matrix containing day as 1st row and sales as 2nd row for  specific day sun    10 mon  20 tue    30 The transpose of the above matrix would be sun mon tue 10  20  30 This is an example scenario of pivot in sql. Now, Lets get on to the actual tables in database and see how we can use pivot . Starting with a fictional scenario, assume a table which contains two columns DAYS and SALES. CREATE TABLE TEST.DAILY_SALES (   DAYS   VARCHAR2(10),   SALES  NUMBER ) insert into DAILY_SALES('SUN',10); insert into DAILY_SALES('MON',20); insert into DAILY_SALES('TUE',15); insert into DAILY_SALES('WED',25); insert into DAILY_SALES('THU',10); insert into DAILY_SALES('FRI',30); insert into DAILY_SALES('SAT',5); Now when we execute the following select statement se
Post a Comment
Read more