[EN] SQL Server 2008 Service Pack 3 Cumulative Update 9 is available

LOGO__SQLServer2008SP3On 21st January Microsoft released Cumulative Update No 9 for SQL Server 2008 with Service Pack 3. In this Cumulative Update 9 [version build 10.00.5829.00] resolved three bugs listed below and wchich could be applied for:

  • Microsoft SQL Server 2008 Service Pack 3
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Workgroup

Here is the list of bugs:

VSTS BUG: 1131071 | 2802244
FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points

VSTS BUG: 1145633 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 1113313 | 2780146
FIX: "Incorrect syntax near ‘IDENTITY_VALUE’" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2 or in SQL Server 2008

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 9

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for 32-bit, 64-bit and Itanium). This release is prepared as multilingual package.

[EN] How to DO IT? SharePoint 2007, 64-bit Office and Data Sheet View.

I have been asked by one of my colleague: “I can’t edit my list in library in SharePoint site in excel view. Changing data are very painfull” So, let’s investigate it. I remember that this functionality worked few years ago. And one of these day or once upon a time… whatever. First targer: browser. Checking Opera, FireFox, Internet Explorer (8, 9, 10) give me results none. Nothing happened: friendly sites, minimalizing security, enablling active-x – doesn’t matter. So, I thought about preparing test lab for this case (before implement something in production system).

Captura_SPListDataSheetView01Pict.1 | Creating new SharePoint 2007 list in library. Choosing option is Create List in Datasheet View.

Captura_SPListDataSheetView02Pict.2 | Choosing name of list, for exampe ConfigDatabase (everything asstandard, as user requested)

Captura_SPListDataSheetView03Pict.3 | And – unfortunatelly – receiving proof of this problem: “It cannot be dispayed in Datasheet View for one or more of the following reasons…”

Emtpy list is not a problem, but list with data? This is a probem. Changing data row-by-row it’s a hard job. Especially when we have more than five or ten rows. Or when we want change data by column in multiple rows. Let’s look for data:

Captura_SPListDataSheetView04Pict.4 | Same error with filled data. Argghhh

The solution is simple. This problem appears when we use Microsoft Office Excell (2007, 2010, 2013) in 64-bit version. Why? Because Datasheet Vie IS NOT SUPPORTED for Office application in 64-bit version. It’s not a problem of SharePoint Server, is not a problem of browser, Internet Explorer (except one exception). It’s incompability problem. Fortunately we can instal special addin on our client machine (in my case working on 64-bit Windows 8 too). We must download 25 MB file named: Microsoft Office Access Database Engine 2007 {available for download from THIS place}

Captura_SPListDataSheetView05Pict.5 | Of course after downloading and executing: accepting license terms

Captura_SPListDataSheetView06Pict.6 | Less than two minutes and go.

Even we don’t have any other Microsoft Office 2007 application we should firs going to Windows Update for getting security updates for this small package.

Captura_SPListDataSheetView07Pict.7 | We get four updates. Client restart is not necessary.

Captura_SPListDataSheetView08

Pict.8 | And finally our list is available in Datasheet View

 

As we see problem wasn’t very hard to resolving, but it was important for users. So, with my Best Practices: add installation of this small application to “Must-To-Do” client’s installation disk.

[PL] Zmiany w cenniku SPLA – na plus (styczeń 2013)

Skoro pojawiły sie zmiany “na minus” (czyli zwyżki cen), zupełnie po krasnoludzku by było, gdyby pojawiły sie również zmiany “na plus” czyli obniżki cen. Udało się ten manewr producentowi oprogramowania przeprowadzić, w efekcie czego mamy obniżki cen na wybranych produktach. A dzięki temu, że jest ich więcej niż z poprzednim wpisie, można śmiało powiedzieć: Microsoft obniżył ceny produktów. Tak samo jak dla poprzedniej tabeli wszystkie wartości podane są w euro (ponieważ należymy do krajów rozliczających się tej właśnie walucie) i są wartościami netto.

Part Number Item Name Item Legal Name Prior Current Difference
DHD-00193 BzTlkSvrEntRFID ALNG LicSAPk MVL 1Proc Microsoft® BizTalk Svr Ent RFID All Lng License/Software Assurance Pack Microsoft Volume License 1 License 1 Proc xxx xxx -42,16
N3F-00077 VSTstPro ALNG LicSAPk MVL SAL Microsoft® Visual Studio Test Professional All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -9,24
125-00361 VSTeamFndtnSvr ALNG LicSAPk MVL SAL Microsoft® Visual Studio® Team Foundation Server All Lng License/Software Assurance Pack Microsoft Volume License SAL xxx xxx -3,57
C5E-00746 VSPro ALNG LicSAPk MVL SAL Microsoft® Visual Studio® Professional All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -3,04
NKF-00318 ExprssnStdioUlt ALNG LicSAPk MVL SAL Microsoft® Expression Studio Ultimate All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -2,69
P73-04837 WinSvrStd ALNG LicSAPk MVL 1Proc Microsoft® Windows® Server Standard All Lng License/Software Assurance Pack Microsoft Volume License 1 License 1 Proc xxx xxx -2,16
YJD-00007 CISStd ALNG LicSAPk MVL 1Proc Microsoft® Core Infrastructure Svr Ste Std All Lng License/Software Assurance Pack Microsoft Volume License 1 License 1 Proc xxx xxx -1,73
76M-01134 SharePointStdCAL ALNG LicSAPk MVL SAL forSA Microsoft® SharePoint Standard CAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL for SA xxx xxx -0,84
6RH-00004 LyncSrvEntSAL ALNG LicSAPk MVL forSA Microsoft® Lync Server Ent SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL for SA xxx xxx -0,83
T9A-00002 ProductivitySteSAL ALNG LicSAPk MVL Microsoft® Productivity Suite SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,83
NHF-00295 ExprssnStdioWebPro ALNG LicSAPk MVL SAL Microsoft® Expression Studio Web Professional All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,68
MFF-00504 SysCtrCltMgmtSte ALNG LicSAPk MVL SAL Microsoft® Sys Ctr Clt Mgmt Suite All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,39
76P-00742 SharePointSvr ALNG LicSAPk MVL Std SAL Microsoft® SharePoint Server All Lng License/Software Assurance Pack Microsoft Volume License 1 License Standard SAL xxx xxx -0,36
F09-00018 ExchgStdPlusSAL ALNG LicSAPk MVL Microsoft® Exchange Std Plus SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License xxx xxx -0,31
T98-02400 WinRghtsMgmtSrvcsCAL ALNG LicSAPk MVL SAL Microsoft® Windows Rights Mgt Services CAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,31
47F-00223 ExprssnEncdrPro ALNG LicSAPk MVL SAL Microsoft® Expression Encoder Pro All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,27
F08-00025 ExchgStdSAL ALNG LicSAPk MVL Microsoft® Exchange Standard SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,27
6QH-00004 LyncSvrStdSAL ALNG LicSAPk MVL forSA Microsoft® Lync Server Std SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL for SA xxx xxx -0,13
F08-00027 ExchgStdSAL ALNG LicSAPk MVL forSA Microsoft® Exchange Standard SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL for SA xxx xxx -0,13
65F-00049 DynSLHstd ALNG LicSAPk MVL eCmmrcGtwyEDI 1Proc Microsoft® Dynamics SL Hosted All Lng License/Software Assurance Pack Microsoft Volume License eCommerce Gateway EDI 1 Proc xxx xxx -0,12
79H-00128 OfficeMultiLangPk ALNG LicSAPk MVL SAL Microsoft® Office Multi Language Pack All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,12
74H-00001 FrfrntOnlnPrtcnforExchg ALNG LicSAPk MVL PerUsr Microsoft® Frfrnt Online Prtcn for Exchange All Lng License/Software Assurance Pack Microsoft Volume License 1 License Per User Per User xxx xxx -0,03
74H-00040 FrfrntOnlnPrtcnforExchg ALNG LicSAPk MVL PerDvc Microsoft® Frfrnt Online Prtcn for Exchange All Lng License/Software Assurance Pack Microsoft Volume License 1 License Per Device Per Device xxx xxx -0,03
D87-03215 VisioPro ALNG LicSAPk MVL SAL Microsoft® Visio® Professional All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,02
K63-00006 ProvisioningSys Win32 ALNG LicSAPk MVL Hosting 1Proc Microsoft® Provisioning System Win32 All Languages License/Software Assurance Pack Microsoft Volume License Hosting 1 Processor License xxx xxx -0,02
021-08183 OfficeStd ALNG LicSAPk MVL SAL Microsoft® Office All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,01
4MH-00001 ExchgEntPlusSAL ALNG LicSAPk MVL Microsoft® Exchange Ent Plus SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,01
5SD-00001 FrFrntUAGSAL ALNG LicSAPk MVL Microsoft® Forefront UAG SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,01
65F-00011 DynSLHstd ALNG LicSAPk MVL AMFullUsr SAL Microsoft® Dynamics SL Hosted All Lng License/Software Assurance Pack Microsoft Volume License Advanced Management SAL xxx xxx -0,01
6QH-00002 LyncSvrStdSAL ALNG LicSAPk MVL Microsoft® Lync Server Std SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,01
74G-00001 ExchgHstdEncryptn ALNG LicSAPk MVL PerUsr Microsoft® Exchange Hosted Encryption All Lng License/Software Assurance Pack Microsoft Volume License 1 License Per User Per User xxx xxx -0,01
H22-01677 PrjctSvr ALNG LicSAPk MVL SAL Microsoft® Project Server All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL xxx xxx -0,01
S92-00164 DynC5 ALNG LicSAPk MVL SAL BscUsr Microsoft® Dynamics C5 All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL Basic User xxx xxx -0,01
T9A-00003 ProductivitySteSAL ALNG LicSAPk MVL ForCoreCALSA Microsoft® Productivity Suite SAL All Lng License/Software Assurance Pack Microsoft Volume License 1 License SAL For Core CAL SA xxx xxx -0,01

 

Trzydzieści cztery produkty taniej. Fajnie nieprawdaż?

Post Scriptum: Na wniosek Kuby, ukryłem ceny podstawowe pozostawiajac tylko różnice, co mam nadzieję nie jest sprzeczne ani z dobrymi praktykami ani z oficjalną linią producenta…