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

Sybase

• 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

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 – Migration Main steps
• Azure – AAD Logins and Connection Strings
• Azure – What is DBaaS
• Azure – Backup and Auditing to Blob Storage