MS SQL General Instance Information

Pair your PC or Notebook with YouTube on smart TV

I have an IPhone, and when I watch YouTube on it, I can stream the video directly to my Smart TV. Since playing YouTube videos directly on Smart TV YouTube app is unpractical, I wondered If I could connect my Laptop with my Smart TV.And I did it with a help of Google Chrome. I …


Active Directory User Auditing – SCOM 2012

Active Directory User Auditing – Simple

Windows Server NIC address error

Server – prevent registration of multiple IP to DNS from one server

Uninistall of SC agents from Core OS

I deinstalled VMM 2012 from one server. But its agents remained on my Hyper-V core installation servers. How to uninstall them if no Add/Remove programs exist, or you dont have original agent.msi package? On Core OS (2008 or 2012) run regedit Go to HKLM\Software\Microsoft\Windows\Current Version\Uninstall Expand Uninstall, then search in subfolders for string in DisplayName =”System …


SCOM – Setting Pending management after manual agent installation

I recently installed for testing, an SCOM 2012 agent on one machine. But I could not see that computer in Pending Management section. After searching through settings, I found out that you have to set Review new manual agent installation in pending management view in Settings->Securitiy in SCOM Console.


Windows: RPC server unavailable

SRSS – Get list of Reports and Its Data sources and Datasets

I needed to get the list of my reports and what data source and dataset they use. use ReportServer; WITH XMLNAMESPACES ( DEFAULT ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’, ‘http://schemas.microsoft.com/SQLServer/reporting/reportdesigner’ AS rd ) SELECT distinct ReportName = name ,DataSetName = x.value(‘(@Name)[1]’, ‘VARCHAR(250)’) ,DataSourceName = x.value(‘(Query/DataSourceName)[1]’,’VARCHAR(250)’) ,CommandText = x.value(‘(Query/CommandText)[1]’,’VARCHAR(250)’) FROM ( SELECT C.Name,CONVERT(XML,CONVERT(VARBINARY(MAX),C.Content)) AS reportXML FROM ReportServer.dbo.Catalog C WHERE C.Content is …


Enable / Re-enable mount of ISO image in Windows 8