YEEK Talk & Music – Page 9

Powershell

Date Calculation in PowerShell
ByYeek December 6, 2020December 23, 2020
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
```
#Current 
```
…
Read More Date Calculation in PowerShell
MS SQL Server

Cascade Delete in MS SQL Server
ByYeek December 2, 2020December 23, 2020

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 …

Read More Cascade Delete in MS SQL Server