Disable Intellisense for SQL files in Visual Studio
.sql files that are for reference only throw ‘errors’ in the VS error window. Since the sql files are not actually utilized within the program and also contain Oracle PL/SQL, …
Customize XtraReport with C#
Use the scripts window of the report designer private void lblAccountName_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { XRLabel l = (XRLabel)sender; string s = l.Text; s = TitleCaseString(s); l.Text = s; } …
wget with Powershell v2
1PS:> (new-object System.Net.WebClient).DownloadString("https://www.google.com") >> output.txt The URL should have http or https or web client will look for a file on disk. Powershell 3 and higher has other ways of …
IIS Maintenance Page
To force IIS to display a maintenance page to all page loads: create a file app_offline.htm in the wwwroot directory.
Error Installing Oracle 11.2.0.1
During the install, the error “OS error in starting service oraclemtsrecoveryservice” To resolve, edit registry key: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\Ora cleMTSRecoveryService\Protid_0] Edit the Host key and set to the machine name.
MS SQL Determine Enterprise Features
Use the following to determine if your MSSQL database has features only available in enterprise versions of the product (partitioning, compression, encryption, etc). 1select * from sys.dm_db_persisted_sku_features
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; …