A backup solution
Posted: June 26, 2009 Filed under: My IT tools Leave a commentI have tried different backup solutions but I like the one from CrashPlan (http://www11.crashplan.com/consumer/features.html).
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.
Split delimited string with XML in SQL Server 2005/8
Posted: June 25, 2009 Filed under: SQL Server 2005 Leave a commentHere 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’
INSERT
INTO @t(data) SELECT ‘BA,BB,BC’
DECLARE
@t1 TABLE( ID INT IDENTITY, data VARCHAR(50))
INSERT
INTO @t1(data) SELECT ‘AA’
INSERT
INTO @t1(data) SELECT ‘AB’
INSERT
INTO @t1(data) SELECT ‘BB’
SELECT
* FROM @t1 a INNER JOIN (
select
F1.id,F1.data,O.splitdata from
(
select *, cast(‘<X>’+replace(F.data,‘,’,‘</X><X>’)+‘</X>’ as XML) as xmlfilter
from
@t F )F1
cross
apply
(
select
fdata.D.value(‘.’,‘varchar(50)’) as splitdata
from
f1.xmlfilter.nodes(‘X’) as fdata(D)) O
)
b
on
a.data=b.splitdata
A working solution with City and ZIP code search in US
Posted: June 9, 2009 Filed under: SQL Server Leave a commentHere is a working example by George Mastros posted on lessthandot.com:
A tip about HTML editor of Visual Studio or should be a default behavior?
Posted: June 1, 2009 Filed under: ASP.NET Leave a commentFrom 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.
Jingyang Li 