Yes. I would like to be able to select a date and have a calculation that will return the average daily sales based on 30 days from the date...

FYI...

This may be a little late but I'm working on the log shipping situation as well and I just went through and created the Transfer Jobs SSIS package. I...

Is there any way to identify either of those situations? Like I said nothing is written to any log event or otherwise that I have seen. Our server...

Ian,

Thanks for the suggestion... guess i should have checked the data before posting. There are actually dups.

Sorry to waste time.

I wouldn't say I'm an avoider but I do like to let my work speak for itself... not real big on the "hands on" micro manager or having to brown...

If the database is 90 compatibility level you can right click on it in MS, reports, standard reports, database consistancy history. This will show the DBCC commands that have...

I totally agree with Chris!

Recently had a review and after ~1hr of kudos we came to the dreaded areas for improvement section...

The negative was that I wasn't 5 minutes early...

I get a kick out of how he works himself into a frenzy then starts freaking out about Microsoft "sucking up" all the talent...

Then at the end he's advertising for...

BI Documenter is nice because it works for databases, SSASm SSIS, and SSRS (Enterprise).

If you are interested in a modeling tool Erwin is nice.

Great article and entertaining read! Thanks!

This might be over simplified but have you tried using the Transfer SQL Server Objects Task in SSIS? There is an option to transfer data which in your case...

Thanks Steve!

identity columns are like the fast food of the database world.

..."Super Size Me" ring a bell.

Basically a lack of understanding on the upfront work involved in modeling. Does anyone...

I think this goes back to an earlier editorial you had this week. There's so much push to get the new stuff out that there's no time to fix...

I agree with Phil...

My focus in the past has been database administration. I've worked for larger companies that had DBA's, application developers, reporting folks, and DA's.

I've since moved to...