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 »
