When storing the data in the database try and store it with as much detail as possible. for example if you have the data here is why

create table #ranks...

Are you using differential and log backups for subsequent refreshes?

http://blogs.msdn.com/b/sqlcat/archive/2008/03/02/backup-more-than-1gb-per-second-using-sql2008-backup-compression.aspx

Interesting read

Login Names and User Names do not have to match , usually when you create a login and then map the login to databases a user with the same name...

Your connection managers are being invalidated at run time ,this can happen for a number of reasons but the most common is when the protection level is set to do...

+1 to data driven subscriptions , that's the inbuilt feature for sending reports to multiple users.

whats the output of this query

select * from sys.fulltext_catalogs

I Imagine you need two conditions one to check for tables that have NC indexes that have included columns and then one to check indexes to confirm the have included...

The final video

https://www.youtube.com/watch?v=Eyjokb1o7Go

its a fairly common requirement and has been asked bfeore , you could start here , the main thing is to use the script task within the dft.

http://www.sqlservercentral.com/Forums/Topic628424-147-3.aspx

You could use Policy based Management which will prevent any operations that violate the defined policy

frankly i dont think anybody expects a thank you when they post answers to the question but damn does it feel nice:-)

While certification course are great to stand out; there is no assurance they will help with all the scenarios you are going to face or explain in details those that...

Data sync can do bidirectional ,premise to cloud and vice versa but considering the volume of data Ssis might be more better.

Sweet !!!

It never occurred to me to use a case statement within the Recr CTE

Thanks Chris.