Various Technical documents on Sybase, MSSQL, Unix and various other subject areas.
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
Sybase
- 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