SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / Quality Control with SQL Server / Latest Posts

RE: Quality Control with SQL Server

noeld — Tue, 10 Apr 2007 09:00:00 GMT

And the zaga continues. They posted that the membership scripting issue was "solved" on SP2 and guess what? When I checked my SP2 installation it still does not scripts built-in database role membership!How bad is this QA going to get??? GRRRRRRRRRRR.

RE: Quality Control with SQL Server

alen teplitsky — Mon, 09 Apr 2007 07:33:00 GMT

used to be MS service packs were like Star Trek. Evens are the best and the odds are the problems. looks like it changing

RE: Quality Control with SQL Server

ALZDBA — Sun, 08 Apr 2007 12:09:00 GMT

Indeed, there 's more than one reason to avoid the path of auto-updates.

Back to controlled releasemanagement and assuring uptime and avoiding surprises like the ones mentioned already...

RE: Quality Control with SQL Server

K. Brian Kelley — Sun, 08 Apr 2007 06:39:00 GMT

It's not just SQL Server. Windows Server 2003 SP2 has issues. Removes Help & Support. Causes issues if you have older Broadcom drivers. Don't forget the furor over what it can do to ISA Server. And the fact that it released on patch Tuesday (when there were no other patches) without warning meaning it got auto-applied to a bunch of systems... yeah. I think Susan Bradley has summed up the fury of the community in some of her posts.

And, if that wasn't bad enough MS07-017 wasn't clean, either. Causes problems with Realtek HD Audio Control Panel. And there's a hotfix out. It was out almost immediately and Microsoft is now pushing that as part of the WSUS / AU process. I know MS07-017 was rushed out the door because of the .ANI animated cursor vulnerability but certainy something like the Realtek issue should have been caught as it's not an unusual piece of software on workstations.

RE: Quality Control with SQL Server

ALZDBA — Sun, 08 Apr 2007 04:41:00 GMT

just wanted to ref to the sp2a article by Andy Warren : http://www.sqlservercentral.com/columnists/pressrelease/2906.asp

and its comments :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=112&messageid=349577#bm351006

RE: Quality Control with SQL Server

David O — Fri, 06 Apr 2007 20:23:00 GMT

The quality hasn't been good on Sql2k either. Remember the AWE patch for 8.00.2039? Then the 1st rollup after that got pulled back? If you read the notes on 8.00.2187, what is post SP3 but not in SP4 but now is in the rollup, it is a mess.The quality stinks and I'm glad someone had the guts to call them on it.

RE: Quality Control with SQL Server

Jason Delaune — Fri, 06 Apr 2007 09:52:00 GMT

Hello all,

I recently asked the question on the SQL Server Forum about the difference between the build numbers. Build numbers in the 30xx range are for GDR patches while build numbers in the 31xx range are for the QFE patches. Here's a reply from Michelle Alexander on the SQL Server product team in regards to my question on the difference between build numbers:

"Yes it is a little confusing but the good news is that installer will make sure that you do the right thing and block you from installing an invalid fix.

Let me attempt to describe how this work. From a customer point of view there are two possible trains you can be on for fixes.

The first is the GDR train where the minimal number of fixes that meet a really high bar in terms of severity and wide impact. They are the lower build number range.

The second is a general QFE train where general fixes that are requested by customers through CSS are added. This has a higher build number range.

Since our QFE's/GDR's are always cumlative then if you need a specific fix that is in the QFE train you always pick up your fix from the QFE train or range of builds. The QFE tree always includes all GDR and QFE fixes.

If you install a GDR and you need subsequent GDR then you pickup you fixes from the GDR train. If you are on a GDR and need a subsequent QFE then you would pick up your fix from the QFE train and stay on the QFE train.

Hopefully I did not make that more confusing

Michelle"

I hope this helps explain the difference in build numbers because I know I wasn't the only one that was confused when I saw the latest 2 KB articles from MS (934458 and 934459).

Jason

RE: Quality Control with SQL Server

ziggy starlight — Fri, 06 Apr 2007 01:26:00 GMT

It seems that developers decided to make a few "shortcuts that will not affect anything previously done", and that project managers decided not to spend time on "something that was already tested before". Now everyone is pointing their fingera at QA people, as if they could know every single thing someone does at such a giant corporation.Quality begins at early stages, it needs to be built into the product.

RE: Quality Control with SQL Server

@Ashish — Thu, 05 Apr 2007 21:59:00 GMT

I completely agree with you on this. MS SQL Server 2005 SP2 is messed up.

See this thread started by me on Microsoft forums about problem in installation of SP2 on one of my servers, no working solution till date.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1249824&SiteID=1

Apparently, this problem is not specific to my server as many users across the SQL Community have encountered the same problem.

All this suggest that Quality Team is not doing its job thoroughly.

Quality Control with SQL Server

Steve Jones - SSC Editor — Thu, 05 Apr 2007 13:54:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sjones/2958.asp