Powershell Check SSL Certs
# set some constants for the script # min cert age is 60 days, print in red if the cert is going to expire in 60 days or less $minCertAge …
Query Cloudflare API
Cloudflare Analytics are available for 1 Year through the API Get the zones listing curl -X GET "https://api.cloudflare.com/client/v4/zones" -H "Authorization: Bearer secret" -H "Content-Type:application/json" Get stats on a zone curl …
MS SQL Database Recovery Pending
Microsoft SQL Server Database status Recovery pending ALTER DATABASE [DBName] SET EMERGENCY; GO ALTER DATABASE [DBName] set single_user GO DBCC CHECKDB ([DBName], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS; GO ALTER DATABASE [DBName] set …
MSSQL Blocked Queries
SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) where session_id IN ( SELECT blocking_session_id FROM sys.dm_exec_requests WHERE DB_NAME(database_id)=’AIMS’ and blocking_session_id <> 0 )
Query MongoDB
db.getCollection(‘logs’).find({ "datetime" : { $lt: new Date(), $gte: new Date(new Date().setDate(new Date().getDate()-1)) } }) db.getCollection(‘plocsec_capacity’).find( {$and: [ {plocsecid:338}, …
Oracle Managed Driver
1). Launch Visual Studio and install OMD – Click Tools > NuGet Package Manager > Package Manager Console – Type: Install-Package Oracle.ManagedDataAccess – Locate the dll Oracle.ManagedDataAccess.dll and copy it …
TSQL Determine Table Size
Determine the size of database tables in a MSSQL Server Database. SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
PL/SQL Determine Table Size
Original Source Link COLUMN TABLE_NAME FORMAT A32 COLUMN OBJECT_NAME FORMAT A32 COLUMN OWNER FORMAT A10 SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE …
Convert RTF data to unmarked up string
static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
TSQL is decimal an INT
Determine if a decimal number can be converted to an INT without any loss of precision. Check if either of the rightmost two digits are non-zero substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …