ststeiger

This is how to fix this error:
An HTTPS binding already exists for the specified IP address and port combination!

netsh http show sslcert

if too long

netsh http show sslcert > sslcert.txt

ststeiger

The SQL Browser service typically listens on UDP port 1434. 
When a client application requests connection information for a specific instance name, 
it sends a query to the SQL Browser service on port 1434, 
which then responds with the port number associated with the requested instance name.

If the UDP port 1434 is blocked by a firewall, the instance name to port lookup may fail, 
resulting in connection issues when using instance names. 
In such cases, connecting using the port number directly (e.g., SQL17,2673) 
might work if the firewall allows traffic on the specific port.

ststeiger

namespace ExportDatabase
{ 


    class AmHoliday
    {


        public static System.DateTime Thanksgiving(int year)

ststeiger

SELECT 
	 deqs.last_execution_time AS [Time] 
	,dest.TEXT AS [Query] 
FROM sys.dm_exec_query_stats AS deqs 
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest 
ORDER BY deqs.last_execution_time DESC 

ststeiger

SELECT 
	 SYSLANG_LCID
	-- ,SYSLANG_Name 
	,SYSLANG_IetfLanguageTag AS IETF 
	--,SYSLANG_TwoLetterISOLanguageName 
	--,SYSLANG_ThreeLetterISOLanguageName 
	--,SYSLANG_ThreeLetterWindowsLanguageName 
	
	,SYSLANG_EnglishName

ststeiger

;WITH CTE AS 
(
	SELECT 
		 0 AS i 
		,CAST('A0' AS varchar(10)) AS paper_format 
		,841e AS width 
		,1189e AS height 
		 
		,841e AS orig_width 
		,1189e AS orig_height 

ststeiger

-- https://www.mssqltips.com/sqlservertip/6828/sql-server-login-user-permissions-fn-my-permissions/

-- List all permissions
-- SELECT * FROM sys.fn_builtin_permissions(DEFAULT);

-- SELECT DISTINCT permission_name FROM sys.fn_builtin_permissions(DEFAULT) ORDER BY permission_name;
-- show the different classes 
SELECT DISTINCT parent_class_desc FROM sys.fn_builtin_permissions(DEFAULT);
-- SELECT * FROM sys.fn_builtin_permissions(DEFAULT) WHERE NULLIF(parent_class_desc, '') IS NULL; 

ststeiger

wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.0g-2ubuntu4_amd64.deb
sudo dpkg -i libssl1.1_1.1.0g-2ubuntu4_amd64.deb

ststeiger

SELECT 
	 base_sch.name AS object_schema 
	,base_obj.name AS object_name 
	,base_obj.type_desc object_type 
	 
	,ref_sch.name AS ref_schema 
	,ref_obj.name AS ref_name 
	,ref_obj.type_desc AS ref_type 

ststeiger

-- https://satoricyber.com/postgres-security/postgres-row-level-security/
-- https://www.enterprisedb.com/postgres-tutorials/how-implement-column-and-row-level-security-postgresql

CREATE TABLE information_under_dataprotection_law
(
     id int not null constraint pk_information_under_dataprotection_law primary key 
	 ,tenant_id int not null
	 ,txt national character varying(4000) not null
	 ,val float not null
);