---
title: "Ji Wang (@peandaddy) | Hashnode"
description: "Senior Database Administrator. Financial Planner. Business owner. Adventurer. Entrepreneur. Read the latest articles by Ji Wang on Hashnode."
url: "https://hashnode.com/@peandaddy"
---

@peandaddy

# Ji Wang

@peandaddy · Joined July 2024

Senior Database Administrator. Financial Planner. Business owner. Adventurer. Entrepreneur

### [Troubleshooting Tips for CDC for Oracle on SQL Server](https://peandaddy.com/troubleshooting-tips-for-cdc-for-oracle-on-sql-server?utm_source=hashnode&utm_medium=feed)

Learn how to troubleshoot common CDC issues in SQL Server with solutions for transaction, DLL, and data sync errors

2 min read · [peandaddy.com](https://peandaddy.com/troubleshooting-tips-for-cdc-for-oracle-on-sql-server?utm_source=hashnode&utm_medium=feed)

[Feb 28, 2025](https://hashnode.com/posts/troubleshooting-tips-for-cdc-for-oracle-on-sql-server/67c4b15f3f51bd5ae60627ec)

### [Uncovering Enabled Guest Users in SQL Servers: A PowerShell Guide with HTML Output](https://peandaddy.com/uncovering-guest-users-in-sql-servers?utm_source=hashnode&utm_medium=feed)

Use PowerShell to identify enabled Guest users in SQL Servers, improving security with HTML outputs and reusable templates for database management

4 min read · [peandaddy.com](https://peandaddy.com/uncovering-guest-users-in-sql-servers?utm_source=hashnode&utm_medium=feed)

[Feb 1, 2025](https://hashnode.com/posts/uncovering-guest-users-in-sql-servers/67b8cec17a3c8aa04440aaf0)

### [Visualizing Data Flow: CDC Table Diagrams for ODS](https://peandaddy.com/cdc-table-diagrams?utm_source=hashnode&utm_medium=feed)

Use CDC Table Diagrams to enhance ODS data flow visualization, highlighting key features and roles in data management

1 min read · [peandaddy.com](https://peandaddy.com/cdc-table-diagrams?utm_source=hashnode&utm_medium=feed)

[Jan 10, 2025](https://hashnode.com/posts/cdc-table-diagrams/67b8d86f2956f1df47cae80f)

### [Unlocking SQL Server CDC for Oracle: Essential Permissions and Roles Explained](https://peandaddy.com/sql-cdc-for-oracle-essential-permissions-and-roles?utm_source=hashnode&utm_medium=feed)

Understand permissions and roles for SQL Server CDC for Oracle to ensure secure, efficient data capture

5 min read · [peandaddy.com](https://peandaddy.com/sql-cdc-for-oracle-essential-permissions-and-roles?utm_source=hashnode&utm_medium=feed)

[Oct 2, 2024](https://hashnode.com/posts/sql-cdc-for-oracle-essential-permissions-and-roles/66fd4bad36a656cda647e8c8)

### [How to Use INSTEAD OF Triggers for Custom SQL Logic](https://peandaddy.com/instead-of-triggers?utm_source=hashnode&utm_medium=feed)

Learn to customize SQL actions using INSTEAD OF triggers. Enhance data integrity and control with examples and detailed explanation

5 min read · [peandaddy.com](https://peandaddy.com/instead-of-triggers?utm_source=hashnode&utm_medium=feed)

[Aug 16, 2024](https://hashnode.com/posts/instead-of-triggers/66bf3f63c50419a27cec443c)
