display – using an ultra large LG 34um94-p monitor with a mini mac in late 2012

I have this cool new LG monitor that I mounted and plugged into my Mac Mini (late 2012, High Sierra), but the LG monitor is not receiving a signal. I tried HDMI and a mini screen to HDMI adapter.

How do I get my Mac mini to talk to my LG monitor?

SQL Server 2012 – Stuff With XML Path

DECLARE @v NVARCHAR(MAX)=''
select @v =STUFF((SELECT CASE WHEN MeterID=0 THEN '' ELSE CONVERT(VARCHAR(50),MeterID) + ',' END AS (text()) 
                        FROM (SELECT DISTINCT mr.MeterID FROM #FilteredMeterIDs mr WHERE mr.apartmentID = fmr.apartmentID)m
                        FOR XML PATH,TYPE).value('(.)(1)','NVARCHAR(MAX)'),1,0,'')
                    FROM #FilteredMeterIDs fmr
select @v

Result:
181,834,

BUT when I use the query below, it gives NULL as RESULT,

DECLARE @v NVARCHAR(MAX)=''
select @v =STUFF((SELECT CASE WHEN ISNULL(MeterID,0)=0 THEN '' ELSE CONVERT(VARCHAR(50),MeterID) + ',' END AS (text()) 
                        FROM (SELECT DISTINCT mr.MeterID FROM #FilteredMeterIDs mr WHERE mr.apartmentID = fmr.apartmentID)m
                        FOR XML PATH,TYPE).value('(./text())(1)','NVARCHAR(MAX)'),1,0,'')
                    FROM #FilteredMeterIDs fmr
select @v

Result:
NO

I used "/ text ()" to improve performance. What's wrong, can anyone tell me ?!

Windows Server 2012 R2 – Certificate does not ask for a password

Happy New Year everyone! I have a Windows Server 2012 server that issues certificates to all users from the user model of the certification authority, I use these certificates to sign PDF files, but when signing of the certificate, I cannot password, because probably when it was created, this configuration did not come! Anyone know how to get the certificate to weigh a password when signing a document?

SQL Server 2012 – Offline Index Rebuilding

As I know, when rebuilding an online index, SQL Server virtually creates an index, then at the end, it exchanges the old existing index with the new one created, then finally deletes the old index. I would like to know if these operations are the same for rebuilding offline indexes. Will SQL Server virtually create an index and then replace it with the existing one?

PAGE_FAULT_IN_NONPAGED_AREA (srv.sys) Windows Server 2012 r2

I have an HP proliant 380 gen9 server. The problem started with the automatic restart of the server when checking ilo logs. I found out that we had a smart battery failure, so we replaced it. After turning it back on, the system works for about 10 minutes and then gives us a blue screen with this error "PAGE_FAULT_IN_NONPAGED_AREA (srv.sys)", then go to the repair screen. We are using Windows Server 2012 R2.

Windows Server 2012 R2 – A fatal alert has been received from the remote endpoint. The fatal alert code defined by TLS is 46

Our system event is saturated with this error. Whenever someone reaches our website deployed on the Windows 2012 R2 server with IIS 8.5, this error is logged in the system event.

A fatal alert has been received from the remote endpoint. The fatal alert code defined by the TLS protocol is 46.

Please, someone helps me solve the online search, but no suitable solution.

Hardware – MacBook Air 2012 screen crashes immediately, can it be fixed?

Yes – this is eminently repairable and easy to diagnose from a distance as you describe a typical and physical failure of the hinge clutch.

The good news is that you can buy Macs damaged by broken liquids / motherboards that are vintage for a very low cost and may know that the screen assembly is correct when booting for recovery or by simply trusting the seller.

Swapping the entire screen is fairly easy, but to access it, there are many delicate and flimsy connectors that can break the rest of your Mac if you're not careful or don't care. Have no help holding things. In addition, you must remove the battery, which can be bent / damaged and cause a fire hazard.

It is also a very easy repair for someone who does repairs professionally and who can get parts cheaper than you in most cases. They're right, you can't just fix the hinges – you need an exceptionally solid press that costs a lot more to do than buying hundreds of screens.

You may break the LVDS cable if there is a broken sharp piece, so in the short term you should use it in closed mode with an external display and the baby while you decide if it worth $ 300 to fix it.

Windows Server 2012 R2 – PowerShell exception – PS: unable to find a process with the name "C: UserPath". Check the process name and call the cmdlet again

Please note that I have omitted the actual user path, indicated by *

What am I trying to achieve?

My desired result is a PowerShell script which allows me to generate a WSUS report of the necessary Windows updates containing my selected variables:

PS C: UserPath * ### Provide configuration data ###

$ TargetGroup = "Computers not assigned"

$ WSUSServer = "name of my WSUS server" *

$ Severity = "Critical", "Security"

$ Product = Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Office 2019, Office 365 Client, Windows 7, Windows Internet Explorer 7 Dynamic Installer, Windows Internet Explorer 8 Dynamic Installer, Windows Server 2003, Datacenter Edition, Windows Server 2003, Windows Server 2008 R2, Windows Installer 2008 Server Manager Dynamic Installer, Windows Server 2008, Windows Server 2012 R2 and later, Windows Server 2012 R2, Windows Server 2012 R2, Windows Server 2012, Windows Server 2016 and later, Windows Server 2016, Windows Server Drivers, Windows Server Manager – Windows Server Update Services (WSUS) Dynamic Installer

Error 1

Currently, this shows me this as an error:

PS: unable to find a process with the name "C: UserPath *>". Check the
name of the process and call the cmdlet again.
In C: WSUSReport_Critical_Security_Defined_Products.ps1: 1 char: 1
+ PS C: UserPath *> ### Provide configuration data ###
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~

  • CategoryInfo: ObjectNotFound: (C: UserPath *: String)
    (Get-Process), ProcessCommandException
    • FullyQualifiedErrorId: NoProcessFoundForGivenName, Microsoft.PowerShell.
      Commands.GetProcessCommand

macos – Offset of the 2012 MBP 4k external monitor

I'm running an MB7 i7 / 16 GB 2012 (in discrete graphics mode) with display port on a 4k monitor at 30 Hz. I understand that the "jump" of the mouse is part of the 30 Hz setting, but I feel also a noticeable lag in the user interface and videos; 1-2 seconds skips moving windows, etc. which I wouldn't attribute to the refresh rate. I monitor the usage of the processor / ram / gpu, and the processor / ram does not exceed 30%, and even the gpu does not exceed 70%. Can anyone shed light on this situation?

Server 2012 MS update causes a startup loop – How to stop or diagnose?

Running an EC2 instance with Server 2012. Windows is set to Automatically install updates. I do not know which update the cause, but it was installed after December 1st. When this update restarts the server, the server enters a startup loop where it returns for 20 seconds, and then goes back down. I can't RDP to it given the short window. The root drive restore in the December 1 version is working, but with the automatic updates installed, I'm afraid it will not go down again. I disable automatic updates for the moment.

Here is a screenshot of the version of the player 12/1 and "Check Updates" executed. There are 2 "important" that I guess are the only ones that are self-installed, and 3 option.
Important: https://imgur.com/a/Nw8cmDY
Optional: https://imgur.com/a/jK9P3V5