Tuesday, November 1, 2016

Failed to initialize the PowerShell host

Got the following message after updating Visual Studio 2013 to Update 5.

Package Installation Error
Could not add all required packages to the project. The following packages failed to install from 'C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Stack 5\Packages':

jQuery.1.10.2 : Failed to initialize the PowerShell host. If your PowerShell execution policy setting is set to AllSigned, open the Package Manager Console to initialize the host first.
Modernizr.2.6.2 : Failed to initialize the PowerShell host. If your PowerShell execution policy setting is set to AllSigned, open the Package Manager Console to initialize the host first.

Fix was to install - following hotfix -

2.8.7 for VS 2013:
https://github.com/NuGet/Home/releases/download/2.8.7/NuGet.Tools.vsix

Or updating the NuGet library again after updating to Update 5. Logically it should be taken care by the update itself, but Microsoft Gods like one to spend some time on the internet.

Monday, October 31, 2016

How to use table types to execute a stored procedure in SSMS?

  1. Stored procedure expects  - table type - @TableType as an input parameter. In case you want to run the stored procedure in SSMS we can do the following -
  2. Find out the table definition of the table type. Best way to find it out is from code which calls the stored procedure.
  3. Define a variable of the TableType.
  4. Insert test values into the table type.
  5. Use the variable in the stored procedure.
  6. Example is as follows -

DECLARE @TableType TableType

INSERT INTO @TableType VALUES ('TEST','TEST')
EXEC [SPName]
  @Otherparameter= N'Test',
  @TableType= @TableType
 
GO

Monday, October 10, 2016

Important X Urgent

Spending time on important things, lets one to get urgent things done in time.

Friday, October 7, 2016

Results

If you continue to do the things you have been doing, you will continue to see the results you have been seeing.

Thursday, August 4, 2016

Notes

It's important to make a note.

It's equally important to revisit the notes in timely fashion and refine them. Refining might result in few newer ones too.

Thursday, July 21, 2016

Naavas/Mannat - 2.0

It's a custom to offer prayer to deity in a certain way when we are faced with challenging situations. It's called नवस in Marathi or मन्नत in Hindi. I think it's one of the positive things one can do to cope up.

Now that times are changing, I think it would be good if we change नवस little bit.

Couple नवस I can think right now are -
  1. Donate blood
  2. Plant/take care of a tree
Would like to think more on more such नवसs.

Thursday, July 14, 2016

काही सुविचार

लक्षराच्या  भाकऱ्या कधीही भाजू नयेत.
एक नकार हजारो विघ्न टाळतो.
ज्या गावी जायच नाही, त्याचा पत्ता विचारू नये.