Access to Server and Real Data for Performance Tuning [closed]

Question

I'm newbie in performance tuning (PT) in SQL server and I have read some documents about how to do it. It is based on theory from the articles or books.

The next step to is to learn about it by practice and if you are a private person who doesn't have access to a server with lots of data. Let's say that it is a student who wants to learn about PT in practice.

My question is: How should a student learn about PT in practice when you don't have access to a server with real data?

Is there a company which provides education with a server and real data?

Answer 1

Below is not complete (and longer than a comment)- since this is a very open ended question and will be closed (I am voting it to close as well).

I have laid below down to give you guidance and help you get started.

• You have to install sql server. Go for a Developer edition.
• download and restore Adventure Works 2014 Sample Databases
• If you want to work with lots of data then - Enlarge the AdventureWorks Sample Databases
• You can have open source data - e.g. stackexchange data and then import it into sql server.
• Highly recommend to read this answer - performance tuning is an art not science .. and you will slowly and gradually master it.
• Among many book that I have read, I would highly recommend T-SQL Querying by Itzik Ben-Gan

Is there a company who provide education with server and real data?

Stackexchange does provide with data and an interface. Infact, Brent and his team utilizes this data to demonstrate query tuning.

Also, you can play with optimizer to lead it to believe you have a large data (this is very advance and would not recommend to any novice in SQL Server field)

UPDATE STATISTICS table_name WITH ROWCOUNT = 10000000000, pagecount = 100000000000