Lessons learnt from the world of Software Development, Object Oriented Design and .NET Architecture.
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.
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
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
“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
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
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 creating
Click on TFS Source Control Explorer , there should be … Continue reading