Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

  • A Look at the Bing Webmaster Keyword Research Tool and Open API

    Bing Keyword Research Tool
    March 8 2012: Bing Officially Releases their New Bing Keyword Research Tool

    In today’s (08/03/2012) Bing Webmaster tools newsletter, I received the announcement that Bing has officially rolled out two new features that look very handy. These features are a keyword research tool as well as an API to access your Webmaster information through code.

    I am including the email text below. The actual feature release, however, happened earlier this year on 2/27/2012. Here is a link if you’d like to get the scoop from the Bing.com community announcement.

    In particular I am interested in playing around some more with the keyword research tool. I have included a screen capture with this article to show what the keyword research tool looks like. At first glance it appears quite similar to Google’s keyword research tool, but on closer inspection it does have some interesting features unique to this tool.

    (more…)

  • SQL Server: Search Stored Procedure Create/Modify Date or Text using tSQL

    SQL Server Management Studio (SSMS) is a great tool for managing instances of your SQL Server databases. Sometimes, though, the fastest way to retrieve information you are looking for isn’t through the SSMS GUI, but through direct SQL queries.

    Case in point: if you want to search for specific information about stored procedures in your database. Rather than look one by one through the code, you can query the SQL Server sys.objects and sys.procedures tables to find exactly what you are looking for.

    To search for stored procedures that were created or modified on a specific date, you can directly search either the sys.objects and sys.procedures tables.

    Note: I have written and tested the example queries below in SQL Server 2005 and SQL Server 2008. The syntax for earlier or later platforms may vary. For example SQL Server 2000 does not support the sys.objects and sys.procedures tables.

    (more…)

  • VS2010 Outlook ThisAddIn – How to Get the Sent Email Message

    When writing an email add-in for Outlook with Visual Studio, it’s really quite easy to get the email message object while the send event is in progress using the Application.ItemSend event. However this event happens before the email is sent, so although it can be useful, the Application.ItemSend event is often not the correct event handler to be used when working with Outlook email messages programmatically.

    (more…)