Git Support Added to Visual Studio and TFS

January 31st, 2013 



Announcing Chocolatey, NuGet for Windows

January 31st, 2013

PowerShell extension for installing programs easily from a NuGet type repository for Windows.

*I installed KDIFF3; worked nicely.


Available Positions for IT Professionals

January 24th, 2013

The Center for Business & Information Technologies with the University of Louisiana at Lafayette is currently looking for developers with preferred experience (2+ years) in SharePoint, Dynamics, and or ASP .NET MVC; will also strongly consider those with knowledge of CF, Ruby, PHP, etc. (experience in web development is a major +)

In addition we need DBAs, UX/UI, BI Professionals, etc… job listings can be found here:

***Please see official postings for additional requirements.

We will train individuals depending upon their area of interest (the work exp. is not required if they meet the educational requirements and are a “good fit” for the team)

Spread the word.




Good programmers are GREAT at playing chess

January 8th, 2013

Good programmers are GREAT at playing chess. When you write code you have to be thinking 5 steps ahead of what the client “might” want… and simultaneously figure out how to write your code in a dynamic way that will meet any of those 5 steps at any given time. That way when the customer needs a new feature or changes scope, your code base is prepared…. A few lines of code here, maybe a few there, and bingo done.  It isn’t just about selecting the right tool for the job, but understanding how to best use those tools in combination to make something truly special…  it’s a process of discovery, evolution, solution development/design, and then finally implementation.


SSRS Local Security Access (Resolved)

January 8th, 2013

I recently configured SSRS 2008 r2 to use local accounts so that I could place it onto a stage server for a client. Unfortunately, try as I might I could not get the local account to resolve… after 2 days of searching I realized it must not be an issue with SSRS at all and set about to find out what was going on with windows.

True to form, it turned out to be a domain setting:

Turns out our network admin had configured an AD policy to only allow domain members to remotely access machines… (that or this is a windows default I was not previously aware of). Either way, going to Local Security Policies, I found a setting called “Access this computer from the network Properties” … YES! only domain users were here but it was greyed out and I could not change it.

A bit more googling reveled that I could change this in script using the admin tool pak for windows server… and the command is as follows:

c:\Program Files (x86)\Windows Resource Kits\Tools>ntrights +r SeNetworkLogonRight -u Everyone

I added the startup script with gpedit.msc to run on windows boot – works AOK. problem solved.

sql, Uncategorized

Importing Excel to SQL – Correcting Improper Column Type Detection

January 7th, 2013

When importing Excel Data into SQL Server the JET Driver Settings must be reconfigured to not misappropriate the source column type which can cause data to be lost due to erroneous conversion methods.

The Jet OLE DB provider reads a registry key to determine how many rows are to be read to guess the type of the source column. The registry setting is:


By default, the value for this key is 8. Hence, the provider scans the first 8 rows of the source data to determine the data types for the columns. If any field looks like text and the length of data is more than 255 characters, the column is typed as a memo field. So, if there is no data with a length greater than 255 characters in the first 8 rows of the source, Jet cannot accurately determine the nature of the data type.

To change the value of TypeGuessRows, use these steps:

  1. On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
  2. Open the following key in the Registry editor:

    Note For 64-bit systems, the corresponding key is as follows:

  3. Double-click TypeGuessRows.
  4. In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for Value data.
  5. Click OK, and then exit the Registry Editor.

A second way to work around this problem (without modifying the registry) is to make sure that rows with fields, which have data 255 characters or greater, are present in the first 8 rows of the source data file.

Ref. []



Adding Design Time Support for Custom Controls in Visual Studio

May 30th, 2012

No sense in reinventing the wheel and here is a great series of tutorials by Amr Elsehemy:

Visual Studio

Adding Holidays to Outlook

February 20th, 2012

Simply save & run the file …. supports multiple countries. Enjoy 8-)

(Outlook 2002, 2003, 2007, 2010+)



Units of Measurement

December 19th, 2011

I stumbled across this while looking at the references used on a wikipedia article for “Watt” and thought I would share. This is the most complete and organized collection of Units of Measurement you will find anywhere – period. You’ll find everything you need to be able to do conversion methods in your software too.


NASA Radio

December 15th, 2011

NASA launched a radio staiton just a few days ago … good music and interesting commentary between songs. Check it out:

Third Rock is Live!


Welcome to something brand new!  It’s THIRD ROCK RADIO, and it’s all about exploration.


While NASA is synonymous with the exploration of space, technology, and science education, THIRD ROCK, which is focused on NASA and the great things going on there every day, is all about the exploration of New Rock.


On THIRD ROCK, you’ll hear New Rock of all kinds, including a whole galaxy full of new music that seems to go largely unexplored by ordinary radio.  Just like a healthy scientific curiosity leads to great discoveries in technology, a good musical curiosity is constantly leading us to great New Rock, which we will immediately share with you!


You will also hear some things that you recognize, of course, but we’re excited about the opportunity to really roll up our sleeves and share great music with you.  You can also “like” us on Facebook, and “follow” us on Twitter by clicking the links on the home page.


We have a lot of exciting things to share with you in the coming days, but for now, you’ve landed on the home of great new music and information about NASA itself!  This is AMERICA’S SPACE STATION–THIRD ROCK!  Welcome!