Software Development

IIS: Solution for HTTP 404 of WebService api after ssl integration

All the end point are getting HTTP 404 after ssl is integrated in IIS. To fix that issue, following the steps   1.  Add new binding <binding name="uploadBindingSSL"

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

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