Showing posts from 2013

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

V Image Mover - Copy/Move Images Making Easy

The first thing you might ask every time you see a software is "what is the need for it?".There are 100's if not 1000's of free softwares out there on the web for image organizing and browsing, how is this software different from them?.

I have personally used many of the free image viewers like Infranview, Slowview, Xnview,FastStone and many more.These softwares do lot more things than "V Image Mover" and provides several ways to move/copy your images from source to destination. However some of them are not quick while others are not very intuitive. So V Image Mover came to life and is solely targetted for moving/copying images.

Photography has been changed drastically in the last decade, with today's camera's and mobile devices you can take 10's if not 100's of pictures per minute. So there is lot of burden on us to selectively pick pictures that we like and keep them for our memories. Space is getting much cheaper every day, it doesn't…

Duplicate Folders Freeware - Not Duplicate Files

Update: 1/27/2013

I have got a very good response and feedback for the tool, I am working on the new version of it and soon will be releasing it out. Mean while here is how 1.3 looks.

Published On 8/10/2010

Locate duplicate folders with this tool.

V Folder Dups is a small, simple, easy to use application, specially designed to help you located the duplicate folders on your computer and keep your disk duplicate free.

Using this tool is as easy as can be: you just have to select the folder to scan, and you're good to go. So, if you were looking for a program to help you locate duplicate folders with just a click, then take V Folder Dups for a spin and see if its capabilities are enough to satisfy your needs.

It uses folder contents to determine duplicates instead of folder names.

Here is the link to download it.

V1.2 V 1.0

Keywords :
Freeware free software computer desktop laptop dups dupe dup folders duplicate sa…

Remote Desktop "Credentials Did Not Work"

I know that my username and password are right when connecting to a pc using remote desktop connection, but always giving me error about the credentials.After playing around for hours and hours I found that the user name I am entering is not the user name that Remote Desktop Connection.

When I installed the operating system I have created a user name "tester" and then renamed it to "debugger". I opened control panel and cheked the profile and it seems like it kept "tester" instead of debugger, but Remote Desktop Connection was expecting me to type "tester" which is weird. User in the control panel and in the login screen were showing as "debugger".

SQL Server 2012 sp1 and Visual Studio 2012 Installation Errors

It literally took me 2 days not 8 hour days 14 hour days to make everything work right.

I started with Windows Home Premium(which I shouldn't have) and SQL Server 2012 with SP1(note that VS Studio Express was there on the pc).I didn't go any where as I need Windows 7 sp1 and I couldn't install it on my pc successfully(TRUST_E_NOSIGNATURE(0X800B0100), searched through web and found out that re-install was my only option).

I have decided to re-install win 7 home premium and got the sp1 going on, then I started with SQL Server 2012 with SP1 Dev Edition.After about 20% in the installation process I got an error about Visual Studio 2010 shell(along these lines This installation package could not be opened).I continued with the error and installation completed with errors syaing that Sql Server Data Tools installation is failed. Then installed Visual Studio 2012 Premium, everything seems to went fine.

I was able to start the SQL Server instance and connect to it, but when I open…

Error 87 Paramater is invalid using runas

Some times you might have to impersonate a user when launching visual studio, to automate this process we can create a batch file with runas and /savecred.

When doing that you might encounter a error 87 parameter is invalid, to avoid this make sure you put the user name with domain like 'Test\User1'