Skip to primary content

Midsund

IT Consultancy & WebSite Creation

Midsund

Main menu

  • Home
  • Consultancy
  • Contact Us
  • DBA Docs
  • PRINCE2 & PM Docs
  • Web Design

DBA Docs

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

Sybase

  • 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

 

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

 

 

 

Proudly powered by WordPress