IT
Cyberlink Power2Go 8
I came across with the needs to burn Blue-ray disk and system backup for my machine Asus Support team recommend me to use Cyberlink Power2Go 8 for Windows 7, and apparently this software is simply cracked due to many hackers are keen to use many utilities on their 15 days trial version, and its multiple …
VMware KB Articles
List of VMware KB Articles Unable to upgrade existing VMware Tools (1001354) Troubleshooting an unresponsive host and multiple Disconnected virtual machines (1019082) VMware ESXi 5.0, Patch Release ESXi500-201209001 (2032584) Understanding vSphere 5.1 network rollback and recovery (2032908)
Setting Up Windows Server 2012 Domain Controller
In order to make the windows server 2012 domain controller we will install ADDS (Active Directory Domain Services) role from the server manager on Windows Server 2012.
EXCEPT and INTERSECT (Transact-SQL)
They both return distinct values by comparing the results of two queries. EXCEPT returns any distinct values from the left query that are not also found on the right query. INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand. The basic rules …
NTILE() in Transact-SQL
This function is used to distribute the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs. Syntax NTILE (integer_expression) OVER ( [ <partition_by_clause> ] < order_by_clause > ) Arguments integer_expression Is …
Microsoft Windows Server 2012 R2 Preview is Now Available for Download
Microsoft announced availability of the System Center 2012 R2 and Windows Server 2012 R2 previews. You can download these products right now from the evaluation center. Windows Server 2012 R2 brings Microsoft’s experience delivering global-scale cloud services into your infrastructure. Some highlights are as follows Enabling hybrid cloud – Windows Server Hyper-V and System Center …
Details of features supported by the different editions of SQL Server 2012
There are myriad numbers of Microsoft SQL Server 2012 comparison among its editions. In my opinion, the best source is on below MSDN url. Features Supported by the Editions of SQL Server 2012
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 …
