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: , ,

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: ,

Microsoft SmallBasic

June 18, 2010 at 9:47 AMalex

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

Posted in: Development

Tags:

Leveraging Business Rule Technology

June 13, 2010 at 1:41 PMalex

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

Posted in: Development

Tags: ,