You are here
Home > 2016

IIS Cheatsheet

IIS Reverse Proxy Server: I have found following url useful for Reverse Proxy Server FTP IIS Manager User This url can be helpful

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 Connection: 2. Server=ServerNameOrIpAddress;Database=DatabaseName;Trusted_Connection=True; Connection to a SQL Server instance: 1. Server=ServerNameOrIpAddress\InstanceName;Database=DatabaseName;User Id=myUsername;Password=Password; Trusted Connection from a CE device: 1. Data Source=ServerNameOrIpAddress;Initial Catalog=DatabaseName;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=Password; Connect via an IP address: 1. Data

C# CheatSheet

Creating a comma separated string from IList<string> or IEnumerable<string> IList<string> strings = new List<string>{"1","2","testing"}; string joined = string.Join(",", strings);   Creating a comma separated string from IList<int> or IEnumerable<int> List<int> list =List<int>{1,2,3}; string joined = string.Join(",", list.Select(n => n.ToString()).ToArray())   Converting a comma separated string  to IList<int> or IEnumerable<int> string commaSeparatedString = "1,2,3"; List<int> list = Array.ConvertAll(commaSeparatedString .Split(','), int.Parse).ToList(); or string commaSeparatedString

PHP Cheatsheet

PHP is a server scripting language, and a powerful tool for making dynamic and interactive Web pages. PHP is a widely-used, free, and efficient alternative to competitors such as Microsoft's ASP. from w3schools Example of several ways of Loop Foreach Loop: foreach ($array as $value) { code to be executed; } example: foreach($ArrayOfObject as $object) { } For Loop: for (initialization;

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 databasename Import Database: mysql -u username -p password databasename < /importfilePath Import Database: mysqldump -u username -p password databasename > /exportfilePath List all Databases: show databases; Select Database: use databasename; List Tables of a

Linux Cheatsheet

Creating symbolic link ln -s [sourcepath] [destination] example: ls -s /tmp/webportal /var/www/mysite To search for a particular package by name or description apt-cache search package- example: apt-cache search php5- Insalling module in Ubuntu sudo apt-get install nameofthemodule Watch Process Show all the running processes within your Linux environment using following one of these top watch -n 1 "ps u -C processname1,processname2,processname3" example: watch

Windows Cheatsheet

Creating Symbolic link: Step 1: Open command prompt Step 2: mklink /d SymbolicLinkPath TargetPath example: mklink /d C:\testfolder\SymbolicLink d:\testfolder\folderorfiletobelinked   Networking related commands: Find Your IP Address: Step 1: Open command prompt Step 2: ipconfig DNS can be flushed using following command: Step 1: Open command prompt Step 2: iipconfig /flushdns Following might be helpful for checking whether the connectivity between your pc