[EN] SQL Server 2012 Cumulative Update 5 is available

LOGO__SQLServer2012Xmass gift from Microsoft for DBA this year has been delivered in three parts. First part is for newest child, for SQL Server 2012.

In this Cumulative Update 5 [version build: 11.0.2395.0] Microsoft resolved a lot of requested issues which can be applies to:

  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express
  • SQL Server 2012 Enterprise Core

Here is the list of fixed bugs:

VSTS BUG: 919032 | 2509302
FIX: A database transaction log continues to grow after you upgrade to SQL Server 2008 SP2 or SQL Server 2008 SP3

VSTS BUG: 1133944 | 2674636
FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2

VSTS BUG: 1133923 | 2696161
FIX: Error message when you try to view a report in SSRS 2008 R2 or in SSRS 2008: "Different query parameters resulted in a same hash"

VSTS BUG: 1061517 | 2715512
FIX: Error messages when you use dtexec to execute packages in SQL Server 2008 Integration Services

VSTS BUG: 1080477 | 2739213
FIX: Error message when you render an SSRS report that uses the rc:Toolbar=false parameter in the URL: "An error occurred within the report server database"

VSTS BUG: 1090566 | 2742131
FIX: "0xe0434f4d" exception and "0xC001000A" error message when you create a maintenance plan on an MSX server

VSTS BUG: 1080460 | 2749560
FIX: "SQL Server Assertion: File: , line= Failed Assertion = ‘src’" error message when you update BLOB data in SQL Server 2008 R2

VSTS BUG: 1080463 | 2749913
FIX: Unhandled exception when you use a marked transaction that spans multiple databases in SQL Server 2008 R2

VSTS BUG: 1080487 | 2752432
FIX: High CPU usage when you query a binary large object column by using the NOLOCK hint in SQL Server 2008 R2

VSTS BUGS: 1080466, 1124525 | 2754301
FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2

VSTS BUG: 1080469 | 2754800
FIX: Error 17066 when you replicate a table article that contains an ntext data type column in SQL Server 2008 R2

VSTS BUG: 1080489 | 2755767
FIX: A transaction log restore operation takes longer than expected and a 3402 error occurs if a database file is removed in SQL Server 2008 R2

VSTS BUG: 1133928 | 2756471
FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008

VSTS BUG: 1080475 | 2757356
FIX: "The component is waiting for a notification" error message and SSIS 2008 R2 package stops responding when you use Microsoft Connector 1.1 for SAP BI to extract data from SAP BW

VSTS BUG: 1088696 | 2761400
FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2

VSTS BUG: 1080457 | 2761600
FIX: Text is truncated in a Tablix control in an SSRS 2008 R2 report after you export the report as a PDF or image file

VSTS BUG: 1133940 | 2761934
FIX: Support for the varchar(max), nvarchar(max), and varbinary(max) data types is added in most OLE DB providers in SQL Server 2008

VSTS BUG: 1080491 | 2762102
FIX: Incorrect result when you run an MDX query that has an Aggregate function in SSAS 2008 R2

VSTS BUG: 1064356 | 2764343
FIX: The DateTime parameter is not displayed by using the regional setting format of a SharePoint website in SSRS 2012

VSTS BUG: 1072035 | 2767183
FIX: Installation failure when you try to install SQL Server 2012 Remote Blob Store for an additional database on the same instance of SQL Server by using the command line

VSTS BUG: 1075658 | 2769594
FIX: SQL Server 2012 experiences out-of-memory errors

VSTS BUG: 1076187 |2769673
FIX: Data type length is doubled in a generated script when you use the SQL Server 2012 Change Data Capture Service for Oracle by Attunity

VSTS BUG: 1089258 |2776947
FIX: Incorrect result in a calculated column when the column contains an expression that resembles "ISBLANK(RELATED())" in SSAS 2012

VSTS BUG: 1092506 |2777097
FIX: Defined measure groups for a perspective are missing after you save or deploy the perspective in Visual Studio

VSTS BUG: 1133953 |2778088
FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008

VSTS BUG: 1114158 |2778200
FIX: A hotfix is available that improves performance for an MDX query that uses "NON EMPTY" operation together with overlapping calculations in SQL Server 2012 Analysis Services

VSTS BUG: 1088517 |2779898
FIX: Error messages when you impersonate another user and run an MDX query in SSAS 2012

VSTS BUG: 1062516 |2785699
FIX: Error message when you view SharePoint integrated data-driven subscriptions after you upgrade to SSRS 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, 64-bit). This release is prepared as multilingual package.

[EN] A Review: SharePoint 2013 Developer Machine

I’m hungry. Not angry, just hungry. Why? I finished new book by Sahil Malik and Srini Sistla (is a book or not a book? Later). Last sentence:

From here, you can either take the IT pro route, the developer route, or the SharePoint designer route. But before we dive into any of those, let’s get some basic familiarization with, well – what the hell is using SharePoint like? In other words, let’s examine some of interesting SharePoint features, at least as far as the end user is concerned

Where the hell is next part? SharePoint 2013 Developer Machine is a Kindle book, not very big (just 81 pages) but very, very important for all SharePoint freaks. It’s does not matter: either You are newbie, admin, developer, expert – You not only should, but You must have knowledge about Developer Machine (in fact You must have The Machine) – especially for SharePoint (2010 or 2013).

BOOKLET__WS_SharePoint2013DevelopmentMachineFor less than 7 dollars You get chapters:

· Introduction and Credits,

· Virtualization Choice

· Local Development Environment

· Preparing A Single Machine Setup

· Setting Up Office Web Apps

· Installing Office Web Apps Server

· Summary

readable on any Kindle devices – in fact I have no one (all my Kindles are Kinndle App).

 

Is a book or not a book? Is a part of bigger project, 80 pages oriented for most important part for any SharePoint Administrators: The Development Environment. I still remember many of problems with my first SharePoint Production Environment without Development part (Yes, It sounds weird). Now the world has changed. We have…

Virtualization Choice – which is too productive to ignore. Now on one physical laptop, or servers or servers with storage, or network storage – in many ways we can use virtualization: VirtualBox, Boot to VHD, VMWare, Hyper-V, and The Cloud. Of course Physical Site Development Machine sound really good, but… You can’t get it with You, and You can’t work with them with Your favourite music (even is Rammstein, Gershwin, Karsh Kale or DJ Cheb I Sabbah). When You choose right option You should focus to…

Development Choice – depends of our business (and skills) You can use web browser, command line, SharePoint Designer and Visual Studio to developing Your solutions. As always different methods give You similar or different results, but You should know as much as possible about…

possibility of choosing right machine. First – You should think about disk: better SDD than SATA, memory: better 12GB than 8GB (but not always) and processor: better newest than older. Second – You should thing about performance: like mSATA SSD and speed: like single file and security: like RAID. Third – remember about anemia. And not fight with that: “Your Anemic Domain Controller with 20GB HDD and 768 K RAM” is enough.

Prerequisities is a huge list: Windows Server 2008 R2 x64, SQL Server 2008 R2 x64, plus service packs, plus cumulative updates, plus security updates and before SharePoint 2013 x64: ,BET Framework 4.5, IIS Role, Application Role, WCF 5.0, MSIPC, PowerShell, AppFabric, WIF, Azure, Excel, MDS, RBS, Office, Silverlight, popular browsers. And when You collect everything You can…

Prepare Single Machine Setup where You spend one day. With many advices from Sahil Malik You will do it quick, but remember about documenting Your environment from the beginning. Which advices? dcpromo, fqdn, dns, designer, sql server instance features and shared features, preparation tool, port 40000, web server extension 15 and many, many more. For SharePoint 2010 Installation and configuration was enough. For SharePoint 2013 we have something special called…

Office Web Apps which is something new, something interesting, something administrator’s time consuming, something users experience improving (hope You’ll understanding me). In this part You can learn how install second machine, office web apps, prerequisites and (!!!) PowerShell. Questions? Get-Help. After that, after meeting WOPI, after SSL with FQDN and simple configuration

You will be hungry. Like me.

 

Product Details

  • File Size: 1767 KB
  • Print Length: 81 pages
  • Publisher: Winsmarts, LLC (October 27, 2012)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B009Y4QZT8
  • Text-to-Speech: Enabled
  • X-Ray: Not Enabled
  • LINK to AMAZON

PS: MUST HAVE

[PL] WeTransfer, gdyby ktoś go jeszcze nie znał

Wprawdzie w dobie dzisiejszych wirtualnych katalogów, jakie oferowane są przez SkyDrive, DropBox, Amazona, Novella i innych dostawców przechowywanie danych w sieci i ich udostępnianie nie jest kłopotem, ale… często zapominamy o skasowaniu danych z udostepnionego katalogu. Efektem jest ciągłe ich przyrastanie. Od dwóch, może trzech lat korzystam z funkcjonalności jaką daje portal WeTransfer.com. Pozwala on na bezkosztowe (poza łaczem i czasem procesora) przesyłanie danych o łącznej maksymalnej wielkości w jednej przesyłce, nie przekraczającej dwóch gigabajtów. A co najważniejsze trzyma on owe dane tylko przed dwa tygodnie.

  

Rys.1&2 | Bez opłat, podając mail nadawcy, odiorcy, treść wiadomosci oraz w prosty sposób wybierając pliki do przesłania dostajemy całkiem fajne narzędzie.

 

Rys.3&4 | Ponieważ całość idzie po HTTP, więc potrzebujemy trochę czasu na wysłanie (oraz odebranie pliku) ale można to śmiało zrobić w odpowiadających nam godzinach. Po wysłaniu dostajemy powiadomienie mailem.

 

Rys.5&6 | Na końcu w mailu mamy specjalnie spreparowaną wiadomość ze szczegółami przesyłki (mamy nawet opcje pobrania pliku dla siebie, jeśli akurat korzystamy z innego komputera i chcemy mieć kopię lokalną), zaś adresat dostaje również spreparowaną wiadomość z bezpośrednim linkiem do pobrania.