So the other day I was working on a T-SQL query that I was using to take data from generic data types and insert it into a strongly typed table. One of the columns was moving from an nvarchar(255) to an decimal data type. As some of the rows had character data in it, I [...]
Being that I have been involved in a project since the first of the year that pretty much drained me week-to-week, I sadly wasn’t able to keep up with my blog. However now that I’ve moved onto to a new project I plan on getting back to posting blogs again. I continue to be very [...]
Don’t you just love alliteration? I’ve now dealt with few migrations from SQL 2000 to SQL 2005; SQL 2005 to SQL 2008 and SQL 2000 to SQL 2008. However there still seems to be a lot of confusion around what is supported on which version and whether something is deprecated, depreciated or discontinued. So first [...]