Archives for Language features, Development Methodologies - Page 15
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…
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…
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…