Lessons learnt from the world of Software Development, Object Oriented Design and .NET Architecture.
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
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
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 – 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
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
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
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
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
The cell formatting is set to text as it should be. Change it to SPECIAL.. That fixes it.