Category: "SQL Server"
Return Default SQL Server Folder
Mar 31st
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
Mar 26th
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 π
Mar 14th
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 »
Service Pack SQL Server 2008 SP2 and SQL Server 2005 SP4 - Based on feedback from the community !!!
Feb 15th
They will do it! Here is the statement of Matthias Berndt, Group Program Manager Microsoft SQL Server:SQL Server Servicing plans
Hello Community, we appreciate your recent comments regarding the servicing needs of your current SQL Server… more »
Cumulative Updates for SQL Server 2008 and SQL Server 2008 Service Pack 1
Jan 20th
Mention, the CSS SQL Server Engineers blog listed a note that some end of support dates were coming up.
SQL Server 2008 RTM support ends on April 13, 2010. You should make plans to upgrade to SQL Server 2008 SP1 soon.
So I think, it is definitely… more »
CSS SQL Server Engineers - "End of Support” Dates
Jan 18th
Last week the CSS SQL Server Engineers blog listed a note that some end of support dates were coming up. The end of support dates and products were:
SQL Server 2005 Service Pack 2 support ends next week January 12, 2010. You should upgrade to SQL 2005… more »
SQL Server 2008 Service Pack 2 - Vote for
Dec 30th
It's time to vote at MS-Connect for Service Pack 2 for SQL Server 2008
When is SQL Server 2008 Service Pack 2 slated to be released? Many companies depend on these Service Packs to stay patched, being unwilling, and unable, to install CUs on a regular… more »
Service Pack 4 for SQL Server 2005 - Vote for
Dec 30th
It's time to vote at MS-Connect for Service Pack 4 for SQL Server 2005
I am wondering when Service Pack 4 for SQL Server 2005 is slated to be released. Many companies will not install CUs, and depend on SPs to provide additional stability and patch… more »
SQL Server Disaster Recovery: Recovering from Disasters Using Backups - Part II
Nov 6th
Paul S. Randal explains in his second feature article - TechNet Magazine November 2009 - the using of the RESTORE command.
Content:
The four phase of restore
What do you need
What are you able to restore
Excample restore scenarios
Considerations when… more »
SSMS Tools Pack 1.7.5.1 is out! Bug fixes for international users - by Mladen Prajdiæ
Nov 3rd
You can simply reinstall 1.7.5.1 over the 1.7.0.0.
You can download the new version here.
So, take a look - and feel free :-)
http://www.ssmstoolspack.com
CU tosc more »