Nick Zhebrun

AnjLab Sql Profiler with Application Performance Dashboard is out!

2011-11-22T10:05:00.000-08:00

New version of AnjLab SQL Profiler 1.2 is out. The main feature of the release is Application Performance Dashboard. Using this feature you can profile your database server queries grouped by application.

AnjLab Sharepoint 2010 RichControls now is open source

2011-08-30T03:20:00.003-07:00

Hi!

AnjLab Sharepoint 2010 RichControls now is an open-source. Here is the link: https://github.com/AnfiniL/richcontrols

Sharepoint: how to move ListItem or Folder to another folder

2011-06-01T10:11:00.001-07:00

I created the utility method that moves list item or folder to another folder.

///         /// Moves item to folder

        ///;Path like 'Folder1/Folder2/'        public static void MoveItemTo(SPListItem item, string path)

        {

            switch (item.FileSystemObjectType)

            {

                case SPFileSystemObjectType.Folder:

                    var newFolder = string.Format("{0}/{1}{2}", item.ParentList.RootFolder.Url, path, item.Folder.Name);

                    item.Folder.MoveTo(newFolder);

                    break;

                case SPFileSystemObjectType.File:

                    var file = item.Web.GetFile(item.Url);

                    var newFilePath = string.Format("{0}/{1}{2}_.000", item.ParentList.RootFolder.Url, path, item.ID);

                    file.MoveTo(newFilePath);

                    break;

            }

        }

New AnjLab SQL Profiler with Performance Dashboard is out!

2011-05-05T06:10:00.000-07:00

New AnjLab SQL Profiler with Performance Dashboard is out! Performance Dashboard is forgotten by Microsoft guys cool utility that shows your server performance using reports.

The SQL Server Performance Dashboard Reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem. For example, if the system is experiencing waits for disk IO the dashboard allows the user to quickly see which sessions are performing the most IO, what query is running on each session and the query plan for each statement.

Common performance problems that the dashboard reports may help to resolve include:

CPU bottlenecks (and what queries are consuming the most CPU)
IO bottlenecks (and what queries are performing the most IO).
Index recommendations generated by the query optimizer (missing indexes)
Blocking
Latch contention

The information captured in the reports is retrieved from SQL Server's dynamic management views. There is no additional tracing or data capture required, which means the information is always available and this is a very inexpensive means of monitoring your server.

SQL Profiler installs Performance Dashboard automatically and provides interface for reports. You can download it here.

Sharepoint Provider Load Failure

2011-03-23T07:48:00.000-07:00

To solve this problem restart Windows Management Instrumentation service (on russian "Инструментарий управления Windows")

sharepoint "Content types that are available to this Document Set have been added or removed. Update the Document Set."

2011-03-17T13:59:00.000-07:00

When you create Document Set in Sharepoint 2010 via code you can get strange notification message: "Content types that are available to this Document Set have been added or removed. Update the Document Set."

Look at http://sharepointfieldnotes.blogspot.com/2010_06_01_archive.html:
"The next step is to update the “docset_LastRefresh” property of the document set. Why? This apparently is a stamp of approval by the SharePoint UI that the document set was configured correctly. If you do not set this, then you will have a nagging yellow bar at the top of the SharePoint UI stating that the document set is missing some content types and needs updating. You can click on the link and it will generate the property for you. This value is stored in the SPFolder.Properties property bag."

If you set the docset_LastRefresh property via code you will hide the yellow line but you still have problems with 'Create document' button. It will be disabled.

By 2 hours and reflector I found the solution: you should provision the document set.
Run this code on you list item and be happy:

DocumentSet.GetDocumentSet(listItem.Folder).Provision();

AnjLab Sharepoint 2010 RichControls

2011-01-31T03:04:00.000-08:00

After a few months of lazy work I'm glad to introduce a new control for Sharepoint 2010: enhanced lookup control with autocomplete feature. The main features:

No Sharepoint dropdowns and preloaded data

Quick data finding and selecting using autocomplete

Select fields you would like to see in autocomplete box

Supports single-selection and multi-selection modes

Customizable title, description fields, look and behavior

Filter lookup data using CAML queries at server side!
Adds button to create new item in lookup list

Use RichControl with Sharepoint 2010 lookup fields

Supports languages (English and Russian included)

Uses JQuery library

Delivered as Sharepoint Solution Package (WSP)

You can get more information here: http://anjlab.com/en/project/sharepoint2010-richcontrols

Sharepoint: why content type fields are not required even they are setted as required?

2010-11-16T05:01:00.001-08:00

Content type fields are not required even they are created as required in xml reference. To fix it use uppercase letters on boolean values of xml attributes: required="TRUE".

Sharepoint: Visual Studio 2010 does not refresh Sharepoint Site Contents

2010-11-16T04:57:00.000-08:00

Sometimes Visual Studio 2010 does not refresh Sharepoint Site Contents. Rebooting does not help. I didn't find the way to fix it in generic way. To avoid this problem I changed ID's of content types.

Sharepoint: как сделать название списка русским, имея "правильный" URL

2010-11-08T07:48:00.000-08:00

Sharepoint имеет 2 названия для списков: Internal Name - внутреннее имя списка и Display Name - имя для отображения. Внутреннее имя задается один раз при создании списка, а имя для отображения можно менять сколько угодно раз.
Если в коде эти параметры можно указать, то в случае использования Sharepoint или Sharepoint Designer эти имена принимают значения, указанные при вводе название списка. Всвязи с этим URL списка представляет собой escape-последовательность русского названия.
Чтобы обойти это сперва назовите список английским именем, а затем переименуйте по-русски.

New version of AnjLab.SqlProfiler is out!

2010-06-10T02:36:00.000-07:00

We released the new version of the AnjLab.SqlProfiler (0.1.1094.67). Most of bugs are fixed.

C#: RefreshSection method of ConfigurationManager is not refreshing sections under debug mode

2010-04-13T03:52:00.000-07:00

RefreshSection method of ConfigurationManager is not refreshing sections when you run application at Visual Studio. Try to run application without VS.

Rails 2.3.2 + Google Email App + ActionMailer

2009-07-31T03:21:00.000-07:00

Today I have problem while sending mail via Google Email App which raises exception

Net::SMTPAuthenticationError: 535-5.7.1 Username and Password not accepted. Learn more at

from /usr/local/lib/ruby/1.8/net/smtp.rb:942:in `check_auth_response'
from /usr/local/lib/ruby/1.8/net/smtp.rb:733:in `auth_plain'
from /usr/local/lib/ruby/1.8/net/smtp.rb:725:in `send'
from /usr/local/lib/ruby/1.8/net/smtp.rb:725:in `authenticate'
from /usr/local/lib/ruby/1.8/net/smtp.rb:566:in `do_start'
from /usr/local/lib/ruby/1.8/net/smtp.rb:525:in `start'

The problem was in incorrect password that I entered before at my browser. After that Google wants captcha. To disable captcha go to https://www.google.com/a/[your domain].com/UnlockCaptcha and unlock captcha request.

For more information you can read http://mail.google.com/support/bin/answer.py?answer=14257.

Yandex карты в Ruby on Rails

2009-07-03T09:20:00.000-07:00

Давно использую плагин geokit-rails для ROR-проектов. Добавил Yandex-геокодинг. Теперь можно более точно искать объекты на просторах нашей необъятной родины и стран бывшего СССР.

Ссылка: github

JADE is alive!

2009-02-13T11:19:00.000-08:00

JADE team released version 2.0.1 of WOLF, the graphical development environment for WADE based applications.

Caire Giovanni:

We are pleased to announce the release of version 2.0.1 of WOLF, the graphical development environment for WADE based applications. As the version number states, this is mostly a consolidation release that fixes a number of problems related to the management of classes available in source form only.

Even more important, however, is the release of a complete tutorial (http://jade.tilab.com/wade/doc/tutorial/WADE-Tutorial.pdf) that guides the reader through all the steps necessary to develop an application where the main agent tasks are defined in from of workflows. The tutorial addresses a simple yet sufficiently articulated scenario and describes the creation of a complete multi agent system from the project setup to the execution highlighting noteworthy aspects such as invoking web services and delegating subflows. The complete source code of the application described in the tutorial is available for download at (http://jade.tilab.com/wade/doc/tutorial/toysAssembler.zip).

WOLF is an Eclipse (www.eclipse.org) plug-in and is distributed OPEN SOURCE by Telecom Italia S.p.A. under the terms of the LGPL Version 2 License. It can be downloaded at http://jade.tilab.com/wade/html/download.php.

New version of SQL Server Express Profiler is out!

2009-01-11T23:11:00.000-08:00

The new version of SQL Express Profiler is out! Now it supports SQL Server Express 2008! Sorry for delay. You can find it here.

New version of AnjLab.SqlProfiler is out!

2008-09-22T06:14:00.000-07:00

We released the new version of the AnjLab.SqlProfiler (0.1.468.59). The list of new features:
- deployment using installer
- select / deselect all events
- save events settings
- auto-resize columns
- now it contains all needed Microsoft libraries from SQL Server SDK
- and other.

We want to thanks all users who submitted feedback.

Are you tired to create DataTemplateSelector? Use GenericDataTemplateSelector!

2008-09-04T03:24:00.000-07:00

Programming using WPF is a very cool programming. But sometimes WPF framework upsets of absence some useful functionallity. One of them is creating DataTemplateSelector directly in xaml. Here is the code of GenericDataTemplateSelector which can be defined in xaml:

public class GenericDataTemplateSelector : DataTemplateSelector

        public DataTemplateSelectorItem[] DataTemplateSelectorItems { get; set; }

        public override DataTemplate SelectTemplate(object item, System.Windows.DependencyObject container)

            if (item != null && DataTemplateSelectorItems != null)

                foreach(var selectorItem in DataTemplateSelectorItems)

                    var value = Reflector.GetValue(item, selectorItem.PropertyName);

                    if (selectorItem.Value.Equals(Convert.ToString(value)))

                        return selectorItem.Template;

            return null;

    public class DataTemplateSelectorItem

        public string PropertyName { get; set; }

        public string Value { get; set; }

        public DataTemplate Template { get; set; }

Reflector is static class which uses ferlection to retrieve value of property.

Now you can define custom DataTemplateSelector in xaml:

<fx:GenericDataTemplateSelector x:Key="executionStatusSelector">

        <fx:GenericDataTemplateSelector.DataTemplateSelectorItems>

            <fx:DataTemplateSelectorItem PropertyName="ExecutionStatusID" Value="0">

                <fx:DataTemplateSelectorItem.Template>

                    <DataTemplate>

                        <Image Source="{StaticResource greenBulletImageSource}"/>

                    </DataTemplate>

                </fx:DataTemplateSelectorItem.Template>

            </fx:DataTemplateSelectorItem>

            <fx:DataTemplateSelectorItem PropertyName="ExecutionStatusID" Value="1">

                <fx:DataTemplateSelectorItem.Template>

                    <DataTemplate>

                        <Image Source="{StaticResource orangeBulletImageSource}"/>

                    </DataTemplate>

                </fx:DataTemplateSelectorItem.Template>

            </fx:DataTemplateSelectorItem>

            <fx:DataTemplateSelectorItem PropertyName="ExecutionStatusID" Value="2">

                <fx:DataTemplateSelectorItem.Template>

                    <DataTemplate>

                        <Image Source="{StaticResource blackBulletImageSource}"/>

                    </DataTemplate>

                </fx:DataTemplateSelectorItem.Template>

            </fx:DataTemplateSelectorItem>

    </fx:GenericDataTemplateSelector>

Статистика Google AdSense по проекту AnjLab.SqlProfiler

2008-09-01T14:41:00.000-07:00

WPF bug with ValidationError

2008-03-31T08:00:00.000-07:00

If you use validation errors in your WPF application you can meet the following exception during runtime validation:

System.Windows.Data Error: 12 : Cannot get '' value (type 'ValidationError') from '(Validation.Errors)' (type 'ReadOnlyObservableCollection`1'). BindingExpression:Path=(0).[0].ErrorContent; DataItem='TextBox' (Name='textBox1'); target element is 'TextBox' (Name='textBox1'); target property is 'ToolTip' (type 'Object') TargetInvocationException:'System.Reflection.TargetInvocationException...

To fix this problem you should create your own ValueConverter:

public class ErrorContentConverter : IValueConverter

        public object Convert(object value, Type targetType, object parameter, CultureInfo culture)

            var errors = value as ReadOnlyObservableCollection<ValidationError>;

            if (errors == null) return "";

            return errors.Count > 0 ? errors[0].ErrorContent : "";

        public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)

            throw new NotImplementedException();

After that you can use ValidationErrors in your style trigger with the following way:

<Trigger Property="Validation.HasError" Value="True">

                <Setter Property="ToolTip" Value="{Binding RelativeSource={x:Static RelativeSource.Self}, Path=(Validation.Errors), Converter={StaticResource errorConverter}}"/>

                <Setter TargetName="Border" Property="BorderBrush" Value="Blue" />

            </Trigger>

Посещаемость ресурса Sql Profiler перевалила за 100 человек в день

2008-03-14T04:00:00.000-07:00

Свершилось! 12 марта 2008 г. сайт AnjLab.SqlProfiler посетило 106 человек.

Я - к.т.н!

2008-02-27T05:53:00.000-08:00

Наконец я получил уведомление о том, что моя защита кандидатской диссертации утверждена ВАК. Теперь я - к.т.н., осталось только получить диплом.

За последние 20 дней AnjLab.SqlProfiler «заработал» 30$

2008-02-21T09:44:00.001-08:00

Открылся наш сайт

2008-02-21T06:47:00.000-08:00

Открылся сайт нашей комманды AnjLab. На нем находится блог, который собирается из наших блогов. Очень удобно.
Но самое главное, что это означает, что блог необходимо пополнять. То есть нужно перестать лениться и любые наши находки открывать общественности.

Use custom classes in Application Settings

2007-11-24T05:12:00.000-08:00

You can use custom classes in settings of .NET application. Your class must be marked as Serializable and it must implement TypeConverter to convert string from settings designer.

Bind a list of objects to GridView

2007-10-18T01:27:00.000-07:00

How to bind a list of object to a GridView? I do it using own DataSourceControl - ListDataSourceControl. You can use properties of nested classes.

Here is the code:

<ListDataSourceControl runat="server" id="ListDataSourceControl1">
                <DataTableConfig>
                    <Columns>
                        <PropertyColumnElement ColumnName="CustomerId" PropertyName="Id" />
                        <PropertyColumnElement ColumnName="CustomerNumber" PropertyName="Number" />
                        <PropertyColumnElement ColumnName="CustomerNominal" PropertyName="Data.Nominal" />
                    </Columns>
                </DataTableConfig>
                <SelectParameters>
                    <asp:ControlParameter ControlID="numberFilter" Name="CustomerNumber" PropertyName="Value" />
                </SelectParameters>
            </ListDataSourceControl>
 
            <asp:GridView runat="server" ID="grid" DataSourceID="ListDataSourceControl1">
                <Columns>
                    <asp:BoundField DataField="CustomerId" />
                    <asp:BoundField DataField="CustomerNumber" />
                    <asp:BoundField DataField="CustomerNominal" />
                </Columns>
            </asp:GridView>

You can download code from here.

Converting an object collection to a DataTable or DataSet

2007-10-18T00:18:00.000-07:00

I've read the post of Ayende Rahien about converting an object collection to a DataSet.
I have one solution which helps to make the operation of converting. I've wrote DataTableAdapterFactory. It can create converting adapters. I used CodeDom to create adapters compiled code.
You can set the rules of converting using PropertyColumn list. Also you can set as columns the properties of inner classes.

Here is the client code:

public class TestClass1
        {
            public int? Field;
            private string property;
 
            public TestClass1(int field, string property)
            {
                this.Field = field;
                this.property = property;
            }
 
            public string Property
            {
                get { return property; }
            }
        }

public class TestClass2
        {
            private TestClass1 class1;
            public DateTime Time;
 
            public TestClass2()
            {
 
            }
 
            public TestClass2(TestClass1 class1)
            {
                this.class1 = class1;
            }
 
            public TestClass1 Class1
            {
                get { return class1; }
            }
        }

public void TestCreateAdapter()
        {
            DataTableAdapterFactory factory = new DataTableAdapterFactory();
            PropertyColumn[] columns = new PropertyColumn[]
                {
                    new PropertyColumn("Class1.Field", "Field"),
                    new PropertyColumn("Class1.Property", "Property"),
                    new PropertyColumn("Time", "Time")
                };
 
            IDataTableAdapter<TestClass2> adapter = factory.New<TestClass2>(columns);
 
            List<TestClass2> list = new List<TestClass2>();
            for (int i = 0; i < 10000; i++)
            {
                list.Add(new TestClass2(new TestClass1(4, "4")));
                list.Add(new TestClass2(new TestClass1(40, "40")));
                list.Add(new TestClass2(new TestClass1(12, "12")));
                list.Add(new TestClass2());
            }
 
            DataTable dt = adapter.Get(list);
        }

I've quickly created the small project. You can download the source code of DataTableAdapterFactory from here.