Archives for Software Dev - Page 46
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…
Adding CHECK mark symbols in Powerpoint
"Insert" from the top menu of PowerPoint "Symbol" from the set of options. Find "Wingdings" from the "Font" drop-down menu. The check mark symbol is towards the end of the…
Intellisense disappears after Resharper Uninstall
I lost Intellisense – and had some trouble getting it back. One thing to try is to delete the .suo file (usually at the Solution level) – after shutting down…