After demise of my favorite RSS Synching Service … Google Reader back in July 2013, I was little lost in quest for ultimate alternative since like many IT guys, I don’t stick to just one device and read my feed always from there. Plus me “experimenting” on different things on same system means loosing all of my unbackedup feeds at some unfortunate event of catastrophic system failure … which is just not acceptable for me.
So after little Googling I found out that it’s not just me there are many many people who were upset with Google for discontinuing this great service in the name of “cleaning”. And unlike many upset users who switched to just other local readers… some went a step further and decided to not to be dependent of any other service but to rollout their own solution !! I was able to find two services particularly interesting, one is CommaFeed and another one is Tiny Tiny RSS (aka tt-rss). But former can be pain in back to setup since it requires to checkout project from github and then deploy it on your sever and do whole lot of juggling. But Tiny Tiny RSS (aka tt-rss) is way more simpler solution than that. So I decided to use it to take my revenge to Google Reader . This post is about how did I setup tt-rss on my own server and use it to synch my feeds automatically.
First thing first, you need to find a hosting provider who provides hosting with PHP v. 5.3 or up. There are many providers that do free hosting with required PHP version. I decided to try http://www.freehostingeu.com/ for this demo (no strings attached with this provider ).
Next is to get latest version of tt-rss from project site. And either extract whole project in your computer and upload everything from your computer OR just upload one TAR file and extract it on site.
Recently I stumbled upon really weird issue with VS 2010. We have bunch of database projects created in VS 2010 which are part of our regular development build. As part of my task, I was trying to automate deployment of these database projects using PowerShell and came across really really strange issue that I have never seen before.
I was simply checking out database project from our source control and using MSBUILD (aka MSFT Build Engine) to build and deploy the database project to my test SQL Server instances. Ideally what it does is it allows me to deploy that database at instance that I wish with database name of my selection. But with my surprise when I built and tried to deploy the project I was welcomed with this error …
There are many after market tools available to monitor health of SQL Server. But with help of built-in tools you can actually create some pretty neat solution by yourself too. And one of the most handy tool is “Alerts” in SQL Server. With help of Alerts you can monitor SQL Server Events, Various Performance Conditions and oddly WMI events !! And what great thing about it is you can setup it to notify users and / or run specific job (stored in SQL Agent) to handle specific event.
It is very simple to setup Alerts using SQL Server Management Studio (SSMS). Since Alert notification uses Database Mail, you need to have a valid mail profile in order to be able to sent notifications. You can actually use your gmail account for testing. While back I did post about it.
First you need to create an operator which will receive an alerts via Email or Net Send or Pager. You can create new operator in SSMS –> SQL Server Agent –> Operators. Right click on Operators and select “New Operator”.
It has two simple parts, in 1st General part you provide way you want to get notification … be it Email, Net Send Address or Pager. Furthermore you can setup pager schedule. For demo, I will be using my Gmail account as operator email.
I like to work with scripting languages be it PowerShell or Batch or VB… One of the reasons for liking is it gives me “false sense” of Linux environment … But the main reason I like scripting because I am lazy by nature and scripts are great way to automate lot of things which are routine of my work.
But even will all greatness there are few quirks like no GUI, cryptic syntax exists that make one bit shy to use these scripting languages. I think it is one of the reasons why usually scripting is considered forbidden knowledge for anyone other than likes of system administrators
This week I ran into strange issue. Out of no where my Who Is report stopped working. To be exact, InfoDB API stopped working ! With little digging I found that it needs to have format=xml not XML !! For some reasons InfoDB guys just decided that it has to be in lower case, but then again I can’t complain about it because it is free and you don’t expect much out of free service …
Few weeks back I went to North Dakota at one customer site, that town was literally in middle of nowhere. And roads were just flat straight line. Being long time resident of CT, I find it difficult to drive when I have to drive in one straight line for 70-80 miles
Past few weeks have been super busy for me, and I have not got enough time to do any “experiment” or prepare better post. So think of this as a “filler” post …
Due to change in my role in our company, I had to do traveling on different customer locations for installation projects and it is usually a week long stay. But I kind of like travelling because it gives me a chance to meet new people and gives me chance to interact with them.
But it could be difficult sometimes because you never know what customer is going to ask you and you have to be ready to answer that thing. Now I know that you don’t necessarily have to have an answer for all questions but then again you don’t want them to feel that you don’t know your product enough (or just say … look dumb ? ) !! …
Overall I would think traveling to customers as a good learning experience and in time it improves your people and professional skills .