Sourcegear Vault Troubleshooting
1). When an error is generated. Such as when trying to do a page load of Vault Admin 2). Check the Vault error log on the Vault server Windows\Temp\sgvault\sgvault.log 3). …
Install VMWare Tools Ubuntu 12.04
Ubuntu Server with only a command line interface 1). Go to Virtual Machine > Install VMware Tools (or VM > Install VMware Tools). Note: If you are running the light …
VMWare ESXi 5.5 sshd
To enable sshd on ESXi 5.5 1). Login to vSphere 2). Click the host > configuration > Security profile 3). Click Services > Properties 4). Select SSH > Options 5). …
Oracle 12c Create PDB User
Oracle 12.1.0.1 Standard, create a user for a specific PDB. 1234567891011121314151617181920C:\> sqlplus SYSTEM@oracle12 Enter password: ******** SQL> SELECT PDB FROM v$services; PDB ———– MYDB CDB$ROOT SQL> ALTER SESSION SET container=MYDB; …
TSQL Determine Table Size
Determine the size of database tables in a MSSQL Server Database. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
PL/SQL Determine Table Size
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 …
Convert RTF data to unmarked up string
12345678static 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 123substring(convert(varchar(10), a.DebitAmount), len(convert(varchar(10), a.DebitAmount)) …
TSQL List all Columns in a Database
1234567891011121314151617Declare @Table_Name VarChar(100) ,@Column_Name VarChar(100) Set @Table_Name = ” Set @Column_Name = ” Select RowNumber = Row_Number() Over( PARTITION BY T.[Name] Order By T.[Name],C.column_id ), SCHEMA_NAME( T.schema_id ) As SchemaName …
EC2 Terminology
EC2 Terminology