Browse by Tags

Missing exceptions in code after Raiserror() and SET NOCOUNT ON workaround
19 December 08 01:59 AM | idragoev | 0 Comments   
These days I worked on a problem related with using raiserror() in SQL 2000 and why the exception is not raised in ADO.NET application using ODBCCommand. What I had is a simple stored procedure, that performs some check on its parameters and if some of Read More...
Animating ListBox items - the VisualStateManager
13 June 08 04:13 AM | idragoev | 0 Comments   
Check out my second article on ListBox items animations . Here you can see how to use VisualStateManager and also some problems I faced during the migration to Silverlight 2 beta 2 Enjoy! Read More...
Filed under:
Interactive Silverlight Voting Control
05 December 07 05:43 AM | idragoev | 0 Comments   
As you might know, we at CompletIT are behind the SilverlightShow.net - the independent Silverlight community site. Also, the last few weeks we've published several articles (with source code included) just to show how easy is to create nice stuff with Read More...
CompletIT at DevReach, Sofia, Bulgaria 1-2 October, 2007
08 October 07 06:36 AM | idragoev | 0 Comments   
At the beginning of October I have visited DevReach - the premier conference for Microsoft technologies in South Eastern Europe. I was on several lectures about MS SQL: What's New in SQL Server 2008 for Developers - by Vladi Tchalkov; T–SQL Querying: Read More...
Filed under:
How to select the primary key data type?
04 July 07 11:00 PM | idragoev | 0 Comments   
When a new database is about to be designed, have to think about what data type to use for the primary keys. There are several things that should be taken into consideration: the average database size expected, the possibility of growing in the future, Read More...
Increase Stored Procedure execution performance dramatically
18 June 07 05:52 AM | idragoev | 0 Comments   
Last month we spent a lot of time in data loading optimization due to performance problems. I started with optimization of the heaviest views and put them in parameterized stored procedures . I also used a simple method to check the performance by measuring Read More...