BPM book

October 28, 2010 at 10:59 PMalex

Handbook of Business Process Management, described here is a comprehensive review of the leading practices in BPM cycle.

Posted in:

Tags:

Quick and Dirty SQL Server Slow Query Log

October 12, 2010 at 2:32 PMalex

This was reposted a miriad of times, but I seem to can't find it when needed, so here it is, the famous slow query sql:

SELECT TOP 20 SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, 
        ((CASE qs.statement_end_offset
          WHEN -1 THEN DATALENGTH(qt.text)
         ELSE qs.statement_end_offset
         END - qs.statement_start_offset)/2)+1), 
qs.execution_count, 
qs.total_logical_reads, qs.last_logical_reads,
qs.min_logical_reads, qs.max_logical_reads,
qs.total_elapsed_time, qs.last_elapsed_time,
qs.min_elapsed_time, qs.max_elapsed_time,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
WHERE qt.encrypted=0
ORDER BY qs.total_logical_reads DESC

Posted in: Development

Tags:

PDBs and strings secrets revealed

September 23, 2010 at 2:04 PMalex

Posted in: Development

Tags:

CodePlex Foundation

September 22, 2010 at 10:24 PMalex

Just came across a new project started by Microsoft called CodePlex Foundation, http://www.codeplex.org/ which supposted to grow with the best gallery of projects from http://codeplex.com Check it out in a few years ;-)

Posted in: Development

Tags:

IARIA 2010

September 12, 2010 at 8:50 PMalex

There is an interesting conference called Cloud Computing will take place in Lisbon, Portugal, where the detailed conference agenda can be found at http://www.iaria.org/conferences2010/ProgramCLOUDCOMPUTING10.html This conference will be devoted to the latest trends in cloud computing and future of this technology. Worth checking out.

It turned out that that IEEE-related conference was bogus and guy wanted to get money from authors. Beware.

Posted in: Development

Tags: ,

Focus on UX

August 30, 2010 at 12:35 AMalex

An interesting trend in modern computing and UX is that users want to focus on a particular task and employ all the resources on their computing device on that task. In this regard, the power of GPU computing couldn't be underestimated with the availability of Tesla and CUDA programming suplimentary infrastructure. Another interesting prototype from Microsoft supported by a patent called Copenhagen sets up the focus on the user activity.

Posted in: Development

Tags:

Xml normalization utility

August 26, 2010 at 1:09 PMalex

Periodically, I need to parse a string, which represents an xml file into formatted file with intendation. Here is a simple .Net code which does this and can be compiled into a console application:

More...

Posted in: Development

Tags:

Running Oracle 32-bit and 64-bit on the same 64-bit machine

August 10, 2010 at 2:48 PMalex

Here is the complete info:http://realfiction.net/go/153. The gist of it is that you create a symbolik link under %WINDIR%\System32 and %WINDIR%\SysWOW64 to point to either 32 or 64-bit oracle client depending on the bitness of a client app.

Posted in: Development

Tags: , ,

Performance optimization of software system.

August 5, 2010 at 8:51 AMalex

I'm opening a new series of posts related to performance optimization of software systems, which is my primary area lately. First, and most useful suggestion when it comes to setting up the environment, pay attention to the exact spec of the testing system, namely, CPU, disk, memory, software installed and running etc.

Posted in:

Tags:

Hello from iPhone

August 4, 2010 at 8:28 AMalex

This is the first post from iPhone, so that I should confess that this sleek device attracted my attention and it's really about users and all the features are well-polished and well-organized. For example, it really saves time to listen to a podcast with 2x speed when one wants to cram more into shorted period of time. Although, my current blog engine doesn't play well when it comes to posting, so, I'll continue to look at consolidated blog/photo content management system. If you know one that is open and is based on .Net, drop me a line.

Posted in: Blog | BlogEngine.NET | Development

Tags: ,