For one of my applications I had a simple task: the business needed an easy way to download all PDF files we create in various places inside our application. Offering them one single button who combines all those different files into one big PDF looked like a good idea. Little did I know about all the obstacles I had to overcome to get it done.
One of the simplest improvements for an efficient environment is to define the technology stack you want to use at your company. A little bit of upfront documentation can safe you endless discussions at the start of a new project. Instead of debating what framework you could use, you check if the one you defined is a good fit. Only if this is not the case you go and search for an alternative. Let’s look how you can define your own stack.
How long does it take to learn something? Not 10,000 hours, as many people think. If Josh Kaufman is right and you do not aim to be one of the best performers of that field, you may get away with just 20 hours of deliberate practice. Does it sound too fantastic? It is all a question of how good and comfortable you want to feel by doing it – and how you spend those 20 hours.
Whenever someone talks about learning, it is only a matter of time before someone mentions the 10,000 hours rule by Malcolm Gladwell. His book "Outliers: The Story of Success" is most famous for this rule that after a telephone game ended up being quoted along those lines:
To learn something, you need to spend 10,000 hours doing it.
Knowing just a few keyboard shortcuts can improve your workflow dramatically. That is true for a general-purpose tool like Microsoft Office and even more for Visual Studio. The only question is where to start, then Visual Studio can not only adapt to your needs but also change its shortcuts completely.
Visual Studio Team Services (VSTS) offers a very useful but well-hidden feature: you can have more than one code repository per project. What seams not that interesting can help you to separate code with a different lifecycle and reduce your administrative work. Let's have a look on how you can use this feature.
The SQL Server Integration Services (short SSIS) are a great tool to move data around. Not only are they fast, they have many useful parts to make data migration a simple task. The same is true for their production use. Cleaning up their own database is a feature that most applications completely ignore. All is set-up in a way that SSIS can run for a long time without user intervention.
Humanizer is a nice library to get human readable representations for strings, numbers and dates in .Net. Cutting strings down to a certain size or turning a TimeSpan into "an hour" isn't magic. Nevertheless, trying to do all that work on your own will take time that Humanizer has already spent. Let's look on a few use cases where this library has proven to be a great help.
Not every design decision for your database will pass the test of time. Better names pop up or sometimes you just created a table in the wrong place. You could throw everything away and start from scratch, but a much better approach is just to fix what is wrong. If you want to move a table to another schema, you can use this SQL Server command:
With every newly installed Windows Server, I run into the same problem:
