Archives for Software Dev - Page 42
iTunes 12 doesn’t Recognize My Device on Windows 7
I upgraded to iTunes 12 – only to find that my devices were no longer recognized by the new iTunes. I went through all the blogs, all the apple troubleshooting…
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…