January 2010 - Posts

• Invitation to startup meeting for PASS Scania

  PASS Scania is a new PASS chapter in Sweden which will promote the interest, networking and knowledge for professional SQL Server-users such as developers, DBA's and BI-specialist in Skåne. The Chapter also has a business alliance with an existing usergroup Read More... Posted Wednesday, January 27, 2010 10:43 AM by Peso | 0 Comments Filed under: Miscellaneous, PASS

• Convert binary value to string value

  With SQL Server 2008, we can easily use DECLARE @bin VARBINARY ( MAX ) SET @bin = 0x5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8 SELECT CONVERT ( VARCHAR ( MAX ), @bin , 2 ) But how can we do this in SQL Server 2005? You can't use a simple CAST or CONVERT, Read More... Posted Wednesday, January 27, 2010 10:41 AM by Peso | 6 Comments Filed under: Algorithm, SQL Server 2008, SQL Server 2005