I love new SSDT (SQL Server Data Tools) product from Microsoft. I blogged about it a few times already. One thing that was bugging me though is the face that IntelliSense was not working for me at all. I have been ignoring that for a while being that I am busy and the fact that …
On my current project we recently started getting the following error while running integration tests as part of continuous integration build. System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I tested …
Continue reading ‘Connection Pooling and Integration Tests’ »
Exciting news for developers in Atlanta! Atlanta annual Code Camp is almost here. It is scheduled to commence on Saturday, May 19th at Southern Polytechnic State University in Marietta, GA. This event is free to everyone that wishes to attend, as long as capacity is not exceeded in the event facilities. We will offer coffee …
I mentioned months before my WinRT database project. I was going to stop working on it, but unfortunately as of now there is no good alternative to structured storage in WinRT applications. SQLite team is working on WinRT version, but there is no projected date as far as I know. So, upon some thinking I …
As you may know, Magenic has been putting on Code Mastery events for quite some time. This is a free event, similar to Code Camp, but is put on by our company, We do it every year in all the cities where Magenic has an office. Code Mastery events are designed to present attendees with …
I blogged a long time ago on how to use WinDbg to find memory leaks in Silverlight application. Yesterday I had to face a variation of the problem, but this time I had to debug a custom issue. So, what we did is have customer create memory dumps. To do that we instructed them to …
Continue reading ‘More on WinDbg, Memory Leaks and Silverlight’ »
I blogged a while back on shortcoming of getRowData function of jqGrid in edit mode. I also recently ran into an issue when getRowData was returning blank for a cell that contains select (dropdown) control in edit mode. So, I wrote a quick function that I wanted to post here to help others that handles …
Continue reading ‘More on jqGrid and getRowData function in edit mode’ »
There is one very interesting behavior of connection pooling feature in .NET framework / SQL Server that I learned yesterday. You can read the Connect issue here. Interestingly enough, default setting for TransactionScope object is to use Serializable Isolation Level. Here is a typical scenario to put the problem in perspective. An application is using …
Continue reading ‘TransactionScope and Connection Pooling in SQL Server’ »
If you are wondering how many cool features are coming in Entity Framework 5.0, the EF team wrote an awesome white paper on performance improvements and tips to get the best performance out of EF. Please read the article here. To me this article proves a great commitment that Microsoft as a company has to …
Continue reading ‘Performance Considerations for Entity Framework 5’ »
I wanted to make a few more points about using SSDT in addition to previous posts. As I was working on my project, I wanted to drop a procedure that was no longer used, but there is nothing on re-factor menu to support that. Come to find out, you have to follow a different pattern …