Archives
Our Thought in One Place

  • Happy hump day friends. My apologies for being a bit late with our weekly recap. We’ve been dealing with a tough illness in Nicole’s family the last few days, so I’ve been a bit out of the loop. If I miss you this week, we’ll connect next week when things settle down. What have you been up to? I’ve been getting a few updates from you guys at @parnellk63 and would love to hear more!

    Monday, March 9th

    • Cameron worked a bit on Monday on content marketing and SEO for two of our clients: Gordy EyeCare and Janney Insurance. In a world where content is king, strategic social articles are imperative for electronic success.
    • Several members of our creative team continued their good work on collateral design for our new JASE Restaurants initiative. Man, the designs look dynamite! I can’t wait to show them off.
    • Our tech team closed a mini project where we integrated the WordPress admin panel into our JASE Office Social App. The so-what of that is, now our clients have one place to login to work all of their social initiatives including blogging, Facebooking, Tweeting, etc.
    • Sally Horvath of Dragas Management Company had us do a few updates to their website to keep the content current on their new condominium communities. Our developers have done outstanding work for Dragas over the years and continue to do so today.

    Tuesday, March 10th

    • I attended the Cox Business Executive Discussion Breakfast at the Norfolk Waterside Marriott early Tuesday morning. The topic of discussion was Transportation in Hampton Roads, and the panel of speakers included William E. Harrell, CEO of Hampton Roads Transit, Dr. Camelia Ravanbakht, Executive Director of HRTPO, and Aubrey Layne, Virginia Secretary of Transportation.
    • I also received an unexpected and welcomed visit at the Studio from Will Christopher, President of HRPTA.

    Wednesday, March 11th

    • David and Mark Ramm had their bi-weekly update conference call on the .NET work we’re doing for TRL, Inc.
    • I visited our friends and Ghent neighbors, TechFix Repair Center, to drop off one of our iPhones and an iPad for glass repair. These guys do great work–and are affordable. Visit them on 21st street in Norfolk when you need electronic equipment repair.
    • Thanks to Walt’s and Sue’s hard work, we delivered another fabulous ad concept to Sally Horvath at Dragas Management Company. This medium production was for a Crofton Village @ Spence Crossing condominium community Virginian-Pilot Home Search Magazine ad. Check it out in your grocery store’s news stand.
    • I did happy hour with a few buddies at Yard House in Virginia Beach on Wednesday. Lotta fun catching up with Frank, Tom and Mike.

    Thursday, March 12th

    • We had a Ghent Business Association marketing committee meeting at Ronald McDonald House on Thursday morning. This is a fun group to be a part of: Jennifer McDonald (VEER Magazine), Elyse Brown (Ronald McDonald House Charities Norfolk), Ashley Huber (Changes Hairstyling & City Spa), Laurie Harrison (EVMS), Kristen Ricks (Pilot Media).
    • Our developers made a few website updates for Karla Muro of Hampton Mental Health Associates. These guys have been a fun client for us for a long time.
    • Cameron made a visit over to our friends at Fleet Printing on Thursday. He worked with Brian MacKeil to put a portion of our JASE Restaurants collateral into production. Awesome!

    Friday, March 13th

    • Yep, Friday the 13th, it was. No worries though–we beat down the myth.  :)
    • A group us went to the Shamrockin’ In Ghent festival Friday evening, organized by the Hope House Foundation. Hope House does amazing work supporting adults with intellectual disabilities. After the festival we scurried into No Frill Bar & Grill for dinner with our friends Tom & Jane once the rain began.

    Sunday, March 15th

    • Nicole and I had brunch with Christie, Dennis and Mary on Sunday at Lubo Wine Bar in Virginia Beach. What a great local spot in the Chick’s Beach area–just wish it was a bit closer to us.

    As usual, I have to give a plug to our newest initiative, JASE Restaurants. We’ve been honored with a couple of new clients already and would love to see you or your favorite restaurant hop onboard.

    I hope you guys have a great rest of the week. Keep your chin up, your eyes bright, and your ears open–you never know when a juicy bit of knowledge will come flying at you. Stop in for coffee. I’m available any time.

    Your friend in Christ,
    kp.

    JASE at Emerson's Cigars

  • JASE does technology. JASE does technology well. After all, technology is where we began this journey. In the late 90’s and early 00’s we were designing websites, building content management systems, complex eCommerce applications, financial toolsets and intranets. Life was good.

    Then, we had an epiphany. We could see the unavoidable collision of the internet and marketing and we knew that if JASE were to have a sustainable business model well into the future, we would have to capitalize on the inevitable.

    What we didn’t know was that our foray into marketing would make us a better technology company. While we were experiencing the world of advertising and public relations, we were refining what we knew best, technology. That long refinement process allows us, today, to create the best custom solution for your business. So you may sit down and talk with us about web design or mobile app development, but our years of experience help us to determine what will deliver the best and most effective result for your money. In other words, you may come in wanting a mobile app, but we never just build a mobile app because we can. Instead, we show you why you need, or don’t need, that mobile app and what is the best solution for your needs.

    The beauty of this whole evolution of JASE is the fact that you, our client, can ask us for just about anything. We don’t just build websites. We build the custom solutions to make your business work smarter, more efficiently and more profitably than you previously thought possible. After all, isn’t that what technology is supposed to do for us?

    JASE Custom Programming

    JASE Custom Programming
    Tape Rental Library, Inc. is an online audio and video rental service that specializes in business titles and training materials for corporations in the United States. TRL came to JASE and asked for technical assistance with streamlining their online resource library application. We first developed a .NET application with on-demand downloadable audio integration and then through code efficiency and speed improvements, improved reporting, customizations to the user interface, and integrations with third party APIs. JASE’s work for TRL has enabled the company to market their services to a wider variety of customers and has provided their clients with an overall better user experience.

  • faulty motherboard

    We haven’t talked tech in a while on our blog but since a good percentage of our readers consists of programmers and database administrators, we feel the need to sneak in an article or two every once in a while. So if this one doesn’t interest you, don’t sweat it; more cool, mainstream articles are coming.

    For our techie friends, this information is a subset of a great article from Steve Moore on SQL Server Central. His source article is here in full.

    Email Formatted HTML Table with T-SQL

    One of the most common tasks for me is to send data from a query as the body of an e-mail.  You can do this in SSIS by outputting a query to a flat file, but there’s no easy way to format the content.  You have the option of using XML and XSLT transformations, but that is a bit onerous for simple use cases.

    This article is about how to produce a table in an e-mail using just SQL.  The only real complexity is formatting alternate rows, which was my goal.  I wanted it to look like a .NET DataGrid.

    The basic approach involves three steps:

    • Create a query that pulls together the data as HTML.
    • Use bcp and xp_cmdshell to write the SQL to a file.
    • Email the file using Blat, a free SMTP client (www.blat.net)

    One of the problems I ran into is the use of a <script> tag in the email, so there I had to abandon CSS styling and instead do inline styling on every row.

    In order to find the odd/even rows, you need the ROW_NUMBER() function in a CTE, then use a CASE statement, and the modulo operator.

    Once you have the SQL with HTML formatting, you want to use that within another stored procedure to write the result to a file.

    Now you should be able to open the file “C:MyProjectSqlHtml.html” in a browser and it should look similar to a .NET DataGrid. Finally, send the file as the body of an e-mail.

    Thanks to Steve for the great explanation. For those interested, he shows full explanations of the stored procedures in his article on SQL Server Central here.

    image credit: javaprogrammingforums.com