Monday, January 16, 2017

Drive: The Surprising Truth About What Motivates Us

In "Drive : The Surprising Truth About What Motivates Us" Daniel Pink, drives home concept of "Motivation 3.0" a new operating system for new jobs that demand creativity and focus.

Parts of Motivation 3.0 are -

1)Autonomy - Freedom to work on problems that inspire us and collaborate with (cross functional)teams.
2)Mastery - Work that helps us get into the "flow".
3)Purpose - How do we identify with what we are doing. Why are we doing what we do?

Succinct and gives ideas to think further. Half of the book covers "Motivation 3.0" toolkit. Ideas and people who have shown that the new approach work.

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.