To find out how to install SQL Server, please go to ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PBG40wvhiG0.html for the Express edition, and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WdvTb7YKi6Y.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
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
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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-glxE7w4D8v8.html Hope this helps!