Archives for Software Dev - Page 45
Changing default font in Outlook
I do not like the default Outlook fonts. I prefer Palatino Linotype for all my new messages. In addition, I like to specifically mark MY responses – in an email…
Changing existing powerpoint slides to widescreen
If you are stuck with a non-widescreen template (theme), you may still be able to show your LIVE presentation in widescreen mode. This can be done by: Click the…
SQL Server–Multiple Instances on same physical server
If you need instance separation – that is – you want to isolate two different databases completely – while hosting them on the same physical box, you can install SQL…
Some iPhone Tips
Restoring iCloud data onto a new iPhone Settings—> General –> RESET –>REset all settings –> Will delete all your local data. Now, it is ready to be setup as a…
Changing Powerpoint Theme ( changing template)
What used to be Applying a new template to an existing powerpoint presentation, has become Changing the theme for an existing presentation. Step 1 – Open SLIDE MASTER (Under…
sql aggregates and group by
When you select an aggregate (such as count (*), ) you also need to do a group by on the results. Select ,count() as NumberOfBooks from AUTHOR a join BOOKS…
Excel–grouping a column by specific values (and performing aggregates)
Grouping column by its values - and getting an accurate count (or sum) Select the Column Click the Data tab (or press Alt-A on keyboard) Click Subtotal icon (or press…
To NOT show the wrapped text as ############ in excel
To NOT show the wrapped text as ############ in excel The cell formatting is set to text as it should be. Change it to That fixes it.
Winning eBay Auctions
Do not place a bid – wait till the last 10 seconds of the auction. Think of your MAX bid – a lot higher than the current bid. This is…
Thinking of (Free) WordPress on EC2?
This is the summary of my research (skip to the end) - VERY easy to setup, VERY hard to manage – and NOT ENTIRELY FREE. Installing Plugins and Themes There…