Blog posts written during September 2010

ASP NET Security hole patch

Wednesday Wednesday, September 29, 2010 by Ian Pettman

A severe security hole discovered in the NET framework recently now has a patch available. It affects versions of the net framework from 1.1 to 4.0. It affects current versions of windows from XP onward. The patch is discussed in Scott Guthrie's (aka Scott Gu) blog here:

https://weblogs.asp.net/scottgu/archive/2010/09/28/asp-net-security-update-now-available.aspx

The patch its self is available here:

https://www.microsoft.com/technet/security/bulletin/ms10-070.mspx

Please apply to all public facing web servers immediately.

What is the future for Pulse software

Tuesday Tuesday, September 28, 2010 by Ian Pettman

What is the future for Pulse software? Pulse software is part of Pulse. It has been reported in the industry that the Blackstone Group is in talks to acquire Pulse. The history of Pulse is that it was bought by HgCapital for £67m over ten years ago. It is also reported that Hg has been preparing Pulse for an IPO in the region of £100m plus slated for next year. Either way HgCapital are looking to unload Pulse and from the known figures, taking inflation into account, this does not look an especially good return on investment. Blackstone also recently bought ICS so economies of scale look likely.

SQL version numbers: update

Tuesday Tuesday, September 14, 2010 by Ian Pettman

Over the years it has been helpful to read the SQL version in use by our recruitment software for temporary staff (www.ava.co.uk). This originated in SQL7.0. We have scoured the web for information on SQL versions. It started with the Tripod entry https://vyaskn.tripod.com/sqlsps.htm.  Over time other resources surfaced: https://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx https://www.sqlteam.com/article/sql-server-versions. Needless to say, the least helpful was https://support.microsoft.com/kb/321185 but then what is new? The following script is for the current stored procedure we use to report version numbers for our Help About Window.

 

Please feel free to use. It is provided without any warranty of any kind. If you found this helpful,  please host a link to:  www.ava.co.uk with the words 'Recruitment software for temporary staff' adjacent to or within the link on a web site you administer. Thank you

 

 

Code:

 

Create procedure [dbo].ap_SQLVersion  

AS  
SET NOCOUNT ON  
SELECT  
CONVERT(CHAR(25), @@SERVERNAME) AS 'SERVER'  
, LTRIM(RTRIM(SUBSTRING(@@VERSION, 22, 5))) AS 'VERSION'  
, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))  
WHEN '6.5' THEN SUBSTRING(@@VERSION, 35, 4)  
WHEN '7.00' THEN SUBSTRING(@@VERSION, 35, 4)  
WHEN '2000' THEN SUBSTRING(@@VERSION, 35, 4)  
WHEN '2005' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.00.', @@VERSION) +5  , 5), '.', '')))  
WHEN '2008' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('- 10.', @@VERSION) +7 , 5), '.', '')))  
END AS 'BUILD'  
, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))  
WHEN '6.5' THEN CASE SUBSTRING(@@VERSION, 35, 4)  
WHEN '121' THEN 'NO SP'  
WHEN '124' THEN 'SP1'  
WHEN '139' THEN 'SP2'  
WHEN '151' THEN 'SP3'  
WHEN '201' THEN 'NO SP'  
WHEN '213' THEN 'SP1'  
WHEN '240' THEN 'SP2'  
WHEN '252' THEN 'SP3 ** BAD **'  
WHEN '258' THEN 'SP3'  
WHEN '259' THEN 'SP3 + SBS'  
WHEN '281' THEN 'SP4'  
WHEN '297' THEN 'SP4 + SBS'  
WHEN '339' THEN 'SP4 + Y2K'  
WHEN '415' THEN 'SP5 ** BAD **'  
WHEN '416' THEN 'SP5a'  
WHEN '479' THEN 'SP5a(update)'  
ELSE 'Unknown Hot-Fix version or script out of date'  
END  
WHEN '7.00' THEN CASE SUBSTRING(@@VERSION, 35, 4)  
WHEN '1077' THEN 'SP4+Q316333'  
WHEN '1063' THEN 'SP4'  
WHEN '1004' THEN 'SP3 + Q304851'  
WHEN '996' THEN 'SP3 hotfix'  
WHEN '978' THEN 'SP3 + Q285870'  
WHEN '977' THEN 'SP3 + Q284351'  
WHEN '970' THEN 'SP3 + Q283837/282243'  
WHEN '961' THEN 'SP3'  
WHEN '921' THEN 'SP2 + Q283837'  
WHEN '919' THEN 'SP2 + Q282243'  
WHEN '918' THEN 'SP2 + Q280380'  
WHEN '917' THEN 'SP2 + Q279180'  
WHEN '910' THEN 'SP2 + Q275901'  
WHEN '905' THEN 'SP2 + Q274266'  
WHEN '889' THEN 'SP2 + Q243741'  
WHEN '879' THEN 'SP2 + Q281185'  
WHEN '857' THEN 'SP2 + Q260346'  
WHEN '842' THEN 'SP2'  
WHEN '835' THEN 'SP2 Beta'  
WHEN '776' THEN 'SP1 + Q258087'  
WHEN '770' THEN 'SP1 + Q252905'  
WHEN '745' THEN 'SP1 + Q253738'  
WHEN '722' THEN 'SP1 + Q239458'  
WHEN '699' THEN 'SP1'  
WHEN '689' THEN 'SP1 Beta'  
WHEN '677' THEN 'MSDE O2K Dev'  
WHEN '662' THEN 'Gold+Q232707'  
WHEN '658' THEN 'Gold+Q244763'  
WHEN '657' THEN 'Gold+Q229875'  
WHEN '643' THEN 'Gold+Q220156'  
WHEN '623' THEN 'Gold, no SP'  
WHEN '583' THEN 'RC1'  
WHEN '517' THEN 'Beta 3'  
WHEN '416' THEN 'SP5a'  
WHEN '415' THEN 'SP5 ** BAD **'  
WHEN '339' THEN 'SP4 + y2k'  
WHEN '297' THEN 'SP4 + SBS'  
WHEN '281' THEN 'SP4'  
WHEN '259' THEN 'SP3 + SBS'  
WHEN '258' THEN 'SP3'  
WHEN '252' THEN 'SP3 ** BAD ** '  
WHEN '240' THEN 'SP2'  
WHEN '213' THEN 'SP1'  
WHEN '201' THEN 'No SP'  
WHEN '198' THEN 'Beta 1'  
WHEN '151' THEN 'SP3'  
WHEN '139' THEN 'SP2'  
WHEN '124' THEN 'SP1'  
WHEN '121' THEN 'No SP'  
ELSE 'Unknown - Hot-Fix version or script out of date'  
END  
WHEN '2000'  
THEN CASE SUBSTRING(@@VERSION, 35, 4)  
WHEN '2162' THEN 'SP4 + cumulative hotfix'  
WHEN '2159' THEN 'KB 907250 907009'  
WHEN '2151' THEN 'KB 903742'  
WHEN '2148'  
THEN 'KB 902150 898626 895123 899431 901200 899430 901212 900404 902955 900390 903086 900629'  
WHEN '2145' THEN 'KB 826906'  
WHEN '2040' THEN 'SP4 AWE hotfix'  
WHEN '2039' THEN 'Service Pack 4 Downloadable'  
WHEN '2026' THEN 'Service Pack 4 (Beta)'  
WHEN '1029' THEN 'KB 902851 900625'  
WHEN '1027' THEN 'KB 900335'  
WHEN '1025' THEN 'KB 899430 899428'  
WHEN '1021' THEN 'KB 897578 887700'  
WHEN '1020' THEN 'KB 896985'  
WHEN '1019' THEN 'KB 897572 896980'  
WHEN '1017' THEN 'KB 896425'  
WHEN '1014' THEN 'KB 895123 892985'  
WHEN '1013' THEN 'KB 891866'  
WHEN '1009' THEN 'KB 894254 894257'  
WHEN '1007' THEN 'KB 892840 891640 893172 893402 893312 892940'  
WHEN '1003' THEN 'KB 892935 892923'  
WHEN '1001' THEN 'KB 891707 892310 892551 892205 892141 891719'  
WHEN '1000' THEN 'KB 892392 891585'  
WHEN '0997' THEN 'KB 891311'  
WHEN '0996' THEN 'KB 891017 891201 891268'  
WHEN '0994' THEN 'KB 890768 890767 890942'  
WHEN '0993' THEN 'KB 888444 890925'  
WHEN '0991' THEN 'KB 889314'  
WHEN '0990' THEN 'KB 890755 890200'  
WHEN '0988' THEN 'KB 889170 890637 889166'  
WHEN '0985' THEN 'KB 888998 888429 889239 890730'  
WHEN '0980' THEN 'KB 886708 887974'  
WHEN '0977' THEN 'KB 889266 884850 885442 843534 884856'  
WHEN '0973' THEN 'KB 884554'  
WHEN '0972' THEN 'KB 885290'  
WHEN '0970' THEN 'KB 884864 885158 884854 884853 884855 872842'  
WHEN '0967' THEN 'KB 878501 884772 884260'  
WHEN '0962' THEN 'KB 883415'  
WHEN '0961' THEN 'KB 873482 875445 872843 873446'  
WHEN '0959' THEN 'KB 878500'  
WHEN '0957' THEN 'KB 870994'  
WHEN '0955' THEN 'KB 867798'  
WHEN '0954' THEN 'KB 843282 870972'  
WHEN '0952' THEN 'KB 867878 867879 867880 839096'  
WHEN '0949' THEN 'KB 867746 843266 843267'  
WHEN '0948' THEN 'KB 843263'  
WHEN '0944' THEN 'KB 839280'  
WHEN '0937' THEN 'KB 841776'  
WHEN '0936' THEN 'KB 841627 838409'  
WHEN '0935' THEN 'KB 841401'  
WHEN '0934' THEN 'KB 841175 841404'  
WHEN '0933' THEN 'KB 840406'  
WHEN '0929' THEN 'KB 839529'  
WHEN '0928' THEN 'KB 840166 839529 839589 839884'  
WHEN '0927' THEN 'KB 839688'  
WHEN '0926' THEN 'KB 839523 839458'  
WHEN '0923' THEN 'KB 839096 838460'  
WHEN '0922' THEN 'KB 837231 837970 837969 833045 838459'  
WHEN '0919' THEN 'KB 837890 837957'  
WHEN '0915' THEN 'KB 837401'  
WHEN '0913' THEN 'KB 836839 836651 309802'  
WHEN '0911' THEN 'KB 834923 836096 836136 834720'  
WHEN '0910' THEN 'KB 834798 835864'  
WHEN '0908' THEN 'KB 834290 834688 835581'  
WHEN '0904' THEN 'KB 834451 834453'  
WHEN '0892' THEN 'KB 833710'  
WHEN '0891' THEN 'KB 833406 836141'  
WHEN '0879' THEN 'KB 832977'  
WHEN '0878' THEN 'KB 838166 832674 832437 831950'  
WHEN '0876' THEN 'KB 831997 831999'  
WHEN '0873' THEN 'KB 831675 830912 830887 830773'  
WHEN '0871' THEN 'KB 829386 830767 830860 831302'  
WHEN '0870' THEN 'KB 830262'  
WHEN '0869' THEN 'KB 830596 830588'  
WHEN '0866' THEN 'KB 830366'  
WHEN '0865' THEN 'KB 821537 830382 830375 830395 830298 828945 829183'  
WHEN '0863' THEN 'KB 829205 829444'  
WHEN '0859' THEN 'KB 821334'  
WHEN '0858' THEN 'KB 828637'  
WHEN '0857' THEN 'KB 827714 828308 828017'  
WHEN '0856' THEN 'KB 828096'  
WHEN '0854' THEN 'KB 828699 818079'  
WHEN '0852' THEN 'KB 827954 830466'  
WHEN '0851' THEN 'KB 827175 826754 827178'  
WHEN '0850' THEN 'KB 826906 826815 826860'  
WHEN '0848' THEN 'KB 826822'  
WHEN '0847' THEN 'KB 826433'  
WHEN '0845' THEN 'KB 825854 826364 826376'  
WHEN '0844' THEN 'KB 826080'  
WHEN '0842' THEN 'KB 825043'  
WHEN '0841' THEN 'KB 825225'  
WHEN '0840' THEN 'KB 825197 825042 825025 824430 319477 822033'  
WHEN '0839' THEN 'KB 824018 824028 824027 823877'  
WHEN '0837' THEN 'KB 820788 823455 825045 821806 822757 822747 822746 822668 821535' +  
' 821688 821740 820727 823514 824227 825019 821548 819829 823429 825883 825884'  
WHEN '0818' THEN 'KB 826161 821277 821688 811188 818806 814919 814950'  
WHEN '0816' THEN 'KB 818766 818767 818768 818769 820835 820837 332004'  
WHEN '0811' THEN 'KB 819662 818897 819248 819955'  
WHEN '0807' THEN 'KB 818899 818335'  
WHEN '0804' THEN 'KB 818729'  
WHEN '0800' THEN 'KB 817780 818414 818188 818097 818095 816937 818540 828269'  
WHEN '0794' THEN 'KB 817464 816440 816883 813524 817709'  
WHEN '0789' THEN 'KB 816840 817263 817262 817186 816780 817368 817359 816503 314128'  
WHEN '0781' THEN 'KB 815057'  
WHEN '0780'  
THEN 'KB 815056 319477 816084 816069 816039 815593 815592 815114 812915 815183 814997 815476'  
WHEN '0775' THEN 'KB 815115'  
WHEN '0769' THEN 'KB 815008 814893 815199 814889'  
WHEN '0765'  
THEN 'KB 814509 821548 814654 331158 814894 812995 813494 810688 811611 813769 813759 810163 814460 814916'  
WHEN '0763' THEN 'KB 814113'  
WHEN '0762' THEN 'KB 814032'  
WHEN '760' THEN 'SP3 or SP3a'  
WHEN '679' THEN 'SP2 + Q316333'  
WHEN '667' THEN 'SP2 + 8/14 fix'  
WHEN '665' THEN 'SP2 + 8/8 fix'  
WHEN '655' THEN 'SP2 + 7/24 fix (Q323875) *SQLSlammer worm vuln fixed here'  
WHEN '650' THEN 'SP2 + Q322853'  
WHEN '608' THEN 'SP2 + Q319507'  
WHEN '604' THEN 'SP2 + 3/29 fix'  
WHEN '578' THEN 'SP2 + Q317979'  
WHEN '561' THEN 'SP2 + 1/29 fix'  
WHEN '534' THEN 'SP2.01'  
WHEN '532' THEN 'SP2'  
WHEN '475' THEN 'SP1 + 1/29 fix'  
WHEN '452' THEN 'SP1 + Q308547'  
WHEN '444' THEN 'SP1 + Q307540/307655'  
WHEN '443' THEN 'SP1 + Q307538'  
WHEN '428' THEN 'SP1 + Q304850'  
WHEN '384' THEN 'SP1'  
WHEN '287' THEN 'No SP+Q297209'  
WHEN '250' THEN 'No SP+Q291683'  
WHEN '249' THEN 'No SP+Q288122'  
WHEN '239' THEN 'No SP+Q285290'  
WHEN '233' THEN 'No SP+Q282416'  
WHEN '231' THEN 'No SP+Q282279'  
WHEN '226' THEN 'No SP+Q278239'  
WHEN '225' THEN 'No SP+Q281663'  
WHEN '223' THEN 'No SP+Q280380'  
WHEN '222' THEN 'No SP+Q281769'  
WHEN '218' THEN 'No SP+Q279183'  
WHEN '217' THEN 'No SP+Q279293/279296'  
WHEN '211' THEN 'No SP+Q276329'  
WHEN '210' THEN 'No SP+Q275900'  
WHEN '205' THEN 'No SP+Q274330'  
WHEN '204' THEN 'No SP+Q274329'  
WHEN '194' THEN 'RTM No SP'  
WHEN '190' THEN 'Gold, no SP'  
WHEN '100' THEN 'Beta 2'  
WHEN '078' THEN 'EAP5'  
WHEN '047' THEN 'EAP4'  
ELSE 'Unknown - Hot-Fix version or script out of date'  
END  
WHEN '2005' THEN CASE RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.00.', @@VERSION) +5  , 5), '.', '')))  
WHEN '608' THEN 'Beta 1'  
WHEN '645' THEN 'Internal'  
WHEN '747' THEN 'Internal (IDW1)'  
WHEN '767' THEN 'Internal (IDW2)'  
WHEN '790' THEN 'Internal (IDW3)'  
WHEN '823' THEN 'Internal (IDW4)'  
WHEN '836' THEN 'Express Edition Technical Preview'  
WHEN '844' THEN 'Internal'  
WHEN '849' THEN 'Internal'  
WHEN '852' THEN 'Beta 2 '  
WHEN '917' THEN 'Internal'  
WHEN '951' THEN 'October CTP'  
WHEN '981' THEN 'December CTP'  
WHEN '1090' THEN 'March CTP (Doc as Feb)'  
WHEN '1116' THEN 'April CTP'  
WHEN '1187' THEN 'June CTP'  
WHEN '1314' THEN 'September'  
WHEN '1399' THEN 'RTM '  
WHEN '1500' THEN 'RTM +KB 910414 910416 910419'  
WHEN '2047' THEN 'SP1'  
WHEN '3042' THEN 'SP2 needs hot fix'  
WHEN '3043' THEN 'SP2 +MaintenancePlanTasks.dll'  
WHEN '3044' THEN 'SP2 +GRD2'  
WHEN '3050' THEN 'SP2 +GRD1'  
WHEN '3052' THEN 'SP2 +933097'  
WHEN '3054' THEN 'SP2 +934458'  
WHEN '3059' THEN 'SP2 +934459'  
WHEN '4266' THEN 'SP3 + Q974648 (Cumulative HF6)'  
WHEN '4230' THEN 'SP3 + Q972511 (Cumulative HF5)'  
WHEN '4226' THEN 'SP3 + Q970279 (Cumulative HF4)'  
WHEN '4224' THEN 'SP3 + Q971409'  
WHEN '4220' THEN 'SP3 + Q967909 (Cumulative HF3)'  
WHEN '4216' THEN 'SP3 + Q967101'  
WHEN '4211' THEN 'SP3 + Q961930 (Cumulative HF2)'  
WHEN '4207' THEN 'SP3 + Q959195 (Cumulative HF1)'  
WHEN '4035' THEN 'SP3 + Q955706'  
WHEN '4053' THEN 'SP2 Express advanced services'  
WHEN '3355' THEN 'SP2 + Q216793 (Cumulative HF16)'  
WHEN '3330' THEN 'SP2 + Q972510 (Cumulative HF15)'  
WHEN '3328' THEN 'SP2 + Q970278 (Cumulative HF14)'  
WHEN '3327' THEN 'SP2 + Q948567 / 961648'  
WHEN '3325' THEN 'SP2 + Q967908 (Cumulative HF 13)'  
WHEN '3320' THEN 'SP2 + Q969142'  
WHEN '3318' THEN 'SP2 + Q967199'  
WHEN '3315' THEN 'SP2 + Q962970 (Cumulative HF12, available via request.)'  
WHEN '3310' THEN 'SP2 + Q960090'  
WHEN '3303' THEN 'SP2 + Q962209'  
WHEN '3302' THEN 'SP2 + Q961479 / 961648'  
WHEN '3301' THEN 'SP2 + Q958735 (Cumulative HF11, avail. via request.)'  
WHEN '3295' THEN 'SP2 + Q959132'  
WHEN '3294' THEN 'SP2 + Q956854 (Cumulative HF10, avail. via request.)'  
WHEN '3291' THEN 'SP2 + Q956889'  
WHEN '3289' THEN 'SP2 + Q937137'  
WHEN '3282' THEN 'SP2 + Q953752 / 953607 (Cumulative HF9, avail. via request.)'  
WHEN '3261' THEN 'SP2 + Q955754'  
WHEN '3260' THEN 'SP2 + Q954950'  
WHEN '3259' THEN 'SP2 + Q954669 / 954831'  
WHEN '3257' THEN 'SP2 + Q951217 (Cumulative HF8, avail. via request.)'  
WHEN '3253' THEN 'SP2 + Q954054'  
WHEN '3244' THEN 'SP2 + Q952330'  
WHEN '3242' THEN 'SP2 + Q951190'  
WHEN '3240' THEN 'SP2 + Q951204'  
WHEN '3239' THEN 'SP2 + Q949095 (Cumulative HF7, avail. via PSS only)'  
WHEN '3235' THEN 'SP2 + Q950189'  
WHEN '3233' THEN '(QFE) SP2 + Q941203 / 948108'  
WHEN '3232' THEN 'SP2 + Q949959'  
WHEN '3231' THEN 'SP2 + Q949687/949595'  
WHEN '3230' THEN 'SP2 + Q949199'  
WHEN '3228' THEN 'SP2 + Q946608 (Cumulative HF6, avail. via PSS only)'  
WHEN '3224' THEN 'SP2 + Q947463'  
WHEN '3222' THEN 'SP2 + Q945640 / 945641 / 947196 / 947197'  
WHEN '3221' THEN 'SP2 + Q942908 / 945442 / 945443 / 945916 / 944358 '  
WHEN '3215' THEN 'SP2 + Q941450 (Cumulative HF5, avail. via PSS only)'  
WHEN '3209' THEN 'SP2 (KB N/A, SQLHF Bug #50002118)'  
WHEN '3208' THEN 'SP2 + Q944902'  
WHEN '3206' THEN 'SP2 + Q944677'  
WHEN '3205' THEN 'SP2 (KB N/A, SQLHF Bug #50001708/50001999)'  
WHEN '3203' THEN 'SP2 (KB N/A, SQLHF Bug #50001951/50001993/50001997/50001998/50002000)'  
WHEN '3200' THEN 'SP2 + Q941450 (Cumulative HF4, avail. via PSS only)'  
WHEN '3195' THEN 'SP2 (KB N/A, SQLHF Bug #50001812)'  
WHEN '3194' THEN 'SP2 + Q940933'  
WHEN '3186' THEN 'SP2 + Q939562 (Cumulative HF3, avail. via PSS only)'  
WHEN '3182' THEN 'SP2 + Q940128'  
WHEN '3180' THEN 'SP2 + Q939942'  
WHEN '3179' THEN 'SP2 + Q938243'  
WHEN '3178' THEN 'SP2 (KB N/A, SQLHF Bug #50001193/5001352)'  
WHEN '3177' THEN 'SP2 + Q939563 / 939285'  
WHEN '3175' THEN 'SP2 + Q936305 /938825 (Cumulative HF2, avail. via PSS only)'  
WHEN '3171' THEN 'SP2 + Q937745'  
WHEN '3169' THEN 'SP2 + Q937041/937033'  
WHEN '3166' THEN 'SP2 + Q936185 / 934734'  
WHEN '3162' THEN 'SP2 + Q932610/935360/935922'  
WHEN '3161' THEN 'SP2 + Q935356/933724(Cumulative HF1, avail. via PSS only)'  
WHEN '3159' THEN 'SP2 + Q934459'  
WHEN '3156' THEN 'SP2 + Q934226'  
WHEN '3155' THEN 'SP2 + Q933549 / 933766/933808/933724/932115/933499'  
WHEN '3154' THEN 'SP2 + Q934106 / 934109 / 934188'  
WHEN '3153' THEN 'SP2 + Q933564'  
WHEN '3152' THEN 'SP2 + Q933097 (Cumulative HF1)'  
WHEN '3077' THEN 'SP2 + Q960089'  
WHEN '3073' THEN 'SP2 + Q954606 (GDR)'  
WHEN '3068' THEN '(GDR) SP2 + Q941203 / 948109'  
WHEN '3054' THEN 'SP2 + Q934458'  
WHEN '3050' THEN 'SP2 + Q933508'  
WHEN '3043' THEN 'SP2 + Q933508 (use this if SP2 was applied prior to 3/8)'  
WHEN '3042' THEN 'Fixed SP2 (use this if SP2 was NOT applied yet - orig. RTM removed)'  
WHEN '3033' THEN 'SP2 CTP (December) - Fix List'  
WHEN '3027' THEN 'SP2 CTP (November)'  
WHEN '3026' THEN 'SP1 + Q929376'  
END  
WHEN '2008' THEN  
CASE RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.', @@VERSION) +3 , 1), '.', '')))  
WHEN  '0' THEN  
CASE RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.0.', @@VERSION) +5 , 5), '.', '')))  
WHEN '1019' THEN 'June CTP'  
WHEN '1049' THEN 'July CTP (requires Virtual Server 2005 R2)'  
WHEN '1300' THEN 'February CTP'  
WHEN '1600' THEN 'RTM'  
WHEN '1750' THEN 'RTM + Q956718)'  
WHEN '1771' THEN 'RTM + Q958611)'  
WHEN '1779' THEN 'RTM + Q958186 Cumulative HF2, available by request.'  
WHEN '1787' THEN 'RTM + Cumulative Update 3'  
WHEN '1798' THEN 'RTM + Cumulative Update 4'  
WHEN '1806' THEN 'RTM + Cumulative Update 5'  
WHEN '1812' THEN 'RTM + Cumulative Update 6'  
WHEN '2531' THEN 'Service Pack 1'  
WHEN '2710' THEN 'SP1 + Cumulative Update 1'  
WHEN '2712' THEN 'SP1 + Q970507'  
WHEN '2714' THEN 'SP1 + Cumulative Update 2'  
WHEN '2723' THEN 'SP1 + Cumulative Update 3'  
WHEN '2734' THEN 'SP1 + Cumulative Update 4'  
WHEN '2746' THEN 'SP1 + Cumulative Update 5'  
WHEN '2757' THEN 'SP1 + Cumulative Update 6'  
WHEN '2766' THEN 'SP1 + Cumulative Update 7'  
WHEN '2775' THEN 'SP1 + Cumulative Update 8'  
ELSE  
'unknown'  
END  
WHEN '5' THEN  
CASE RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('- 10.5', @@VERSION) +7 , 5), '.', '')))  
WHEN '1600' THEN 'R2 RTM'  
WHEN '1702' THEN 'CU1 R2 RTM'  
WHEN '1720' THEN 'CU2 R2 RTM'  
WHEN '1450' THEN 'R2 RC 0'  
ELSE  
'unknown'  
END  
END  
END AS 'SP'  
, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))  
WHEN '6.5' THEN SUBSTRING(@@VERSION, 30, 4)  
WHEN '7.00' THEN SUBSTRING(@@VERSION, 30, 3)  
WHEN '2000' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('8.', @@VERSION) +2  , 3), '.', '')))  
WHEN '2005' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.', @@VERSION) +2  , 3), '.', '')))  
WHEN '2008' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.', @@VERSION) +3 , 1), '.', '')))  
END AS 'VER'  
SET NOCOUNT OFF  
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Umbraco improvements

Monday Monday, September 13, 2010 by Ian Pettman

Umbraco CMS have just released a number of improvements to the Umbraco system. We have been testing the upgrade process for a site originally written with v 3.0.

 

 

Microsoft Baseline Analyser and other errors

Wednesday Wednesday, September 1, 2010 by Ian Pettman

Problem solving with SQL2008R2: or who put the Anal in R2 best practice analyser?
There is a new kid on the block and it's called SQL 2008 R2 Best practices analyser. Even by Microsoft standards the install is somewhat fraught. Do they ever test these installs? However the end result should be automatic testing of your installs for best practice - and that has to be good.


The steps are: download and install Power shell 2.0 ( its now called Windows Management Framework Core)
https://www.microsoft.com/downloads/details.aspx?FamilyId=f2fa1227-9a34-4e29-aa03-62f5c00e16f2&displaylang=en
You may be prompted for an update on Vista:
The Windows Management Framework BITS package provides updated management functionality for IT Professionals.
https://www.microsoft.com/downloads/details.aspx?FamilyID=d7ae9660-bb13-4f0c-816b-85de3980ec1b&displaylang=en&Hash=bT%2bM0D5bmCtAsBdCdyuVotjBveBjfO%2bEw%2fy3nnAnr53M3oDmlTDZocV1wxhHc5eqLjQ%2bzaHNaq5WTk9AtetwdA%3d%3d
You can then install Microsoft Baseline Configuration Analyzer 2.0
https://www.microsoft.com/downloads/details.aspx?FamilyID=1B6E9026-F505-403E-84C3-A5DEA704EC67&displaylang=en
Which then allows you to install (sorry download because there is a known issue here) the R2 best practice analyser
https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
You will almost certainly hit a "there is a problem with this windows installer..."
The work round is to run the installer from the command line as described here:
https://blogs.msdn.com/b/psssql/archive/2010/06/21/known-issues-installing-sql-2008-r2-bpa-relating-to-remoting.aspx
You will then find the shortcut in startmenu / programs

 

If like me you are running this on a local (fully service packed) vista machine to test against a Local instance of 2008 R2 Express, then you will probably get the following message:

 

Baseline Analyser

 

Ok, so I right mouse click and "run as" administrator.

Still no luck.

So I fire up power shell (right click - run as adminsitrator) and paste an run the scripts in 2 and 3

2. Helpfully tells me all is enabled

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...