@peandaddy
Senior Database Administrator. Financial Planner. Business owner. Adventurer. Entrepreneur
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.
I am available for unique projects in backend tech.
Feb 28, 2025 路 2 min read 路 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...
Join discussionFeb 1, 2025 路 4 min read 路 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: ...
Join discussion
Jan 10, 2025 路 1 min read 路 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:...
Join discussionOct 2, 2024 路 5 min read 路 In this article and from CDC official document, I will outline the specific permissions I鈥檝e tested and used in my environment, as admin privileges are not allowed in Oracle. Windows User Roles Computer Administrator: Oracle CDC Service The compu...
Join discussion
Aug 16, 2024 路 5 min read 路 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...
Join discussion