Siusic Dot Com

I was asked to write a SQL server job to restore nightly a database running on a server onto another server. The database on the original

server was backed-up nightly by a database maintenance plan. So the job I was going to write was to find the latest backup on the original server, copy it […]

Different database system has different level of control on the truncate statement.
In Sybase you can grant the truncate

privilege to user. In SQL or Oracle database you can not do that. In Oracle in order to truncate a table you have to have the right to drop any table which is not good in […]

I was doing some experiment on my own to try to format an XML file into HTML

result using an XSL style sheet and I encountered the case where I needed to test whether the first 10 characters of a variable is numbers. I didn’t know how to do that and did some research. […]

Yahoo reported that the SANS institue found automate hacking tool that use Google’s search engine to look for vulnerable application and hack to the web sites automatically.
Up to 20,000 Web sites have been hacked since January…
The SANS Institute found a sneaky software tool that uses Google’s search engine to hunt for Web sites running […]

If you already know HTML very well then it is going to be very easy. I think a lot of people especially starter bloggers don’t know how to link a video from YouTube on their own blog. So I did a post to explain it. Basically you can copy the following code and past it […]