(Abhijit Jana) Most of all are well aware about command line profiling for ASP.NET Application using VSPerfASPNETCmd command line tool . This can easily profile your ASP.NET Web applications which is hosted on IIS.
Other News
XML Development with Database Integration
(ecavanaugh) Did you know that XMLSpy connects to relational databases?
ASP.NET MVC 4 Overview – Part 2: Default template changes and Adaptive Rendering using Viewport and CSS Media Queries
(Jon Galloway) This is Part 2 of a series overviewing changes in ASP.NET MVC 4. In Part 1, we looked at installation and new options in creating a new project. In Part 2, we’ll look at changes to the default project template and how it uses adaptive rendering to optimize the display for the end user
Remote DBA In Action
(Laura) Find out how Remote DBA works! We have produced a series of videos to show exactly what DB2 support from Triton is all about.
An update on those pesky DB2 for z/OS ‘reserved words’: DB2 10 edition
(Willie Favero) A new version of DB2 almost always means additional reserved being added to DB2. Reserved words are those pesky words that you cannot use in an SQL statement under penalty of error (-199 or DSNH083I) unless they are a delimited identifier (mark off by a quotation mark (“) for exampl
Waiting for Parallel Tasks to Complete
The ninth part of the Parallel Programming in .NET tutorial considers that the parallel nature of tasks means that it is not possible to assume that tasks have completed. It describes how to synchronise tasks and capture their unhandled exceptions.
Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN
(Jørgen Løland) Understanding why MySQL chooses a particular join order or why table scan is chosen instead of range scan is often very hard even for experienced MySQL users. Two almost identical queries, differing only in constant values, may produce completely different plans.
How to SPLIT a delimited string values in SQL Server 2005
(Vadivel) There are many ways by which we can SPLIT delimited string in SQL Server. Few years back I have already done couple of posts regarding this. Let me link those here for quick reference:
SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
(Pinal Dave) SQL Server Denali has many new interesting feature – one of the interesting feature is New DMVs.
SQL Server Denali: New warnings in Actual Execution Plan
(Ana) I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sort_warning and hash_warnig. In SQL Server 2008R2, we can create SQL Trace to capture sort and hash warnings but there is no easy w