Ji Wang

@peandaddy

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

Joined July 2024

About

My career path has been shaped by my experiences with databases, cloud computing, and application development.

🚀 Data Architect & DBA | SQL Server Expert | GCP & AWS & Azure Platforms | Driving Data Efficiency for High-Traffic Applications 🚀

My interests include reading about Real Estate, Financial Planning, participating in sports, watching films, engaging in sport shooting, and traveling. I am fluent in English, Mandarin, and Taiwanese. Feel free to reach out to me.

Available for

I am available for unique projects in backend tech.

Ji Wang's blogs

Ji's Cloud, Database, Engineer Worldpeandaddy.com6 posts

Articles Comments

Recently published

JWJi Wangpeandaddy.comFeb 28, 2025 · 2 min read

Troubleshooting Tips for CDC for Oracle on SQL Server

Get Processing Range error Timeout Reason: It's because you have a CDC transaction not committed yet. Solution:Run DBCC OPENTRANIdentify the active sessions running the program: MSXDBCDC$OracleCDCService1$xxxxYourCDC Database End the sessionsReru...

0

JWJi Wangpeandaddy.comFeb 1, 2025 · 4 min read

Uncovering Enabled Guest Users in SQL Servers: A PowerShell Guide with HTML Output

Use PowerShell to identify enabled Guest users in SQL Servers by extracting registered servers, preparing a T-SQL script, and formatting results in HTML. This method enhances security and provides a reusable template for database management. Tasks: ...

0

JWJi Wangpeandaddy.comJan 10, 2025 · 1 min read

Visualizing Data Flow: CDC Table Diagrams for ODS

PDF link here (Diagram PDF download) Introduction: Unveiling the Power of CDC Table Diagrams Understanding the Role of ODS in Data Management Exploring the Visual Representation of Data Flow Key Features of CDC Table Diagrams for ODS Conclusion:...

0

JWJi Wangpeandaddy.comOct 2, 2024 · 5 min read

Unlocking SQL Server CDC for Oracle: Essential Permissions and Roles Explained

In this article and from CDC official document, I will outline the specific permissions I’ve tested and used in my environment, as admin privileges are not allowed in Oracle. Windows User Roles Computer Administrator: Oracle CDC Service The compu...

0

JWJi Wangpeandaddy.comAug 16, 2024 · 5 min read

How to Use INSTEAD OF Triggers for Custom SQL Logic

Trigger Types in SQL Data Manipulation Language trigger (DML) It's type of special Stored Procedure that automatically execute action (INSERT, UPDATE or DELETE) in a table or view. Data Definition Language trigger (DDL) It's type of triggers tha...

0

Ji Wang

About

Available for

Ji Wang's blogs

Recently published

Troubleshooting Tips for CDC for Oracle on SQL Server

Uncovering Enabled Guest Users in SQL Servers: A PowerShell Guide with HTML Output

Visualizing Data Flow: CDC Table Diagrams for ODS

Unlocking SQL Server CDC for Oracle: Essential Permissions and Roles Explained

How to Use INSTEAD OF Triggers for Custom SQL Logic

Search Hashnode

Ji Wang

About

Available for

Ji Wang's blogs

Recently published

Troubleshooting Tips for CDC for Oracle on SQL Server

Uncovering Enabled Guest Users in SQL Servers: A PowerShell Guide with HTML Output

Visualizing Data Flow: CDC Table Diagrams for ODS

Unlocking SQL Server CDC for Oracle: Essential Permissions and Roles Explained

How to Use INSTEAD OF Triggers for Custom SQL Logic