To find out how to install SQL Server, please go to th-cam.com/video/PBG40wvhiG0/w-d-xo.html for the Express edition, and th-cam.com/video/WdvTb7YKi6Y/w-d-xo.html for the Developer edition.
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!
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.
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
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
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
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
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
Hi @Taz yes you can. by using docker. Just quickly search on youtube . here's one video that explains how th-cam.com/video/glxE7w4D8v8/w-d-xo.html Hope this helps!
To find out how to install SQL Server, please go to th-cam.com/video/PBG40wvhiG0/w-d-xo.html for the Express edition, and th-cam.com/video/WdvTb7YKi6Y/w-d-xo.html for the Developer edition.
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!
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.
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
Useful content!
I am using SSMS 2018 right now, is it okay if I move to sql 2022? thank yo
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
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
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
Can I install both express and developer on my computer?
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
how to instal web edition?
please i need your help i couldn't install my sql server ????
Can you install it on a Mac
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
Hi @Taz yes you can. by using docker. Just quickly search on youtube . here's one video that explains how th-cam.com/video/glxE7w4D8v8/w-d-xo.html Hope this helps!