Oct 24 2011

Comment by Seth Spearman on Powershell: How to recursivelly delete all svn files

OK...thanks for the clarification ; / )
Oct 24 2011

Comment by Seth Spearman on Powershell: How to recursivelly delete all svn files

Keith, both you and stej included the -recurse argument in the remove-item cmdlet. Is that really necessary? I tried it without and it worked which seems logical since remove-item is going to operate on what it is passed through the pipeline? But the fact that both of you included it in your example gives me pause. Am I missing something or am I right that the second recurse is not needed? Seth
Oct 19 2011

Comment by Seth Spearman on Are there other .NET based Content Management Systems (CMS) beside DotNetNuke that support multiple sites with one install?

Chris, GREAT comment and thanks for the insight. My company is considering hosting micro-sites for each of our customers. The customers will have very limited theming and extending options. They would definitely not be able to add modules. We are talking 1000s of site. In that circumstance do you think multi-tenancy could be made to work? Seth
Oct 19 2011

Are there other .NET based Content Management Systems (CMS) beside DotNetNuke that support multiple sites with one install? [migrated]

I know that there are a LOT of questions on SO about CMSs based on .NET but I have just one specific question.

I know that DotNetNuke supports multiple site creation on one installation. Of the other wellknown .Net CMSs...

N2CMS Composite C1 Umbraco Orchard AxCMS

...do any of them support this feature out of the box (or with relative ease)?

BTW, if you know of some low-cost non-free CMSs that would support this feature don't hesitate to give them a mention (as long as they are built on the Microsoft stack.)

EDIT Just learned that this feature is called multi-tenancy...thanks David. Thanks for your answers. Can anyone give clarity on whether N2CMS, Composite, or AxCMS support multi-tenancy.

Seth

Oct 19 2011

Are there other .NET based Content Management Systems (CMS) beside DotNetNuke that support multiple sites with one install?

I know that there are a LOT of questions on SO about CMSs based on .NET but I have just one specific question.

I know that DotNetNuke supports multiple site creation on one installation. Of the other wellknown .Net CMSs...

N2CMS Composite C1 Umbraco Orchard AxCMS

...do any of them support this feature out of the box (or with relative ease)?

BTW, if you know of some low-cost non-free CMSs that would support this feature don't hesitate to give them a mention (as long as they are built on the Microsoft stack.)

EDIT Just learned that this feature is called multi-tenancy...thanks David.

Seth

Oct 12 2011

Comment by Seth Spearman on Can you pivot and aggregate on two columns with a Sql PIVOT query

Thanks...thought it would be something like this. How does this perform? Seth
Oct 11 2011

Can you pivot and aggregate on two columns with a Sql PIVOT query

Can you pivot two columns in a pivot query.

Suppose I have the following data...

CREATE TABLE JudgeScores 
    (PerformanceID int, 
    JudgeID int, 
    Criteria varchar(10), 
    StrengthScore decimal(9,4), 
    StyleScore decimal(9,4))

--first team performance
--judge1
INSERT INTO JudgeScores (1, 1, "Stunts",        4.2, 1.1)
INSERT INTO JudgeScores (1, 1, "Jumps",         3.9, 0.8)
INSERT INTO JudgeScores (1, 1, "Tumbling",      4.5, 1.0)
INSERT INTO JudgeScores (1, 1, "Choreography",  4.2, 1.5)
--judge2
INSERT INTO JudgeScores (1, 2, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (1, 2, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (1, 2, "Tumbling",      4.4, 1.1)
INSERT INTO JudgeScores (1, 2, "Choreography",  4.2, 1.6)

--judge3
INSERT INTO JudgeScores (1, 3, "Stunts",        3.8, 1.2)
INSERT INTO JudgeScores (1, 3, "Jumps",         4.2, 0.7)
INSERT INTO JudgeScores (1, 3, "Tumbling",      4.3, 1.2)
INSERT INTO JudgeScores (1, 3, "Choreography",  4.1, 1.3)


--second team performance
--judge1
INSERT INTO JudgeScores (2, 1, "Stunts",        4.3, 1.3)
INSERT INTO JudgeScores (2, 1, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (2, 1, "Tumbling",      4.6, 1.1)
INSERT INTO JudgeScores (2, 1, "Choreography",  4.0, 1.0)
--judge2
INSERT INTO JudgeScores (2, 2, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (2, 2, "Jumps",         4.0, 0.9)
INSERT INTO JudgeScores (2, 2, "Tumbling",      4.5, 1.2)
INSERT INTO JudgeScores (2, 2, "Choreography",  4.2, 1.6)

--judge3
INSERT INTO JudgeScores (2, 3, "Stunts",        4.1, 1.1)
INSERT INTO JudgeScores (2, 3, "Jumps",         4.5, 0.9)
INSERT INTO JudgeScores (2, 3, "Tumbling",      4.4, 1.2)
INSERT INTO JudgeScores (2, 3, "Choreography",  4.2, 1.6)

I want to select the data so that it will pivot this data as follows

PerformanceID, JudgeID, StuntsStrength, StuntsStyle, JumpsStrength, JumpsStyle, TumbleStrength, TumbleStyle, ChorStrength, ChorStyle
1     1     4.2,    1.1,    3.9,    0.8,   4.5,   1.0,    4.2,     1.5
1     2     4.1,    1.1,    4.0,    0.9,   4.4,   1.1,    4.2,     1.6
...
2     1     4.3,    1.3,    4.0,    0.9,   4.6,   1.1,    4.0,    1.0
2     2     4.1,    1.1,    4.0,    0.9,   4.5,   1.2,    4.2,    1.6
2     3     ...

Can this be done with a pivot query. If not what is the best way to do it?