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.
Figure 1-13 shows an example of executing a new query against an OLTP database.
Search JabSto ::