Skip to content
Donner's Daily Dose of Drama
Donner's Daily Dose of Drama
  • The Good
    • Blogging
    • Consumer Protection
    • Environment
    • Ethics
    • Geek’s Home
    • Lisa Lanett
    • Medfield
    • Music
    • Parenting and Technology
    • Travel
    • wow
  • The Bad
    • Business
    • Ebay
    • Investment
    • Job search
    • Personal Finance
    • Politics
  • The Ugly
    • Information Technology
      • Business Intelligence
      • Content Management
      • Free Software
      • I18N and L10N
      • Java
      • Open Source
      • Mobile Devices
      • Open Source Business Intelligence
      • OSBI
      • SDA
      • Security
      • Smartphone
      • Software Best Practices
      • Software Engineering
      • SQL Server
      • Streaming Media
      • Web
    • Austria
    • Fiction
    • Hardware
    • iPod
    • Miscellaneous
    • Uncategorized
    • Video
    • Weekend Warrior
Donner's Daily Dose of Drama

Category: SQL Server

Different seed after IDENTITY INSERT in SQL Server 2012 and SQL Server 2008

Christian Donner, May 21, 2015May 21, 2015

Once something takes more than an hour to figure out, it is always a good…

Continue Reading

T-SQL: replace occurrences of two or more characters in a row with a single new character

Christian Donner, May 31, 2013May 31, 2013

Here is a T-SQL UDF that replaces occurrences of two or more characters in a…

Continue Reading

Business Intelligence Showcase by pod consulting

Christian Donner, May 27, 2009January 26, 2014

The Business Intelligence Showcase demonstrates our expertise with Microsoft’s business intelligence application suite. These technologies…

Continue Reading

Setup projects with SQL Server Compact Edition (CE) databases

Christian Donner, April 12, 2009August 19, 2009

This article is no longer relevant. In Visual Studio 2008 SP1, setup projects allow you…

Continue Reading

Free mileage tracker with desktop import for Windows Mobile 6 Smartphones

Christian Donner, April 12, 2009December 8, 2011

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

Continue Reading

Combining contiguous date ranges in a SQL query – using CTE recursion

Christian Donner, November 6, 2008April 12, 2009

Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows…

Continue Reading

DateTime comparisons in SQL Server 2008 and 2012

Christian Donner, August 28, 2008December 2, 2015

The issue is that SQL Server’s DateTime data type appears to be able to resolve…

Continue Reading

SQL Server 2005 – Recursion

Christian Donner, May 3, 2008April 12, 2009

Why do I find all the examples of how to use recursion in SQL Server…

Continue Reading

Using SQL Server Column Aliases

Christian Donner, March 14, 2008January 12, 2013

When you have a query that does complex calculations, maybe even has function calls in…

Continue Reading
  • About
  • Awards
    • TechnoLawyer
  • Contact Christian Donner
  • Project Portfolio
  • Publications
  • Speaking Engagements
©2025 Donner's Daily Dose of Drama | WordPress Theme by SuperbThemes