-
Monitor SqlServer Stored Proc execution time
I have had the task to made something to monitor what stored procedure,in Sql Server,in most used. The problem that I have had is that the host_name is easily changed by putting,in the connection string WSID (see http://msdn.microsoft.com/en-us/library/ms178598.aspx ) The code is for sql server 2005 and I have not realized without the help of…
-
file helpers
More than one time you need to let users / application import bulk data in your system . I have had many cases – data is old data from old software,that is exported in some text files,usually csv. In order to import fast the data,I used FileHelpers from http://www.filehelpers.com/ Let’s say you have the following…
-
Twitter Weekly Updates for 2010-06-06
.net salary http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=21216925&gid=136510&commentID=17252387&trk=view_disc # Powered by Twitter Tools
-
MVC Helper Templates
In my experiences with MVC I have some utilities to share . Some of them are : DateTime fields Numeric fields Watermark Dropdownlist more! Please see the project and give feedback MvcHelperApplication
-
Selenium and testing WebInterfaces
On some cases you need to test the whole web interface. Why ? Suppose you have some Ajax call. You can test the call on server,but how do you ensure that user experience is OK ? There are several testing projects for Web – for example selenium and Watin I will show how to test…
-
Entity Framework profiler
Many times I’ve had problem with the following error when inserting objects with dates with Entity Framework : System.Data.UpdateException An error occurred while updating the entries. See the inner exception for details.SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Ok,it’s my faute – but to remember each one date is too…
-
Twitter Weekly Updates for 2010-05-09
The State of Web Development 2010 http://www.webdirections.org/sotw10/ # Powered by Twitter Tools
-
Caching in .NET
In every application you have some data that is more read-more,write-once or twice. For example you can have the list of Cities of a country,the list of Countries of the world or list of exchange currency. This data is modified rarely. Also,you can have data that is not very sensitive to be real-time,such as the…
-
Twitter Weekly Updates for 2010-05-02
mvc contest : http://www.mvcmelee.com/faq.html # programmer bill of rights :http://www.codinghorror.com/blog/2006/08/the-programmers-bill-of-rights.html # Powered by Twitter Tools
-
Intercept errors
Errors interception and rising Description We will speak here about the errors raised by external conditions (bugs) and the errors rose by the application. There is not application without bugs. The bugs are not desired for an application – but programmers are human beings and,by consequence,they cannot verify every possible path that go an application…
I am ok , you are ok