FREE SQL Server Express or SQL Server Developer - which edition should you install?

preview_player
Показать описание
You can install a version of SQL Server on your computer for free - but which should you choose. Well, it depends. :-)
My SQL Server Udemy courses are:
----
Both SQL Server Express and SQL Server Developer are free. You don't need a server to install them. However, which should you install?
SQL Server Developer gives you all of the features of the expensive Enterprise version. However, it cannot be used for commercial purposes.
SQL Server Express can be used for commercial purposes. However, it is a cut down version, and you cannot use it with SSIS or SSAS. If you want to use SSRS, then you can use Express with Advanced Services.
Рекомендации по теме
Комментарии
Автор

As someone who’s getting into SQL and BI development, you answered all of my questions about which version of SQL Server I should download. Thank you for this thorough breakdown!

Louisianish
Автор

Thanks for this informative video. One thing you did not touch on was if the SQL Express edition lets you subscribe to a publication? If not, is there a way to push the data from a SQL Server Standard or Enterprise server to SQL Express? We just need to offload some tables for reporting purposes.

tberneman
Автор

please i need your help i couldn't install my sql server ????

nouraamina
Автор

I am using SSMS 2018 right now, is it okay if I move to sql 2022? thank yo

deryansyah
Автор

Glad to meet again..
As a new sql learner i hold a simple enquiry.
SQL Server 10.50.4000
How these numbers (10.50.4000) reveal anything about the version of sql server?
Thanks a lot

hasanmougharbel
Автор

Can I install both express and developer on my computer?

patricknornyibey