That's an interesting thought. Not sure how many people do this and if it's worth the time.

Advertising is an issue as many of the ads are not mobile friendly...

Sometimes we rerelease the articles, and the posted date changes based on when we set it for publication. I have the old date, should add an item to display that.

How large is the db? Loading means just that, it's loading from a restore. Is it possible that you checked the box that allows for more restores?

Did the restore complete?

You can limit the view by including a WHERE clause.

select * from myview where username = 'x'

It shouldn't happen. Are you sure you've got the correct current size? The log could grow itself if you haven't limited it.

The big loopholes are the ones you won't think of. Haveing the DBA handy is the important thing since unforseen things might happen.

Other than that, DR could be as simple...

I typically run optimizations once a week and integrity before all backups.

I'd run integrity, then optimizations.

I assume the space was already allocated on your SAN drive and SQL just picked it up? How much space was added v how much was there? Are you sure...

You can make it the last step in the package, or make a second package and use the job system to call the 2nd when the first successfully completes.

I'm not sure what you are looking to compare? If you want the current fillfactor of the table, then it will be gathered by dbcc showcontig, but this only works...

SQL Server preallocates space for the dbs and then fills it up. If you create a 10GB database, SQL Server allocates that much space from the OS filesystem, then zeros...

You haven't really provided very much detail here as to what you are looking for. If you want to limit access to data based on username, then a view might...

My buddy Andy would say use Access and link it to your tables. Setup only links to those tables the users need.

There are a few issues with using Master. 1 you are changing the base system of SQL Server, no strong recovery on this db, contains system level information, etc., so...

Maybe this?

http://www.pcmag.com/article2/0,1759,1561029,00.asp

I'd check more on programming Windows sites instead of here. Mostly SQL Server guys here, not as many programmers.