DBA's Diary
I am Pranaw, the writer and video creator of DBA’s Diary! It was my note keeping habit which led to this blog and video. I try to put as helpful information as possible regarding Database. If you have any specific query, drop me a message in comments or contact me, I will be happy to help you.
Recommendation based on Sysmon Report & Validation
How to Become Valuable & Respected DBA
Understanding sysmon report
SAP Sybase Replication Server Installation
Setting up Sybase Bi Directional Route in Replication between PRS & SRS
Setting up Route in Primary & Secondary Replication Server
Basic Unix Commands used by DBA
SAP(Sybase) Bi Directional Table Level Replication
Sybase System & MDA Tables
Sybase Table Level Replication
Sybase Servers Backup Servers Run file Binaries & Important locations
Sybase Bi-Directional Replication with Dump Marker
Sybase - Primary Clustered/Non-Clustered, Foreign & Unique Key
Mastering Sybase BiDirectional Replication without Materialization
Mastering Tempdb Management in Sybase: Strategies for Multiple Tempdb and Binding Techniques.
SAP Sybase Replication DSI Options, Unique Keys and Their Role in Replication
Ultimate Guide to Sybase DB Backup: Types, Restoration, RPO, RTO & PITR Like a Pro!
Replication Definition - Include, Exclude List of Tables, System Tables, DDL, DSI Options
Dump Marker DB Def and Sub
Logins, Users, Alias, Roles, Groups & Permissions
Replication Issue Troubleshooting
Sybase ASE & MSSQL Deadlock & Solution
SAP Sybase ASE dbccdb
How to Setup MSA Replication Using Dump Marker
SAP Sybase Replication Installation, Configuration, Connection, Definition & Subscription
Understanding SAP Sybase Cache
SAP Sybase ASE Execution Plan
Transaction & Isolation, Block & Deadlock, Latch & Spinlock, Locking & Types of Locking
SAP Sybase(ASE) Training - Are You Interested?
SAP Sybase REP Complex Questions with Answers