Remoting Examples - Good 70-320 Revision

CallContext

Summary of Available COM+ Services

Creating a pivot table with SQL :

select application_group.id
, application_group.display_name
, sum(case when state = 'Online'
then 1 else 0 end) as cntOnline
, sum(case when state = 'Offline'
then 1 else 0 end) as cntOffline
, sum(case when state = 'Faulted'
then 1 else 0 end) as cntFaulted
from application_group
inner
join resource_group
on application_group.id = resource_group.app_group_id
group
by application_group.id, application_group.display_name

ASP.NET.4GuysFromRolla.com: Summarizing Data with ROLLUP