So long, CFgears!

{ Posted By : Eric Cobb on March 19, 2015 }
Related Categories: General

For some time now I've been debating whether or not to keep this blog up and running. I've had this blog up for just over 6 years, and have 115 blog posts, which comes to an average of right at 20 posts per year. It appears that the majority of those post were in 2009 and 2010 (I only had 1 post in 2013!). So, needless to say, I don't blog much anymore.

While lack of time can certainly be a contributor to my not blogging, the truth is I just don't have anything to blog about anymore. After becoming a full time DBA, I don't do any development. I'm not up to date on any of the latest mobile or web technologies, and the last version of CF I used was version 9. So, I feel most of the content here is outdated and no longer relevant. I have considered starting a DBA focused blog, but if I do it will be a clean start and separate from this blog anyway.

All that to say, I'm going to be shutting down at the end of the month. I'm in the process of setting up a new VM for my personal stuff and will be turning this one off soon, and I really can't justify setting up CF/MySQL just to run a blog I don't use anymore.

It's been a good run, and I actually enjoy blogging, but the time has come to say "So long, CFgears!"

NCDevCon 2014 - SQL Server Tips for Everyday Programmers slides and video

{ Posted By : Eric Cobb on September 17, 2014 }
Related Categories: Presentations, SQL Server, Conferences

For those of you that attended my NCDevCon session, you can download a copy of the slides. For those that missed it and would like to see my presentation, here is the video.

If you missed out on NCDevCon this year, I highly recommend you try to go next year. It was a great conference, and a lot of fun. There were a lot of good sessions, all of which were recorded and can be viewed here.

I'm speaking at NCDevCon 2014

{ Posted By : Eric Cobb on September 4, 2014 }
Related Categories: Tips 'n Tricks, Databases, SQL Server, Conferences

I'm a little late in blogging this, but I'm excited to announce that I will be speaking at NCDevCon 2014! This will be my first time back at NCDevCon since I spoke there in 2010, so I'm definitely looking forward to it. My session is SQL Server Tips for Everyday Programmers. If you're in the area, be sure to get registered and come on out to NCDevCon, there's an excellent line up of sessions this year!

New Beginnings

{ Posted By : Eric Cobb on May 9, 2014 }
Related Categories: Personal

As some of you know, the company where I've worked for the last three years is going out of business. As a result, most everyone there (myself included) was laid off last week. Fortunately, most of us saw this coming and had enough advanced warning that we started looking for jobs some time ago. I'm happy to report that by the time the layoffs hit, many of my coworkers already had new jobs in place, or were in the process of doing so. I myself actually accepted a new position the morning of the day I was laid off.

So, next week I start my new job as a full time SQL Server DBA!

More »

SQL Server Tips for Everyday Programmers: Stretch Goal Announced

{ Posted By : Eric Cobb on April 21, 2014 }
Related Categories: Personal, Databases, SQL Server

With only a week left in the Kickstarter project, I've decided to go ahead and add a Stretch Goal. If the goal is met, I will add an additional "Under the hood" chapter to the book. To find out more, check out my Kickstarter, SQL Server Tips for Everyday Programmers, at

New website for my upcoming book

{ Posted By : Eric Cobb on April 15, 2014 }
Related Categories: Personal, Databases, SQL Server

This is just a quick update to announce that I have a new domain and temporary website up and running for SQL Server Tips for Everyday Programmers. Currently, the site is just promoting my Kickstarter project, but my plan moving forward is to have the site promote this book, as well as any future books I may write, and a new blog for database related topics.

You can view the website at

More »

My Kickstarter: SQL Server Tips for Everyday Programmers

{ Posted By : Eric Cobb on April 8, 2014 }
Related Categories: Personal, SQL Server

Yesterday I launched a Kickstarter project for my book, SQL Server Tips for Everyday Programmers ( I'm super excited about this, and hope that you will take a minute to read through my project and consider supporting it.

To briefly summarize the project, my goal in writing this book is to help other programmers enhance their applications. When I was going through my MCSE training, I learned many new things about SQL Server, things that would have made my life as a programmer easier and my applications much more efficient. So, I compiled some of these into a group of useful tips specifically for programmers. I want to help programmers get beyond just creating tables and stored procedures, and use their databases for more than a simple container for storing information. Regardless of the programming language you use, if you use SQL Server I am sure these tips will come in handy.

To find out more about my project, you can view my Kickstarter here:
And please, feel free to comment here! I'm always interested in hearing your opinions.

New and Improved, now with Microsoft Certifications!

{ Posted By : Eric Cobb on January 7, 2014 }
Related Categories: General, Personal, Databases, SQL Server

Well, I may not be new, but I certainly feel I've improved professionally. I'm a little late on blogging this, but towards the end of last year I decided to get some Microsoft SQL Server certifications. I got my MCSA: SQL Server 2012 certification around the beginning of October, and then I immediately dove in and got my MCSE: Data Platform certification a few weeks later in November. All total I took 5 certification exams within about 6 weeks, and I'm already setting my sights on the SQL Server 2014 certifications coming out in a few months.

Me being the database junkie that I am, I have to say I really enjoyed deep-diving into the features of SQL Server, and am amazed at some of its capabilities. I'm looking forward to becoming more involved with it and putting my newfound knowledge to good use!

First Glance at ASP.NET MVC for a ColdFusion developer

{ Posted By : Eric Cobb on August 28, 2013 }
Related Categories: General

One of the things we've been contemplating here at work is the possibility of switching our platform over to another programming language. We're planning a big rewrite of our main site in the future, and have decided to spend some time evaluating other languages to see if there is something else that we would like to use. At this point, we really don't have any specific criteria other than just picking a language and trying a few tutorials to see if we like it.

More »

Problem Using Database Defaults with ColdFusion ORM

{ Posted By : Eric Cobb on October 4, 2012 }
Related Categories: ORM, CFML, Databases

Today I was trying to convert a simple insert query over to ORM, and for the life of me I could not get the insert to work. Everything ran perfectly, there were no errors being thrown (that I could find), but the new record would not get inserted into the database. It took me a while to figure out what was going on....well, to be honest I still don't know what was going on, but I figured out how to fix it. Here is an example of what I was running in to:

More »

More Entries »