SQL server integration services
Microsoft SQL server 2008 inherits from the base of Data Transformation Services of Microsoft SQL server 2000 and improves the performance, usability and manageability aspects of the tool. That contains the Business Intelligence Workbench and SQL server Workbench. Moreover, those services enable to extract data from the data warehourse. Analysis Services to give the better performance.
Relational and XML data support
SQL server 2008 supports both relational and XML data. The XML is available through the addition of the XML data types and allows XML fragments and document. It have many new data types such as VARCHAR(MAX), NVARCHAR(MAX), which allows to store up to 2GB of data such as text, ntext, and image data types.
SQL computer manager
This utility is accessible from the Programs menu and implemented as the Microsoft Management console snap in.
SQL profiler
The SQL profiler is enhanced with a few new features. This includes the MDX Analysis Services statements and monitoring the operation of the Data Transformation services. Grouping and recorded events by views on the basic of selected criteria. Special file types can be used to extract and store events for ease of troubleshooting.
Database tuning advisor
It integrated with SQL profiler and reduces the time to tuning. It analyzes workload and physical implementation of one or more databases.
Command line utilities
The SQLWB.EXE launches the SQL server Management studio from the command prompt.
SQLCMD.EXE
This is a new and improved version of the OSQL and ISQL programs. It helps connect to other SQL server versions and connect to server via Dedicated Administrative connections.
Features of SQL server 2008
References:
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032368942&EventCategory=5&culture=en-US&CountryCode=US
http://www.sqlsoft.com/coursedescriptions/SQL-243.html?c=1662
No comments:
Post a Comment