Databases

SQL CE Transaction Handling

posted @ Monday, March 31, 2008 7:50 PM | Feedback (9)

SQLite vs. SQL CE

posted @ Tuesday, January 22, 2008 4:18 AM | Feedback (17)

Serialazble isolation level on rows that does not exists

posted @ Friday, January 18, 2008 3:38 AM | Feedback (5)

Another paging approach

posted @ Thursday, December 06, 2007 1:20 PM | Feedback (21)

Perfoming joins without having all the data in memory

posted @ Thursday, December 06, 2007 12:22 PM | Feedback (23)

The CRM Horror

posted @ Sunday, October 07, 2007 7:33 PM | Feedback (14)

More on Data Layer Componentization

posted @ Sunday, October 07, 2007 1:56 AM | Feedback (1)

Schema to wince by...

posted @ Wednesday, October 03, 2007 12:12 AM | Feedback (15)

Re: Saving to Blob

posted @ Saturday, August 18, 2007 8:11 PM | Feedback (19)

Re: SSIS - 15 Faults Rebuttal

posted @ Friday, July 27, 2007 11:13 PM | Feedback (2)

Free doesn't give it a license to suck

posted @ Friday, July 27, 2007 11:02 PM | Feedback (4)

SSIS: The backlash

posted @ Friday, July 27, 2007 3:41 PM | Feedback (2)

Rhino ETL: Thinking about Joins & Merges

posted @ Thursday, July 26, 2007 10:54 PM | Feedback (4)

The Small Comforts of Life

posted @ Tuesday, July 24, 2007 9:05 PM | Feedback (3)

Rhino ETL: First Code Drop

posted @ Tuesday, July 24, 2007 1:24 AM | Feedback (11)

Rhino.ETL: Full Package Syntax

posted @ Saturday, July 21, 2007 7:10 PM | Feedback (5)

Rhino.ETL: Turning Transformations to FizzBuzz tests

posted @ Saturday, July 21, 2007 2:12 AM | Feedback (4)

Rhino.ETL: Providing Answers

posted @ Saturday, July 21, 2007 1:22 AM | Feedback (6)

Framework building: Rhino.ETL Status Report

posted @ Saturday, July 21, 2007 12:17 AM | Feedback (1)

Idea: The Boo ETL DSL

posted @ Thursday, July 19, 2007 1:12 AM | Feedback (6)

Why I hate SSIS: Part N+1

posted @ Thursday, July 19, 2007 12:21 AM | Feedback (9)

SSIS' 15 Faults

posted @ Sunday, July 15, 2007 10:51 PM | Feedback (42)

private Database myDatabase;

posted @ Thursday, June 07, 2007 10:36 AM | Feedback (0)

You are allowed to disagree, too

posted @ Thursday, June 07, 2007 2:21 AM | Feedback (4)

What does it takes to calculate a sales tax?

posted @ Thursday, June 07, 2007 12:56 AM | Feedback (4)

A developer perspective on SQL Server 2008

posted @ Wednesday, June 06, 2007 7:38 AM | Feedback (7)

Generating Random Assoications

posted @ Thursday, May 24, 2007 11:07 AM | Feedback (2)

Roy Osherove, It is Time for Violence

posted @ Sunday, May 20, 2007 4:31 AM | Feedback (0)

Problem Solving skill - the wrong way around

posted @ Friday, May 11, 2007 7:08 PM | Feedback (3)

Transaction Isolation Levels

posted @ Thursday, May 10, 2007 7:05 AM | Feedback (1)

Converting an object collection to a DataSet

posted @ Wednesday, May 09, 2007 6:33 PM | Feedback (15)

ODBC is not an API

posted @ Friday, May 04, 2007 5:00 PM | Feedback (2)

SSIS: I know better than you do

posted @ Sunday, April 15, 2007 4:07 PM | Feedback (6)

SSIS: You really don't need all this data

posted @ Sunday, April 15, 2007 3:54 PM | Feedback (5)

That might take a while...

posted @ Wednesday, April 11, 2007 7:44 AM | Feedback (2)

SSIS Integration Woes

posted @ Thursday, April 05, 2007 6:28 PM | Feedback (9)

Remote Keys: Cross Database Foreign Keys

posted @ Monday, April 02, 2007 7:20 PM | Feedback (6)

Data Migrations Woes

posted @ Tuesday, March 27, 2007 7:21 PM | Feedback (2)

Transactions and concurrency

posted @ Sunday, March 25, 2007 3:21 PM | Feedback (25)

Unit Testing Database: Embedded vs. In Memory..

posted @ Sunday, February 25, 2007 11:59 AM | Feedback (18)

From SQLite to SQL Server Compact Edition

posted @ Saturday, January 27, 2007 2:54 AM | Feedback (17)

NHibernate Web Cast Series: Thinking about the infrastructure

posted @ Sunday, December 10, 2006 8:47 PM | Feedback (9)

Messy database: NHibernate as the maid...

posted @ Saturday, December 02, 2006 1:33 AM | Feedback (0)

Complex Queries With Active Record

posted @ Wednesday, November 22, 2006 9:50 PM | Feedback (4)

Why this is failing?

posted @ Thursday, November 09, 2006 10:26 PM | Feedback (6)

Unit testing with NHibernate / Active Record

posted @ Saturday, October 14, 2006 11:47 PM | Feedback (5)

NHibernate Query Generator 1.5 Is Done! [Time With Magic]

posted @ Saturday, October 14, 2006 7:18 PM | Feedback (14)

Bringing Active Record and NHibernate Query Generator Together

posted @ Saturday, October 07, 2006 5:55 PM | Feedback (0)

Active Record Rocks!

posted @ Saturday, October 07, 2006 4:52 PM | Feedback (3)

SQL Refactor

posted @ Saturday, October 07, 2006 1:40 AM | Feedback (0)

Should you use NHibernate with Stored Procedure?

posted @ Wednesday, October 04, 2006 11:23 PM | Feedback (2)

The little query that could... drive me crazy

posted @ Wednesday, October 04, 2006 11:19 PM | Feedback (0)

The really bad side of composite keys...

posted @ Monday, October 02, 2006 12:52 AM | Feedback (0)

Using SQL Functions in NHibernate

posted @ Sunday, October 01, 2006 2:06 PM | Feedback (5)

PluralizingNamingStrategy for NHibenrate

posted @ Saturday, September 30, 2006 11:30 PM | Feedback (0)

There Be Dragons: Rhino.Commons.SqlCommandSet

posted @ Thursday, September 14, 2006 5:25 AM | Feedback (2)

Opening Up Query Batching

posted @ Wednesday, September 13, 2006 10:15 PM | Feedback (3)

Measuring NHibernate's Queries Per Page

posted @ Thursday, September 07, 2006 6:09 PM | Feedback (2)

How to quickly judge the quality of a database

posted @ Tuesday, September 05, 2006 9:35 PM | Feedback (0)

The Mighty Server and the Killer Queries

posted @ Sunday, September 03, 2006 5:42 PM | Feedback (0)

Spot the WTF

posted @ Thursday, August 31, 2006 11:07 AM | Feedback (5)

NHibernate Generics 1.0.10

posted @ Monday, August 21, 2006 6:40 PM | Feedback (0)

I want one of those: Active Writer - VS Designer for Active Record

posted @ Saturday, August 19, 2006 1:54 PM | Feedback (0)

Working with high levels tools: A Performance Perspective

posted @ Sunday, August 06, 2006 3:27 AM | Feedback (0)

Fixing log4net 1.2.9 AdoNetAppender NULL bug

posted @ Monday, July 24, 2006 11:13 PM | Feedback (0)

Riddle: Active Record as a Rule Engine

posted @ Sunday, July 02, 2006 5:47 AM | Feedback (2)

Pessimistic Locking

posted @ Saturday, July 01, 2006 3:56 PM | Feedback (5)

ADO.Net Entity Framework: Round II

posted @ Saturday, June 24, 2006 10:50 AM | Feedback (2)

NHibernate's "Stored Procedures" - Named Queries

posted @ Saturday, June 24, 2006 12:55 AM | Feedback (3)

Better solution to the Tricky SQL problem

posted @ Friday, June 23, 2006 3:16 PM | Feedback (2)

Solving a Tricky SQL Problem

posted @ Thursday, June 22, 2006 11:13 PM | Feedback (7)

ADO.Net Entity Framework

posted @ Saturday, June 17, 2006 4:17 PM | Feedback (8)

Command Batching in ADO.Net 2.0

posted @ Thursday, June 15, 2006 7:03 PM | Feedback (1)

On System.Transaction

posted @ Saturday, June 10, 2006 5:21 PM | Feedback (1)

The Wheel, slightly eliptic

posted @ Wednesday, May 24, 2006 8:12 PM | Feedback (9)

NHibernate Best Practice - Assert Cascade Behaviors

posted @ Monday, May 22, 2006 10:11 PM | Feedback (2)

Date Merging Challange Solved

posted @ Friday, May 19, 2006 9:42 AM | Feedback (2)

SQL Challange, Date Merging

posted @ Thursday, May 18, 2006 8:38 PM | Feedback (6)

25 Reasons Not To Write Your Own Object Relational Mapper

posted @ Friday, May 12, 2006 11:05 PM | Feedback (1)

DLinq Answers

posted @ Friday, May 12, 2006 4:44 PM | Feedback (0)

Number Of Joins

posted @ Monday, May 08, 2006 6:11 PM | Feedback (2)

The Prison Domain Model Challange: Answers

posted @ Wednesday, May 03, 2006 4:06 PM | Feedback (4)

You're a DBA If...

posted @ Tuesday, May 02, 2006 4:23 PM | Feedback (0)

Bulk Data Operations Using NHibernate

posted @ Tuesday, April 18, 2006 10:01 AM | Feedback (4)

Primary Keys: Identity vs. Guids

posted @ Thursday, April 13, 2006 9:48 AM | Feedback (3)

One upon a time, in an IT operation far far away...

posted @ Thursday, April 06, 2006 3:58 PM | Feedback (2)

You really shouldn't write your own O/RM

posted @ Wednesday, April 05, 2006 11:25 PM | Feedback (0)

You can't escape the complexity

posted @ Wednesday, April 05, 2006 10:07 PM | Feedback (1)

Advantages of Stored Procedures?

posted @ Wednesday, April 05, 2006 8:08 PM | Feedback (18)

Avoid Mixing O/RM and SQL

posted @ Friday, March 31, 2006 9:18 PM | Feedback (0)

Shuffling a list in SQL

posted @ Thursday, March 23, 2006 5:37 AM | Feedback (4)

O/RM are not Magic (but they are close)

posted @ Wednesday, March 22, 2006 11:03 PM | Feedback (0)

Using O/RM Properly

posted @ Monday, March 20, 2006 9:03 PM | Feedback (1)

SQL Perfromance Reference: Joins vs. Seperate Queries

posted @ Saturday, March 18, 2006 11:27 PM | Feedback (3)

On Toads

posted @ Thursday, March 16, 2006 11:53 PM | Feedback (8)

My WTF of The Day

posted @ Thursday, March 16, 2006 11:33 PM | Feedback (2)

Clemens on O/R Mapeers: Take II

posted @ Tuesday, March 14, 2006 10:46 PM | Feedback (0)

More On The Object Relational Siren

posted @ Saturday, March 11, 2006 10:57 PM | Feedback (0)

More about Object Relational Mappers vs. Custom DAL

posted @ Thursday, March 09, 2006 7:01 PM | Feedback (0)

Transactional Data Defination Language in SQL Server 2005

posted @ Thursday, March 09, 2006 3:31 PM | Feedback (1)

SQL Server 2005 and database snapshots

posted @ Thursday, March 09, 2006 11:13 AM | Feedback (0)

Clemens on O/R Mappers

posted @ Tuesday, March 07, 2006 11:00 PM | Feedback (2)

SqlClr outperforms T-SQL (7 times faster!)

posted @ Sunday, February 26, 2006 11:43 AM | Feedback (2)

Refactoring SQL

posted @ Wednesday, February 22, 2006 11:15 AM | Feedback (1)

Price of Indirection

posted @ Monday, February 20, 2006 2:00 PM | Feedback (7)

Profiling SQL Server

posted @ Sunday, February 19, 2006 8:11 PM | Feedback (3)

Piping, Primary Keys and Three Hours I'll not get back

posted @ Sunday, February 19, 2006 7:17 PM | Feedback (0)

Best Practice

posted @ Sunday, February 19, 2006 6:21 PM | Feedback (0)

Optimization Story

posted @ Sunday, February 19, 2006 5:56 PM | Feedback (1)

Batches

posted @ Friday, February 17, 2006 12:46 AM | Feedback (1)

25 Things that I don't like in Oracle Tools

posted @ Friday, February 17, 2006 12:35 AM | Feedback (5)

Creating Tables From Queries

posted @ Thursday, February 16, 2006 11:04 PM | Feedback (0)

On Lies & Linked Server

posted @ Thursday, February 16, 2006 10:58 PM | Feedback (0)

SQL Debugging

posted @ Thursday, February 16, 2006 10:53 PM | Feedback (0)

Circular Dependencies

posted @ Thursday, February 16, 2006 10:29 PM | Feedback (2)

JustDate: Striping the time part from datetime variables

posted @ Thursday, February 16, 2006 10:15 PM | Feedback (1)

Using Data Ranges

posted @ Thursday, February 16, 2006 10:05 PM | Feedback (1)

The value of parallelism

posted @ Thursday, February 16, 2006 5:13 PM | Feedback (1)

The lost art of batch files

posted @ Thursday, February 16, 2006 4:46 PM | Feedback (0)

More on date ranges

posted @ Thursday, February 16, 2006 4:04 PM | Feedback (1)

SQL Date Ranges

posted @ Thursday, February 16, 2006 3:38 PM | Feedback (3)

SQL Date Processing

posted @ Thursday, February 16, 2006 2:30 PM | Feedback (4)

On Default Error Messages

posted @ Tuesday, February 14, 2006 8:43 PM | Feedback (0)

SQL Server 2005 Pitfalls

posted @ Wednesday, February 08, 2006 10:09 PM | Feedback (3)

More reasons to hate Oracle...

posted @ Tuesday, February 07, 2006 2:15 PM | Feedback (1)

Favoraite Error Message of The Week

posted @ Tuesday, February 07, 2006 9:50 AM | Feedback (1)

Why I hate linked servers

posted @ Tuesday, February 07, 2006 9:48 AM | Feedback (0)

Performance of SQL Server & SSIS

posted @ Saturday, February 04, 2006 9:30 AM | Feedback (0)

Pitfalls of moving data to SQL Server from Oracle

posted @ Saturday, February 04, 2006 9:18 AM | Feedback (0)

On Production "Agile" Databases

posted @ Saturday, February 04, 2006 8:42 AM | Feedback (1)

Tip: Searching Stored Procedures Text

posted @ Monday, January 30, 2006 10:00 AM | Feedback (2)

Performance tuning mystery

posted @ Wednesday, January 25, 2006 3:54 PM | Feedback (2)

Code reuse, cursors and NIH, oh my!

posted @ Wednesday, January 25, 2006 3:40 PM | Feedback (0)

SQL Frustrations

posted @ Tuesday, January 24, 2006 3:39 PM | Feedback (2)

Hierarchical queries with Common Table Expressions

posted @ Saturday, January 21, 2006 3:46 PM | Feedback (1)

Sql Tips

posted @ Wednesday, January 18, 2006 7:59 AM | Feedback (3)

Triggers & Auditing: Take 2

posted @ Tuesday, January 17, 2006 7:13 PM | Feedback (2)

Triggers and auditing

posted @ Monday, January 16, 2006 7:55 PM | Feedback (10)

Performance Tuning In SQL Server

posted @ Saturday, January 14, 2006 4:22 PM | Feedback (0)

How to debug your head agasint the wall

posted @ Friday, January 13, 2006 8:46 PM | Feedback (0)

More annoying stuff about SSIS

posted @ Friday, January 13, 2006 8:36 AM | Feedback (0)

SQL Management Studio

posted @ Friday, January 13, 2006 7:24 AM | Feedback (0)

SSIS Debugging Frustrations

posted @ Thursday, January 12, 2006 10:03 PM | Feedback (0)

SQL Tidbits

posted @ Thursday, January 12, 2006 9:53 PM | Feedback (0)

Heavy Load

posted @ Thursday, January 12, 2006 9:47 PM | Feedback (0)

No more occupational therapy

posted @ Thursday, January 12, 2006 9:43 PM | Feedback (0)

Comparing LINQ and Its Contemporaries

posted @ Sunday, January 08, 2006 7:43 PM | Feedback (0)

Moving from procedural code to sets: Part 2

posted @ Sunday, January 08, 2006 12:49 AM | Feedback (0)

SqlClr and anonymous delegates

posted @ Monday, December 26, 2005 7:18 AM | Feedback (0)

Picking a database... and staying with it.

posted @ Friday, December 23, 2005 11:52 AM | Feedback (0)

NHibernate Generics & EntityList - Update

posted @ Friday, December 23, 2005 11:34 AM | Feedback (0)

About SSIS and Code

posted @ Tuesday, December 20, 2005 7:21 AM | Feedback (0)

Verifying you Data Access Layer when using NHibernate, Active Record, And Friends

posted @ Monday, December 19, 2005 11:30 PM | Feedback (0)

WOW! Native Queries in C# 2.0

posted @ Thursday, November 17, 2005 2:35 PM | Feedback (3)

SQL Express 2005

posted @ Wednesday, November 02, 2005 6:56 PM | Feedback (1)

My First Trigger

posted @ Sunday, October 30, 2005 9:25 PM | Feedback (4)