The Business Intelligence Showcase demonstrates our expertise with Microsoft’s business intelligence application suite. These technologies include the SQL Server database, Analysis Services, and Reporting Services. Recently added to the stack was the .Net chart control, a very powerful component that greatly improves productivity for producing visually appealing charts and diagrams on web sites and Windows [...]

This article is no longer relevant. In Visual Studio 2008 SP1, setup projects allow you to select the ‘User’s Application Data Folder’ as a deployment target. This is where any SDF files and other application data and content should go. The ‘Common Application Data Folder’ is no longer accessible for write operations in Windows 7 [...]

It is finally ready – the new and improved TripsNMiles, pod consulting’s free mileage tracker for the Windows Mobile platform.

Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows into one. While this is a common classic SQL problem, I was unable to find an elegant solution that also performs well, and came up with my own. This article explains the problem and outlines the solution using a Common [...]

The issue is that SQL Server’s DateTime data type appears to be able to resolve milliseconds – but it really does not. It rounds to the nearest 0, 3, or 7.
Consider the following:

Why do I find all the examples of how to use recursion in SQL Server 2005 too complicated (including the one in the Microsoft help)?
Here is mine that does the bare minimum.

When you have query that does complex calculations, maybe even has function calls in the select list

select
costly_function_A() as result_A,
costly_function_B() as result_B
from
table_T

and then you need to return the result of such a calculation, but also [...]