Great article - I love our language!

Can anyone suggest a suitable word for the all-import-no-design reporting database that's made up from flat file extracts from business OLTP systems imported daily...

As an oldie from the pre-PC generation it's paper and pen every time as it's the way I came through school and university. I couldn't type notes and still watch...

Favourite software:

Notepad ++ both home and work

Mailwasher (Free) at home

WordPress and TOAD for MySQL at home

You can use sequence containers to group things and put precedence constraints between the containers to run them one at a time.

Are you sure each data load is running sequentially within the package? Are they linked by constraints? What is/are the values for MaxConcurrentExecutables property of the package? You can also...

Bring your own hardware - LOL - it's an absolute no no here. We even have port security so you can't move a pc or plug a laptop in without...

+1 for the "for each" solution - I've used it a lot with csv files as we get them delivered by ftp. Processed files are then moved to a "done"...

The Microsoft course teaches you only how to use the SSAS tool rather than why you should or shouldn't do something or cube design.

Is it set up such that one record failing to import will lose the whole batch that that record is in?

I've had this before and either changing to "slow load"...

Certainly in my last two posts I have had job specifications consisting of short clauses covering my responsibilities such as "Assist in maintaining and safeguarding the backup and recovery routines,...

My son introduced me to mind mapping when he was taught it at school at the age of 8 or 9 (mid 1990's) as a study aid and I've used...

Another great argument against the use of cursors - thanks!

Heartily agree. I recall working in the steam-pressing room of a clothing factory during university holidays - a real sweat shop as it was the hot summer of '76 -...

We have a large staff car park by the main gate to the site and then have to walk past security and down the road to our building and it...

Document each report in an MS Office doc (Word/Excel/Visio/Powerpoint as appropriate) stored in a sharepoint library and add the hyperlink to the document as a description via report manager or...