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 default font in Outlook | Posted on by Anuj Varma

I do not like the default Outlook fonts. I prefer Palatino Linotype for all my new messages. In addition, I like to specifically mark MY responses – in an email chain – so that people do not confuse who said … Continue reading

Changing existing powerpoint slides to widescreen | Posted on by Anuj Varma

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 Design tab, and then click Slide Size.

Change from Standard (4:3) to Widescreen … Continue reading

SQL Server–Multiple Instances on same physical server | Posted on by Anuj Varma

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 Server multiple times on the same box. This does incur … Continue reading

Cloud Foundry–a better option for Apps as a Service (PaaS) | Posted on by Anuj Varma

Cloud Foundry – An alternative PaaS – competes with Elastic BeanStalk and AppFabric from Azure.
Cloud Foundry PaaS supports apps written in Ruby, Node.js., and Java
Developers can add their own applications and runtimes by building Custom Buildpacks

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.