SQL Server: how to disable a Linked Server

DECLARE @Linked_Server_Name sysname = 'SRVZUC02\SQLEXPRESS'

-- check the existent linked servers
SELECT s.is_data_access_enabled, *
FROM SYS.SERVERS s
WHERE s.NAME = @Linked_Server_Name


-- Disable data access
EXEC sp_serveroption 
      @server   = @Linked_Server_Name
	, @optname  = 'data access'
	, @optvalue = 'FALSE'


-- check the existent linked servers
SELECT s.is_data_access_enabled, *
FROM SYS.SERVERS s
WHERE NAME = @Linked_Server_Name

Found here.

About procedure [sp_serveroption] on SQL Docs.

HOWTO configure Windows Firewall for SQL Server

New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow

New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow

NOTE: Remeber to activate the SQLServer Browser service.

Adobe Acrobat: Copiare i form fields da un PDF ad un altro

Non bisogna copiare i campi ma, partendo al vecchio file, sostituire le pagine "sotto" ai campi modulo:

Are you familiar with using Replace Pages as a tool for keeping your form designs, while replacing the page backgrounds? It sounds exactly what would save you a lot of time.

Found here.