Category Archives: SQL

ORM techniques for legacy databases

Posted on July 26, 2012 by Jimmy Bogard

One of the reasons folks typically go with a hand-rolled ORM (i.e., using ADO.NET by hand) is the assumption that ORMs don’t work well with legacy databases or databases designed in isolation from any sort of object model used to … Continue reading →

| 22 Comments

Hitting the upper limit of foreign key constraints

Posted on November 24, 2009 by Jimmy Bogard

There are bugs, and then there are bugs.  We recently hit one that fell directly in crazy-town category.  What exactly would you do if you get this fun message: The query processor ran out of stack space during query optimization. … Continue reading →

| 17 Comments

Viewing all foreign key constraints in SQL Server

Posted on November 27, 2008 by Jimmy Bogard

This one goes in the “so I never have to look again” category.  I needed to get a list of all foreign keys in the database, for some reason which was probably dire but now escapes me.  This guy had … Continue reading →

| 2 Comments

Designing primary keys

Posted on June 5, 2008 by Jimmy Bogard

When creating a primary key for a table, we have a few options: Composite key Natural key Surrogate key Each has their own advantages and disadvantages, but by and large I always wind up going with the last option. Composite … Continue reading →

| 23 Comments

Calling .Net Web Services from Oracle PL/SQL

Posted on September 14, 2007 by Joshua Lockwood

I’m working relatively closely these days with an Oracle DBA on this super-cool mainframe integration project (anyone want to join me?  LOL).  The old batch ops were managed through cron’d jobs in Oracle and I was asked to take a … Continue reading →

Also posted in Oracle, SOAP, Web Services | 29 Comments