To add an inline image to an email you are composing in Gmail: Make sure rich text editing is turned on in the Gmail message you are composing and Insert images is enabled. If you see a Rich formatting » link above your message’s text editor, click it. See below for turning on image insertion. […]
Month: August 2009
Submit Your Blog to Google, Yahoo and Other Search Engines
Submit your blog url to Google at: Add your URL to Google. A better idea is to add a Google sitemap to your blog. Go to Adding Google sitemap to your blog to learn how. You may also submit your blog to Google Base and include a link back to your blog. You may also […]
Creating Bootable Vista / Windows 7 USB Flash Drive
This will walk through the steps to create a bootable USB flash drive. These instructions assume that you are running Windows Vista or Windows 7. Required: USB Flash Drive Microsoft OS Disk (Vista / Windows 7) A computer running Vista / Windows 7 Step 1: Format the DriveWarning: This will erase everything on your USB […]
Amazon CloudWatch Commands
Amazon CloudWatch Commands Enable monitoring for an instance: ec2-monitor-instances instance_id [instance_id…] Disable monitoring for an instance: ec2-unmonitor-instances instance_id [instance_id…]
Free, Encrypted Password Storage
Password Safe allows you to safely and easily create a secured and encrypted user name/password list. With Password Safe all you have to do is create and remember a single “Master Password” of your choice in order to unlock and access your entire user name/password list.
Display List of MS SQL Database Tables
use <DatabaseName>select * from information_schema.tables Example: use myDatabaseselect * from information_schema.tablesorder by table_name
Shrink (truncate) Microsoft SQL transaction log files
Shrink (truncate / purge) MS SQL transaction log files. Use <dbname>Goalter database <dbname> set recovery simplegodbcc shrinkfile (<dbname>_log, 100)gocheckpointgodbcc shrinkfile (<dbname>_log, 100)alter database <dbname> set recovery fullgo Example: Use myDatabaseGoalter database myDatabase set recovery simplegodbcc shrinkfile (myDatabase_log, 100)gocheckpointgodbcc shrinkfile (myDatabase_log, 100)alter database myDatabase set recovery fullgo
View logical log filename and physical location for MS SQL database files
View logical log filename and physical location (current DB only).select physical_name from sys.database_files where type = 1 View logical log filename for all DBs: select a.name, b.name as ‘Logical filename’, b.filename from sys.sysdatabases ainner join sys.sysaltfiles bon a.dbid = b.dbid where fileid = 2
View SQL DB log size and space used
View DB log size and space used. use dbcc sqlperf(logspace) Example: use myDatabase dbcc sqlperf(logspace) MSSQL
AWS Elastic Load Balancing
Elastic Load Balancing provides round robin web call distribution across a set of identical web instances. In addition to ease of administration it keeps an eye on the health of instances in the pool and auto routes traffic around any problem instances that show up. Here is the summary from Amazon. Elastic Load Balancing – […]