One of my standard questions I ask when interviewing a candidate with some database or SQL know how is: Assume you have a fairly complex select statement operating on some serious tables (tens of millions of rows). The customer complains the SQL statement is to slow. What options would you consider for tuning such a [...]
I am writing this during a chess tournament for kids and I just talked to a mother, which triggered this post. When her son made a mistake which resulted in loss of his queen and as a result loss of the game she said: “I better don’t talk to him. I’d only scold him for [...]
You want to become an even better developer? Then you must read these books. If you have already read them. Read them again. Design Patterns. Elements of Reusable Object-Oriented Software: This is the standard book on patterns and patterns are an extremely important piece of vocabulary for every developer. Not to impress coworkers with your [...]