SQL Server CONVERT() Function
Convert data types in SQL Server with CONVERT styles for dates, strings, and binary representations.
Continue ReadingTag: Database
Oracle connect remotely
Allow remote SQL*Net connections to Oracle Database by configuring listener.ora, tnsnames.ora, and firewall rules.
Continue ReadingSQL Server Handle Transaction and Try Catch
Wrap SQL Server operations in TRY/CATCH with explicit transactions for atomic commits and rollbacks.
Continue ReadingStore historical records in a history table in SQL Server
Audit data changes in SQL Server with history tables triggered on UPDATE and DELETE from base tables.
Continue ReadingAccessing MySQL databases from remote computer
Allow remote MySQL connections by binding address, creating users with host %, and opening firewall port 3306.
Continue ReadingOracle EM Configuration
Configure Oracle Enterprise Manager Database Express or Cloud Control for monitoring and administration.
Continue ReadingImport and Export MySQL Database
Back up and restore MySQL databases with mysqldump and mysql client for migrations and disaster recovery.
Continue ReadingOracle Replication through Oracle Data Guard
Achieve high availability with Oracle Data Guard physical standby databases, redo transport, and role transitions.
Continue ReadingSQL Snippets
Reusable SQL patterns for paging, duplicates, pivots, and date ranges across SQL Server and MySQL.
Continue ReadingClone SQL Server database
Duplicate a SQL Server database with BACKUP/RESTORE, DBCC CLONEDATABASE, or scripting for dev/test copies.
Continue Reading