Using PowerShell to view Site created on the previous day


How to view name of the SharePoint sites which was created previous day?

$w= Get-SpWeb http://yoursite
$date=$w.created
$old=($date.AddDays(-1))
Get-SPSite -Filter {$w.Created -eq $old}

PowerShell Tips for SQL Server


http://blogs.technet.com/b/heyscriptingguy/archive/2013/05/06/10-tips-for-the-sql-server-powershell-scripter.aspx