>The MERGE statement in SQL Server 2008 is a new DML statement that combines multiple DML operations. It performs INSERT, UPDATE, or DELETE operations on a target table based on the results of a join with a source table. This statement enables you to merge two tables based on a set of criteria. In previous […]

>If you happen to check your WindowsUpdate.log file and found this error, you might want to check your WSUS’ IIS settings especially if you have your URLScan.ini modified. If you install WSUS after you configured your URLScan.ini, it doesn’t change the settings at all. You need to add the following setting in the URLScan.ini: [Allow […]

>If you’ve had your hands on T-SQL for quite some time, it wouldn’t be hard for you to identify the new enhancements available in SQL Server 2008. Now just for fun, try to identify what’s unusual in this script, from a SQL Server 2000/2005 point-of-view: DECLARE @variable int = 1;SET @variable += 1;CREATE TABLE table1 […]

>Microsoft did a very literal translation of the term Books Online with SQL Server 2005. Books Online happens to be the help file for SQL Server. In SQL Server 2005 (and now with SQL Server “Katmai”), Books Online has the capability to go “online” and look for related searches on the Internet, MSDN Online, community […]

>I have been using ROBOCOPY for a lot of reasons – Home folder replication for disaster recovery purposes, file-copy utility for custom transaction log shipping for SQL Server, etc. It has been a very useful tool for me, especially when you talk about disaster recovery. But what a lot of people do not realize is […]