Let’s learn a little T-SQL. Yes, I am doing a series on T-SQL for the absolute beginner who is interested in understanding how to get specific pieces of information for their company’s data. Do you know what are the top selling products or who are the best sales people or maybe even who the best customers are? We are going to start from the ground up learning the environment of Sql Server Management Studio:
, Connecting to a Database Engine
, Querying your Database
, Tables , etc.
To start the series, let’s discuss what Sql Server Management Studio is. The definition provided by MSDN: http://msdn.microsoft.com/en-us/library/ms174173.aspx.
What it says is: “SQL Server "Denali"SQLServer 2008SQLServer 2005
SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server Management Studio combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.”
Basically, a company has data and they need to store and management the data. SSMS assists them in doing that. Being able to organize their data and search for specific information will help them make decisions for their business. Here is a link to download the trial of the application: http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx.
My next post will discuss how to install the AdventureWorks databases. Stay tuned!!!