How to install sample data (from AdventureWorks) on your SQL Server

Подписаться 17 тыс.

Просмотров 37 тыс.

50% 1

In this video, we'll have a look at how to install sample data on your SQL Server.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
Do you want to have some sample data to play with on your SQL Server?
The good news is that Microsoft has released a set of sample data called AdventureWorks.
The bad news is that Microsoft keeps changing its location.
In this video, I'll show you how I find the current location. We'll also find out which version of AdventureWorks you should NOT install (if you are not running the latest version of SQL Server), and then how to install it.
I cover backup and restore more in depth as part of my 98-364 course (rebrand.ly/dat... ). Why not check out that course, or any of my courses, on www.filecats.co.uk ?

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@jillannsarah5932 5 месяцев назад

This is the second video of yours that I have watched, and once again it was excellent. I was able to get Adventureworks installed on the first try!

@leez6321 9 месяцев назад

thank you so much, I have been stuck on this issue for a long time. BEST video on this topic.

@kimberlysomething9012 7 месяцев назад

Thank you. I managed to upload the 2016 version, all later years would not execute, so for those struggling try earlier versions.

@monicabright2903 Год назад

Thank you, you just helped me get past the point I was stuck.

@gadshoaib2402 2 месяца назад

Thanks, you nailed it especially in 2:55

@surajbhardwaj428 7 месяцев назад

Thank you so much 😃. I Really need sample data for practicing.

@Sasha-nk6is 4 месяца назад

thanks! this was so clean and quick

@cupcakes3886 29 дней назад

Thanks bro that was helpful

@swghavoc Год назад

OMG.!!!!!!!!!!!!!!!!!!! THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@shivamsinghtomar3440 2 года назад

I Found it on similar website Explanation was wonderful and very smooth Thanks for Sharing it with us Bless You😇

@moustaqssamohamed3328 23 дня назад

good job

@genelizleyici6739 10 месяцев назад

Thank you dear kind sir

@EWaveRadiator 4 месяца назад

Thank you!

@martineavila5708 Год назад

Great video, thanks.

@marinabenny616 2 месяца назад

I have followed the exact steps from the video but when I try to find the file through SQL it says it doesn't exit. Bu when you go to the file location in file explorer you can see it. Not sure how to get past this.

@SQLServer101 2 месяца назад

Hi Marina. Thank you for your question. I would move to a simple folder, such as C:/b/, and see if you still have the same problems. Phillip

@pratyashananda707 4 месяца назад

thank you so much

@xinyue3317 3 года назад

so that website shutdown right now, do you have other suggestions to download a practice one?

@larisa8772 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2VQrygVUP-4.html this video helped me

@ellaacheampong8824 3 месяца назад

Hi I love your tutorial. So easy to understand. But I am stuck. I cannot get past the Connect Dialog box that appears on my screen. i do not know the details to fill in these columns; Server Name and Host In Certificate. Kindly assist me

@SQLServer101 3 месяца назад

Hi Ella. If you have installed SQL Server on your own machine, then you can use localhost or . as the server. Phillip