123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354# 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 …
Cloudflare Analytics are available for 1 Year through the API Get the zones listing 1curl -X GET "https://api.cloudflare.com/client/v4/zones" -H "Authorization: Bearer secret" -H "Content-Type:application/json" Get stats on a zone 1curl …
Microsoft SQL Server Database status Recovery pending 1234567891011ALTER 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 …
12345SELECT * 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 )
1234567891011121314151617181920212223db.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}, …
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 …
Determine the size of database tables in a MSSQL Server Database. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
Original Source Link 1234567891011121314151617181920212223242526272829303132COLUMN 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 …
12345678static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
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 123substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …
