standard sql drives

stdsqldrives.ps1

<# 
20gb E: SQLBinaries
20gb F: SystemDB
10gb G: TempDBData
10gb H: TempDBData2
10gb I: TempDBData3
10gb J: TempDBData4
10gb K: TempDBLog
50gb L: SQLData
20gb M: SQLLog
10gb W: NonSQLData

Clear All Disks:
Get-Disk 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 | Clear-Disk -RemoveData
#>

$newdisk = @(Get-Disk | Where-Object partitionstyle -eq 'raw')
$Labels = @('SQLBinaries','SystemDB','TempDBData','TempDBData2','TempDBData3','TempDBData4','TempDBLog','SQLData','SQLLog','NonSQLData')

for($i = 0; $i -lt $newdisk.Count ; $i++)
{

    $disknum = $newdisk[$i].Number
    $dl = get-Disk $disknum | 
       Initialize-Disk -PartitionStyle MBR -PassThru | New-Partition -AssignDriveLetter -UseMaximumSize
    Format-Volume -driveletter $dl.Driveletter -FileSystem NTFS -NewFileSystemLabel $Labels[$i] -Confirm:$false

}

Get-Volume | Where-Object FileSystem -eq 'NTFS' | Sort-Object DriveLetter | Out-GridView #Out-File drives.txt