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 (91 articles)

Geek of the Week (35 articles)

Tony Davis - Editor (6 articles)

Phil Factor (40 articles)

Damon Armstrong (8 articles)

Douglas Reilly (40 articles)

Adrian Furnham (1 articles)

Claire Brooking (1 articles)

Richard Morris (29 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

August 2008

Go With the Flow

Knowing enough about the routes that messages take is vital to being an effective Exchange admin,... Read more...

When Email Collaboration Could Have Changed History

In our mission to make history relevant to the busy IT executive, we speculate how Email might have... Read more...

Bunnikins!

When an IT manager is selected as a victim of office politics of a large corporate, it is time for him... Read more...

Exchange Database Technologies

One of the most misunderstood technologies in Exchange Server, regardless of its version, is the... Read more...

Top Tips for Exchange Admins

Michael Francis hands out imaginary Olympic medals to the winner of the August 'Top Tips for Exchange... Read more...

Site map | Become an author | Contact us