Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

November 2015 - Page 4 of 15 - Scripting Blog [archived]

Automating Index Fragmentation Reports

November 24, 2015 Nov 24, 2015 11/24/15
Doctor Scripto
Summary: Guest blogger, Laerte Junior discusses how to use PowerShell to automate an index fragmentation report and generate an Excel file.One of the day-to-day tasks of a DBA is to maintain your environment. This task includes checking the fragmentation of indexes. In this post, I will show how to automate this collection and generate an ...

PowerTip: Use PowerShell to Generate Object with Two Property Types

November 23, 2015 Nov 23, 2015 11/23/15
Doctor Scripto
Summary: Use Windows PowerShell to generate an object with two property types. (image)  How can I use Windows PowerShell to generate an object with two property types from simply splitting a string? (image)  Use the ConvertFrom-String cmdlet to pipe a string, and then specify the desired property types, for example: PS C:\>“123 ...