Scripts

• IBM Websphere Scripts

  • List WAS Resources

• SQL Server DBA Scripts

  • BackupTSQL code in a file
  • Copy User Login
  • Find Index Fragmentation Level
  • Identify All Foreign keys in a Database
  • Index Fragmentation Report
  • Last Time Index Was Rebuilt
  • List Size of Databases
  • List Size Of Tables
  • List SQL Login Information
  • Locate all procedures with a SEARCH string
  • Rebuild Fragmented Indexes
  • ShrinkUserDatabases
  • Tables with column name XYZ
  • Truncate All Tables in DB
  • TSQL Partitioned Queries

• SQL Server User Scripts

  • Split Surname from Name