Category Archives: Transactional SQL

Google BigQuery and Predictions API – Swap data for processing time?

By Woody | August 10, 2010

Something led me to happen across the following video from google I/O 2010 which gives a full expo (57 minutes) on their BigQuery and Prediction API’s. You can see they have made a lot of ground with ridiculous processing, claiming to be able to run SQL queries (or a derivative) on trillion’s of rows in [...]

Also posted in Business Intelligence, Technology, Web Technology | Leave a comment

Multiple WordPress blogs from 1 instance / 1 wordpress folder to maintain

By Woody | January 23, 2010

WordPress is a victim of its own success, but its no victim. It is huge. Millions upon millions of people use wordpress to power their blogs (like this one for example) to make money and to have their voice present on the internet. It has become a first stop for a huge host of people [...]

Also posted in Affiliate Marketing, PHP, Web Development, Web Technology, Wordpress | 2 Comments

ReSeed Identity column – TSQL

By Woody | November 9, 2009

Randomly I didn’t remember the code to reseed the identity column in tsql, this works though on ms sql 2008 – DBCC CHECKIDENT (tbl_crazyTableName, RESEED, 20000) TSQL

Also posted in SQL Server | Leave a comment