Posts

Showing posts from 2017

Install URL Rewrite 2.0 Module for IIS 10.0 on window 10

Please follow the below step for the installing url rewriting 2.0 Module in IIS 10 on window 10 Open Regedit > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\InetStp Edit "MajorVersion" and change base Hexadecimal to Decimal  Set the "DECIMAL" value to 9 Press F5 while in Regedit Install the URL Rewrite 2.0 module. Change the "MajorVersion" back to "DECIMAL" value of 10 Press F5 while in Regedit Close Regedit Enjoy the URL Rewirting 2.0 Module :-)

New features in different version of SQL SERVER

SQL SERVER 2000 Query Analyzer and Enterprise manager are separate We can create maximum of 65,535 databases. SQL SERVER 2005 Query Analyzer and Enterprise manager are combined as SSMS(Sql Server management Studio) XML data type is introduced We can create 2(pow(20))-1 databases We can compress the tables and indexes Varchar(max) or Varbinary(max) is available SSIS is started using PIVOT and UNPIVOT functions are introduced. Database can encrypt SQL SERVER 2008 We can able to Encrypt the entire Database Introduced Back-Up Encryption. XML Datatype is implemented and used. FILESTREAM Datatype is introduced LINQ is introduced for retrieving multiple types of data Table-Valued Parameters is introduced Merge Statement is included Major Changes in DateTime -DATE, TIME, DATETIMEOFFSET, DATETIME2 The restriction has been removed for UDTs( In 2005, UDTs where restricted to max. size of  8 KB) Data Synchronization is introduced. It support maximum of 64 logical pro