With this article, we start a series of posts that will be introducing Microsoft SQL Server.These posts will be talking about the major features of SQL Server, as well as provide the necessary knowledge in order to start working with this powerful data platform. SQL Server is a Relational Database Management System (RDBMS).A RDBMS is a Database Management System (DBMS) based on the relational model which was invented by E. F. Codd. A database is an organized collection of data. This collection may include tables, functions, views, stored procedures, queries, and more. The data is organized in such a way that based on the relational model, each tables can have primary keys as well as foreign keys that reference other tables and so on.SQL Server has many powerful features with which you can do just about anything that has to do with data management. That is why SQL Server is one of the leading data platforms worldwide.Currently, at the time of writing, the SQL Server versions that are officially supported by Microsoft are:
SQL Server 2008 R2 (End of Extended Support: Jul 9 2019)
SQL Server 2012 (End of Extended Support: Jul 12 2022)
SQL Server 2014 (End of Extended Support: Jul 9 2024)
SQL Server 2016 (End of Extended Support: Jul 14 2026)
The easiest way to get started with SQL Server is to download and install SQL Server Express Edition and SQL Server Management Studio. By installing SQL Server Express Edition you will end up having the database engine of SQL Server up and running and ready to accept connections.
With SQL Server Management Studio you will be able to connect to the SQL Server Database Engine and create databases, tables, as well as other database objects.Subsequent posts in this series will include:
A step-by-step tutorial on how to install SQL Server Express Edition and SQL Server Management Studio
Examples of using SQL Server Management Studio
T-SQL examples like: sql insert, sql join , and other sql queries
Comparison of SQL Server versions (i.e. compare SQL Server 2008R2 with SQL Server 2012, SQL Server 2014 and SQL Server 2016)
Comparison of SQL Server editions (i.e. standard edition vs enterprise edition vs express edition, etc.)
Rate this article: (5 votes, average: 5.00 out of 5)
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found at aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.com and TechHowTos.com.