SqlServer-QA.net

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 of the user asked me how to find out how many update packages were released after SQL Server 2008 ...

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 since the release of SQL Server 2008. After you apply this CU1 on SQL 2008 instance ...

Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's  runtime.   This will allow you to log the output to 5 providers, such as text ...

Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs in getting the list swiftly, they are as follows: Books Online (updated) - As the ...

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy to download files from the Microsoft download site, you have to submit a Online Customer ...

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic management views and functions: Server-scoped dynamic management views and functions. ...

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application.  I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and 64-bit editions and bit hard for ...

Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the ...

If you remember we have blogged about release of Cumulative Update 4 for SQL Server Service Pack 2 since it has been declared to be available on download, CUpdate4-SQL2005SP2 is the one I'm referring. So is it is available for download (released recently), now here it comes another wait episode for cumulative update package 5 for SQL Server 2005 ...