Browse by Tags

All Tags » sql server » testing (RSS)
SQL Server 2008 February CTP - report a bug and get a chance to win XBOX!
Published 25 February 8 2:20 AM | SSQA.net
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 j oin the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules...
Filed under: , , , , , , , ,
What is Business Intelligence? How to obtain complete tools suite to test?
Published 8 February 8 12:11 PM | SSQA.net
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...
Filed under: , , , , , , , , , ,
SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?
Published 1 February 8 9:50 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!
Published 27 December 7 2:2 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!
Published 24 December 7 4:42 AM | SSQA.net
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...
Filed under: , , , , , , , , , , , ,
SQL Server 2005 Database Mirroring - basics and related resources
Published 10 December 7 4:33 AM | SSQA.net
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"...
Filed under: , , , , , , ,
Windows Vista SP1 Release Candidate Announcement
Published 6 December 7 12:32 PM | SSQA.net
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...
Filed under: , , , , , , , ,
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?
Published 23 November 7 8:51 AM | SSQA.net
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 & http://sqlserver-qa.net/blogs/tools/archive/2007...
Filed under: , , , , , , , , ,
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
Published 15 November 7 9:41 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
How to find whether that service pack file is a 32 bit or 64 bit?
Published 1 November 7 6:44 AM | SSQA.net
Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...
Filed under: , , , , , , , , , ,
SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
Published 30 October 7 10:41 PM | SSQA.net
You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...
Filed under: , , , , , , , , ,
Best practices for Data Importing using SQL Server native methods
Published 26 October 7 6:8 PM | SSQA.net
Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server...
Filed under: , , , , , , ,
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
Published 16 October 7 7:18 AM | SSQA.net
You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and...
Filed under: , , , , , , , , ,
How to gain Disk related performance with few simple steps
Published 30 July 7 9:24 AM | SSQA.net
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write...
Filed under: , , , , , , , , ,