Syntax for XML query in SQL

by alski 10. September 2009 13:39
Use the following SELECT Doc.value('data((/OrganisationAccountOpeningForm/KYCCustomer/EntryDate)[1])','datetime') or syntactically SELECT <XML Column Name>.value('data((/<XPATH>)[<1-based index into possible values returned>])','... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Code | SQL | Work

Getting things done in OneNote

by alski 8. September 2009 10:49
  Make since that the "show original tagged notes as dimmed" option is set. This then lets you start a new summary page each day that brings forwards any incomplete items.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Work

Remote debugging - 2008 steps

by alski 18. August 2009 12:08
·         Log on to Server as local admin account e.g. User, o   Run Visual Studio remote debugger remotely (Deployed to Dev workstation as part of Visual Studio install, can be installed on server). o   Transport qualif... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Hardware | VisualStudio | Work

Which app pool in which process?

by alski 9. June 2009 13:11
Something I really whould have known. How much time have I spent loading all processes in remote debugger and detaching one by one because they have the wrong dlls loaded. No more. Just run iisapp.vbs to get C:\Documents and Settings\me\Desktop>iisapp.vbs W3WP.exe PID: 781... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Tools | Work

WTF!

by alski 21. May 2009 12:15
I've just seen some of the worst code of my life... fortunately it was from an AutoGenerated application. Lets start with this pValue = Utility.GetParam("issue_id");Response_issue_id.Value = pValue; if(Session["UserID"]!=null) pValue = Session["... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

Code | Work

The joy of (English) snow

by alski 2. February 2009 22:13
Its always amazing how different places handle events outside of the norm. Take today's heavy snow for example. I am sitting on a train travelling over 100 miles through white countryside, leaving huge swirls of displaced snow, and we are on time. As the train tilt's I can see the rails on the line ... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Work | Snow

CheaperTalentHypothesis and offshoring

by alski 15. February 2008 07:39
  Martin Fowler recently published CheaperTalentHypothesis on the cheaper cost of more expensive programmers. I apologise for hacking this down Naturally better programmers cost more, either as full-time hires or in contracting. But the interesting question is, despite this, are more expensiv... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

Work

Deadline de-skilling

by alski 11. October 2007 20:58
This gem is in the comments, 2nd one down. Lesson learned: even Einsteins become Morts when faced with a deadline. From The Greatest Compliment A Developer Can Receive See also http://www.nikhilk.net/Personas.aspx It got me thinking about my current employment. We have the right ingredients for pe... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Work

When Off is actually On

by alski 8. April 2005 20:56
Strange as it seems but “Server encountered an internal error. For more information, turn on customErrors in the server’s .config file.” is actually begging for you to add, <system.runtime.remoting>     <customErrors mode="off"... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Code | DotNet2.0 | Work

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

RecentComments

Comment RSS