The problem: a blog post is supposed to show a temperature chart. The chart is…
Category: The Ugly
SQL Server 2005 – Recursion
Why do I find all the examples of how to use recursion in SQL Server…
Gigabit Ethernet
I wanted to know exactly how much throughput I get from my new switch (HP…
Synology Rack Station RS407 – NAS with Benefits
I installed the Synology Rackstation last night and so far I like it a lot….
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…
MP3 Filer (free iPod Ripper!)
Others have shown how to copy music files from an iPod to the local harddrive…
How it all began
August 21, 2009 There is an old saying, “The jug goes to the well until…
More Synology Rackstation Network Tests
In an earlier post I presented the network throughput results of my tests with the…
DateTime comparisons in SQL Server 2008 and 2012
The issue is that SQL Server’s DateTime data type appears to be able to resolve…
Using SQL Server Column Aliases
When you have a query that does complex calculations, maybe even has function calls in…
