Solving tech problems

Microsoft .NET to run on Linux and Mac OS X

Learning, Products and Services, Programming, Technologies

Microsoft .NET will finally run fully on Linux and Mac OS X platform and this is a great news. Visual Studio is maybe the best tool for developers and Microsoft decided to open sourcing the full server-side .NET Core stack, from ASP.NET 5 down to Core Runtime and Framework. Microsoft is also giving for free Visual Studio Community 2013 full featured edition of Visual Studio, available today. You can watch more about this here. Open source links ASP.NET – https://github.com/aspnet/home .NET Compiler – https://roslyn.codeplex.com/ .NET Core – https://github.com/dotnet/corefx .NET –…read more

How to delete duplicated records in MS SQL Server?

Databases, Programming

First, create one demo table Let’s create one demo table first. It will be called Person and will hold some fictive person data. Now, fill the data Insert some fictive person data and do some duplicated records that have the same values for fields  firstname, lastname and email. Now the magic Use this subquery trick to extract duplicate records and then delete them. Notice the use of PARTITTION and WITH Transact-SQL keywords. All records that have RowNumber > 1 are deleted.

How to escape parenthesis/brackets ‘{‘, ‘}’ in string.Format?

Programming

Usually you have something like this: string.Format(“Output: {0}”, “A”); This will result as: Output: A What you should do if you want to make an output like this? Output: {A} You need to escape parenthesis/brackets like this: You use {{ to output { You use }} to output } So, you final C# command should look like this: string.Format(“Output: {{{0}}}”, “A”);

Daily project: Automatic Twitter status updater

Programming

I like to read great quotes, because they express the wisdom and the creativity of human race. So, I was thinking how I can share them automatically on my Twitter account. First task was to find out the source of great quotes and RSS/Atom feeds are perfect data source to complete this task. After some researching I found out few publicly available sources on BrainyQuote.com: Quotes of the day: https://feeds.feedburner.com/brainyquote/QUOTEBR Love quotes: https://feeds.feedburner.com/brainyquote/QUOTEFU After having the source all we need to do now is to parse these RSS feeds and…read more

Scrum and Kanban development frameworks

Learning

Just returned from the very interesting lecture (by Dušan Omerčević from Zemanta and Andrej Zrimšek from NiceLabel) about Scrum and Kanban development frameworks here in Ljubljana, Slovenia and I am right now thinking about what I heard there and comparing with our approach, what we are doing in out development process. What I like is this: Developers protection from new feature requests while they are in one Sprint cycle. We have this problems all the time (adding new features and breaking the release date agreement). What was agreed this exactly…read more