Moved to: WoodyHayday.com
Woody Hayday

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

MySQL datetime examples – first/last day of the year – dates and unix-times

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 […]

Also posted in Snippets, SQL Server, Web Development, Web Technology Tagged , , , , , , , ,

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
WoodyHayday.com
A Quote..
"Where is the justice of political power if it executes the murderer and jails the plunderer, and then itself marches upon neighboring lands, killing thousands and pillaging the very hills"
Khalil Gibran
Old Random Projects
    © Woody Hayday 2008-2024