For some reason I had an abstract memory of SQL SERVER 2000, timestamps and pain. Who knows why. Perhaps its a faulty memory. lol. Anyhow working with timestamps in MySQL/MSSQL these days is nothing short of simple. With MySQL Workbench free its ridiculous how far the barrier of entry for database design has come, its […]
Fresh Ideas
Hi there! This is my old blog, I don't hang around here much.
You can now find me trying to mix things up here:
Visit WoodyHayday.com Subscribe To My Email List
Transactional SQL
From SQL Server 2008 r2 to SQL Compact Edition. Doing things the wrong way.
Program written using csharp and SQL Server 2008 r2? Great eh? … What about your users? …Doh. Anyway its good to re look at your data layer, so if this crops up and you need to switch to a more portable solution (Compact edition means anyone can use it on windows) then put in the […]
Also posted in Snippets, SQL Server
Google BigQuery and Predictions API – Swap data for processing time?
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
Multiple WordPress blogs from 1 instance / 1 wordpress folder to maintain
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
ReSeed Identity column – TSQL
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
xp_fileexist Network Drive – T SQL Based File checking
If you didn’t already know you can check whether files exist, find file sizes and all sorts of other useful things directly from within Transactional SQL Query. In this example I had a table containing a few columns that gave me the network drive location and filename of a few thousand files and I wanted […]
Also posted in Social Media, SQL Server
The New Blog
A Quote..
"I'm only good at being young"
John Mayer
Blogroll
Archives
Old Random Projects