Torsten Schuessler

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 SP3 or SQL 2008 SP1 immediately.
• SQL Server 2008 RTM support ends on April 13, 2010. You should make plans to upgrade to SQL Server 2008 SP1 soon.

There for I guess we have to vote for:

• SQL Server 2008 Service Pack 2 - Vote for
• Service Pack 4 for SQL Server 2005 - Vote for

CU
tosc

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 basis.

CU
tosc

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 their systems. Release Services has stated that there will be one SP a year, containing all CUs in it.

SQL Server 2005 SP3 was released on Dec 15, 2008. It is now over one year old.

CU
tosc

Link: http://www.insidesql.org/aktuelles/treffen-der-regionalgruppe-franken-am-dienstag-den-19-januar-2010

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 restoring to a different location
• Dig deeper

You can get it her:

PART I  :  http://technet.microsoft.com/en-us/magazine/dd939132.aspx
PART II:  http://technet.microsoft.com/en-us/magazine/ee677581.aspx

CU
tosc

Link: http://www.insidesql.org/aktuelles/treffen-der-regionalgruppe-franken-am-dienstag-den-10-november-2009

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

Paul S. Randal describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes of downtime and data loss, and how to evaluate and balance requirements and limitations when planning a high-availability strategy involving SQL Server 2008.

This white paper is targeted at architects, IT pros, and database administrators (DBAs) tasked with implementing a high-availability strategy. It assumes the reader is familiar with Windows and SQL Server and has at least a rudimentary knowledge of database concepts such as transactions.

Link: http://msdn.microsoft.com/en-us/library/ee523927.aspx

CU
tosc

Do you know the SSMS Tools PACK Add-In, it is an very exciting Add-In (Add-On)for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express.

It contains many interesting features, and I mean many!

So, take a look - and feel free :-)

http://www.ssmstoolspack.com

CU
tosc

The cumulative update package 6 for SQL Server 2005 Service Pack 3 (Build 09.00.4266) is available:http://support.microsoft.com/kb/974648/.

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released: http://support.microsoft.com/kb/960598/

CU tosc