There are many ways to find locking /blocking sessions in Oracle, this is what I normally use. If Blocker is identified, in certain case you many need to kill the blocker session with below command: […]
RSS is a very command news feeds, often I need to retrieve the feeds and load into the relational database. Recently I’ve been using PowerShell to manage schedule jobs on Windows system. I found it’s pretty easy to do RSS feeds in PowerShell. Here is a small sample code to share: […]
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 Instance: ProdServer:1521/DB1 Target Active Standby Instance: StandbyServer:1521/DB1STANDBY (new installation) Preparation: Run below query to check if ARCHIVING LOG, FORCE LOGGING is enabled on the Primary database, if not enable them. On […]
Following code has been tested on SSRS 2010 to 2016 Install the Reporting Service Powershell Module 2. Code to download RDLs […]
[…]
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 […]
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 […]
