Posts

Image
  Restoring AdventureWorks2017 and AdventureWorksDW2017 Databases Restoring the AdventureWorks sample databases In this post we would see the steps to download/Update AdventureWorks sample databases, and steps for restoring database on our SQL Server. search "download adventureworks database" in google and click on the first link (docs.microsoft.com) As we click, the following page comes up We will find three types of files : OLTP  data is for most typical online transaction processing workloads. Data Warehouse (DW)  data is for data warehousing workloads. Lightweight (LT)  data is a lightweight and pared down version of the OLTP sample. We would download OLTP and also DW  AdventureWorks2017.bak AdventureWorksDW2017.bak Now we will open the SSMS and restore the database that we have downloaded. As we can see, we have different databases but not AdventureWorks. Right on databases and Restore Database  A dialog box pops up as below... Click on the device and ...
Post a Comment
Read more

Welcome to My Blog Data Works 4U

Greetings one and All, Before I start posting blogs let me briefly introduce myself.  Myself Samiullah Khan Mohammed, I have around 12+ years of Industry experience, done my Bachelors of Engineering in Computer Sciences.  Green Belt, ITIL Foundation in IT Service Management and Prince 2 Certified. I am Permanent Resident of Australia and currently residing in Adelaide, South Australia.  Have made this Blog to help self and others who may be in need of any help. Please comment and let me know, if you like or dislike any of my post... your feedback would help me in improving myself. Best Regards, Samiullah Khan Mohammed
Post a Comment
Read more