Posts

Installing Microsoft Sql Server including the Management Studio

Image
Installing Microsoft Sql Server including the Management Studio What is Sql Server? SQL Server is a relational database management system, or RDBMS, developed, maintained and marketed by Microsoft. It is used to store and retrieve data as requested by the user in a tabular form. The storing and retrieval and be done same system or over a computer network. Downloading the system Type Microsoft Sql Server download in url bar and select SQL Server Downloads | Microsoft From the search results, or click here Select either Developer or Express version and click download as shown below In this case, we are selecting Developer Edition for this tutorial, therefore click on Download now for Developer as shown below Select the installation type you want, in our case, we are selecting Basic, so click on Basic and accept the License Terms by clicking on Accept to continue Specify the location you want to install the application and click on insta...
Post a Comment
Read more

What is SQL Server

What is SQL Server SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs. SQL Server works exclusively on Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 that ran on both Windows and Linux. SQL Server consists of two main components: 1.       Database Engine 2.       SQLOS Database Engine The core component of the SQL Server is the Database Engine. The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, index, etc. The...
Post a Comment
Location: Abuja, Nigeria
Read more