Doh!! Don’t install DC on SQL box

Ok I did this mistake in my VPC, I tried to make my machine a domain controller (DC) , But the box already have a SQL Server installed, The SQL stopped and if you try to uninstall, it gives you this error: The setup has encountered an unexpected error while Setting Internal Properties. The error…

1

SQL Server Hijri (Hijra) Dates

(Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21866389.html)Hijri Date The SQL Server datetime data type supports only Gregorian dates, but you can use a conversion function to convert the Gregorian date to the Hijri date based on the Kuwaiti algorithm.Conversion to and from the Hijri calendar is possible through the CONVERT intrinsic. There are two CONVERT styles that are available in…

5

Microsoft SQL Server has a stronger security posture than the Oracle RDBMS!!

This was a nice white paper David Litchfield on November 2006 and he published it in the NGSSoftware Insight Security Research (NISR) Publication. a copy of the white paper is on the follwing site: www.databasesecurity.com/dbsec/comparison.pdf The article had a nice and non-biased points on each product…   Summary: “paper will examine the differences between the security…

2

Weird Thing about Microsoft SQL Server 2005 Enterprise Edition VHD!!

 Ok, I might be blind, but if you go and download the Microsoft SQL Server 2005 Enterprise Edition VHD from this site: http://www.microsoft.com/downloads/details.aspx?familyid=558F3ECE-6509-45E9-8D60-25175848A8B7&displaylang=en you’ll find an excellent VM to work on SQL Server 2005,,, but the strange thing, YOU CAN’T FIND THE ADMINISTRATOR PASSWORD any where in the pag,,, and oh, what makes it more fun,…

1