Monthly Archives: November 2009

OCAU Hacked! Whirlpool Hacked(?)

Another day, yet another vBulletin break-in. Making off with potentially thousands of passwords… this time it’s Overclockers Australia forum.

Possible Security Issue (ya think?)

Just got this via email…

We’re still investigating what happened.  However, it is very likely that your OCAU password has been compromised.  Therefore please change your OCAU password as soon as possible.

Also, if you use the same password elsewhere, you should probably change those as well.  However, please be aware that using the same password on multiple services is a bad idea.

While there probably isn’t anything lower you can do than to hack a community forum, hopefully the fact that vBulletin now store passwords MD5′d and Hashed will add a level of security to prevent a stolen User table being brute-forced easily.

Still, it’s a timely reminder to only give out access to those you trust, and if possible, lock down database access to only a handful of site engineers & developers.

UPDATE:

Holy shit! Looks like Whirlpool was hit too.

*craps pants*

*cries*

LinkedInDiggRedditTumblrGoogle GmailPrintFriendlyEmailShare

Scripting data in SQL 2008 Enterprise Manager

Did you know this incredibly useful feature now comes with SQL 2008′s Enterprise Manager? I haven’t tested it with multiple tables that have complex relationships, but if you want to script data with more complexity, you should consider Red Gate’s SQL Data Compare.

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard

If neither is feasible, one of the most popular, creative and often-overlooked options is to use Microsoft Excel and write a formula to generate INSERT statements. Drag the cell corner to copy this formula for multiple rows. There are also many other code generation possibilities from this technique if you think creatively.

SQL Queries from Excel

Scripting SQL data is easy to do, make it part of your build process! Stick it in SVN and you bring version control to your database development.

LinkedInDiggRedditTumblrGoogle GmailPrintFriendlyEmailShare

Switch to our mobile site