SqlServer-QA.net

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

In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. ...

I feel this type of contest by Microsoft will make this (2008) SQL Server release as a best release as more and more users will be interested to join the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules that govern how the Microsoft SQL Server February CTP Bug Bash ...

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business segment within your organization with ...

In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging the data related activites is a 'must' ...

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

To provide High Availability feature within your database environment you could take advantage of Database Mirroring when using SQL Server 2005. As with all critical databases, minimizing data loss and downtime are of the highest importance. Having ''AlwaysOn'' configuration within the SQL Server 2005 that allows a database to be highly available ...

Windows Vista SP1 RC is released on 05th December to the Beta Testers on the Microsoft-Connect and on 06th December it is available via MSDN and TechNet subscribers.  Few things if you want to know about Vista SP1 RC refer to the following notes from Microsoft: ·         Microsoft are ...

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

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a value that will affect the whole server ...