Tuesday, March 23, 2021

RSAT instalation

Open Powershell with Admin permissions and add the folowing:
Set Windows Update Server Key to 0

Set-ItemProperty -Path HKLM:SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU -Name UseWUServer -Value 0
Restart Windows Update Service
Restart-Service -Name wuauserv -Force
Get RSAT Tools
Get-WindowsCapability -Name RSAT* -Online | Add-WindowsCapability -Online
Set Windows Update Server Key to 1
Set-ItemProperty -Path HKLM:SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU -Name UseWUServer -Value 1
Restart Windows Update Service
Restart-Service -Name wuauserv -Force
Done

Thursday, September 26, 2019

SQL SSRS subscription to scheduled jobs query

SELECT  Schedule.ScheduleID AS JobName
       ,[Catalog].Name AS ReportName
       ,Subscriptions.Description AS Recipients
       ,[Catalog].Path AS ReportPath
       ,StartDate
       ,Schedule.LastRunTime
FROM    [ReportServer].dbo.ReportSchedule
        INNER JOIN [ReportServer].dbo.Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID
        INNER JOIN [ReportServer].dbo.Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID
        INNER JOIN [ReportServer].dbo.[Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID
                                                         AND Subscriptions.Report_OID = [Catalog].ItemID

Friday, June 23, 2017

Samsung S7 edge pink line

Started getting random pink line on my 10 month old phone.

Let's see if Samsung service is as good as Apple. Stay tuned traveling to NYC downtown to get it fixed.

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.

Tuesday, August 23, 2011

Thursday, August 18, 2011