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

SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
08 September 09 01:11 PM | ssqa.net | 1 comment(s)

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often more from here ...

Filed under: sql server, performance, best practices, benefits, dba, monitoring, tempdb, dbcc, transaction log, backup

SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.
29 June 09 11:35 AM | ssqa.net | with no comments

There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning.... read more !

Filed under: sql server, microsoft, best practices, download, error log, installation, express, slipstream, editions

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

Find and Search for SQL Server - Cumulative Update packages, Incremental Service Model and support information?
08 April 09 07:29 AM | ssqa.net | with no comments

In continuation to Cumulative Update 3 package for SQL Server 2005 SP3 I think there is bit more to add up, recently when I have been volunteering at recent SQL conferences one of the users mentioned about few questions on these CU package updates: where...

Filed under: sql server, microsoft, best practices, download, service pack, cumulative update, ism, incremental service model

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

Help Microsoft BI Development team to Build next version of AdventureWorks databases
06 February 09 01:13 PM | ssqa.net | with no comments

Until SQL Server 2000 you may be familiar with pubs & northwind sample databases that were available along with SQL Server installation and since release of SQL 2005 the scenario has been changed for Sample databases.The version of AdventureWorks...

Filed under: sql server, best practices, download, features, databases, northwind, feedback, msft, samples, pubs, adventureworks

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

Production version of SQL Server 2005 Service Pack 3 (SP3) is released
16 December 08 11:14 AM | ssqa.net | with no comments

Ok, you have seen many blog posts out there asking for Service pack 3 for SQL Server 2005 (such as Are you ready for SP3 and SQL2005SP3_WorkStarted , it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to...

Filed under: sql server, 2005, best practices, download, service pack, production, sp3

SQL Server 2000 to 2005 to 2008 Upgrade Technical Reference Guide
05 December 08 09:02 AM | ssqa.net | 1 comment(s)

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...

Filed under: sql server, microsoft, best practices, documentaiton, benefits, upgrade

[OT] UK Government Helps You - Beware its a SPAM*
26 November 08 08:49 AM | ssqa.net | with no comments

Wednesday, November 26, 2008 1:33 AM SQL Master Edit UK Government Helps You - Beware its a SPAM* With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are...

Filed under: best practices, database, government, spam

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

RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008
13 November 08 09:07 AM | ssqa.net | with no comments

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to...

Filed under: sql server, performance, best practices, dba, monitoring, pssdiag, rml utitilies

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

More Posts Next page »