Yeek - Yeek Talk & Music (Page 16)

07 Dec 2020 Oracle

Step by step instruction to setup an Oracle Active Standby Instance using RMAN

This instruction is created for Oracle on Windows, it also applies to Unix/Linux installations. The difference will be mainly the folder path locations. Master

07 Dec 2020 MS SQL Server Powershell SSIS, SSRS, SSAS

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

PowerShell to retrieve and parse RSS news feeds

06 Dec 2020 Powershell

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=

How to install AD Tool and other RSAT tools on Windows 10 1809 and later

06 Dec 2020 Powershell

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

How to search all objects in all databases with specific word phrase in SQL Server

02 Dec 2020 MS SQL Server

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