We use SQLSentry at our company. Another worth trying tool that comes free with the RedGate SQL Bundle is SQL Response. You can download the trial version, it's free to...

Hi,

What are some of the good books for preparing MCTS Exam 70-432 and MCITP Exam 70-450?

Please advise.

Thanks,

run xp_readerrorlog on Query Analyzer and look for any errors, warnings.

Did you check the event logs to see for error details? If possible backup your database to the Server where you are trying to the restore (network backup) and as...

Try robocopy command to copy your bak files across, i think you can re-start the file copy in case it fails for some reason.

In order to get the incremental data, first of all you need to store the last fetched date in a table and use this date as a basis to get...

Make sure you have mapped the right field to OLE DB Destination. If possible re-create the OLE DB Destination component and re-map.

Hi,

Most importantly, try to learn the business as much as possible, this will earn you respect from your peers.

Also being able to play datacop and defend your DB Design...

Good question! But wouldn't the backup and restore get affected because of the compressed row size? The DB backup would be relatively smaller and hence the restores would be faster.

Thanks,

Nice article and i would use the same technique in a DW environments when i have to pull information from different sources. But would be curious to see alternate methods...

alen teplitsky

I agree with you. We have a centralized SQL Server that runs only SQL Jobs, it runs all our Import/Export/ODS ETL jobs. We leverage SSIS Packages and then these...

I like the idea of kicking off a separate job using T-SQL step in the Job. This makes it easy to re-run in case of the package failure. You just...

Hey Paul,

Just wanted to let you know the App Development team came back to me saying the pagination is lightning fast using the TOP (@var) approach. They are going to...

I agree with Elliott, you can't get away from transaction logging. As regards processing everything in memory, even SSIS is capable of doing that, only when you think the performance...

Very interesting question! The alias name puzzled me for a while.