Tuesday, March 27, 2012

SharePoint 2010 and the Health Analyzer | The Beagle - Technology for SMB's

Good article about Sharepoint and the Health Analyzer.  The main take away for me was the index fill factor which I've over looked in previous deployments.

SharePoint 2010 and the Health Analyzer | The Beagle - Technology for SMB's:

Reference: http://www.microsoft.com/download/en/details.aspx?id=24282

'via Blog this'

Wednesday, March 14, 2012

SQL Powershell Set all DBs to Simple recovery

Simple recovery model has its place but here's an easy way to set it programatically

$DBinstanace = sqlserver:\sql\\
gci $DBinstanace\Databases| where {$_.RecoveryModel -like "Full"}|`
foreach {
$_.RecoveryModel = [Microsoft.SqlServer.Management.Smo.RecoveryModel]::Simple
$_.Alter()
}

Thursday, March 1, 2012

Sharepoint 2010 PrerequisiteInstaller.Arguments File

Here's a helpful tip if you create your own PrerequisiteInstaller.Arguments.txt file.  Make sure there is a space at the end of each line if you're breaking it out to make it more readable.

/unattended
/SQLNCli:PrerequisiteInstallerFiles\sqlncli.msi
/ChartControl:PrerequisiteInstallerFiles\MSChart.exe
/IDFXR2:PrerequisiteInstallerFiles\Windows6.1-KB974405-x64.msu
/NETFX35SP1:PrerequisiteInstallerFiles\dotnetfx35setup.exe
/KB976462:PrerequisiteInstallerFiles\Windows6.1-KB976462-v2-x64.msu
/Sync:PrerequisiteInstallerFiles\Synchronization.msi
/FilterPack:PrerequisiteInstallerFiles\FilterPack\FilterPack.msi
/ADOMD:PrerequisiteInstallerFiles\SQLSERVER2008_ASADOMD10.msi
/Speech:PrerequisiteInstallerFiles\SpeechPlatformRuntime.msi
/SpeechLPK:PrerequisiteInstallerFiles\MSSpeech_SR_en-US_TELE.msi
/ReportingServices:PrerequisiteInstallerFiles\rsSharePoint.msi

other resources:
http://technet.microsoft.com/en-us/library/ff686793.aspx#switcharg
http://technet.microsoft.com/en-us/library/cc262485.aspx#section5