Пікірлер
@willwill6150
@willwill6150 22 сағат бұрын
Finally, I had it installed with your help. I tried it before but twas confusing.
@JayJamison
@JayJamison 2 күн бұрын
Very informative, helped a lot!
@prathish3169
@prathish3169 3 күн бұрын
Thank you so much it helped me
@moroccomc2670
@moroccomc2670 5 күн бұрын
Hello, I need help, There is a very small project in an attempt to develop the administration and I deal with citizens on a permanent basis There is data on each paper and this paper or document that I give them is the birth certificate, for example one person has data such as the first name, the last name, the date of birth, the name of the father and mother and the place of birth The document is the same and it is as if it is unified, but the data of each person differs and based on this data each person has a number that is not repeated, that is, when searching, you write that number and that person appears (but there are people whose numbers are repeated) so based on these data, a document is extracted in the form of A4 and A5 and those data that I mentioned are in Arabic and French So what is the best program to deal with this?
@SQLServer101
@SQLServer101 4 күн бұрын
Hi Moroc. Thank you for your question. I don't think that there is a single "best program". You could look at Power Apps including AI Builder, or you could look at Azure AI Document Intelligence, for examples. Please have a look at my courses on these topics at www.idodata.com for more details.
@TeddyAllPlays
@TeddyAllPlays 6 күн бұрын
this help me thank you for fixing my sql
@pedromarcos1541
@pedromarcos1541 7 күн бұрын
I keep getting “ Failed to execute activity CheckRulesOnlyActivity”
@SQLServer101
@SQLServer101 4 күн бұрын
Hi Pedro. Thank you for your question. I would suggest redownloading the software. If you have the problem with the Express edition, try downloading the Developer edition instead. Phillip
@ianb5486
@ianb5486 8 күн бұрын
Don't forget the Windows "Advanced" Firewall config
@jonathankingombetshungeoko8627
@jonathankingombetshungeoko8627 9 күн бұрын
Thanks 🙏🙏🙏🙏
@KimZhou-x1c
@KimZhou-x1c 9 күн бұрын
This works on my end, SSMS 2022, too. Thank you so much for saving my time to figure out by myself.
@manjulaguneratne6439
@manjulaguneratne6439 9 күн бұрын
Thank you sir
@saquibhassan5370
@saquibhassan5370 12 күн бұрын
Thanks
@guyborlo6723
@guyborlo6723 13 күн бұрын
Just wonderful ! Thank you so much sir ! See you on Udemy
@hemanthsaimanikantaappari3905
@hemanthsaimanikantaappari3905 13 күн бұрын
working
@vidhipatel5931
@vidhipatel5931 15 күн бұрын
I am using ssms 2022 in that I am not able to find sql server configuration manager dialoge box.Could you please help me with this problem?
@SQLServer101
@SQLServer101 15 күн бұрын
Hello Vidhi. Thank you for your question. Please see learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16 and scroll down to the table which started "Operating system". Phillip
@Abhi-ou3zf
@Abhi-ou3zf 16 күн бұрын
Resolved My Problem. Thanks
@nickrowan
@nickrowan 16 күн бұрын
What if we want to keep the connection encrypted and not use the trust server certificate option or disable encryption? I configured the protocols in SQL server configuration manager to use a cert signed by our CA. When i check the chain it looks fine. The thumbprint of the CA ties up with the one in the chain of the certificate but when I try use a Mandatory or strict encryption it still moans about not trusting the certificate. Any idea where I can start or read up on issues like that?
@SQLServer101
@SQLServer101 15 күн бұрын
Hi Nick. Thank you for your message. Please see learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-sql-server-encryption?view=sql-server-ver16 . Phillip
@filipepaganelli
@filipepaganelli 17 күн бұрын
Fantastic
@yassineelouahmani5702
@yassineelouahmani5702 20 күн бұрын
Thank you for this helpfull video !
@mangalpriyansh074
@mangalpriyansh074 20 күн бұрын
Please suggest a beginner level certificate. Also for oracle database administrator junior level certificate.
@SQLServer101
@SQLServer101 17 күн бұрын
Hi Mangal. There is an Oracle foundamental exam "Oracle Database Foundations" - see education.oracle.com/oracle-database-foundations-novice-level-exam/pexam_1Z0-006 . The closest to a junior level database administrator certificate is Certification Exams Oracle Database Administration I Exam Number: 1Z0-082: education.oracle.com/oracle-database-administration-i/pexam_1Z0-082 . Phillip
@mustafacomez37
@mustafacomez37 21 күн бұрын
Thank you very much
@sudipadhikari7388
@sudipadhikari7388 23 күн бұрын
This worked. Thanks
@vedantsahu3213
@vedantsahu3213 Ай бұрын
why i am getting invalid or not authorized notification
@SQLServer101
@SQLServer101 22 күн бұрын
Hi Vedant. Where/when do you see that? Phillip
@shyamchakravarthy8555
@shyamchakravarthy8555 Ай бұрын
Thank you so much , it worked
@LaadiarmyHR
@LaadiarmyHR Ай бұрын
ERROR: could not open file "C:\Users\dheer\Downloads\Employee_Data.csv" for reading: No such file or directory HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy. SQL state: 58P01
@theentity3061
@theentity3061 Ай бұрын
Hi Phillip, how should I notify sql that the data I'm importing has/doesn't have headings? Also how should I specify 'tab' as a delimiter for importing from a text file when they only accept a single 1-bit character? Thanks in advance
@Abhi2533
@Abhi2533 Ай бұрын
Comprehensively explained.
@ajshah2748
@ajshah2748 Ай бұрын
wonderful - super helpful
@Scaazlol
@Scaazlol Ай бұрын
Since when does KZbin sub button shine when you say "Subscribe"? Anyway good video, thanks
@DataGeniusAcademy
@DataGeniusAcademy Ай бұрын
Well Explained
@matushuriken
@matushuriken Ай бұрын
I don't see anything in Client Protocol
@GoDFazel2
@GoDFazel2 Ай бұрын
i do have the data already in the excel how to import it to the db ? and then get data back to the excel from db ??
@SQLServer101
@SQLServer101 Ай бұрын
Hi GoDFazel. Thank you for your message. Please watch kzbin.info/www/bejne/n3jdc5qaZdaqipY . Phillip
@nonpotpot
@nonpotpot Ай бұрын
Could I ask some question? that I got the issue when I'm restart my computer, it is shown that ORA-12514: Cannot connect to database. Service null is not registered with the listener at host localhost port 1521.What should I fix it?
@SQLServer101
@SQLServer101 Ай бұрын
Hi Nonpotpot. Thank you for your message. Please have a look at kzbin.info/www/bejne/l6i5eJd-etd3rtk . Phillip
@sweetdivine2701
@sweetdivine2701 Ай бұрын
Best video ever for me explanations on point and i just have to followed along to get things done after several attempt. . I will like to have advice on what course to buy for a start . I am interest in Data analytics.
@SQLServer101
@SQLServer101 Ай бұрын
Hello Sweetdivine. It depends what branch of Data analytics you are interested in. If SQL for instance, then I have a 1-hour, 9-hour and 29-hour course, depending on how deep you want to go into it. Please see idodata.com/sql/ for details. Phillip
@rosemarywilliams6904
@rosemarywilliams6904 Ай бұрын
Thank you very much. Problem solved.
@phatluong7420
@phatluong7420 Ай бұрын
Follow your step but cannot connect to the SQL server. An error message saying "A connection was successfully established with the server, but then the error occur during the login process. (Provider: SSL provider, error: 0 - The certificate chain was issued by an authority that is not trusted). Don't know how to fix this. Google but couldn't find a solution
@SQLServer101
@SQLServer101 Ай бұрын
Hi Phatluong. Thank you for your question. Have a look at kzbin.info/www/bejne/hpO1hIKMl6dogdU . Phillip
@srinandhegde3791
@srinandhegde3791 Ай бұрын
This was the best video I found so far, thanks!!! I have a question, if we import before deleting the table from database, does this new imported table replace the existing one? (Assuming names of both tables are same)
@SQLServer101
@SQLServer101 Ай бұрын
Hello. Thank you for your message. It depends on the import settings. By default, the wizard will throw an error saying that the table already exists. However, you may be able to either append the data, or drop the existing table before importing the new data. I hope that helps. Phillip
@SporadicStuff
@SporadicStuff Ай бұрын
Thank you for this video. It's just what i needed.
@pujadey2771
@pujadey2771 Ай бұрын
The video was very helpful.. thanks
@Heldermc04
@Heldermc04 Ай бұрын
thank you.
@HayfordMensah-x5k
@HayfordMensah-x5k Ай бұрын
hello, i followed all the steps on the video but I'm still getting challenges to connect to a server. is there anything i can do?
@SQLServer101
@SQLServer101 Ай бұрын
Hello Hayford. Thank you for your question. Please have a look at kzbin.info/www/bejne/hpO1hIKMl6dogdU . Phillip
@laminationsaidykhan2671
@laminationsaidykhan2671 2 ай бұрын
Thank you so much for the informative video. Could you have a video of how to install Oracle SQL Developer Data Modeler 24.3 If you have time :)
@aditya8646
@aditya8646 2 ай бұрын
thank you so much sir
@scottconklin7417
@scottconklin7417 2 ай бұрын
Thank You!
@elmegderyassine9195
@elmegderyassine9195 2 ай бұрын
thank you man you saved my life
@BenjaminOrkins
@BenjaminOrkins 2 ай бұрын
Thank you for the video! Installation was efficient thanks to this. However, when I go to import an excel file, I get the following error message - "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." How do I fix this?
@SQLServer101
@SQLServer101 2 ай бұрын
Hi Benjamin. Thank you for your message. You will need to install the "Microsoft Access Database Engine 2016 Redistributable" - see www.microsoft.com/en-us/download/details.aspx?id=54920 . Phillip
@paolagarcia7593
@paolagarcia7593 22 күн бұрын
How did you fix it?
@Setalag
@Setalag 2 ай бұрын
Hi, very very helpful to install. Thanks. What next with you ?
@SQLServer101
@SQLServer101 2 ай бұрын
Hi Setalag. I'm currently updating my DP-600 course, as the exam has been updated. Phillip
@B.A.MANAGEMENTConsultationLLC
@B.A.MANAGEMENTConsultationLLC 2 ай бұрын
Very helpful, thank you!!
@gonhat5961
@gonhat5961 2 ай бұрын
thanks
@DerinsDataDossier
@DerinsDataDossier 2 ай бұрын
After launching the SQL Server Installation Center >> installation>> New SQL Server standalone... It's asking me to selct a folder for the installation and I've tried a few folders and it says the folders are not valid installation folders. Please what is a valid folder. I also noticed you didn't get that prompt.
@SQLServer101
@SQLServer101 2 ай бұрын
Hi Philip. Thank you for your question. I would download the SQL Server installer and put it into a simple folder, such as C:/b. Phillip
@bchero7328
@bchero7328 2 ай бұрын
Thank you so much