Michael - DEV Community

Michael

May 11

IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable

#gbase #database #数据库

1 min read

Michael

May 11

Using Chinese Identifiers in GBase 8a: The gcluster_extend_ident Parameter

#gbase #database #数据库 #parameter

2 min read

Michael

May 11

Troubleshooting Table Locks in GBase 8s: Find and Release Exclusive Locks Fast

#gbase #database #数据库 #onstat

2 min read

Michael

May 10

Ensuring Replication Consistency in GBase 8s: cdr repair vs cdr sync

#gbase #database #数据库

2

2 min read

Michael

May 10

Common Reasons for INSERT Failures in GBase Databases

#gbase #database #数据库

3

1 min read

Michael

May 10

Tuning GBase RTSync for Better Replication Performance

#gbase #database #数据库

2

1 min read

Michael

May 10

Handling Concurrent Access on Tables with Exclusive Locks in GBase 8s

#gbase #database #数据库

2

1 min read

Michael

May 9

Fixing Database Import Failures After Moving Text Files from Windows to Linux

#gbase #database #数据库 #linux

2

1 min read

Michael

May 9

Track Rolling-Back Transactions in GBase 8s

#gbase #database #数据库

2

1 min read

Michael

May 9

Get Real Row Counts in GBase 8s Without UPDATE STATISTICS

#gbase #database #数据库

2

1 min read

Michael

May 9

Upgrading GBase 8c: Online and Offline Strategies

#gbase #database #数据库

2

3 min read

Michael

May 8

Troubleshooting GBase 8c: OS, Network, Disk, and Database

#gbase #database #数据库

2

3 min read

Michael

May 8

GBase 8s Associative Arrays: A Guide to Key-Value Collections

#gbase #database #数据库

2

2 min read

Michael

May 8

GBase 8s Nested Tables: A Practical Guide to Collection Types

#gbase #database #数据库

2

2 min read

Michael

May 8

Remote Physical Backup and Recovery in GBase 8c Centralized Mode

#gbase #database #数据库

2

3 min read

Michael

May 7

GBase 8s JDBC Batch Insert: Configuration and Example

#gbase #database #数据库

2

1 min read

Michael

May 7

count(*) vs count(1) vs count(column_name) in GBase 8c

#gbase #database #数据库

2

2 min read

Michael

May 7

Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management

#gbase #database #数据库

2

2 min read

Michael

May 7

Optimizing GBase 8s JDBC with IFX_AUTOFREE

#gbase #database #数据库

2

2 min read

Michael

May 6

Tracking Long Transactions in GBase 8s with onstat

#gbase #database #数据库

2

2 min read

Michael

May 6

GBase 8s Collection Attributes: count, limit, exist, first, last, next, prior

#gbase #database #数据库

2

2 min read

Michael

May 6

Merging PSM Backups Across GBase 8s Nodes for Continuous onbar Recovery

#gbase #database #数据库

2

2 min read

Michael

May 6

GBase 8s User Management: Mapping OS Users and Internal Users

#gbase #database #数据库

2

2 min read

Michael

May 4

Managing the Event Scheduler in GBase 8a

#gbase #database #数据库

2

1 min read

Michael

May 4

GBase 8a QUALIFY Clause: Filtering Window Functions the Smart Way

#gbase #database #数据库

2

3 min read

Michael

May 4

Expanding a GBase 8a Cluster: Adding a GNode in Practice

#gbase #database #数据库

2

2 min read

Michael

May 4

GBase 8s: How DELIMIDENT Controls Case Sensitivity

#gbase #database #数据库

2

2 min read

Michael

May 3

Managing Permissions in GBase 8s: From Database-Level to Object-Level Access Control

#gbase #database #数据库

2

3 min read

Michael

May 3

End-to-End: Hadoop Deployment and Data Loading into GBase 8a

#gbase #database #数据库

2

2 min read

Michael

May 3

Optimizing GBase 8s JDBC with the OPTOFC Parameter

#gbase #database #数据库

2

2 min read

Michael

May 3

GBase 8a Statistics Tables: Understanding gc_stats_table and gc_stats_column

#gbase #database #数据库

2

2 min read

Michael

May 2

Inside GBase 8a Data Consistency: ddlevent, dmlevent, dmlstorageevent

#gbase #database #数据库

2

2 min read

Michael

May 2

GBase 8a High Availability Explained: How Three-Layer Redundancy Keeps Your Data Services Running

#gbase #database #数据库

2

3 min read

Michael

May 2

A Practical Guide to the ISNULL() Function in GBase 8s

#gbase #database #数据库

2

2 min read

Michael

May 2

GBase 8c High Availability with VIP: A Step-by-Step Verification Guide

#gbase #database #数据库

2

2 min read

Michael

May 1

GBase 8a Sync Internals and GVR Enhancements

#architecture #database #distributedsystems #performance

2

3 min read

Michael

May 1

INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

#gbase #database #数据库

2

2 min read

Michael

May 1

GBase 8a Full-Text Index: Features, Queries, and Configuration

#backend #database #sql #tutorial

2

2 min read

Michael

May 1

Tiered Compression for Hot and Cold Data in GBase 8a: Managing the Data Lifecycle

#gbase #database #数据库

2

2 min read

Michael

Apr 30

GBase 8a Operations Cheat Sheet: Essential Commands for DBAs

#cli #database #sql #tutorial

2

2 min read

Michael

Apr 30

3 General Methods to Optimize Query Performance in GBase 8a

#gbase #database #数据库

2

3 min read

Michael

Apr 30

GBase 8c Performance Tuning: From Statistics to Execution Plan Optimization

#gbase #database #数据库

2

3 min read

Michael

Apr 30

A Practical Guide to Exception Handling and Flow Control in GBase 8a Stored Procedures

#gbase #database #数据库

2

2 min read

Michael

Apr 30

Using RPAD in GBase 8s: Syntax, Examples, and a Stored Procedure Hack

#gbase #database #数据库

2

2 min read

Michael

Apr 30

Time Zone Pitfall When Migrating from MySQL to GBase 8c — and How to Fix It

#gbase #database #数据库 #mysql

2

3 min read

Michael

Apr 30

Working with ROW Types in GBase 8s JDBC

#gbase #database #数据库

2

6 min read

Michael

Apr 29

Fast Fragment Scanning for Tables in GBase 8a

#cli #database #linux #performance

2

3 min read

Michael

Apr 29

Querying Primary-Foreign Key Relationships in GBase 8s

#gbase #database #数据库

2

2 min read

Michael

Apr 29

Analyzing GBase 8a Cluster Workloads and Resource Usage: A Practical Framework

#gbase #database #数据库

2

3 min read

Michael

Apr 29

GBASE GBase 8a Disk Bottleneck: Two Proven Optimization Strategies

#gbase #database #数据库

2

3 min read

Michael

Apr 29

GBase 8a O&M Custom Stored Procedures: A Handy Toolkit for DBAs

#gbase #database #数据库

2

3 min read

Michael

Apr 29

GBase 8a Date Functions: A Complete Guide to Day-Related Built-ins

#database #数据库 #gbase

2

3 min read

Michael

Mar 30

Triggered Stored Procedures in GBase 8s: Adding Complex Logic to Triggers

#gbase #database #数据库

2

2 min read

Michael

Mar 30

Implementing split_part Function in GBase 8s: Two Practical Approaches

#gbase #database #数据库

2

2 min read

Michael

Mar 26

GBase 8a Performance Troubleshooting: From Slow Query Detection to Primary‑Replica Consistency

#gbase #database #数据库

2

6 min read

Michael

Mar 26

Make Your Queries 10x Faster with GBase 8a Rough Index

#gbase #database #数据库

3

3 min read

Michael

Mar 24

Boost JDBC Performance with GBase 8s: Understanding IFX_AUTOFREE

2

2 min read

Michael

Mar 24

Understanding the ISNULL() Function in GBase 8s

#beginners #database #sql #tutorial

2

2 min read

Michael

Mar 23

Common Parameters for GBase 8a MPP Cluster Command-Line Clients: gccli and gncli

#gbase #database #数据库

2

2 min read

Michael

Mar 23

GBase 8s Trigger with Stored Procedure Example

#database #数据库 #gbase

2

2 min read

Writing Debut