SSAS Parallel MaxParallel Issues

You may have got very excited when you find out that you can control the number of partitions you can process in your processing process, aren't you? I was at least.

We have lots of cubes and they are very resource intensive so we couldn't afford to do process all of the partitions in every run. We have designed a custom solution to process X number of partitions in the day job and Y number of partitions in the minute/hour job, ofcourse X is bigger than Y which mean we process more partitions in the day job than minute /hour job.

Our SSAS servers are less busy when compared to the SQL server which is the source for our cubes, so when we let the SSAS decide the number of partitions to process in parallel, it is processing way too many partitions in parallel and SQL Server was not able to handle that much load and is failing by the deadlocks of the processing job.

That's when we decided to play with the Parallel MaxParallel setting in the XLMA of the Analysis Server.


Excel Add in Compile Errors and Upgrade Problems/Issues

Six years ago an Excel add in was developed using VSTO 3.0 and excel 2007, thank you Microsoft for giving out such a stable platform for developing solutions for Microsoft Office applications.

Add in worked well with Excel 2007 and 2010, Excel 2013 started giving problems as Microsoft decided not to support MDI in 2013, so we had to compile and make few changes to make it work well with the new SDI of Excel 2013. But the code in version control system is from 6 years and wont compile, so we had to create a new project in Visual Studio 2012 and VSTO 4.0 and add all the files to that. New project is compile and was able to get a working add in.

Old add in was published to a shared location(in production) and the update interval is set for a week. We wanted to push the new add in and overwrite the existing one but as the old one has a published location that is in production we could take the risk of publishing the new one to the old published location and test it out there to see if it …

Excel 2013 Addin problems after upgrade

Did you just upgrade to excel 2013 and realized that your excel addin can be used only in the first instance of the excel. This may be because Microsoft has doesn't support MDI any more in Excel 2013.

You can fix the code and redeploy the add in that will take care of the problems, you can find what is changed in the article below.

If you are busy and don't have time you can try the following work around.
Try running all the instances of excel using "excel /X" which will open all the instances of excel in its own process.

SSRS Compile Errors

Error 3 [rsCompilerErrorInExpression] The Value expression for the textrun ‘Textbox1.Paragraphs[0].TextRuns[0]’ contains an error: [BC30277] Type character '&' does not match declared data type 'Object'.

Error 3 [rsCompilerErrorInExpression] The Value expression for the textrun ‘.Paragraphs[0].TextRuns[0]’ contains an error: [BC30277] Type character '&' does not match declared data type 'Object'.

You can get the above exception if you have a expression of
="Parameter A's : " & Parameters!ParameterA.Label& " value."


="Parameter A's : " & ParameterA.Label
& " value."

In the first expression & is next to parameter label and in the second one & is on the new line and in either case there is no space between the parameter label and &.

You can fix the issue by changing the expression to

="Parameter A's : " & Parameters!ParameterA.Label & " value.…

Free SQL Server Management Studio Addin/Plugin/External Tool to get object information quickly

A small utility written in c# to help get object information in SQL Server Management Studio quickly and easily. It can be used on any version of SQL Server and on any SQL Server databases. You might have been a big fan of Alt-F1 (sp_help) but it has it own restrictions, object has to be in the same database to use Alt-F1 key and get the object information.This utility can help you overcome that limitation along with other features. Please read the entire documentation to configure and use the utility.

Download VAKATI SSMS Helper
Google Drive by default opens in preview mode and shows you all the files, go to File Menu and click download menu item to download as a zip file.
Features Can run outside of current database context.
Can get information on all the valid objects in the selection at once.

Displays output in a different window so your last execution results stays in the results grid.

Can be used using user defined hotkeys(SSMS 2012).

Output in text, so not selectable using column…

Kingston KTD-PE316K4/32G and ASUS M5A97 R2.0 Socket AM3+ ATX AMD Motherboard

The following two products don't go well together, so get only the ram mentioned in the qualified vendor list from asus.

I couldn't understand why it doesn't work even though the motherboard spec clearly says that it can support DDR3 ECC, Non ECC 1600mhz ram modules.

Kingston 32GB DDR3-1600 (PC3-12800) Desktop Memory Kit (Four 8GB Memory Modules) KTD-PE316K4/32G

FeaturesFeaturesFor Dell PowerEdge R620, T620SpecificationMemory TypeDDR3Number of Modules4Memory Capacity32GB (4 x 8GB)Memory SpeedDDR3-1600 (PC3-12800)Error Correction CodeECCMemory Slot240-pin DIMMWhat's in the BoxWhat's in the Box4 x 8GB DDR3 Memory ModulesManufacturer WarrantyParts5 YearsLabor5 Years

ASUS M5A97 R2.0 Socket AM3+ ATX AMD Motherboard


Creative Sound Blaster Audigy2 ZS SB0350 7.1 Channels 24-bit 192KHz PCI Interface Sound Card Windows 7 64 bit NO SOUND

I like my Creative Sound Blaster Audigy2 ZS SB0350 so I took it from my old pc and installed it on a newly built windows 7 64 bit edition pc but there was no sound. I installed the driver properly no exclamations in device manager but no sound.

I uninstalled the device  from the device manager, restarted the pc and got my sound going.

Creative Sound Blaster Audigy2 ZS SB0350 7.1 Channels 24-bit 192KHz PCI Interface Sound Card

Specs from creative/newegg

ModelBrandCreativeSeriesSound Blaster Audigy2 ZSModelSB0350 Audio coreAudio ChipsetAudigy2Channels7.1Sample Rate192KHzDigital Audio24-bitHardware DecodeDolby Digital EX 6.1Polyphony64 Voices (Hardware) PortsLine InYesLine OutYesSPDIF OutYesMIC InYesMIDI/JoystickYesCD/Aux InYesFireWire (IEEE 1394)1 SpecInterfacePCIOperating Systems SupportedWindows 98SE, ME, 2000 SP2, or XPSystem RequirementsProcessor: Genuine Intel Pentium II, Celeron 350MHZ,AMD-K6 450MHz or faster