Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

January 2010 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

January 2010 - Posts

SQL Server 2008 R2 gets official release date!

Here is an exciting news for SQL Server 2008 R2 CTP users, DataPlatform-Insider blog confirms that ..will be listed on Microsoft’s May price list, and will be available by May 2010.... follow here.

 

SQL Server 2008 Service Pack 2 and SQL Server 2005 Service Pack 4 - Whats your choice?

If you are interested to cast your vote & comment on getting Service Pack release for 2 important versions of SQL Server visit: SQL2005-sp4 & SQL2008-SP2 pages.

Posted by ssqa.net | with no comments

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions!

It is quite common scenario that few of Enterprises may not have gone to upto date service pack on SQL Server 2005 which is SP3 & SQL Server 2008 which is SP1. So here is the reminder for you to ensure to upgrade the 2005 & 2008 instances to upto date service packs, by testing them thoroughly which is a best practice.

Its a reminder that service pack support for  SQL Server 2005 Service Pack 2 (SP2)  will end on January 12, 2010 and support for SQL Server 2008 RTM will end on April 13, 2010.  For more information about the Service Pack support policy visit  http://support.microsoft.com/lifecycle link.  What it means that both of these release versions will no longer receive assisted support or security updates from Microsoft after their respective end of support dates.  Self-Help online support will continue to be available for a minimum of 12 months after the product reaches the end of support.  Self-Help options include public knowledge base articles, FAQs, troubleshooting tools which are typically available from http://support.microsoft.com and the Microsoft Download Center.

Better be workout the possibilities and test the application against latest service pack to keep up the database platform as a part of industry best practices.

 

Posted by ssqa.net | with no comments

SQL Server Migration Assistant for MySQL v1.0 - CTP1

SQL Server Migration Assistant is one of best used tool when there is a huge effort required to migrate the database from other data sources such as MS Access, Oracle & MySQL.

As a part of Microsoft Partner network communication I have received this exciting news about SSMA for MySQL which is available for download freely from SSMA2008-MySQLv1.0_CTP1 which is for SQL Server 2008 version and SSMA2005-MySQLv1.0_CTP1 for SQL Server 2005 version.

SSMA for SQL 2008 can be used to migrate data from MySQL to 2008 & Azure DB engine versions, and SSMA 2005 is for 2005 version only.

A brief note on licensing for the users who are interested to use these SSMA tools: ....a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience.