Last Updated: 11/14/2014 04:21:27 PM

Coldfusion, SQL & Powershell

Some helpful database scripts, tips and info to get you through the day, without any Epic FAILS.

December 7, 2011
How to use showerror with cfabort in CFScript
How to use showerror with cfabort in CFScript

With CFabort you display a custom error message when the page aborts this way: <cfabort showerror="My Fail Whale message"> But how do you do it in cfscript?

 

Read More
October 12, 2011
Why you should drink the Github Kool-Aid
Why you should drink the Github Kool-Aid

 

At Adobe Max 2011, Scott Stroz & Dave Ferguson asked to have me on their show CFHour, to speak about GitHub.  Scott said that while he loves Git specifically, he hasn't drank the Kool-Aid on why GitHub is the best thing since a Vulcan Jedi  Ninja.  I am not sure why they asked me to be the person to speak on the topic.  I don’t proclaim to be a Git or GitHub expert.  I am a vocal advocate about the two, so maybe that is enough.

Below I list the reasons why I think GitHub is the mutt’s nuts.  What would you add? What would change?

Read More
September 15, 2011
Embedding a SWF in a PDF with ColdFusion and iText
Embedding a SWF in a PDF with ColdFusion and iText

 

At a recent presentation that I did on "Working with PDFs made easy with ColdFusion"  for Adobe ColdFusion Developer week an attendee asked me if it was possible to embed a SWF into a page on a PDF with ColdFusion.  I had never tried, so I told him I would find out.  Turns out you can!

Read More
September 13, 2011
Adobe ColdFusion Developer Week
Adobe ColdFusion Developer Week

Thanks to Adam Lehman (www.adrocknaphobia.com) for pulling some strings and Simon Free (www.simonfree.com) for collecting the speakers, ColdFusion got it's own Adobe Developer Week. This article has links to every presentation avialable. Also I have links to my source code, slides and connect recording.

Read More
August 25, 2011
AngularJS Hangout 08/25/2011
AngularJS Hangout 08/25/2011

Video: The Google AngularJS team meets with users to talk about new features added to the latest release, items in work, future enhancements.  I shamelessly plug my NCDEVCon talk about AngularJS.

Read More
August 18, 2011
Understanding the Strategy Design Pattern
Understanding the underlying patterns of MVC

Today I presented on Design Patterns and how multiple design patterns are combine to make up the MVC Frameworks that are so popular in every language.Code for the slids and the Robot Fight code are on https://github.com/boltz/Robot-Strategy-Example  To see the Robot Fight which exemplfies the Strategy Pattern: http://maythe4thbewithyou.com/default/codedemos/robotstrategy/robotDemo.cfm

Read More
August 9, 2011
Micro-Computer Nostalgia
Micro-Computer Nostalgia

You know you are getting old when you come across an obscure magazine cover from 1985 called "Micro Cornucopia: The Single Board Systems Journal" and it sends you into a tail spin of nostalgia.  You have to see this computer magazine from 85! It has articles on Pascal Procedures, FORTHwords, SBASIC, Cooling a Hot Computer. This is what I was reading for fun when I was 14 and I don't regret it one moment.

Read More
August 4, 2011
Coping with SQL Server Deadlocks - PART 2
Coping with SQL Server Deadlocks - PART 2

A continuation of Coping with SQL Server Deadlocks Part -1 This time we cover more info on troubleshooting indexes and SQL Profiler.

Read More
Tags: Deadlocks
January 10, 2012
Coping with SQL Server Deadlocks - PART 1
Coping with SQL Server Deadlocks - PART 1

Nothing is more frustrating than trying to hunt down the underlying cause of a MS SQL Server deadlock.  The problem is there are so many possible causes to a deadlock. It could  bad queries, recursive triggers, cursor usage, missing indexes, duplicate indexes, unnecessary indexes, disk I/O. Where do you start looking?  This article will document some of the many tricks I have used over the years to help narrow down where to look.

Read More
Tags: Deadlocks
July 20, 2011
Creating Vertical Text Image
Creating Vertical Text Image

A co-worker had a need of creating PDF using CFDocument that included vertical text.  We could not find any styling that would make text vertical that CFDocument supported.  Style: writing-mode:tb-rl didn't work.  It seemed the best solution was to use CFIMAGE to dynamically convert text passed in as an argument and turn it into an image of vertical text and then embed that image in the CFDOCUMENT for conversion into a PDF.

Read More
More Results: