>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 […]
>Collation settings define the physical storage of character strings in SQL Server. It specifies the bit patterns that represent each character and the rules by which characters are sorted and compared. Collation settings have a direct impact on the databases if you configure them to use a different collation other than the default. When you […]