How to install AD Tool and other RSAT tools on Windows 10 1809 and later
Active Directory tool is always a very handy tool for most Windows administrators. However, this tool does not come with Windows by default. Prior to
Powershell
PowerShell to retrieve and parse RSS news feeds
RSS is a very command news feeds, often I need to retrieve the feeds and load into the relational database. Recently I've been
Download all RDL report files from SSRS server
Following code has been tested on SSRS 2010 to 2016
1. Install the Reporting Service Powershell Module
Install-Module -Name ReportingServicesTools
2. Code to download RDLs
Remove Quotes and Comma from Quoted fields
# Remove Quotes from deliminated data file, and remove comma from field value
# Parameters definition
[CmdletBinding()]
Param(
[Parameter(Mandatory=$True,Position=1)]
[string]$InputFile,
[Parameter(Mandatory=
Date Calculation in PowerShell
When using PowerShell to schedule automated tasks, it's very commonly needed to calculated dates, like the First Day of a Month, Last Day