Join Martin Guidry for an in-depth discussion in this video Setting up for the course, part of Designing Database Solutions for SQL Server 2012.
- For this course, we'll be using the AdventureWorks sample database provided by Microsoft. You can locate this by going to your favorite search engine and searching for AdventureWorks. The specific version we're looking for is the 2012 version so you might wanna include that in your search also. When downloading, be aware that there are different versions based on the different releases of SQL Server such as 2008 or 2012 and also there is a specific version of AdventureWorks for data warehousing.
That's not the one we want. We don't want the data warehousing one. We just want the general AdventureWorks so I'll click on this one. Go ahead and download it and then I will open from the download. Inside of the zip, we see two files, an mdf data file and an ldf log file. I'm gonna take both of those and copy them into the working data directory for my SQL Server.
I'll just drop both of those files into this data directory. Then I'll open up SQL Server Management Studio and from here I'll need to attach the database. So I can right click on Databases and one of the menu options will be Attach. It's asking me for the location of the MDF file so I'll go ahead and point to that directory I was looking at just a second ago. There we see AdventureWorks2012. Notice it automatically found the Log file.
If not, you could tell it where the Log file is but for me it automatically picked up that location. Hit OK and I should be good. If I open up Databases, I'll see AdventureWorks2012. I can open that up and see lots of tables and just to test this I could right click on one of the tables, do a select top 1000 rows and just ensure that some data comes back up. Doesn't really matter what the data is. Just the fact that it returns some data implies that I have successfully installed the AdventureWorks database.
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell