You are here
Home > 2016 > December

IIS Cheatsheet

IIS Reverse Proxy Server: I have found following url useful for Reverse Proxy Server http://weblogs.asp.net/owscott/creating-a-reverse-proxy-with-url-rewrite-for-iis https://www.saotn.org/iis-outbound-rules-with-gzip-compression/ FTP IIS Manager User This url can be helpful http://serverfault.com/questions/570897/iis-8-5-iismanagerauth-provider-530-user-cannot-log-in

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

Top