A backup solution

I 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.
Advertisements

Split delimited string with XML in SQL Server 2005/8

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:
http://www.sqlservercentral.com/articles/XML/66932/
 
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


A tip about HTML editor of Visual Studio or should be a default behavior?

From this link: Tip#66: Did you know… how to insert quotes values automatically while typing the attrib values?
 
http://blogs.msdn.com/webdevelopertips/archive/2009/05/29/tip-66-did-you-know-how-to-insert-quotes-values-automatically-while-typing-the-attrib-values.aspx
 
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.