Thank you, please I am encountering an issue. i downloaded the sql server, and the ssms, but when i try to connect from the management studio, the section for server name is showing blank. what must i be doing wrong? i use a corei7 with a 8gb ram.
hi, i am having issues installing the SQL SSEI extension. the prompt i receive here is 'could not load file or assembly. system.web.extensions, version 4=0.0.0, bla bla bal. the system cannot find the file specified. Hod do i deal. thank you
Hello, I have tried installing on my system but I keep getting an error that says the path isn't specified. I have changed path and even installed on local drive e but still same error. What can I do please? Thank you.
Apologies for the challenge you are facing. This error is strange to me. Can you give your system specifications. Like the RAM, operating systems. I am assuming that there are some systems library that might be missing. TBH, it's hard to diagnose without having more details. Can you also try to restart your PC and try again
Hi Lauretta. Thank you for your feedback. Are you using your personal computer or work computer? Can you locate the file in your download folder? Which link/site are you downloading the adventureworks db from? Kindly validate that you are downloading the backup file
@@TheOyinbooke Hello. Thanks for your response. I am using my personal computer and i clicked the 3rd link in the description box to download. Yes i can locate the file in my download, its there as a pdf document. I can send you a screenshot of it, if you don't mind.
@@ogonulauretta240 I clicked the same link and I got the file downloaded with a .bak extension. Maybe the thumbnail changed to pdf and it is a .bak file. Kindly check the extension of the file and confirm. Also, for you to restore the adventureworks backup file, you will need to move it from your download to a folder closer to the MSSQLEXPRESS folder in your Program file. I navigated to this folder in the video as well. Do let me know if you are able to resolve this
Hi.. i am learning through your videos .. I have SS-2012 version and this backup fileis not supporting my Sql server..can you provide any other file please so that i can learn better...TIA
Thank you so much for this. Doing the Power BI project, are we to first install the Adventure dataset into the SQL server and then connect power Bi to the SQL server. Or we should write a query to bring out the data we want to work with from the SQL server and then export it as an excel file now load it to the power BI. Question is how do we use power BI and this SQL for the power BI project on Adventure dataset
Here is how you connect with the database in Power BI ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Dv8paxjho_k.html You are to connect directly with the database
Thank you, I find this so detailed. What if I have an mdf file, where should it be stored and how will I install it? BTW... I plan to finish this series