Database Reference
In-Depth Information
F Server Project: Server project templates are available for SQL Server 2005 and SQL
Server 2008. You can use these templates to define server-level objects as well as
modifications to the SQL Server master database. Examples of server-level objects
are logins and custom error messages.
F Data-tier Application: Data-tier application (DAC) projects are useful for
implementing departmental applications (or other simple applications). Using this
method the DAC package will be operated as a single unit of deployment throughout
the development, test, and production lifecycle of an application.
After Visual Studio 2010 is installed, the data-tier applications process can be initiated using
create a new data-tier application project. Once the project is available, the new database
server objects can be authored, to initialize the project with existing schema. We can employ
one of the two techniques to populate the project with database and server objects for
existing databases and applications. More explicitly, we can import a data-tier application
from an existing database, or we can load schema objects from a DAC package file.
Once the extraction of a DAC package is completed the Extract Data-tier Application Wizard
can be used. Similar to Visual Studio 2010, restriction importing from a DAC package with
SSMS can be done only once, to initialize a new data-tier application project.
Managing the Utility Control Point data
warehouse database
Utility Control Point (UCP) is one of the new management features in SQL Server 2008 R2.
UCP enables you to manage and monitor multiple instances of SQL Server. Data collected by
UCP managed instances of SQL Server are stored in the Utility Management Data Warehouse
(UMDW) database called sysutility_mdw .
To generate data for UMDW, it is essential to create a UCP on an instance of SQL Server.
In this recipe, we will use the SSMS to create the Utility Management Data Warehouse
(UMDW). The steps are wizard-driven to specify a SQL instance-where the UCP is
created-and enable the utility collection set to periodically collect and store in UMDW.
How to do it...
The following steps are essential to manage required data for the UMDW database that will be
generated by using the Utility Explorer wizard to validate the SQL Server instances:
1.
In Management Studio, on the Object Explorer, click Utility Explorer to create the
Utility Control Point (UCP).
 
Search WWH ::




Custom Search