Apr
17

Yesterday I posted about upgrading my blog to BlogCFC 5.9.3. How I went about the upgrade process is probably just as important as getting on the latest version. What follows is a run-down of how I upgraded, what tools I used to make it painless, and the SQL scripts I wrote you can use to get your own blog upgraded. Hit the more link for all the goodness.

Continue Reading

Mar
5

Are you a ColdFusion developer with experience managing or supervising other developers? If so, you might be interested in an immediate opportunity in Charlotte, North Carolina. This position is with a major employer in the area who's looking for someone with the following skills.

Required skills:

  • ColdFusion development
  • SQL Server department
Desired skills:
  • Java
  • SharePoint
  • .NET
  • DTS and SSIS
If you have the required skills and you're interested in this position send a current resume to Marianne Mazer at mmazer [AT] premieralliance [DOT] com.

Jan
30

Last night's Nashville ColdFusion User Group presentation was really great. Terrence Ryan presented on his code generation / scaffolding tool called Squidhead. He showed off Squidhead's SQL and stored procedure code generation, as well as ColdFusion DAO code creation. He went on to demonstrate the interfaces Squidhead creates for adding and deleting database records.

At the end of the recording we got to know Terrence a little more and learned what some of his plans are in his new role as an evangelist at Adobe on the ColdFusion team.

View the Adobe Connect presentation now!
http://mmusergroup.adobe.acrobat.com/p44126041/

Jan
28

Just a quick reminder that Terrence Ryan will be presenting at the Nashville ColdFusion User Group tomorrow night. He'll be talking about Squidhead, a scaffolding tool that works with ColdFusion MX 7 (or above) and Microsoft SQL Server 2000 and 2005. Folks local to Nashville are encouraged to attend in person while remote attendees can join via Adobe Connect (http://mmusergroup.adobe.acrobat.com/ncfug/). For more details and to RSVP for this meeting please visit the NCFUG site.

Nov
26

Too often I forget about this handy SQL trick. Maybe I'll help to cement it in my brain by blogging it and hopefully someone out there will find it useful. Nearly every week I find myself rewriting SQL queries on an application that I didn't originally build. This typically involves replacing join criteria written in the where clause with equivalent joins in the from clause. Most of the time I just rewrite the statements on my own but you don't have to. Take the following example for instance:

Old School Method

SELECT E.FirstName, E.LastName, D.DepartmentName
FROM Employees E, Departments D
WHERE E.fkDepartment = D.ID AND D.ID = 5

This query seems simply enough, and it is. But when you add additional tables to the joins in the where clause and perhaps more filter criteria in the where, things quickly get unreadable. SQL's join statement does a much better job at specifying how your tables relate to one another without any filter criteria (like department ID = 5) getting in the way. Here's the above query rewritten using joins.

Preferred Method

SELECT E.FirstName, E.LastName, D.DepartmentName
FROM Employees E INNER JOIN Departments D ON E.fkDepartment = D.ID
WHERE D.ID = 5

While you can rewrite your old queries on your own let SQL Server's tools do the work for you. Open SQL Server's Enterprise Manager and right-click any table. Elect to view the contents of the table and once they show up hit the "SQL" button at the top left in Enterprise Manager. This will show you the SQL used to display the contents of your table. Next, copy the offending query and paste it over the SQL Enterprise Manager is displaying. Press the "!" (run) button and Enterprise Manager will take your old query, rewrite it using the appropriate joins, and display the results. Pretty handy.