Google Wave explained in the style of Pulp Fiction
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
Technology
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, Transactional SQL
WikiMedia Spam – Lock Media Wiki Permissions down
Using Media Wiki (wikiMedia) somewhere online to manage content? chance’s are you’ve had unwelcome guests spamming you to high heavens. By default permissions on wiki media are, well wiki-level, they provide access to everyone – that’s the point of wiki right? But if you want a private wiki (Media Wiki suggests itself that its not […]
Also posted in Web Development, Wiki Media
iPhone HomeScreen’s, Spotify, Evernote and the iphone
Thought I would randomly dump a few iphone screenshots I have just found on my 3gs (too many people have iphones – I am not one of these fanboys :/) – If you didn’t know you can take a screenshot at any point with an iphone by pressing the home key and the lock key […]
SSRS Every Forth Page? – Shortest Code
On looking for the quickest way to spit something out on every forth page of an SSRS report I wrote this – anyone got a yet further abreviated way to set visibility on every forth page? =iif(((Globals.PageNumber+1) Mod 4) = 0, False, True)
SSRS 08 Reports Strait from URL
Looking to get SQL Server Reporting Services 08 reports to people easily? sometimes its simpler to just give them an url, which you can do and works well. If you take the following and replace SERVERHOST, REPORT LOCATION/NAME,PARAMNAME and PARAMVALUE with your SSRS report details you can literally hand it out irrelevant of session, location […]
Also posted in SSRS
TED Talks that inspire – My Pick
My most recent favourite on TED.com is this talk by behavioral economist Dan Ariely, is a funny one. Alex Tabarrok on how “ideas trump crisis” Adam Savage’s Talk on his obsessions in life All worth a watch, if you get a spare chance check out TED.com, you can see my profile where I will try […]
Also posted in Ideas
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, Transactional SQL
The New Blog
A Quote..
"The way I am and the way I write are a unity. All my ideas and all my endeavours are myself. Thus, the autobiography is merely the dot on the i."
C.G.Jung
Blogroll
Archives
Old Random Projects