Thursday, August 18, 2016

Hunt for HDMI capture device

Which Capture Card should I get for streaming or recording? Last Update:Mar 14, 2014
I also want to mention a special thing you have to be aware of with all capture cards below the 500$ range. You cannot capture 1080p 60fps footage at 60fps with a USB/PCI-E x1 or even Thunderbolt device (currently available). The Avermedia Live Gamer HD is the only card I currently know of that supports downscaling this footage to 720p while keeping 60fps. Still if you want to record/stream on 1080p you will only get 30fps as the bandwidth seems to be not sufficient for full 1080p 60fps output of the card over PCI-E x1 slots. For the Hardcore User, Kona/Datapath/BlackMagic all offer more powerful capture cards which can Input up to 2K/4K resolutions. The prices vary between 800-2000$.

omracer Reviews: HDMI Capture card PCI-E (Trident 7160 HD/ Timeleak HD72A)
Published on Oct 20, 2014
From comment:
I can't get it to work on Windows 10. It'll detect it once I have the drivers installed. But when I try to use it (I've tried using the Honestech DVR that it comes with as well as OBS and XSplit), they all give a blank capture.  And apparently the drivers are really only for up to Windows 8.1 anyway

Tuesday, August 9, 2016

Posting Group related

NAV Posting Groups
the Header will always hold information for WHO and the Lines for WHAT

Sunday, August 7, 2016

SQL 2014 related

Fastest way to find row count of all tables in SQL
SELECT T.name AS [TABLE NAME],
       I.rows AS [ROWCOUNT]
FROM   sys.tables AS T
       INNER JOIN sys.sysindexes AS I
               ON T.object_id = I.id
                  AND I.indid < 2
ORDER  BY I.rows DESC

Access denied when backup database :
Give account used by database service (or SQL Agent?) a write access to folder used as backup destination
source: Configure File System Permissions for Database Engine Access