Why are column store indexes disabled automatically when a database is restored?

I have recently done a server migration where we backed up and restored all the databases from a SQL Server 2012 version to SQL Server 2019. However the restored databases appear to all have their column store indexes disabled by default.

Is this expected behaviour? If so, why?

These are archive databases used for selects only, rebuilding every clustered index is going to take a significant amount of time. Any other options?

(sorry, I asked this in the wrong place here. Can that question be removed?)

Has a recent patch disabled TLS1.2 and/or RSA on Internet Explorer?

Our office intranet has from today started refusing access from Internet Explorer 11 (necessary as it uses plugins) to a certain page. The error I get in IE is in Japanese, but talks about old TLS versions. If I look at the page with Chrome, on the Security page

Connection – obsolete connection settings

The connection to this site is encrypted and authenticated using TLS 1.2, RSA, and AES_256_GCM.

RSA key exchange is obsolete. Enable an ECDHE-based cipher suite.

I know that the deprecation date for TLS 1.2 has been extended due to COVID-19, but a recent patch seems to have fixed CVE-2020-1118, but in the process might it have broken something else? Note, I do allow TLS 1.2 connections in IE.

Chrome: why is invalid certificate usage for resources loaded from localhost disabled?

In chrome there is a flag called: allow-insecure-localhost. As far as I can tell all it does is block localhost connection over tls if the certificate is self signed.

Why is this feature turned off by default? Does it affect regular users in any way (regular user = someone who is not developing something). Are there any serious cases of localhost connection being used malicious that could have been prevented by having this option enabled?

Access SATA disk disabled in BIOS

If a remote hacker or a malware gains full root/admin rights on a system, is there any way to access another SATA disk that has been hardware connected but disabled in BIOS ?

I am not sure if the disabled disk even has power in that case (I guess it has not) but I found the following post which raised some doubts : https://superuser.com/a/111009

OS considered : Windows or Linux

Threat Model : Physical access and BIOS reflash are out of scope as it is game over anyway in such cases.

Except this, consider full control of compromised disk system: hacker can issue any command, can modify MBR, kernel, flash the compromised disk firmware, …

How can access to Intel ME / AMT be disabled with firewall?

Short of flashing BIOS, there seems to be no way to disable the Intel ME.

So, is there a reliable way to block access to Intel ME, such using HW firewall (Firewall in front of the machine, not running on the same machine)?

If Intel ME was used legitimately, how exactly would it be accessed ?

Would it be access using the same IP (and same MAC address) as the normal NIC, or does it have separate interface ?

How could I on the firewall distinguish between traffic going to main NIC, ant traffic going to Intel ME ?

Would disabling the onboard NIC, and using some other PCI NIC help ?

Why is it so hard to find description how Intel ME actually works ?

I just need basic info, and cannot find in nowhere online.

Active or Disabled action button in a mobile form?

I have a “change password” screen where the user’s password has expired and he/she has to change it. it’s a standard screen with “New password” and “Re-type new password” fields, with an inline validation that checks whether the password guidelines are met (while the user is typing): 8 characters, 1 digit, 1 number, 1 special character.

we have an argument whether the main “change password” action button should be disabled until all the validations are clear, or to keep it active and provide an error message if needed.

what do you think is better?

The form cannot be displayed in browser because use of session cookies has been disabled in the browser

I am new in SharePoint. I’m receiving the following error while accessing SharePoint online form using c-sharp

“The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed.”

I also tried with following attempts, but did not found solution.

  1. Enabled the session cookie in the browser.

  2. Added the httpOnlyCookies tag and set to false in web.config

Thanks in Advance