SQL Server
Business Intelligence Showcase by pod consulting
The Business Intelligence Showcase demonstrates our expertise with Microsoft’s business intelligence application suite. These technologies include the…
Setup projects with SQL Server Compact Edition (CE) databases
This article is no longer relevant. In Visual Studio 2008 SP1, setup projects allow you to select…
Free mileage tracker with desktop import for Windows Mobile 6 Smartphones
It is finally ready – the new and improved TripsNMiles, pod consulting’s free mileage tracker for the Windows Mobile platform.
Combining contiguous date ranges in a SQL query – using CTE recursion
Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows into one….
DateTime comparisons in SQL Server 2007
The issue is that SQL Server’s DateTime data type appears to be able to resolve milliseconds –…
SQL Server 2005 – Recursion
Why do I find all the examples of how to use recursion in SQL Server 2005 too…
Using SQL Server Column Aliases
When you have query that does complex calculations, maybe even has function calls in the select list…
