Norkevicius

MDX complement operator problem

aurimas.norkevicius — Tue, 18 Nov 2008 13:02:49 +0000

Playing with Microsoft SQL Server Analysis services 2005 and MDX language. Could not find many resources or error reference on the internet. The following MDX query was created using query painter: Select (-({[My Dimension].[My Hierarchy].[My Level].&[Not existing member]})) ON COLUMNS FROM [My Cube] Executing this query results in an error: Set used with the complement operator must have all [...]

anonymous, dynamic, variable classes and methods

aurimas.norkevicius — Fri, 12 Sep 2008 12:53:56 +0000

To call a method by dynamic name you can do this: $methodName="MyMethod"; $result=$methodName(); To create a class by dynamic name you can do this: $className="MyClass"; $classVar=new $className; To call any method by dynamic name in previously initialized class you can do this: $methodName="MyMethod"; $result=$classVar->$methodName();

Generic Configuration Section Handler

aurimas.norkevicius — Mon, 08 Sep 2008 10:55:41 +0000

Check this link. It is a good way to deal with configuration sections in .NET environment.

C# .NET project fails to compile because of System.Data.SqlClient SortOrder data type.

aurimas.norkevicius — Thu, 24 Jul 2008 11:29:06 +0000

Had a headache because of compilation of project which was using System.Data.SqlClient SortOrder data type. After some hours of investigations we found out that Microsoft .NET framework 2.0 SP1 was not installed on the machine. .NET 2.0 contains system.Data.SqlClient namespace but not SortOrder type in it. SP1 adds this data type to the namespace mentioned [...]

asp.net wizard control sidebar template customization

aurimas.norkevicius — Wed, 11 Jun 2008 16:33:42 +0000

Question: How to change sidebar template of the wizard control so that only previous wizard steps would be enabled? Answer:Create something like this in your *.aspx file: <asp:Wizard ID="Wizard1" runat="server"> <WizardSteps> <asp:WizardStep ID="WizardStep1" runat="server" Title="Step 1"> </asp:WizardStep> <asp:WizardStep ID="WizardStep2" runat="server" Title="Step 2"> </asp:WizardStep> </WizardSteps> <SideBarTemplate> <asp:DataList runat="server" ID="SideBarList" OnItemDataBound="SideBarList_ItemDataBound"> <ItemTemplate> <asp:LinkButton runat="server" ID="SideBarButton" Font-Bold="true" /> </ItemTemplate> </asp:DataList> </SideBarTemplate> </asp:Wizard> And create something like this in your *.aspx.cs file: protected void SideBarList_ItemDataBound(object sender, DataListItemEventArgs [...]

Microsoft SQL Server: How to find not partitioned tables

aurimas.norkevicius — Tue, 10 Jun 2008 08:17:53 +0000

Script to find not partitioned tables containing some particular column SELECT o2.NAME FROM sys.objects o INNER JOIN sys.indexes i ON o.OBJECT_ID=i.OBJECT_ID INNER JOIN sys.partition_schemes ps ON ps.data_space_id=i.data_space_id RIGHT OUTER JOIN sys.Objects o2 ON o2.OBJECT_ID=o.OBJECT_ID INNER JOIN sys.columns c ON c.OBJECT_ID=o2.OBJECT_ID WHERE o2.TYPE_DESC='USER_TABLE' AND c.NAME='mycolumnname' AND o.OBJECT_ID IS null

Microsoft SQL server 2005:SQL Script to check if an object contains fulltext index specified

aurimas.norkevicius — Mon, 21 Apr 2008 15:06:47 +0000

IF EXISTS( SELECT * FROM sys.objects o INNER JOIN sys.fulltext_indexes fti ON o.object_id=fti.object_id WHERE o.name='Your table or view name' ) BEGIN --Your Code Here END

Data Dude and Visual Studio 2005: Full Text Indexes on Views With Schema Binding are Ignored During Deployment

aurimas.norkevicius — Sun, 20 Apr 2008 02:54:09 +0000

Data Dude and Visual Studio 2005: Full Text Indexes on Views With Schema Binding are Ignored During Deployment. SQL Script import works. *.fulltextindex.sql files are created, but indexes are ignored to deploy … This is solved in visual studio 2008. In case you are using 2005 put these scripts to your post deployment scripts ….

Boinc Wraper-Worker Solution

aurimas.norkevicius — Mon, 25 Feb 2008 15:50:47 +0000

Just started to look at it. And deployed “first try” on http://boinc.vgtu.lt. I’ll try to move the complete project to use this scheme. If everything will go fine the first non test application will be deployed soon…

Php Script To Detect And Verify Googlebot

aurimas.norkevicius — Mon, 26 Nov 2007 20:37:19 +0000