Archive for the ‘Software’ Category

Using TinyURL with Tweet-SQL

As every post to Twitter is limited to 140 characters it’s important we are able to squeeze as much as we can out of it. To help users of Tweet-SQL with this I’ve integrated TinyURL into version 2 of the product. Here’s how you use it; ?View Code TSQLDECLARE @long_url NVARCHAR(1000), @short_url NVARCHAR(100);   SET […]

My Favourite SQL Tools

BIDSHelper Enhances and extends the functionality of BIDS. I’ve mainly used this with SSIS but there are many tools for SSAS and SSRS included in the package. Two of my favourites include the variable editor (useful when you add them in the wrong scope) and the deployment wizard. These two things alone have probably saved […]

Tweet-SQL Version 2 Sneak Peek

Tweet-SQL is a Twitter Client for Microsoft SQL Server 2005 and above allowing you to interact with the Twitter API with standard T-SQL. The forthcoming version 2 of Tweet-SQL contains a host of new features and improvements. Here’s a sneak peek at what is coming in Tweet-SQL V2; New procedure allowing the use of the […]

Ping-SQL Sneak Peek

Ping-SQL allows you to play with the Ping.fm API with standard T-SQL in Microsoft SQL Server 2005 and above. Ping-SQL includes procedures to programmatically adjust configuration, replicate data to local tables and, of course, interact directly with the ping.fm API. Here’s a quick summary of the procedures currently in the suite… Procedure Classification Comment ping_cfg_debug Configuration […]