Getting ready

1. Create a query from a database, which would serve as the source for other queries via the standard Get Data and Query Editor experience described earlier in this chapter.
   • Select Get Data from the ribbon, choose SQL Server, select a table or view, and click on Edit.
   • A preview of the data will appear in the Query Editor and the Advanced Editor window will expose the server and database name.