Monthly Archives: October 2010

Insert Parent and Child Tables with SSIS Part 2

Examine a different approach for inserting data into parent child tables with SSIS Continue reading

Posted in SSIS | Tagged , | Comments Off on Insert Parent and Child Tables with SSIS Part 2

Inserting Parent and Child Tables with SSIS

Examines a simple pattern in SSIS for handling parent and child tables Continue reading

Posted in SSIS | Tagged , | Comments Off on Inserting Parent and Child Tables with SSIS

QLSaturday #49 and #56 Recaps–A Little Different

SQLSaturday #49 My recap on SQLSaturday #49 is waaay overdue (sorry, Jack and Andy). It was nice to get a chance to present at the home of SQLSaturday, and I have to say, the amount of experience they have in … Continue reading

Posted in SQL Saturday | Tagged | Comments Off on QLSaturday #49 and #56 Recaps–A Little Different

Virtual PC and Windows 7

This morning while trying to spin up one of my Virutal PCs I ran into some peculiar error messages.  In case the same thing happens to you, the workaround is pretty simple.  When I opened Virtual PC and selected my … Continue reading

Posted in Windows | Tagged , , | Comments Off on Virtual PC and Windows 7

One Week to SQLSaturday #49

One week left till SQLSaturday #49 – there’s still time to register. I’m pretty excited about going, as it will be my first Orlando SQLSaturday. Also, it looks like a great lineup of speakers. I’ll be presenting on ways to … Continue reading

Posted in SQL Saturday | Tagged | Comments Off on One Week to SQLSaturday #49

SQLSaturday #48 Recap

I presented at SQLSaturday #48 this weekend. It was a great event, and I thoroughly enjoyed it. K. Brian Kelley and the other organizers put on a great event. This was the first SQLSaturday that I’ve been to in a … Continue reading

Posted in Uncategorized | Tagged | Comments Off on SQLSaturday #48 Recap

Create XML Fragment in SQL Server

The XML datatype, first introduced in SQL Server 2005, can be very  handy when utilized properly. It is an industry standard, and with it, it is easy to import/export data across different servers, as well as different systems entirely. This … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Create XML Fragment in SQL Server