Tag Archives: sproc

Eleven Coldfusion-ish tips from the field

Posted on 02/20/2011 by Eric Fickes

I’ve had this running list of Coldfusion tips on my wall for the last few years and it’s time to get these online.  All of the items in this list came from Coldfusion projects over the last few years, but … Continue reading →

Posted in adobe, coldfusion, database, tips and tricks | Tagged , , , , , , , , , , , , , , | 10 Comments

Today I took 30 minutes to save hours

Posted on 01/03/2011 by Eric Fickes

UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading →

Posted in database, development, SQL, tips and tricks | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

How to TWEET from a SQL CLR Stored Procedure

Posted on 03/03/2010 by Eric Fickes

Here’s another SQL Server 2005 geek out moment, a CLR SPROC that tweets to Twitter. Big shoutout to Danny Battison for sharing the C# code to post to Twitter. This is what got me started on the C# side of … Continue reading →

Posted in .net, C#, database, microsoft, SQL, tips and tricks, tsql, twitter | Tagged , , , , , , , , , , | 12 Comments

I built a calendar in a tSQL SPROC

Posted on 10/06/2008 by Eric Fickes

Here’s a blast from the past that I recently found in my archives. It’s a novelty stored procedure I wrote during my MS SQL 2000 DBA days. Back when I wrote this sproc, I was really big into writing calendar … Continue reading →

Posted in SQL | Tagged , , , , , , | Leave a comment