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. DECLARE @SQLDataRoot… 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 using EXEC xp_msver; for a deep dive to SQL Server version information, the guys of http://sqlserverbuilds. blogspot.… more »

Happy Pi day - the ratio π

Yes, it is Pi-Day! The origninal song by Ken Ferrier and Antoni Chan: Mathematical Pi Song Animation of the act of unrolling a circle's circumference, illustrating the ratio π.  CU tosc more »