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 Excel fil...
Summary: Use Windows PowerShell to generate an object with two property types. How can I use Windows PowerShell to generate an object with two property types from simply splitting a string? Use the ConvertFrom-String cmdlet to pipe a string, and then specify the desired property types, for example:PS C:\>“123 456” | Co...
Summary: Use Windows PowerShell to generate an object with two property types. How can I use Windows PowerShell to generate an object with two property types from simply splitting a string? Use the ConvertFrom-String cmdlet to pipe a string, and then specify the desired property types, for example: PS C:\>“123 456” | ConvertFrom-String –P...
Summary: Jason Walker explores using Windows PowerShell to get the SSID and password for a wireless network. Ed Wilson, Microsoft Scripting Guy is here. Today I'm turning over the keyboard to Jason Walker. Jason is an Office 365 deployment consultant, who assists customers in the public sector arena. Here's Jason... Let me start off with ...
Summary: Boe Prox shows how you can find certificates that are expiring. How can I find if I have any certificates on my system that are expiring within 30 days? Use the ExpiringInDays dynamic parameter when working with the certificate provider, for example: Get-ChildItem Cert:\LocalMachine\My\ -ExpiringInDays 30 | Select-Obj...
