Archives for: March 2010

Return Default SQL Server Folder

Below script will query registry settings to return folder informations (SQL Root, Data, Log and Backup). I use this script to determine the default locations, put it in variables an use it for creating databases or backups. more »

Microsoft SQL Server 2008, 2005, 2000 and 7.0 Builds

In a earlier previous post - Which service pack do I have installed? - based on How to identify your SQL Server version and edition and usingEXEC xp_msver; for a deep dive to SQL Server version Information, the guys of http://sqlserverbuilds. blogspo… more »

Happy Pi day

Yes, it is Pi-Day! Mathematical Pi Song Animation of the act of unrolling a circle's circumference, illustrating the ratio π. more »