Software Development

Installing memcache on Linux ubuntu machine for PHP

Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering. Memcached

Installing Varnish on Linux ubuntu machine

VARNISH IS BUILT FOR SPEED, VARNISH  BRINGS THE BEST IN WEB & MOBILE PERFORMANCE Varnish is an HTTP accelerator designed for content-heavy dynamic web sites as

Database

MS SQL Server Cheatsheet

Reseeding a table identity in MS SQL Server DBCC CHECKIDENT (tablename, RESEED, new_reseed_value) Truncate Table truncate tablename Check Log size of all database DBCC SQLPERF(LOGSPACE);   Connection String Standard Security: 1. Server=ServerNameOrIpAddress;Database=DatabaseName;User Id=Username; Password=Password; Trusted

MySQL Cheatsheet

Login to MySql: mysql -u username -p password Create Database: create database databasename character set utf8 collate utf8_general_ci; grant all on databasename.* to databaseUser@'localhost' identified by 'password'; Delete Database: drop database

Top