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
MSSQL
- 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