Damon Armstrong : Databases

Home SQL .NET Exchange Opinion Blogs Forums About

Caffeine Induced Tirades about .NET and Life

And don't forget to check out my latest Simple-Talk articles

Databases (RSS)

More DB2 Date Conversion Issues Importing Primary Keys into SQL Server

Posted Wednesday, October 25, 2006 8:53 PM | 2 Comments

In a previous blog entry (Date Errors Pulling DB2 Data into SQL Server) I recounted some of the issues I had with date conversions from DB2 to SQL Server. Another interesting issue came up. We were pulling data from a production DB2 database Read More

by Damon | 2 Comments | Comment on this post
Filed Under: Databases

Date Errors Pulling DB2 Data into SQL Server

Posted Tuesday, August 15, 2006 1:03 PM | 4 Comments

Moving data from DB2 to SQL Server has been an experience and a half, fraught with lessons throughout. My latest lesson is on dates. While running a query to import data, I kept running into this particular exception: Error converting Read More

by Damon | 4 Comments | Comment on this post
Filed Under: Databases

Prefixing Database Tables

Posted Wednesday, July 26, 2006 2:24 AM | 2 Comments

Reviewing a database with 400 tables is no easy task, especially when you didn't make the database. It seems like it would make everyone's life easier is if people would prefix their database tables in a way that helps group tables logically. For Read More

by Damon | 2 Comments | Comment on this post
Filed Under: Databases

Demoralizing a Table

Posted Tuesday, July 11, 2006 8:01 AM | 1 Comments

Even though I'm a web developer by nature, I find myself writing about databases fairly often. At work I'm writing a proposal for building a reporting database with a denormalized structure for better query performance and I keep running into a Read More

by Damon | 1 Comments | Comment on this post
Filed Under: Life, Databases

Opinion Home

Opinion Pieces (96 articles)

Geek of the Week (37 articles)

Tony Davis - Editor (6 articles)

Phil Factor (41 articles)

Damon Armstrong (8 articles)

Douglas Reilly (40 articles)

Adrian Furnham (1 articles)

Claire Brooking

Richard Morris (34 articles)

Tim Gorman (1 articles)

Jesse Liberty (5 articles)

Sarah Blow (1 articles)

Anna Larjomaa (1 articles)

Gaidar Magdanurov (2 articles)

Regular Columnists (1 articles)

Ben Hall (2 articles)

Blogs Home

November 2008

Virtual Exchange Servers

Microsoft now supports running Exchange Server 2007 in server virtualization environments, not just on... Read more...

Virtualizing Exchange: points for discussion

With the increasing acceptance of the use of Virtualization as a means of providing server... Read more...

Encouraging .NET Reflector Add-ins

Jason Haley is well-known for the resources he's provided to developers who wish to extend Reflector's... Read more...

Using .NET Reflector Add-ins

.NET Reflector by itself is great, but it really comes into its own with the help of some add-ins. Here... Read more...

Unique Experiences!

You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause a lot... Read more...

Site map | Become an author | Contact us