Archives for Language features, Development Methodologies - Page 15
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…
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…
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…
SQL Server Licensing – Processor versus Client Access Server licensing
Suppose you have a web app that connects to the SQL Server instance using a PREDEFINED SQL Server user (typically an ‘sa’ user). This is the ONLY user that actually…
Insert documents in Outlook Body
For some reason, I prefer the inserts to be in the body as opposed to attachments. They are easier to get to (by the recipient) and they can be placed…
LINQ–search for items in a list that are present in another list
Suppose you have a list of strings – a nursery rhyme may be a good ; And you need to find ALL the words that match from another list of…