Browse by Tags

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!
12 January 10 02:18 PM | ssqa.net | with no comments

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

Filed under: sql server, 2008, 2005, best practices, sp2, service pack, rtm

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits
11 November 09 04:57 PM | ssqa.net | with no comments

How can you achieve the High Availability & Disaster Recovery on database platform? What are factors involved to keep the system available to maintain revenue stream? What kind of management principles you need to implement? Well there are lot more...

Filed under: sql server, 2008, conference, sqlbits, dba, high availability, discussion, best practice, backup, disaster recovery

SQL Server 2008 R2 CTP to download and test the new features
13 August 09 10:20 AM | ssqa.net | with no comments

It is a public news on the availability of the first community technology preview (CTP) of SQL Server 2008 R2 for MSDN and TechNet subscribers, including the general availability. So what's new with SQL Server 2008 R2? To find out that you need to...

Filed under: sql server, 2008, report builder, reporting services, new feature, ctp, r2, BI, business intelligence, release

SQL Server Upgrade issues - How to evaluate potential issues?
09 June 09 06:17 PM | ssqa.net | with no comments

During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology...

Filed under: sql server, 2008, 2005, performance, database, problems, sqlbits, solution accelerator, tools, upgradebest practice

Get and test SQL Server 2008 Service Pack 1, check release notes before proceeding!
15 April 09 07:37 PM | ssqa.net | with no comments

In continuation to SQL_Server_2008-ServicePack1_CTP release information it is official that SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. If you have been involved in SQL 2008...

Filed under: sql server, 2008, microsoft, best practices, download, bol, release notes, slipstream

Do you know how many tools are included in SQL Server 2008 Feature Pack?
07 April 09 11:28 AM | ssqa.net | with no comments

Hmm, interesting to know when you have been asked about such a 'stupid' question! What is a Feature Pack? Feature Packs are a set of collection that are designed to enhance the managing/developing/designing the SQL Server 2008 usability along...

Filed under: sql server, 2008, users, download, dba, installation, upgrade advisor, feature pack

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)
11 February 09 02:15 PM | ssqa.net | with no comments

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...

Filed under: sql server, 2008, 2005, best practices, integration services, dts, ssis package, 2000, backward compatibility

January 2009 update for SQL Server 2008 Books Online aka BOL
04 February 09 08:56 AM | ssqa.net | with no comments

Here comes another update that you need to concentrate, a newest update to the SQL Server 2008 Books OnLine. MSDN site specifically refers that the following categories have had new topics added or existing topics updated with significant changes in the...

Filed under: sql server, 2008, microsoft, best practices, download, books online, upgrade

Cumulative Update package 3 for SQL Server 2008, another instalment of hotfixes!
20 January 09 08:28 AM | ssqa.net | 1 comment(s)

Here comes another instalment of Cumulative Update package 3 for SQL 2008 version and this contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. As usual the Microsoft guidance refers that this is a supported cumulative...

Filed under: sql server, 2008, microsoft, best practices, download, service pack, cumulative update, hotfix

SQL Server 2008 Policy Based Management - managing and troubleshooting policy failures
09 January 09 07:35 AM | ssqa.net | with no comments

Policy Based Management (PBM) is an effective system for DBAs to manage one or more instances of SQL Server. Just to give a brief overview of what it consists, it consists 3 components: Policy management for Administrators to create policies Explicit...

Filed under: sql server, 2008, performance, sqlagent, monitoring, policy based framework, troubleshoot, pbm

Cumulative Update Package 2 for SQL Server 2008
18 November 08 03:44 PM | ssqa.net | with no comments

Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one...

Filed under: sql server, 2008, best practices, download, cumulative update, package, hotfix

Cumulative Update Package 1 for SQL Server 2008 - are you ready for testing!
02 October 08 07:41 AM | ssqa.net | with no comments

First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed...

Filed under: sql server, 2008, stored procedure, best practices, cumulative update, new feature, package

SQL Server 2008 installation vows on Windows Server 2008
08 August 08 11:14 AM | ssqa.net | with no comments

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet...

Filed under: sql server, 2008, windows server, installation, firewall, error

SQL Server 2008 RTM is released, its official now!
06 August 08 07:48 PM | ssqa.net | 2 comment(s)

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence...

Filed under: sql server, 2008, microsoft, data warehousing, rtm, rc0, development, community

Get ready for SQL Server 2008 RTM release!
11 July 08 04:05 PM | ssqa.net | with no comments

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 will be on the August price list. This means that customers and...

Filed under: sql server, 2008, 2005, users, launch, windows server, visual studio, itpro, rtm, rc0, developer

More Posts Next page »