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

LOGO__SQLServer2008SP3The second package from week-old updates for SQL Server is for SQL Server 2008 with Service Pack 3.

In this Cumulative Update [version build: 10.00.5844.00] Microsoft resolved only six bugs, listed below:

VSTS BUG: 1178048 | 2793580
FIX: An update is available that enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server 2008 R2 or in SQL Server 2008

VSTS BUG: 1325147 | 2803799
FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2, SQL Server 2008 or SQL Server 2012

VSTS BUG: 1337795 | 2812884
FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1361672 | 2859713
FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008

VSTS BUG: 1274213 | 2861939
FIX: Cannot uninstall, repair, add new features to, or add a new instance to SQL Server 2008 in Windows 8

VSTS BUG: 1194531 | 2862883
FIX: Poor performance when SQL Server 2008 requires memory from a local node in a NUMA environment

This update could be applied for:

  • Microsoft SQL Server 2008 Service Pack 3, when used with:
    • Microsoft SQL Server 2008 Standard
    • Microsoft SQL Server 2008 Web
    • Microsoft SQL Server 2008 Workgroup
    • Microsoft SQL Server 2008 Developer
    • Microsoft SQL Server 2008 Enterprise

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 11

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

  • SQL Server 2008 | x86 | SQLServer2008_SP3_CU12_2863205_10_00_5844_x86
  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU12_2863205_10_00_5844_x64
  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU12_2863205_10_00_5844_IA64

Enjoy!

[EN] SQL Server 2012 Service Pack 1 Cumulative Update 5 is available

LOGO__SQLServer2012Week ago Microsoft released two packages for SQL Server Environment. In first post I’ll write about update for Microsoft SQL Server 2012 with Service Pack 1.

In this Cumulative Update [version build: 11.0.3373.0. ] Microsoft resolved over thirty five bugs which could be applied to:

  • Microsoft SQL Server 2012 Service Pack 1, when used with:
    • Microsoft SQL Server 2012 Standard
    • Microsoft SQL Server 2012 Web
    • Microsoft SQL Server 2012 Developer
    • Microsoft SQL Server 2012 Enterprise

Here is the list of resolved bugs:

VSTS BUG: 1362028 | 2811842
FIX: Missing parameter panel of a drillthrough report when a top-level report contains hidden parameters or no parameters in SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1363711 | 2833989
FIX: Object ID that is used in memory differs from the object ID on the disk in SQL Server 2012

VSTS BUG: 1356013 | 2837247
FIX: W3WP.exe process stops unexpectedly when multiple merge replication subscribers synchronize at the same time in SQL Server 2008 R2

VSTS BUG: 1277961 | 2846345
FIX: Slow performance when you render a Power View report that uses a SQL Server 2012 SP1 PowerPivot workbook as its data source

VSTS BUG: 1356019 | 2847467
FIX: Poor performance when you run a query that uses the LIKE operator in the WHERE clause in SQL Server 2008 R2

VSTS BUG: 1356021 | 2849351
FIX: Error 3241 when you run RESTORE FILELISTONLY statement in SQL Server 2008 R2

VSTS BUG: 1319759 | 2850282
FIX: Changes in the last two columns are not captured by the CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1319121 | 2850388
FIX: "Index was out of range" error message when you use SSDT to create a perspective in SSAS 2012

VSTS BUG: 1325209 | 2852061
FIX: MDX query excecution takes longer than expected in BIDS or SSDT in SQL Server 2012

VSTS BUG: 1330298 | 2854370
FIX: Cannot update data in a workbook that uses a .bism file to connect to an SSAS instance

VSTS BUG: 1356015 | 2854420
FIX: An UnhandledReportRenderingException error occurs when a report is rendered in Report Manager in SQL Server 2008 R2 Service Pack 2

VSTS BUG: 1332122 | 2855020
FIX: Dates and telephone numbers displayed incorrectly after you export a report to Word in SSRS 2012

VSTS BUG: 1340145 | 2858573
FIX: Non-yielding scheduler error when you run a stored procedure that uses a TVP in SQL Server 2012

VSTS BUG: 1347214 | 2860520
FIX: DateTime value is parsed incorrectly for an SSIS package in SSIS 2012

VSTS BUG: 1352560 | 2861387
FIX: Access violation occurs when a CTE calls a synonym in SQL Server 2012

VSTS BUG: 1317007 | 2862837
FIX: "Add Member" button does not work if the selected entity member has read-only permission in SQL Server 2012

VSTS BUG: 1338633 | 2863144
FIX: Access violation when many users who belong to different roles run queries against a cube at the same time in SSAS 2012

VSTS BUG: 1242784 | 2863192
FIX: You experience poor performance when you validate a large amount of data in SQL Server 2012 MDS

VSTS BUG: 1361005 | 2863256
FIX: Report that contains a multivalue parameter is displayed as a blank page in SSRS 2012

VSTS BUG: 1352669 | 2863728
FIX: Property value and path that contain double quotation marks for a job step of an SSIS package aren’t saved in SQL Server 2012

VSTS BUG: 1263738 | 2863979
FIX: Stored procedures won’t generate on a subscription database when you configure a transactional replication in SQL Server 2012

VSTS BUG: 1375290 | 2866504
FIX: "The specified user DOMAIN\Username could not be found" error when you create SharePoint document library subscriptions in SSRS 2012

VSTS BUG: 1335674 | 2867316
FIX: You cannot restore a SQL Server 2012 database in the Windows Azure BLOB storage service

VSTS BUG: 1226090 | 2869734
FIX: Scheduler deadlock on AlwaysOn Availability Group primary replica in SQL Server 2012 when you perform a database backup on a secondary replica

VSTS BUG: 1352539 | 2869735
FIX: Cannot scroll the horizontal scroll bar to view all the characters of a label for a multivalue parameter in SSRS 2012

VSTS BUG: 1333060 
FIX: CU refresh MSI’s are only dropped for ENU when you create the Windows Azure images.

VSTS BUG: 1333051
FIX: The configuration files that are used by the SQL Image Installer are hard-coded as ENU.

VSTS BUG: 1326849
FIX: The ConfigureImage workflow is not triggered for Windows 2012 images.

VSTS BUG: 1222472 | 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

VSTS BUG: 1356011
FIX: Memory dump may be created when you run a query in SQL Server 2012.

 

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 5

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

  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU5_2861107_11_0_3373_x86
  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU5_2861107_11_0_3373_x86
  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU5_2861107_11_0_3373_x86
  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU5_2861107_11_0_3373_x64
  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU5_2861107_11_0_3373_x64
  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU5_2861107_11_0_3373_x64

Enjoy!

[DE]/[EN] Samstag Schule mit SQL Server? Warum nicht!

Samstag + Deutsch + Schule + SQL Server + Rheinland = SQL Saturday #230.

Aus Facebook Seite gestolen:

sqlsat230_webDer SQLSaturday ist eine kostenlose 1-Tages Konferenz für SQL Server Professionals und alle, die mehr über den Microsoft SQL Server erfahren wollen. Ursprünglich aus den USA kommend, wurden mittlerweile unter der Schirmherrschaft der PASS Global weit über 150 SQLSaturdays auf fast allen Kontinenten veranstaltet. In den verschiedenen, vor allem technischen Tracks, vermitteln Sprecher primär aus der lokalen aber auch aus der internationalen SQL Server Community hochkarätiges Wissen rund um den Microsoft SQL Server. Der PASS Deutschland e.V. übernimmt als ofizielles Chapter der PASS Global, mit weltweit über 100.000 Mitgliedern, die Organisation des Events vollständig mit Freiwilligen aus der deutschen SQL Community. Der kostenlose SQLSaturday ist nicht nur die ideale Gelegenheit sich überden SQL Server 2012 zu informieren, sondern auch um sich mit Kollegen, SQL Professionals, führenden Experten, MCMs und MVPs zu treffen und über spannende Themen zu diskutieren.

Enough? Yes, for many of us is enough. SQL Saturday No 230 in Rheinland (exactly in Sankt Augustin, close to Bonn) will be my last SQL Saturday, before few weeks brake. It will be (in my private calendar) last one in first half of this year, after Exeter, Kiev, Edinburgh, Dublin. And it will be my second SQL Saturday in Germany (after last one un Munich <not exactly in Munich, just forty minutes by train from München Hackerbrücke). Friday (12th July) with three very interesting workshops:
* "A New Method for Effective Database Design"
* "From SQL Traces to Extended Events. The next big switch."
* "Data Analytics & BigData"

After Friday evening about 300 hundred SQL Folks will come to Hochschule Bonn-Rhein-Sieg in Sankt Augustin for full day of free conference, with many local speakers. On Saturday 13th July I expecting session in German provided by: Thomas Strehlow, Christoph Muthmann, Jan Steemann, Johan Bijnens, Constantin Klein, Rafael Dabrowski, Stephan Pepersack, Ruben Pertusa, Andreas Wolter, Dennis Traub, Marcel Franke, Pierre Flammer, Torsten Schüßler, Tillmann Eitelberg, Oliver Engels, Sascha Lorenz, Sascha Dittmann, Gabi Münster, Alexander Karl. Somewhere between German in English session attendees can meet multi-lingual speaker (English, German, Russian, Portugese): Niko Neugebauer. And of course few speakers from non-german language countries, such as: Matija Lah, Hugo Kornelis, Tobiasz Koprowski, Jen Stirrup, Mladen Prajdic, André Kamman, Chris Harris, Neil Hambly, Milos Radivojevic. Five rooms, five tracks from early morning till late afternoon.

Imspeaking230My session will be only a part of community work at this event, I’ve scheduled: pre-event setup, post-event setup, some photo sessions, and maybe popcorn machine (yes I would be good popcorn machine operator). In the meantime of communnity tasks (but on schedule) I will present session on beginners level about Windows Azure SQL Database, Clouds, Plans, Backups and RedGate tool. Another hour of fun for me and (hope) for audience.

Registration are still open, so You can go to: SQL Saturday #230 Page to register, next to Facebook page and use Twitter for be sociable! See You in Rheinland!