I was trying to fix my installation of SQL Server 2005 as my IIS was totally screwed up (this is what happens when you toy around with your machine too much). I uninstalled and reinstalled SQL Server 2005 and the other related services on my test machine which has SQL Server 2000 instances as well. […]
>It must have been tough trying to capture INSERT, UPDATE and DELETE activities in a SQL Server database. Usually, developers may resort to creating DML triggers just to solve this problem in previous versions. The problem with this approach is that it introduces unnecessary overhead in the database engine. Another approach is to read the […]
>While I rarely use my Windows Vista laptop at home, I happen to use it to convert my PowerPoint 2007 files to 2003 version and sometimes to copy slides from 2007 to 2003. As I was copying my slides from my USB thumb drive to the laptop, I noticed an unusual (for me, it is […]
>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 […]