Enroll an Instance of SQL Server or a Data-tier Application from Utility Explorer You can easily enroll an instance of [!INCLUDE ssNoVersion] into the [!INCLUDE ssNoVersion] Utility. In Utility ...

Utility Dashboard (SQL Server Utility) To see data in the [!INCLUDE ssNoVersion] Utility dashboard, select the top node in the Utility Explorer tree - labeled "Utility<UCP_Name>\ (ComputerName\UCP)." ...

Setup of a UCP is wizard-based and is launched directly from SQL Server Management Studio (see Fig. 1). When in SSMS, click the View menu, and then choose the Utility Explorer.

But SQL Server itself provides you with no way to see what's in the transaction log. If something goes wrong with your database, you can restore from a backup -- but there's no way to see in ...

SQL Server In my last blog entry, I talked about setting up a Utility Control Point in SQL Server 2008 R2 (CTP) and enrolling managed instances so we can monitor multiple servers from that UCP.