Welcome to Michaels Blog

All posts published in August 2004

Blog of latest news, updates, and stories for developers

Create a copy of an existing SQL Server database

I was searching for an easy way to create a copy of an existing live database and put it on the same SQL Server in a test database. Because I didn't find a good stored procedure I build my own SQL. To use it I put the code to the master database as a stored procedure, now I can run one short command to get a copy!

Posted by Michael Schwarz on Thursday, August 26, 2004

Windows XP Service Pack 2 Security Problems

I read on the heise c't magazine security list some security issues with the Service Pack 2 for Windows XP. The article talks about the zone identifier in the NTFS file. If you download a file from the internet the file will be marked with a ZoneIdentifier in a NTFS stream. This stream will be used to decide to show a warning dialog. The warning dialog will allow you to decide wether you want to start this file or not.

Posted by Michael Schwarz on Wednesday, August 18, 2004

Check you Internet Explorer (Win XP SP2) Settings

On this german website you can run several test for the new security settings:

Posted by Michael Schwarz on Tuesday, August 17, 2004