All the posts ordered in chronological order. The further down you go the older the post.
I do not mean to offend anyone. But it’s very symptomatic and evident that people forgot the complexity of the work we do and the problems we try to solve. I can see numerous example of people that make it clearly evident that they spend drastically more amount of time thinking about and setting up their home offices during these hard times.
The value and importance of perspectives
Edsger W. Dijkstra , “On the role of scientific thought”, 1974
[Updated for the 15.3 release] In March this year we’ve got a brand new and shiny Visual Studio. To many of us the favorite development environment. Here is a high-level recap of the changes made:
The guys from Microsoft seem to be working with lightning speed. At least when it comes to C# and the .Net framework. Looks like C# 8.0 is at our doorstep and while it’s still early news it’s exciting nevertheless. In a recent channel Channel 9 video Mads Torgersen has demonstrated the first few features that […]
Hi all, A video of a talk I did on “Overview of Azure” to on an internal conference at tretton37. It’s a comprehensive but brief overview of Microsoft Azure It’s been a while. It seems like I took a longer than usual(even for a lazy person like me) break from blogging. Well, I hope that’s about […]
From the many activities and awesome stuff we’ve got going on at tretton37, one is virtual reality. We are a bunch of guys particularly interested in this subject and willing to experiment with various equipment and software around it. The spotlight of the industry on VR has come back in the recent years as these gadgets […]
We are living in a time where businesses and the people running them often change their mind. I won’t be going into details of why is that so, let’s just say it is a given, and let’s say they are right. It gives them the competitive edge when they are flexible. It is on us […]
Fear of becoming so awesome that the human race can’t handle it and everyone dies.
Every day thousands and thousands of developers fight stress, anxiety, deadlines, pressure, guilt, hard work. They give their everything so that they make the world a better place….These are their stories…
Whatever you do in the .NET framework deals either with value or reference types, yet, there seems to be a great deal of confusion in many discussions with fellow developers and on online forums and QA sites about where the actual variables reside. It is so basic yet a cause of so many misconceptions. For […]
When our projects reach a certain size it is very hard to determine the complexity of our code. It gets harder and harder to see the overall picture. It also becomes very easy to introduce unnecessary complexity to parts of our system that we don’t want to. In simple words, it’s easy to get lost. […]
There are several ways to find a stored procedure in the server by name: we can query sys.procedures, syscomments, or information_scema.routines. Respective examples would be: or or
Software Developer, a “Programmer” even an “Engineer” or a “Craftsman“, although there are substantial differences between these according to some people, when we say any of them we mean one thing….an organism that transforms coffee into code 🙂 so I will continue with the term “Developer” and I wouldn’t like to go into that discussion […]
The MSDN documentation for datetime recommends using datetime2. datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage. Furthermore, datetime2 has a date range of “0001 / 01 / 01” through “9999 / 12 / 31” while the datetime type […]
To get all stored procedures related to a table: Option 1: Option2:
Here’s a code snippet to remove duplicate rows in a table: More on Common Table Expressions(CTE) can be found here: http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx
Problem: Filtering out(removing duplicates) from an IEnumerable One possible solution with using linq would be to group by key and take the first element of each group. Here’s an example:
A little helper query I came accross, very useful if you want to find all the tables that contain a specific column: SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE ‘%ColumnName%’ What it basically does is that it will do a join on […]
It is pretty hard writing an article on something that so many super cool authors have written books about. But, as I said it is my own experience learning and embracing TDD that I want to share here so that maybe I can help someone out there that can relate to this. And also I […]
There have been many questions I encountered lately of what are the best practices / guidances that you can take up on when designing an application. Wheather that’s an ASP.NET application or any other type of application that uses object oriented principles. First and upmost, let me begin with probably one of the most important principles […]
The question of providing a file trough a SaveAs dialog in a web browser appears very often in the forums and QA websites like Stackoverflow. The default action of the web browser when a file is provided is to open it. It automatically determines the file type and opens it inside the browser. An example would be […]
Many times you fnd yourself in a situation where you have to do something that seems too complex to implement in TSQL or you just want to use some feature from the .NET framework, or you already have something implemented in an assembly and you want to use it in your stored procedure or function. While TSQL is very […]
Hello again. In the first part of these mini series we discussed how you can create a custom membership provider and a custom role provider.Many times you will find yourself in a situation where you need to store and retrieve more data for a specific user than it is available in the MembershipUser class, which is the default for a MembershipProvider.While there […]
In the first part of these series we discussed and provided an example of how to create a custom membership provider. We will continue these mini series with a discussion and an example of how to create a custom role provider. We said in the first part that the reason of why you would like to create a custom membership […]
Custom Membership, Role Providers, Membership User Series. Since these articles and the examples in them are pretty long, it could get pretty cumbersome to have all of them in one go so I split them up in several articles. Here goes the first one. The Custom Membership Provider Implementation There are many times when the MembershipProvider and its underlying database construction aren’t […]
When you want to work with the FileUpload control in ASP.NET probably the most important thing to have in mind is that you are working with files, and files can get big, sometimes really big. By default with the FIleUpload control you can upload files that are 4096 KB (4 MB) in size.