Following code has been tested on SSRS 2010 to 2016 Install the Reporting Service Powershell Module 2. Code to download RDLs […]
Download all RDL report files from SSRS server
Month: December 2020
Remove Quotes and Comma from Quoted fields
[…]
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 of Previous Month based on current date. Here are some sample of dates calculation in PowerShell […]
Cascade Delete in MS SQL Server
Different from ORACLE and MySQL, MS SQL Server does not provide Cascade delete function natively. This maybe considered as a safety feature to prevent unintentional data deletion, however, there are situations, that need Cascade Delete to quickly clean up data in complex referenced tables. To easy my life, this is what I wrote. It’s been […]