I’m back… I think?

Live and in print…

Sorry for the hiatus.  The regularly scheduled programming was interrupted by a job change, getting the feel of things and working out what to write about. 

2012-07-20 14.16.21

Now, this I don’t get.  A “Professional” toilet tissue dispenser.  Professional? Is the roll holder at home an amateur?  How does a toilet tissue dispenser make it to professional?  Is there a dispenser competition?  What would the events be?  The quick change?  The long pull?  Side tear? 


Sorry, got on a tangent there…


Here’s a neat little snippet for checking if data coming into a table that is supposed to be numeric strips out the alpha in Teradata syntax:


If the field coming in is not Case Specific then the following check will not catch the alpha characters even though logically it seems that it should:


Using “CASESPECIFIC” is certainly a lot easier than messing around with collation options.


In looking around, I found this blog on the topic dealing with MS SQL:

Make SQL Queries Case Sensitive

Here’s some interesting information on SSIS from MS Connect:

SSIS – SQL Server 2008 – Add Case INsensitive search ability to lookup component

Collate is a popular solution:
SQL Server Journey with SQL Authority


A short snippet sure but it’s good to be back and writing away.

Published by


Originally, this was a pretty darn boring post. Kinda like... Well I won't go there. Perhaps its still on the robotic side but... I could say I like music. Safe, generic and non-comittal. Or, I could say that I've been having a blast tuning up my old guitars, getting blisters on my fingers and turning the amp up past 2. Amazaing what a little overdrive and a half pressed wahwah pedal can do for a sound. Get that cool "Money for Nothin" vibe happening. I get a real kick out of reading old Sci Fi. Reading Asimov's vision about the future is really entertaining now. When he wrote much of the material, the items that were futuristic were day to day tools I used in the early part of my career. Microfiche and the like. I also remember that upstart Microsoft and MS DOS...and can you say Lotus 123? So maybe this is a little better than "I like to read and play music". My career is focused on Team Leadership and Technology. Both share the attributes of continual growth and education. Currently, I manage a team of 4 programmers as direct reports. I've been in this role since 08/2007. Prior to that, I was the team lead (on site) for integration with the customer. Customers ranged from local government to manufacturing and medical. Teams ranged in size from one to six additional team members. On the other side is technology. I've been keeping current with .net technologies focusing on C# and Sharepoint (2007/2010). Specialties Team Building and Management Technical Staff Recruiting Microsoft Visual Studio 7 through 2010 (VB.NET and C#.NET) Microsoft SQL Server 6.5-2008R2 (DTS, TSQL, SSIS, SSAS, and SSRS ) SharePoint 2010 (Office Integration, InfoPath, Site Management and planning) Windows Server 2008 R2 AD DS PowerShell Techology analysis Puchasng and working with vendors Microsoft licensing management and compliance Business Systems Analysis Traning plans Mentoring Training coordination.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s