The Microsoft SQL query pane in Visual Studio 2008 is used to write T-SQL queries to extract data from Microsoft Dynamics 2011 and then manipulate the data in Excel 2007 and 2016 in order to profile our customers. Visual Studio 2008 is used to build SSRS reports for users to run themselves. I am self taught so there are gaps in my knowledge. I use forums to fill those gaps where possible.