A couple things.

First, replication isn't a high level thing. It works by copying over transactions from the publisher to the subscriber, which can be your production and test environments, respectively....

If it is truly a master package, I might follow the advice above. If it's an 11th package that needs execution, you could create a 12th package that manages everything...

I might ignore it. He or she is either a troll, thinking that everyone should automatically...

The IP doesn't matter. SQL tends to work by name, and that's what's important. SQL Server tends to listen on all IPs that the server has configured.

That gets translated to...

In AdventureWorks, this will return the oldest record:

SELECT cc.CreditCardID, cc.CardNumber, cc.ModifiedDate

FROM Sales.CreditCard cc

WHERE cc.ModifiedDate = (SELECT MIN(ModifiedDate)

...

SSRS should do this, setting up reports, but that might be a lot of work. However it does subscriptions in the Enterprise edition.

Failing that, are you looking to generate the...

Robocopy may work. I used it years ago, but I believe it worked for just this kind of work.

There are lots of options these days in the cloud, but for...

OK, so to get a list of tables that are older than that date, this works:

SELECT name

FROM sys.objects

WHERE type = 'u'

AND create_date...

Nevyn is correct, it's hard to understand what you need. The description you've given isn't that clear as to what is needed.

You can mock up the table, but please give...

Enjoy presenting. Couple things.

1. Breathe. Easy to race through things. Take a moment at a few spots to get a drink of water or take a deep breath and pace...

Chris,

you'd have to remind me which VAS post, but I do think that we could use more articles that push this more complex information out to people to help them...

I don't have mugs or much swag at all anymore....

It sounds like you have thought things through well and I'd go with your gut.

re: mirroring: it's mostly a load of transactions issue. You can mirror 100 databases on x86...

My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan,...

If I understand your question, you want to know if you can specify the file names for multiple file backups?

This is a part of the BACKUP command. You enter the...