Blog Archives

T-SQL Tuesday #46: You did what? Creative hacks to common problems


This whole thing, was put in a store procedure and then called from a job step for a long running job. For example, like a database backup job. And additional logic was written around the return value to write proper error numbers to application log. These event-ids where then picked up by monitoring applications and alerts where raised.

I have mixed feelings about this solution. Although, it worked without a problem (I am secretly proud that I was able to write something like this); I would have loved to just upgrade the servers to SQL 2008 and be done with it.

Advertisements
Tagged with: , , , , ,
Posted in SQL Server

Reading a tweeters timeline using PowerShell-Take2


Some additional modifications made to the original script to make the output more readable by formatting the table results with alternating colors for each row and process a list of users which are passed as a comma separated string.

Tagged with: , , , , ,
Posted in PowerShell

Reading a tweeters timeline using PowerShell


I was reading about the REST API on Twitter and got to thinking if I could read the Twitter time line of a user, any user I was interested in directly from the console? The answer is yes. So, I quickly brewed a PowerShell script to read tweets of users.

Tagged with: , , , , ,
Posted in PowerShell