Databases Reference
In-Depth Information
Figure 10-3.
Managing your SQL Database instance
Clicking on the Manage icon brings up another window, asking you to log in to the database server you selected.
On that screen you can also specify the name of your database (EnzoLog2 in my example). Once logged in, you are in
the SQL Database Management Portal, as shown in Figure
10-4
.
Figure 10-4.
Viewing the properties of your database
You will notice that your federations are showing up on the right; both CustomerVisits and PurchaseHistory
can be seen in Figure
10-4
. Let's click on PurchaseHistory. The Drop Federation button right underneath it becomes
enabled, allowing you to drop the entire federation with a single click. Dropping a federation will drop all the
federation members. From this screen you can also create a new federation by clicking the New button on top, or you
can also view the performance of your queries by clicking Query Performance. Note, however, that the performance
information shown will only apply to the root database because that's what we are looking at right now.
To view the details of a federation, click the arrow to its right. If you click to view the details of PurchaseHistory,
for example, the screen will look like Figure
10-5
. You can browse on top of each federation member, or click on them
to see a window showing additional options. For example, you can resize individual federation members from this
