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 …
Restart Cortana via Script
1taskkill.exe /S PCNAME /IM SearchUI.exe Schedule in task scheduler, tell to run only if logged into PC and set to run at highest privilege level.
Most Useful Git Commands
Useful Log git log –pretty=format:”[%an]|%h|%ad|%s|%d” –date=short Set your details git config –global user.name “John Doe” git config –global user.email “[email protected]” Use –global to set the configuration for all projects. If …
Parsing VSS History Files
Parse those nasty VSS history files. Put them in a format more suitable for Gource. 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; namespace ConsoleApplication2 { …
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