Hi. You can increase the max degree of parallelism (MAXDOP) setting by running EXEC sp_configure 'max degree of parallelism', 8; -- replace 8 with the number of processors you want to use RECONFIGURE; Phillip
Hi Soumesh. I have two courses about "Software Development Fundamentals", one using C# and the other VB.Net, and I have a video on connecting to SQL Server in that course. Please have a look at my website, idodata.com/fundamentals/, to see my Udemy programming courses. Phillip
I downloaded SQL2019-SSEI-Dev file - my installation seems very different from your video. I'm not sure what I did incorrectly. can you help me out here?
Hi, everything was going great until the installation part, i got an error: Microsoft OLE DB Driver for SQL Server, The feature you are trying to use is on a network resource that is unavailable. It is asking me for a path but I don't know exactly why. I would really appreciate some help, thank you!
Sir Good day! im new to SQL. im not sure how did i passed the interview but i was hired as Information Systems admin and i just knew that it focuses more about database. They are currently using MYsql. Please advice on what will be the adjustments and the certificates that i needed since im just new to database. I used to work as IT Support for 5years and this is my first week as a database admin and have zero knowledge :) please help
Sir , Could you please this error which I had while installing SQL server developer 2019 edition. Data base engine service -failed ,analysis service -failed ,sql writer -failed
Hello, thank you for the very detailed tutorial. I am having trouble completing the installation on my system. Can you please help me. "Setup completed with required actions for features. Troubleshooting information for those features: Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again." I copied this from the summary txt
If I may add… What brought me to your page is SQL server developer installation while having SQL server express already installed… after installing the developer version.. i had difficulties in connecting to It What I finally did to connect to the developer version and not the express is : Server name/ browse / Engine data base/(choose the name of the instance I gave during sql developer installation)… I was able to connect to SQL developer and not SQL express already installed on my computer (which is the default instance ..the first installed)… We should take not of the instance name we give during installation it will later on help to connect to different versions of SQL server. Thanks for the video.
This video is for the 2019 edition. To install the latest 2022 edition, please go to ruclips.net/video/WdvTb7YKi6Y/видео.html . Phillip
Your calm talk is hypnotizing, you are perfect for giving explanations. Thanks for all those guides
Great video. Thanks. I didn't realize there was a full blown free version of SQL Server. Thank you again.
Hi Bob. Glad to help. Phillip
@@SQLServer101 how can i force sql server developer edition to use more cpu
Thank you, for your amazing content, i just installed sql server 2019! wao
BIG THANK YOU for this tutorial , very very helphful and well explained
My guy, thank you so much. Super helpful video!!
Great tutorial, works like a charm!!!
This is legit content man, thank You!
how can i force sql server developer edition to use more cpu
Hi. You can increase the max degree of parallelism (MAXDOP) setting by running
EXEC sp_configure 'max degree of parallelism', 8; -- replace 8 with the number of processors you want to use
RECONFIGURE;
Phillip
best video , i learnt a lot. thank you
Thank you so much this is was very helpful
Thanks for your video 🙏🏾
Thank you so much for this
thanks a lot for this video!
Great video. Congrats.
I have done all of the above steps it worked but How to connect this with the spring boot app I am facing some errors pls make some video on this
Great tutorial, Thank you, can I consult with you, send you a question about the version?
Feel free to add a question into the comments.
Thank you so much!
could you please make a video on how to connect sql server developer edition to vs code. it will be a great help
Hi Soumesh. I have two courses about "Software Development Fundamentals", one using C# and the other VB.Net, and I have a video on connecting to SQL Server in that course. Please have a look at my website, idodata.com/fundamentals/, to see my Udemy programming courses. Phillip
I downloaded SQL2019-SSEI-Dev file - my installation seems very different from your video. I'm not sure what I did incorrectly. can you help me out here?
I ran the Basic installation instead of the Custom installation. Followed along after fixing that.
Hi, everything was going great until the installation part, i got an error: Microsoft OLE DB Driver for SQL Server, The feature you are trying to use is on a network resource that is unavailable. It is asking me for a path but I don't know exactly why. I would really appreciate some help, thank you!
Hi Ana. I would download SQL Server Developer (using the third option in the thumbnail), and then put it somewhere on your C drive. Phillip
Its working 👍
i am not authorized to install the server. please help
Hi Doggy. It sounds like you don't have administrative rights. You will need to contact whoever set your computer up. Phillip
great guide very helpful 👍
Sir Good day! im new to SQL. im not sure how did i passed the interview but i was hired as Information Systems admin and i just knew that it focuses more about database. They are currently using MYsql. Please advice on what will be the adjustments and the certificates that i needed since im just new to database. I used to work as IT Support for 5years and this is my first week as a database admin and have zero knowledge :) please help
Please have a look at education.oracle.com/oracle-certification-path/pFamily_406
Good video, thanks.
Sir ,
Could you please this error which I had while installing SQL server developer 2019 edition.
Data base engine service -failed ,analysis service -failed ,sql writer -failed
same Database engine service - failed
Same what to do?
Hello, thank you for the very detailed tutorial. I am having trouble completing the installation on my system. Can you please help me. "Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again." I copied this from the summary txt
Hey thank you dude
Thank you Sir.
Thanks alot🤘
THANK YOUUU.
GREAT VIDEO
Thanks so much
As a Data Scientist which version of SQL server 2019 Developer version or Express version?
Please help me with this.
Dear Fun - both will be fine. The Developer edition does have more features, so if you want to use R or Python in SQL Server, go for that. Phillip
great guide ...
THANKS A LOT
is it possible to have data subscription in this edition
sir i m facing issue i m using window 8 i have tried all versions but no version is working on winodw 8 .1 help pls
I assume that you are using a 32-bit version of Windows. If that is the case, you will need to download SQL Server 2014.
@@SQLServer101 problem has been solved thank you!
thxxxxxxxxxxxxxxxxx
Gréât
If I may add…
What brought me to your page is SQL server developer installation while having SQL server express already installed…
after installing the developer version..
i had difficulties in connecting to It
What I finally did to connect to the developer version and not the express is :
Server name/ browse / Engine data base/(choose the name of the instance I gave during sql developer installation)…
I was able to connect to SQL developer and not SQL express already installed on my computer (which is the default instance ..the first installed)…
We should take not of the instance name we give during installation it will later on help to connect to different versions of SQL server.
Thanks for the video.
Thank so much !!!
thanks so much