Sql-server – SQL Server Express Edition feature and upgrade concerns

sql serversql-server-expresst-sql

I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is the Express Edition 2017.

  1. Will the express edition support procedures, triggers, dynamic sql, PIVOT, sequences, dynamic management views and functions?

  2. Will it be upgradable to adding ssis, ssrs and ssas in future (I read documentation on Microsoft community blogs, but couldn't find an answer specific to this edition), maybe I will need them in future.

Best Answer

You should simply download and use SQL Server 2017 developer edition. Dev edition is same as enterprise edition so regarding feature you would not have any limitation and free to use for testing and learning. Do not use it in production

Related Question