[EN] PowerShell Impressions

I’m not a fan of PowerShell. Yes, not yet. But sometimes PowerShell is necessary – even not for work task, but maybe for learn something. Yesterday I just tried to use PowerShell on my laptop (with Windows 81. on board). And as many of you know I’m a little strange person – using Spanish version of systems, even living in Poland (ok, sometimes apps are in Catalan or Icelandic or other languages).

And I open my PowerShell Gui. Because I never use PowerShell on this machine, when I use Get-Help command I got answer (in Spanish):

Pict. 1 – Having not any Get-Help library. Do You want to execute Update-Help cmdlets?

Crapy. What will happen if I would be able to work with Spanish version of PowerShell? It’s a standard for my command line and sometimesis not easy to use:

I was able to choos only one, right option: {S} that means Yes, update for library just started (in light blue part of screen. Of course I was a little aftraid, because I’m ready for work in Spanish Windows version, I’m not good enough to work with Spanish PowerShell version. But fortunatelly after update I saw:

Pict. 2 – Standard English based PowerShell Get-Help library.

Simple things make me happy!

[EN] SQL Server 2008 SP3 Cumulative Update 14 is available

LOGO__SQL_ServerTwo updates pack has been published one day ago. First pack is for SQL Server 2008 SP3. In this Cumulative Update No 14 (build number: 10.00.5848.00 / 210 MB in zipped file for x64 env.) Microsoft fixed six submitted bugs. Here is the list:

VSTS BUG: 1517718 | 2591461
FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1480650 | 2884888
FIX: Unable to click OK or Cancel in the query designer in BIDS 2008 or in SQL Server 2008 Report Builder

VSTS BUG: 1494726 | 2887465
FIX: You receive an incorrect result when you run a query that uses some ranking functions in SQL Server 2008

VSTS BUG: 1516349 | 2889492
FIX: You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1560626 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008

VSTS BUG: 1596875 | 2901479
FIX: You experience query failure when you run MDX queries in SSAS 2008

 

This update could be applied for: Microsoft SQL Server 2008 Service Pack 3, when used with:

  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Reporting Services

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 14

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 all platforms: 32-bit, 64-bit & Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 | x86 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x86

  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x64

  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_IA64

Enjoy!