Most of our problems are small compared to landing a rocket on the moon. Something that was done in 1969. Today, whatever the problem is that you are working on, most likely, it has been solved by someone. So in most cases, you don’t have to figure out the solution yourself, you just need to find if someone documented the solution. For that reason I am keeping this link list. It keeps a record of useful links I found over time. I find myself referring to the content of these links regularly.
Productivity
Scott Hanselman on scaling yourself (Youtube) This is the video that inspired the creation of this blog. I like this video because it goes through a number of different ideas and rationalization for those ideas that would all work by themselves. So you don’t have to start with all of them at once.
Scrum
Henrik Kniberg on product ownership in agile scrum methodology (Youtube) The best introduction video to scrum agile. What I like about this video is that it emphasizes the importance of having a product vision. Something I also agree with.
SQL Server
Brent Ozar How to Think Like the SQL Server Engine You’ve been working with Microsoft SQL Server for a while and you need an understanding of the fundamentals of query plans and indexes.
Brent Ozar on statistics in the database engine (Youtube) An explanation of how and when statistics are build up and how the database engine uses them.
The Dangers of using Float or Real Datatypes gives nice examples to show what goes wrong when using floating point datatype. Floating Point Errors gives a detailed explanation about what is going on under the hood when you store a value as a float.
Programming
Scott Hanselman tells you about computer stuff they did not teach you (Youtube) There is a little something in here for everyone. If you are looking for an explanation about Git, watch video nr 4 to 8.
On this Microsoft learn page you will find a lot of useful tips on comparing strings in C#. Before you write another line of code, you should read through this!
Scott Hanselman dissects three lines of code to explain about the pitfalls in date calculations and comparisons. If you’re ever tempted to do a ‘clever’ date calculation, watch this first and think again.
Developer Blogs
Scott Hanselman writes about a broad range of software development topics, personal productivity and whatever else comes accross his mind.
Pull request reply links
Whenever you see SELECT * Brent Ozar: The Perils of SELECT *