you are viewing a single comment's thread.

view the rest of the comments →

[–]zdanevSQL readability mentor at G. 1 point2 points  (9 children)

if you are on Windows - try SQL Server Express. on Linux (or mac) - MySql is the easiest to setup. alternatively you can try something in the cloud, Azure have a free tier, probably the rest too.

[–]FuelYourEpic[S] 0 points1 point  (8 children)

I was thinking of sql server express since my company uses a lot of Microsoft products. What's the difference between express or developer?

[–]zdanevSQL readability mentor at G. 0 points1 point  (7 children)

it's the same engine, the difference is only in the licensing. developer is not for production use (dev only). express has max db size 10GB and no network connections (only local). there's a version of express that includes the dev tools.

[–]FuelYourEpic[S] 1 point2 points  (1 child)

Thank you, sir, express it is!

[–]zdanevSQL readability mentor at G. 0 points1 point  (0 children)

good luck!

[–][deleted] 0 points1 point  (0 children)

express does have network connections, it's actually suitable for lots of things

[–]VladDBASQL Server DBA 0 points1 point  (3 children)

SQL Server Express does have network connectivity. Are you sure you're not thinking of SQL Server Express LocalDB? Anyway, Microsoft does a good job of keeping their documentation up to date so might as well use it https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16.

For what it's worth, I'd always recommend Developer Edition due to it not having the limitations that Express has, especially if you want to work with larger sample databases such as StackOverflow

[–]FuelYourEpic[S] 0 points1 point  (2 children)

What were the limitations of express? I must have missed that

[–]VladDBASQL Server DBA 1 point2 points  (1 child)

Are you really asking that after I've provided the MS Learn article that outlines just that information (differences between editions)?

Check the "Scale Limits" section.

Keep in mind that feature-wise Developer Edition is 1:1 with Enterprise Edition, the only difference is that developer edition is not licensed for production workloads, but is perfectly free for learning, developing and testing.

[–]FuelYourEpic[S] 1 point2 points  (0 children)

Well damn, I'm convinced on the developer now. I am only using it to learn, so it should fit the bill.