Quality Control with SQL Server

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716172

  • @Ashish

    Old Hand

    Points: 383

    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.

     

     

    _________

    Regards,
    Ashish

  • ziggy starlight

    Old Hand

    Points: 352

    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.

    ***

  • Jason Delaune

    SSCrazy

    Points: 2539

    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

  • David O

    Hall of Fame

    Points: 3228

    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.

  • Johan Bijnens

    SSC Guru

    Points: 134265

    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

    Johan


    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt ?

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me[/url] :alien: but most of the time this is me :hehe:

  • K. Brian Kelley

    SSC Guru

    Points: 114465

    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.

     

    K. Brian Kelley
    @kbriankelley

  • Johan Bijnens

    SSC Guru

    Points: 134265

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

    Johan


    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt ?

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me[/url] :alien: but most of the time this is me :hehe:

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

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

  • noeld

    SSC Guru

    Points: 96590

    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.


    * Noel

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply