How to navigate to the current path of the BAT file

@ECHO OFF
REM Go to the current directory
REM.
CD %~dp0
REM Show files
DIR

Advertisements

How to shrink MS SQL database log file

USE [$(databasename)]
GO

-- Drop old transactions log data (just mark for deletion)
BACKUP LOG [$(databasename)] WITH NO_LOG -- TO DISK='D:BackupSQLServer$(databasename)_log.trn'
GO

-- Physically shrinks the log file
DBCC SHRINKFILE($(databasename)_log, NOTRUNCATE)

Free testing & deployment automatization tools

Accept tests

  • Selenium (Web app. – Firefox plugin)
    Selenium Remote Control – for automatization
    Selenium Grid – for integration tests on separate machine
  • Watin
  • Cucumber
    Selenium + Cucumber – human readable tests

Performance tests

  • httperf (doesn support ASPX due viewstate issue)
  • YSlow (Yahoo) – web page load optimization

Unit tests

  • JUnit
  • NUnit
  • utPLSQL
  • RSpec

Accessibility monitoring

  • Hobbit
  • Monit
  • God

Build

  • Ant, Maven, NAnt

Fast integration

  • Bamboo + NAnt

Performance monitoring

  • Cacti
  • New Rehc RPM (Rubby only)

Administration automatization

  • PUPPET

Installing, deployment

  • Capistrano