Configure the SQL Agent to run a nightly job with a single step that executes the T-SQL code.

/*********************************************************/
/* Job requires use of xp_create_subdir and xp_delete_file to
create backup directories and delete old files */
/*********************************************************/
 
-- All Databases excluding (non-read only and sample) databases are backed up.
-- Expired backups are deleted
 
-- Backups of master, model and msdb are written to a 'System' folder
-- Backups of user databases are written to folders named after the databases
 
-- Get names of eligible databases (excluding tempdb and sample databases)
 
declare databases_to_backup cursor
FOR
SELECT name FROM master..sysdatabases
WHERE name NOT IN ('NorthWind','Pubs', 'AdventureWorks', 'tempdb')
AND (STATUS & 1024) <> 1024
ORDER BY name
FOR READ only
go
 
SET nocount ON
 
declare @db_name varchar(50),
@master_backup_dir varchar(255),
@specific_backup_dir varchar(255),
@backup_date char(8),
@backup_time char(4),
@filename varchar(255),
@retain_days tinyint,
@delete_date datetime
 
-- Specify high level backup directory and number of days' backups to keep on disk
SET @master_backup_dir = 'D:\data\backup\sql2005\'
set @retain_days = 14
 
-- Open the cursor and retrieve the first database name
open databases_to_backup
fetch databases_to_backup into @db_name
 
while (@@fetch_status = 0)
begin
-- Build a datetime string to uniquely identify the backup
set @backup_date = convert(char(8),getdate(),112)
set @backup_time = right('00' + convert(varchar(2),datepart(hh,getdate())),2) + right('00' + convert(varchar(2),datepart(mi,getdate())),2)
 
-- Build the specific backup directory path
if @db_name in ('master','model','msdb')
set @specific_backup_dir = @master_backup_dir + 'System\'
else
set @specific_backup_dir = @master_backup_dir + @db_name + '\'
 
-- Verify the backup directory exists
exec master.dbo.xp_create_subdir @specific_backup_dir
 
-- Build a unique filename and backup the database
set @filename = @specific_backup_dir + @db_name + '_db_' + @backup_date + @backup_time + '.bak'
BACKUP DATABASE @db_name TO DISK = @filename
 
-- Delete files older than specified retain days
set @delete_date = dateadd(d, (@retain_days * -1) , getdate())
exec xp_delete_file 0, @specific_backup_dir, N'bak', @delete_date
 
-- Get the next database name
fetch databases_to_backup into @db_name
end
 
set nocount off
 
close databases_to_backup
deallocate databases_to_backup

Top 5 Web Developer Firefox Add-on’s

• Web Developer - Integrates with Firefox to create a menu and a toolbar with various web developer tools (e.g. outlining page elements, re-sizing browser window size, site-specific cookie management, and validation tools )
• Firebug - Firebug integrates with Firefox to put a wealth of development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page
• YSlow - YSlow brings additional functionality to Firebug regarding site performance. YSlow analyzes web pages and suggests ways to improve their performance based on a set of rules for high performance web pages which coincides with the YSlow team as well as metrics defined in the book High Performance Web Sites: Essential Knowledge for Front-End Engineers
• Server Spy - Indicates the web server type for the sites you visit (e.g. Apache, IIS, Tomcat, nginx, and so forth) this data is invaluable during debugging complex server-side issues.
• Live HTTP Headers - Similar to Server Spy which just pulls the ‘Server’ element from the HTTP response header, this add-on makes additional elements available for debugging. See ‘List of HTTP headers‘ on the Wikipedia for a full listing of request/response definitions.

Define a strategy for your company, just as we have done! I believe transparency is important so here are excerpts from the concepts behind the strategy we are implementing at Juxt Interactive along with explanations of the driving factors behind our approach.

• Have each and every individual that wants to use twitter at work to benefit the company determine their voice. How will they position their messaging and how can that help your company? If you follow me you’ll notice at least 80% of what I say is focused towards business. tasks I’m currently working on, industry news, and research & development.
• Have more seasoned users mentor new users. Technology is usually inherently confusing and twitter is no exception to the rule.
• Adjust your email footer to include a link to follow you on twitter, this is simple and a great way to gain followers.
• Be aware that your clients, prospects, vendors, and staff follow you, if you send messages that are offensive to any of these groups, you probably shouldn’t be part of your company’s twitter team.
• The time of your tweets matter. If you have an important message sending it at 10pm on a Friday night may go unnoticed by many [at least those users who stream in real-time.] with the exclusion of people in different time zones.
• We live in a global economy, if you don’t already do business internationally be prepared to do so, don’t limit yourself to local discussions.
• Retweeting is imperative, but don’t use your companies Twitter account as a straight unidirectional promotional channel.  Have employees retweet as necessary at different intervals so your message is seen by different groups of people at different moments in time.
• Deliver content that is relevant to the audience that you wish to target.
• Make sure your voice is authentic as is your message.
• Engage others in your field in communication.
• Understand Twitter is a push/pull medium - don’t just speak; ask, listen, react.
• People are as smart as you give them credit, don’t just promote your company. Good rule of thumb: think of your audience as your wife, or husband. Don’t be condescending, be respectful.
• Watch the length of your tweet, 140 characters is obviously short.  Use it wisely.  If you @reply to many users in a tweet it becomes an issue when retweeting.
• Lastly, Twitter is dynamic — always changing.  Understand this and embrace this.  Change the structure of your tweets, the sequencing the people you reply too, the tags, etc.

Again, we’ll see over time if this strategy proves to be sucessful.  Currently this is just aggregated research and an attempt at creating a strategy to streamline and organize communication over this specific medium.

In late 2008 Coca-Cola asked Juxt to create a ringtone generator for their Sprite brand. The concept was fairly fairly straight forward, create an engaging rich media campaign for Sprite that would supplement and drive additional traffic to their under the cap program. The under the cap program gives participants a digital prize on their mobile phone every time they text a cap code found under the cap of a 20 oz Sprite.

The rich media unit allowed visitors to mix custom samples to create a ringtone which then could be sent to their mobile phone. The mechanism for delivery of the ringtone was sending a text message with a unique code to 77483 [Sprite’s short code]. The unique code was determined by the selection and pattern of samples chosen in the mixer.

So far so good, four samples (drums, bass, lead, and synth) and four measures the only piece missing is a creative mind to mix yourself a ringtone. This is where things get both complicated and interesting. Due to the hosting environment infrastructure and mobile messaging platform we were unable to create ringtones on demand in real-time. Instead we were require to create all possible combination of ringtones in advance. Using a 4×4 grid of samples and measures we are left with 65,536 possible combination’s but one option is complete silence so our magic number is 65,535 distinct ringtone possibilities.

We tried a wide variety of different software applications to sequence audio tracks to generate our 65,535 ringones. However, after much research we determined that each piece of software resulted in poor results. For the most part, desktop applications weren’t able to process the sheer bulk size of the files we were trying to sequence. It became evident that this wasn’t going to be an easy task. Eventually I found a audio conversion application for linux called the Swiss Army knife of sound processing (SOX). After trial and error and a make shift syntax manual I was able to join four samples (drums, bass, synth, lead) so they all played at the same time. Success. Well, not quite success but progress.

Having a solution to merge audio tracks was comforting, but there was still a few more hurdles. Mainly, how do I go from creating one combination to over sixty-five thousand, and how would I generate a code that could easily be interpreted by the Flash mixing interface so the right SMS code could be generated? Since SOX is a linux tool it made sense to create a script to write an application to sequence the ringtones. PHP was an obvious candidate, its available, easy to write, and very robust. I am going to spare the details of the contents of the script, but I can tell you that it used bit arrays, translation, loops, and math. As I mentioned previously matching the code to a specific ringtone is extremely important. If you are in the industry you are aware that banners and rich media units have file size requirements. In our case the flash mixer needed to be less than 100k. The design and functionality already left us at nearly 100k which meant we didn’t have room for logic in the application and we could not load a mapping into the flash application via XML because the file size would be ~5MB which would kill the experience.

Regardless, we found a pattern relying on hex that allowed us to use a simple naming scheme that the mixer could understand with very little logic. Then we modified the naming convention slightly to make sure we didn’t generate any codes that matched data in the 18,000 row document explaining how to spell vulgar or inappropriate terms using your keypad. After generating 65,535 ringtones in a number of formats we put them on a terabyte drive sent them to an unnamed country in Europe and the rest is history, run through the MTV or VHS properties to find the ringtone mixer and get yourself a new ringtone.

Lastly, I’ve got some portfolio additions that will appear in What I’ve Done section in the coming weeks.