January 2011 - Posts

• My wife has left me . . .

  Posted Monday, January 31, 2011 3:00 AM | 6 Comments
  
  

  LiveJournal Tags: Leaving,Colleagues She announced it before Christmas, in a letter, giving the exact day she intended to leave and what she had planned for her future. We met 8 years ago. We were looking for a data administrator for a CRM system Read More by fatherjack | 6 Comments | Comment on this post Filed Under: Colleagues

• Where did I hide my TSQL mojo?

  Posted Monday, January 24, 2011 3:00 AM | 3 Comments
  
  

  LiveJournal Tags: How To,SQL Server,Tips and Tricks,TSQL,Reporting Services A little while ago I wrote a piece about finding database objects that rely on other objects that no longer exist - OK, I have my database ready, now what's missing? . This is Read More by fatherjack | 3 Comments | Comment on this post Filed Under: How To, Tips and Tricks

• Resolving IIS7 HTTP Error 500.19 - Internal Server Error

  Posted Monday, January 17, 2011 3:00 AM | 1 Comments
  
  

  LiveJournal Tags: RedGate Tools,SQL Server,Tips and Tricks How To The requested page cannot be accessed because the related configuration data for the page is invalid. As part of my work recently I was moving SQL Monitor from the bespoke XSP web server Read More by fatherjack | 1 Comments | Comment on this post Filed Under: Tips and Tricks, RedGate Tools

• One eye on my dinner and one eye on SQL server

  Posted Monday, January 10, 2011 9:40 PM | 4 Comments
  
  

  LiveJournal Tags: RedGate,Work Life Balance,Tips and Tricks,SQL Server This is somewhere between a Tweet and a proper blog article - would that be a Bleet? Anyway, I was at a local restaurant yesterday and after placing my order I was thinking about Read More by fatherjack | 4 Comments | Comment on this post Filed Under: keeping up, Tips and Tricks, RedGate Tools

• Getting the right results with bcp and DTS with multiple versions of SQL Server installed.

  Posted Tuesday, January 04, 2011 3:00 AM | 0 Comments
  
  

  I was using SSIS for the first time on an instance the other day and came across this error when I executed a package Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version Read More by fatherjack | 0 Comments | Comment on this post Filed Under: How To, Tips and Tricks