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

Рет қаралды 16,876

Күн бұрын

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.

Пікірлер: 16

@SQLServer101 Жыл бұрын

To find out how to install SQL Server, please go to kzfaq.info/get/bejne/hqh3Z5Oo287Nd2Q.html for the Express edition, and kzfaq.info/get/bejne/jcqmh8VovrHNZo0.html for the Developer edition.

@Louisianish 2 жыл бұрын

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 3 ай бұрын

Useful content!

@alexunni4360 3 ай бұрын

how to instal web edition?

@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

@nouraamina163 2 жыл бұрын

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

@hasanmougharbel8030 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Can you install it on a Mac

@SQLServer101 2 жыл бұрын

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 kzfaq.info/get/bejne/ndKoeJqomaqcpmw.html Hope this helps!

@patricknornyibey7144 6 күн бұрын

Can I install both express and developer on my computer?

@SQLServer101 3 күн бұрын

Hi Patrick. You can, but one of them would be a "named instance" instead of the "Default instance". If the default instance was addressed as COMPUTERNAME, the named instance would be addressed as COMPUTERNAME\SERVERNAME. Phillip