I previously posted about the effectiveness of defragmenting guest machines (SharePoint servers) in virtualized environments here: SharePoint on Virtual Machines – Is Disk Defragmenting necessary for Performance? Today the...
Read MoreWhen dealing with the slew of SharePoint MS SQL databases that can be found in a typical install, it’s a bit of a time suck to check transaction log sizes manually. I put together the following T-SQL script to quickly show...
Read MoreThe SQL Server provider for Windows PowerShell exposes the hierarchy of SQL Server objects in paths similar to file system paths. You can use the paths to locate an object, and then use methods from the SQL Server Management...
Read More