SQLTip

@SQLTipOfTheDay

Joined January 2018

121Posts 8Followers 1Following

You might like

@FX_LARROCHE

@rauldelcampo_

@ScottSata

@scottpetersen

@DougStanley14

@IBasskung

@PabloZaiden

@cybercopsindia

@MeenaDehri

SQLTip

@SQLTipOfTheDay

Jan 16, 2024

#sqltip #powershelltip #dostip #checkport powershell tnc <hostname> -port <num> e.g. tnc winpc1 -port445 "WARNING: TCP Connect to winpc1:445 failed"

SQLTip

@SQLTipOfTheDay

Jul 22, 2023

#DOSTip #BatchScript #ErrorLogging set "Var1=abc<def<ghi" echo %Var1% abc<def<ghi @rem-- Redirect output to file, and error messages echo Test1 > logfile.out 2>&1

#sqltip #snowflaketip #loginerrors USE DATABASE SNOWFLAKE; SELECT * FROM ACCOUNT_USAGE.LOGIN_HISTORY WHERE USER_NAME = 'username' AND EVENT_TIMESTAMP > DATEADD('day', -1, CURRENT_DATE) ORDER BY EVENT_TIMESTAMP DESC LIMIT 100;

SQLTip

@SQLTipOfTheDay

Oct 28, 2022

#sqltip #snowflaketip #Role #SFJJSON SELECT CURRENT_AVAILABLE_ROLES(); SELECT "SEQ","KEY","PATH","INDEX","VALUE","THIS" FROM TABLE ( FLATTEN (INPUT => PARSE_JSON( CURRENT_AVAILABLE_ROLES() ) ) ) WHERE "VALUE" LIKE '%<dbname>%' ;