Microsoft Office Tutorials and References
In Depth Information
SQL Server Management Studio
SSMS is not something new to developers. You’ve probably used this tool in your day-to-day activities or at least for
a considerable period during any development project. Whether you’re dealing with OLTP databases or OLAP, SSMS
plays a significant role, and it provides a lot of the functionality to help developers connect with OLAP databases.
Not only can you run T-SQL statements, you can also use SSMS to run MDX queries to extract data from the cubes.
SSMS makes it feasible to run various query models, such as the following:
New Query: Executes T-SQL queries on an OLTP database
Database Engine Query: Executes T-SQL, XQuery, and sqlcmd scripts
Analysis Services MDX Query: Executes MDX queries on an OLAP database
Analysis Services DMX Query: Executes DMX queries on an OLAP database
Analysis Services XMLA Query: Executes XMLA language queries on an OLAP database
Figure 1-12 shows that the menus for these queries can be accessed in SSMS.
Figure 1-12. Important menu items in SQL Server Management Studio
the sQl server Compact edition (Ce) code editor has been removed from sQl server Management studio in
sQl server 2012. this means you cannot connect to and query a sQl Ce database using management studio anymore.
tsQl editors in Microsoft Visual studio 2010 service pack 1 can be used instead for connecting to a sQl Ce database.
Note
Figure 1-13 shows an example of executing a new query against an OLTP database.
 
 
Search JabSto ::




Custom Search