Alexander Schmidt Mathematical methods, programming

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

Worth reading,

http://www.wintellect.com/CS/blogs/jrobbins/archive/2009/08/22/how-many-secrets-do-net-pdb-files-really-contain.aspx

http://www.yoda.arachsys.com/csharp/strings.html

http://www.yoda.arachsys.com/csharp/unicode.html

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 ;-)

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.

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.

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...

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.

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.

Microsoft just updated their version of a programming language for children, called SmallBasic.

Loren Goodman, CTO of my company, presented an excellent topic on Microsoft TechEd conference Getting to the Handshake: Leveraging Business Rule Technology through Architecture, Design and Practice which can  viewed and downloaded at http://www.msteched.com/2010/NorthAmerica/ARC301. It highlights the growing interest in this area in the community since people are into rules more and more as they redesigning existing solutions and engineering new ones and the understanding of the flexibility in the first place is a requirement which is one of the core one. You can find more on the current state of the Rule Engines on my company's site at http://www.inrule.com