Various Technical documents on Sybase, MSSQL, Unix and various other subject areas.

Sybase

• Sybase – Backup Auditing Query
• Sybase_generate_revoke_Scripts
• ddlgen-extraction
• Sybase Interview Questions
• Replication – Set up MSA Rep
• Replication – Remove MSA/RepAgent
• Replication check repdef/subscription info
• Tempdb full – recovery
• Kill Logins proc/script
• Elevate a user’s permissions for a proc
• Extract Users Permissions Script
• Sybase IQ commands etc
• Rotate Replication passwords
• Steps to change the Port for ASE
• Sybase Audit Event ID’s
• Sybase Patch Rollback
• Locked Logins Query
• Migrate Syslogins etc from 15.7 to 16
• Restoring the Master Database
• Sybase Load / Restore – Autofit
• Sybase Cumulative Dump / Backup
• Database Replication MSA with dump and load – Easy setup
• Sybase – Assign Read to all objects in database
• Improve RepServer performance
• Sybase ASE upgrade process
• Upgrading Rep server to REP15.0.2
• Installing Heterogeneous Replication
• How to add/update a table for replication
• Installing RepServer 15
• Installing a Sybase ASE15 Server
• How to drop a database when drop database fails
• How to move the master database to a new device
• How to perform a load froma remote backup server
• How to drop a corrupt table
• Database status values in sysdatabases
• Using set showplan
• Structure of databases as regards loading
• A guide to Replication server in plain English
• DR for a Replication Server
• How much Procedure cache
• Common Repserver commands
• Duplicate row removal from a table
• Setting up a Historical server recording
• Installing Sybase Auditing
• Remote table creation
• Correcting identity row gaps
• Installing dbccdb
• Sybase DR – What to do if all devices deleted
• Sybase IQ Guide
• DBCC faults – Corrective actions

Unix

• Block Device info

General

• Keep Alive script – aaa-awake
• chrome_and_teams_loop

MSSQL

• Backup/Restore Progress
• Autogrowth Script
• Trigger Check
• Filesystem Info
• Fragmentation checker
• Hallengren Script options
• MSSQL – Transfer logins and passwords between servers
• DR_encryption_solution_for_failing_over_encrypted_table-column
• MSSQL – Backup Auditing Query
• Centralised Policy Management Solution
• Always-on Guide
• MSSQL – Drive space check
• MSSQL – File| Usage SQL
• MSSQL- Extract Security Objects
• Mirror-Failover-Hanging
• MSSQL Kill_Users_script
• MSSQL Interview Questions
• Check for running Job – MSSQL
• In-Memory OLTP Guide
• Re Sync SQL Server Logins with Users
• Extract User Info in Database
• Rollback time to complete
• Find port number SQL Server
• Mirroring Tips and Tricks
• Migration Login and User steps
• Memory consumption SQL Server
• Database Roles – Find permissions granted
• Database last access time Query
• Installing certificate Keys for SQL Server
• MSSQL – Creating an Oracle Linked Server
• Setting up Log Shipping MSSQL 2008
• Performance Tuning MSSQL

Azure

• Azure Copy Database
• Azure – Database Migration Process
• Azure – High Level Migration Steps
• Azure – Migration Main steps
• Azure – AAD Logins and Connection Strings
• Azure – What is DBaaS
• Azure – Backup and Auditing to Blob Storage