Sunday, December 15, 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.

Tuesday, September 24, 2013

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."


="Parameter A's : " ParameterA.Label
 & " value." (Notice the SPACE before &)

Saturday, August 31, 2013

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.
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 headers.
Supported Arguments at this time:

(Get the objects similar to selection)

(Get the object info of similar objects in selection)

Configuring the tool:
Tool can be found at here

Extract the zip file from above to a folder where you have access level to execute or better yet to a network folder where your entire team has execute access so that updates can be put in one place and the entire team can benefit from the updates.

This tool is entierly dependent on the external tools support of Sql Server Management Studio, to start configuring open external tools dialog under Tools menu item.

Give a meaningful name in the title for the external tool definition based on the tool and parameters.

Select “CurrentText” argument using the arrow key.

You can specify more than one parameter that is supported( indexes,-columns,-constraints, -startswith,-endswith,-like,-likeinfo,startswithinfo,endswithinfo) separating them with a space

Check the “Use Output Window”

You can define multipe external tool definitions using the Add button and repeating the steps described above.

Click OK to close the external tools dialog and start enjoying the tool, highlight the text you want to get info on and run the utility from the Tools menu item or you can use the hot keys defined to run the utility on the selected text.

Configuring Hot Keys(Only SQL Server Management Studio 2012):

From Tools Options Select “Keyboard”

Search in “Show commands containing” for Tools.ex and select “Tools.External Command1” and assign a hotkey by having focus in “Press shortcut keys” textbox.

Sample outputs:

Outputs can be switched using the drop down “Show output from”.

This is still under development, so expect blowups!.

Next Steps
1.Drive the application using xml file so users can run their own commands(stored procedures) based on arguments.
2.Display output in grid like below.

3.Support for DBA commands.
4.Add more intelligence to get information from invalid sql stetements.

I have used TSqlParser library for parsing
Please read their license before using the tool

Microsoft Public License (Ms-PL)

Microsoft Public License (Ms-PL)

This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.

1. Definitions

The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.

A "contribution" is the original software, or any additions or changes to the software.

A "contributor" is any person that distributes its contribution under this license.

"Licensed patents" are a contributor's patent claims that read directly on its contribution.

2. Grant of Rights

(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.

(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.

3. Conditions and Limitations

(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.

(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.

(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.

(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.

(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

sp_help from msdn website:


SQL Server 2000
12 out of 21 rated this helpful - Rate this topic
Reports information about a database object (any object listed in the sysobjects table), a user-defined data type, or a data type supplied by Microsoft® SQL Server™.
sp_help [ [ @objname = ] name ]
[@objname =] name
Is the name of any object, in sysobjects or any user-defined data type in the systypes table. name is nvarchar(776), with a default of NULL. Database names are not acceptable.
Return Code Values
0 (success) or 1 (failure)
Result Sets
The result sets returned depend on whether name is specified, and when specified, what database object it is.
  1. If sp_help is executed with no arguments, summary information of objects of all types that exist in the current database is returned.
    Column name Data type Description
    Name nvarchar(128) Object name
    Owner nvarchar(128) Object owner
    Object_type nvarchar(31) Object type

  2. If name is a SQL Server data type or user-defined data type, sp_help returns this result set.
    Column name Data type Description
    Type_name nvarchar(128) Data type name.
    Storage_type nvarchar(128) SQL Server type name.
    Length smallint Physical length of the data type (in bytes).
    Prec int Precision (total number of digits).
    Scale int Number of digits to the right of the decimal.
    Nullable varchar(35) Indicates whether NULL values are allowed: Yes or No.
    Default_name nvarchar(128) Name of a default bound to this type. NULL, if no default is bound.
    Rule_name nvarchar(128) Name of a rule bound to this type. NULL, if no default is bound.
    Collation sysname Collation of the data type. NULL for non-character data types.

  3. If name is any database object (other than a data type), sp_help returns this result set, as well as additional result sets based on the type of object specified.
    Column name Data type Description
    Name nvarchar(128) Table name
    Owner nvarchar(128) Table owner
    Type nvarchar(31) Table type
    Created_datetime datetime Date table created

    Depending on the database object specified, sp_help returns additional result sets.
    If name is a system table, user table, or view, sp_help returns these result sets (except the result set describing where the data file is located on a file group is not returned for a view).
    • Additional result set returned on column objects:
      Column name Data type Description
      Column_name nvarchar(128) Column name.
      Type nvarchar(128) Column data type.
      Computed varchar(35) Indicates whether the values in the column are computed: (Yes or No).
      Length int Column length in bytes.
      Prec char(5) Column precision.
      Scale char(5) Column scale.
      Nullable varchar(35) Indicates whether NULL values are allowed in the column: Yes or No.
      TrimTrailingBlanks varchar(35) Trim the trailing blanks (yes or no).
      FixedLenNullInSource varchar(35) For backward compatibility only.
      Collation sysname Collation of the column. NULL for non-character data types.

    • Additional result set returned on identity columns:
      Column name Data type Description
      Identity nvarchar(128) Column name whose data type is declared as identity.
      Seed numeric Starting value for the identity column.
      Increment numeric Increment to use for values in this column.
      Not For Replication int IDENTITY property is not enforced when a replication login, such as sqlrepl, inserts data into the table:
      1 = True
      0 = False

    • Additional result set returned on columns:
      Column name Data type Description
      RowGuidCol sysname Name of the global unique identifier column.

    • Additional result set returned on filegroups:
      Column name Data type Description
      Data_located_on_filegroup nvarchar(128) The filegroup in which the data is located (Primary, Secondary, or Transaction Log).

    • Additional result set returned on index:
      Column name Data type Description
      index_name sysname Index name.
      Index_description varchar(210) Description of the index.
      index_keys nvarchar(2078) Column name(s) on which the index is built.

    • Additional result set returned on constraints:
      Column name Data type Description
      constraint_type nvarchar(146) Type of constraint.
      constraint_name nvarchar(128) Name of the constraint.
      delete_action nvarchar(9) Indicates whether the DELETE action is: No Action, CASCADE, or N/A.(Only applicable to FOREIGN KEY constraints.)
      update_action nvarchar(9) Indicates whether the UPDATE action is: No Action, Cascade, or N/A.(Only applicable to FOREIGN KEY constraints.)
      status_enabled varchar(8) Indicates whether the constraint is enabled: Enabled, Disabled or N/A. (Only applicable to CHECK and FOREIGN KEY constraints.
      status_for_replication varchar(19) Indicates whether the constraint is for replication. (Only applicable to CHECK and FOREIGN KEY constraints.)
      constraint_keys nvarchar(2078) Names of the columns that make up the constraint or, in the case for defaults and rules, the text that defines the default or rule.

    • Additional result set returned on referencing objects:
      Column name Data type Description
      Table is referenced by nvarchar(516) Identifies other database objects that reference the table.

  4. If name is a system stored procedure or an extended stored procedure, sp_help returns this result set.
    Column name Data type Description
    Parameter_name nvarchar(128) Stored procedure parameter name.
    Type nvarchar(128) Data type of the stored procedure parameter.
    Length smallint Maximum physical storage length (in bytes).
    Prec int Precision (total number of digits).
    Scale int Number of digits to the right of the decimal point.
    Param_order smallint Order of the parameter.

The sp_help procedure looks for an object in the current database only.
When name is not specified, sp_help lists object names, owners, and object types for all objects in the current database. sp_helptrigger provides information about triggers.
Execute permissions default to the public role.
A. Return information about all objects
This example lists information about each object in sysobjects.
USE master
EXEC sp_help
B. Return information about a single object
This example displays information about the publishers table.
USE pubs
EXEC sp_help publishers

 sql server 2000 2005 2008 r2 2012 tsql database engine free freeware helper utility sp_help alt-f1 alt f1 addin add-in plugin plug-in porr man software visual studio redgate plugins quest toad model modeler ide The Project Lucy intellisense intelli-sense ssmsboost ssms tools ssmstools ssms boost sql sentry sqllite lite nosql hadoop hive SSMS Tools Pack: The best SQL Server Management Studio Add-In SQL Server Management Studio 2005 and 2008 find interesting and useful Addins Productivity SSMS add-in full featured, free edition It's 100% free, no registration required SSMS Addons  SQL Treeo free add-in ApexSQL Search free Red Gate's SQL Search Add-In

Friday, August 30, 2013

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

FeaturesFor Dell PowerEdge R620, T620
Memory TypeDDR3
Number of Modules4
Memory Capacity32GB (4 x 8GB)
Memory SpeedDDR3-1600 (PC3-12800)
Error Correction CodeECC
Memory Slot240-pin DIMM
What's in the Box
What's in the Box4 x 8GB DDR3 Memory Modules
Manufacturer Warranty
Parts5 Years
Labor5 Years

ASUS M5A97 R2.0 Socket AM3+ ATX AMD Motherboard


FeaturesDual Intelligent Processors - TPU + EPU; Remote GO! - One-stop PC Remote Control and Home Entertainment; USB 3.0 Boost - Faster USB 3.0 Transmission with UASP; Network iControl - Real-time Network Bandwidth Control; DirectKey - A Dedicated Button to Access the BIOS Directly; USB BIOS Flashback - Easy, Worry-free USB BIOS Flashback with Hardware-based Design; UEFI BIOS - Flexible & Easy BIOS Interface; Windows 8 Ready Assured Compatibility
Microsoft CertificationWindows 8 Ready
Overclocking FeaturesASUS C.P.R.(CPU Parameter Recall)
North BridgeAMD 970
BIOS64 Mb Flash ROM, UEFI BIOS, PnP, DMI2.0, WfM2.0, SM BIOS 2.7, ACPI 2.0a, Multi-language BIOS, ASUS EZ Flash 2, F12 PrintScreen, F3 Shortcut Function and ASUS DRAM SPD (Serial Presence Detect) memory information
CPU Supported
Socket TypeAM3+
AMD CPU SupportPhenom II
Athlon II
Sempron 100 series
Maximum Processor Wattage Supported140W
Maximum Memory Supported Per Slot32GB
Memory TypeDDR3
Memory Speeds SupportedDDR3-2100 (O.C.), DDR3-1866, DDR3-1800, DDR3-1600, DDR3-1333, DDR3-1066
Memory Slots4 x 240pin DIMM
Max Memory Supported32GB
Memory Channel SupportDual Channel
Supported Memory TechnologiesECC and non ECC Memory Supported
Storage Controllers
SATA 6Gb/s6
SATA RAID0/1/5/10
Onboard Graphic ChipsetNone
Multi-GPU SupportAMD Quad-GPU CrossFireX
Audio SystemALC887
Audio Channels8-Channel
LAN ChipsetRealtek 8111F
LAN Speed10/100/1000Mbps
Expansion Slots
PCI Express x12
Back Panel Ports
USB 2.06
USB 3.02
LAN RJ-451
Audio Ports6
Digital Audio1 x Optical
Internal I/O
USB3 x USB 2.0 Headers (supports 6 additional USB ports)
1 x USB 3.0 Header (supports 2 additional USB ports)
Other I/OS/PDIF-Out Header
Clearing CMOS Jumper
TPM Module Connector
MemOK! Button
System Panel (Q-Connector)
CPU Fan Connector
3 x Chassis Fan Connector
EATX Power Connector
ATX 12V Power Connector
Front Panel Audio Connector
USB BIOS Flashback Button
DirectKey Button
DRCT Header
ATX Power Connector24-pin
ATX12V / EPS 12V Connector8-pin
Regulatory ApprovalsFCC
ROHS CompliantYes
Physical Specifications
Form FactorATX
Dimensions (WxD)12" x 9" (305mm x 229mm)
What's in the Box
What's in the BoxMotherboard, User's Manual, I/O Shield, 2 x SATA 6Gb/s Cables, Support Discs
Manufacturer Warranty
Parts3 Years
Labor3 Years

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


Sound Blaster Audigy2 ZS

Audio core

Audio Chipset
Sample Rate
Digital Audio
Hardware Decode
Dolby Digital EX 6.1
64 Voices (Hardware)


Line In
Line Out
CD/Aux In
FireWire (IEEE 1394)


Operating Systems Supported
Windows 98SE, ME, 2000 SP2, or XP
System Requirements
Processor: Genuine Intel Pentium II, Celeron 350MHZ,AMD-K6 450MHz or faster
Motherboard: Intel, AMD or 100% compatible
System RAM: 64MB for Windows 98SE and ME, 128MB for Windows 2000 SP2 and XP
Hard Disk: 600MB free space
Operating System: Windows 98SE, ME, 2000 SP2, or XP
Available PCI 2.1 compliant slot
Available adjacent slot for Joystick/MIDI bracket (optional)
Headphones or amplified speakers (available separately)
CD-ROM or DVD-ROM drive required for software installation


Package Contents
Sound Blaster Audigy2 ZS Sound Card
Driver Disk
Audigy 2 ZS Internal I/O Drive

Manufacturer Warranty

1 year limited

Sunday, January 27, 2013

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 mean that we should keep all those 1000's of pictures and never look at them again.

The next question is how will I end up with so many images when I could only import the pictures I want using my camera software. In an ideal world you would have time to pick the pictures you want right from the camera, but sometimes you are in a rush to dump all the pictures to a folder and freeup some space on the camera for your next creative photo shooting. Also not to mention that some of the camera softwares to import pictures doesn't support the sizing of thumbnails in the view and other features that you would like.

Thumbnail generation is done using and the the credit goes to them.
For license see

Installer will be published soon.

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.

V 1.0

Keywords :
Freeware free software computer desktop laptop dups dupe dup folders duplicate same files same folders size attributes hidden system tool finder search find locate program opensource source cheap reliable stable not files vakati prashanth windows xp .net windows vista windows 7 pro home professional clean disk space usage low remove duplicate files and folders,easily easy to find duplicate folder, tool to identify/manage duplicates at the directory level, a small Windows utility to find duplicate files and folders, and helps delete them pictures images music videos word pdf excel office documents, Duplicate files/folders detecting software, hard drives,duplicate search tool,System and disk software,file management, file utilities,Duplicate File Finder, Duplicate Image Finder,Folder sizes,Free, Fast and easy tool for removing duplicate folders

Sunday, January 20, 2013

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 opened the adventure works database warehouse project, VS says that it is not a valid project.Tried to get myself a copy of  SQL Server Data Tools on the web with no luck.I thought that problem is with OS so I figured out this I will go Pro or higher version of OS to solve the problem.

Installed Windows 8 Enterprise and repeated the order of installation same as windows 7 mentioned above and ended up with same errors(tired by now, to download and install OS'es,hundreds of updates...etc).Same error with Visual Studio Shell.

I didnt want to give up, so wiped the entire hard drive(3rd time) and started with Windows 7 Enterprise and followed the order below and I am all up and running(aaah!...).

Windows 7 Enterprise(& 143 Updates)
Visual Studio 2010 Premium
Visual Studio 2012 Premium
Visual Studio SP1
Windows 7 SP1(SQL Sever 2012 SP1 & SSDT Needs Win 7 Sp1)
Sql Server Data Tools 2010 & 2012
SQL Server 2012 with SP1

Good Luck Folks!, what a pain.

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'

IIS Manager Crashes on Load/Start Windows 7, IIS 7.5

IIS Manager Crashes on Start  Windows 7, IIS 7.5, Power Shell 5.1. Here is the error I got in the event viewer. IISMANAGER_CRASH IIS Ma...