Coffee isn't necessarily for steak. Maybe after, with the "adult beverage group" included.

First, a diff contains all changes since the last full backup. So if you make 1 change, then run a diff, then make a 2nd change and run a diff,...

You need to make sure that you perform regular log backups to ensure that it does not grow so large again. In doing your log backups, you do not need...

Keep in mind that when you connect to B, the backup is made local to B, meaning from the drives that the service account on B can see.

There are lots of people that are consultants or DBAs that list resumes on their blog. You can try Pinal Dave, maybe Brent Ozar, but you don't want to necessarily...

I believe this is true. Integration Services is the subsystem for running packages. They can be stored in msdb or in the file system, and built in Visual Studio or...

Database Mail should work in all editions except Compact and Express.

Lynn has a good idea. What you need is a programmatic task that will create a new file name each day. How are you doing this right now? What is...

Should be no issue with multiple IP addresses. I haven't seen problems with connectivity because of this. If they are timing out, I might check and be sure that it's...

Now I want a steak for dinner, but my wife put a turkey in 🙁

Good luck, thanks, and I hope this doesn't drag into your weekend.

That's a good idea, Dean. Probably across time that gives you a good idea of how many people are using the server.

I'll have to try milk on the steak. Haven't tried that one yet, though I do like it on a hot grill.

One other thing I'd recommend is soak some red...

The answer, based on LIKE, is that you are looking for 3 character matches without the %.

So you have possible:

John

Jonathan

Jon

Joe

Jack

Of these, the 3 character ones are:

Jon

Joe

Of those, the...

Please refrain from profanity. It doesn't add to the discussion and it is not professional.

I have changed the question to have 1 answer and added a note about the...