A few months ago I wrote an ad-hoc SQL script to help with the frustrating task of, "Where is this value coming from in the database?" It can be incredibly useful if you are inheriting a database from another team, or are developing on an open-source database application. The script uses SQLServer 2005 or later to cycle through each table and each column* in all tables to see if that column is equal to some string or value we're seeking. It then returns three result sets:

• List of tables that had a column matching the search criteria
• Table/column pairs of every column that satisfied the WHERE clause
• SQL queries you may run in order to retrieve the matching results (one query per table), with the SELECT returning the matching columns before the full set of columns from the table

Continue reading to view and download the SQL script.

It's been a little while since out last White Paper (we've been busy!). In fact, this one has been sitting in draft mode for a long time, but it has finally arrived in time for those of you starting to consider planning for your interactive initiatives in 2011. Here's what it's all about.

There is often a disconnect between the now and the future when it comes to crafting interactive strategy - and yet, there need not be. This white paper defines some of the factors that have changed interactive strategy thus far in 2010 and outline effective ways to incorporate them into your company's interactive strategy. Thus, rather than purely chasing a trend or promising new technology, you may focus your resources on the factors that will drive tangible business benefit.

This white Paper on Interactive Strategy covers the following

• What is an Interactive Strategy
• Promise of the Semantic Web
• Ubiquity
• Content is King, Queen and the Court
• Incorporating the New Factors

Click here to get this latest white paper on the topic of interactive strategy beyond 2010. 

And oh by the way, no you can't have a blog post on the topic of strategy without a chess piece image. So enjoy that piece of stock art.

We're proud to announce another recent web site launch for Trinity Solar Systems. The site design was particularly important to Trinity Solar in order to put forward a polished, professional look and feel for both residential and business owners alike. The site features a new underlying CMS powered by Umbraco and establishes a foundation for further online marketing activities. Congrats to the entire team!