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

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:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
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.

[@SQLServer101]

To find out how to install SQL Server, please go to czcams.com/video/PBG40wvhiG0/video.html for the Express edition, and czcams.com/video/WdvTb7YKi6Y/video.html for the Developer edition.

[@Louisianish]

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!

[@muup8073]

Useful content!

[@tberneman]

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.

[@SQLServer101]

Hello - thank you for your question. Yes, you can use Merge, Transaction and Snapshot Replication on SQL Server Express as a subscriber. See expressdb.io/sql-server-express-feature-comparison.html#sql-server-windows-2022 for details.
Phillip

[@alexunni4360]

how to instal web edition?

[@nouraamina163]

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

[@hasanmougharbel8030]

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

[@SQLServer101]

Hi Hasan. You have SQL Server 2008 R2 Service Pack 2 - see docs.microsoft.com/en-us/troubleshoot/sql/general/determine-version-edition-update-level and search for 10.50.4000 on that page. Phillip

[@deryansyah]

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

[@SQLServer101]

It depends on your situation. If you are using it on your own computer, it shouldn't be a problem (but take backups first). If on a corporate computer, it may need planning - speak to your IT department. Phillip

[@taz2392]

Can you install it on a Mac

[@SQLServer101]

Hi TI. Thank you for your comment. You can install it on a Mac if you have Parallel Desktop or dual-boot into Windows. Phillip

[@mawuenaakwayena3056]

Hi @Taz yes you can. by using docker. Just quickly search on youtube . here's one video that explains how czcams.com/video/glxE7w4D8v8/video.html Hope this helps!