45 subscribers

Software Dev
  |  Science Stuff  |  Travel  |  Golf  |  Entertainment  |  Mindfulness  |  Finance and Investing  |  Austin  |  India  |  Diet, Health  |  Petitions, Causes  |  Miscellaneous  |  SaaS  |  Technology  |  

Lessons learnt from the world of Software Development, Object Oriented Design and .NET Architecture.

Changing Powerpoint Theme ( changing template) | Posted on by Anuj Varma

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 the File Menu)

Step 2 – View the THEME (and change it by … Continue reading

WordPress on Azure–Some Tips | Posted on by Anuj Varma

I finally dumped GoDaddy for hosting wordpress (they removed the ability for customers to create support tickets, and somehow promised that this would be a good thing (it wasn’t) and improve incident response time (It didn’t -  my incidents never … Continue reading

sql aggregates and group by | Posted on by Anuj Varma

When you select an aggregate (such as count (*), )  you also need to do a group by on the results.
Select a.Name,count(b.title) as NumberOfBooks from AUTHOR a join BOOKS b on a.ID = b.AuthorID group by a.Name   (this finds the … Continue reading

Azure website , Godaddy domain | Posted on by Anuj Varma

It took me a good 4-6 hours to figure this crap out – so I thought I might as well write a post (in case I need to do it  again). Your domain is registered with goDaddy (or any other … Continue reading

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 B on keyboard)

To NOT show the wrapped text as ############ in excel | Posted on by Anuj Varma

To NOT show the wrapped text as ############ in excel
The cell formatting is set to text as it should be. Change it to SPECIAL.. That fixes it.

Winning eBay Auctions | Posted on by Anuj Varma

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 because – in the last few seconds – everyone will try … Continue reading

Thinking of (Free) WordPress on EC2? | Posted on by Anuj Varma

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 is a 2MB media upload limit
Plugins and themes and uploading to … Continue reading

Adding CHECK mark symbols in Powerpoint | Posted on by Anuj Varma

“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 list of wingdings font symbols.
That’s it  – pick the check mark … Continue reading

Intellisense disappears after Resharper Uninstall | Posted on by Anuj Varma

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 Visual Studio. Try restarting VS and see if you recover … Continue reading