Create a mysql database
12345$> mysql -u ‘root’ -p mysql> create database atestdatabase; mysql> create user ‘myuser’@’localhost’ identified by ‘secret’; mysql> grant all on atestdatabase.* to ‘myuser’@’localhost’;
Windows 8 Enterprise Activation Error “DNS name does not exist”
When trying to activate Windows 8 Enterprise, the error “DNS name does not exist” is shown. To resolve this, issue the following command from an elevated permissions command prompt. 1slmgr.vbs …
Resize VirtualBox Hard Drive (Windows 7)
To resize the Windows VM Disk issue the command (where size is in MB): 1$ VBoxManage modifyhd Windows7.vdi –resize 30720 Afterwards, boot the VM and use Control Panel -> Administrative …
Oracle impdp ORA-00439: feature not enabled: Deferred Segment Creation
When getting the following error when using impdp: 1ORA-00439: feature not enabled: Deferred Segment Creation Alter the impdp syntax (add the version): 1impdp user/secret@ORACLE11G schemas=USERSCHEMA directory=export_dir dumpfile=export.dmp logfile=output.log version=10.2
Oracle data pump export not including 0 row tables
Oracle 11gr2 Enterprise data pump export does not include 0 row tables 1C:\> expdp user/secret@SID DUMPFILE=out.dmp SCHEMAS=user LOG=out.txt To correct, extend 0 row tables: 1SELECT ‘ALTER TABLE ‘ || TABLE_NAME …
Install 11g (11.1.0.6) Oracle Client on Windows 7
http://msutic.blogspot.com/2009/08/how-to-instal-oracle-client-11g-on.html Shortly after initiating installation of Oracle Client 11g (11.1.0.6.0) installation stopped on prerequisite checks with error: Checking operating system requirements … Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1 …
Redirect HTTP to HTTPS IIS
Redirect http to https in IIS. a. Run the control panel, administrative tool, server manager. Click the “Configure IE ESC” link and turn ESC off for Administrators. b. Run Internet …
Oracle determine what tables have rows
To determine what tables contain row data 12345SELECT table_name, num_rows FROM all_tables WHERE owner IN (‘USER’) AND num_rows > 0 ORDER BY table_name;
LOC Visual Studio
Visual Studio 2010 and higher has this built in: Analyze > Calculate Code Metrics Visual Studio Plugin: http://www.wndtabs.com/ Powershell (counts non blanks): 123PS C:\> (dir -include *.cs,*.xaml -recurse | select-string …
SMTP email through Microsoft 365 via C#
An example of how to use the System.Net namespace to send emails (useful for ssl or tls mail servers). 1234567891011121314151617181920SmtpClient server = new SmtpClient("Smtp.mail.microsoftonline.com"); server.Port = 587; server.EnableSsl = true; …