Posted: June 26, 2009 Filed under: My IT tools
The free version for home use works pretty good and it helps a lot for us as IT helpers in various situations.
If you want more powerful feature of the software, you can always go with the commecial licence with the pro version (server/online).
Give it a try. Go CrashPlan.
Posted: June 25, 2009 Filed under: SQL Server 2005
Here is a nice sample for how to split a delimited string in a column in SQL Server table. Here is the link to the article at SQLServerCentral byDivya Agrawal:
A sample of the code in use:
DECLARE @t TABLE( ID INT IDENTITY, data VARCHAR(50))
INSERT INTO @t(data) SELECT ‘AA,AS,AC,AD’
INTO @t(data) SELECT ‘BA,BB,BC’
@t1 TABLE( ID INT IDENTITY, data VARCHAR(50))
INTO @t1(data) SELECT ‘AA’
INTO @t1(data) SELECT ‘AB’
INTO @t1(data) SELECT ‘BB’
* FROM @t1 a INNER JOIN (
select *, cast(‘<X>’+replace(F.data,‘,’,‘</X><X>’)+‘</X>’ as XML) as xmlfilter
@t F )F1
fdata.D.value(‘.’,‘varchar(50)’) as splitdata
f1.xmlfilter.nodes(‘X’) as fdata(D)) O
Posted: June 9, 2009 Filed under: SQL Server
Here is a working example by George Mastros posted on lessthandot.com:
Posted: June 1, 2009 Filed under: ASP.NET
From this link: Tip#66: Did you know… how to insert quotes values automatically while typing the attrib values?
To set this option select Tools->Options. Check Show all settings. From the left pane select Text Editor -> HTML -> Format and check the insert attribute value quotes when typing checkbox.