People are capable of all kinds of good thinking, but some just don't see what's right in front of their noses.

May, 2013

SQL Filegroups for performance, management and DR

As far as I am concerned, we need to break up our big database (more than 500 GB) into a series of filegroups for better performance, easier management and faster disaster recovery. – Filegroup with current active data – Filegroup with old and obselete data First of all, create a series of filegroup, and then …Continue reading

NX or XD compatibility with Windows 8

You would need to enable NX or XD in order to make your machine compatible with Windows 8 Windows 8 has a dependency on the NX bit of the CPU and we are unable to install the Windows 8 RP unless it is enabled. NX stands for No eXecute and is a technology used in …Continue reading