Monday, May 2, 2016

How to get reportname from scheduled SQL job

SELECT
      c.Name AS ReportName
      , rs.ScheduleID AS JOB_NAME
      , s.[Description]
      , s.LastStatus
      , s.LastRunTime
FROM
      ReportServer..[Catalog] c
      JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID
      JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID
      AND rs.SubscriptionID = s.SubscriptionID

Monday, August 10, 2015

Galaxy s6 edge and google now

Well, s6 is a complete failure when it comes to Google now. I use finger print for security, guess what google now will not work. You can say ok Google and ask a question or make a command, but for result you have to unlock the phone. Issue was resolved with google update, took them a while

Wednesday, November 20, 2013

Postgres SQL password passing via script

need to export password into variable, can not pass as a parameter to psql export PGPASSWORD=password

Friday, January 18, 2013

Outlook 2013 ActiveSync is broken

Outlook 2013 ActiveSync is broken. ActiveSync works for android and iPad, but Outlook fails to connect to the same Exchange server. Kinda shows how messes up Microsoft is, can't even connect to their own product. Shame..... Anyone interested should try bluestacks with android email active sync. I can confirm it works on win7.

Tuesday, October 16, 2012

Upgrade T-mobile LG Optimus P509/P500 to ICS

ICS is available for LG P500, but not from Cyanogen:(

I guess Oxygen to the rescue http://code.google.com/p/oxygen-for-p500/ 

I tried it, so far the the most stable among ICS/JB flavors there. Need new basebase , and I can confirm it works with 3G T-mobile in NYC.