Archives for Software Dev - Page 42
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…
Changing Local Working Folder in TFS
Changing your local working folder essentially involves creating a NEW WORKSPACE. The LOCAL folder for that workspace can be set to the new working folder that you are interested in…
Some important server perfmon counters to monitor
Some of the more important ones include: Processor: Processor\% Processor Time (This counter is the primary indicator of processor activity. High values many not necessarily be bad. However, if the…
Changing Outlook’s Theme–making it less bright
Outlook’s default color scheme is far too bright and hurts the eyes. Fortunately, some other themes are built into the product. To get to these options, navigate from the File…