You are confused. You do not log onto Integration Services. SSIS is a part of the SQL Server instance. It has it's own service, but a sysadmin logs onto the...

I guess I wouldn't be working there. Or I'd have them pay me $5xworking-days-in-a-year more 🙂

They are the exact same codebase, with different features/restrictions.

EE servers are usually larger, so it might appear to run faster, and there might be features that allow things to perform...

I wouldn't expect comments outside of a proc to show up. I might run a lot of stuff in a window, and wouldn't necessarily want other items in a batch...

You'll only be able to get the the point in time since the last transaction log backup if you can back up the tail of the log. That's what's in...

You don't log onto SSIS to access the packages. The packages are typically stored in msdb, though they may be in the file system. The sysadmin can access anything on...

Don't know. That sounds like employment for life! Might be THE place to work.

Let us know. That's a strange one. If you aren't getting notes on what's causing growth, I'll ping soem MS people. Might be worth burning a case with them to...

Nelson, excellent points. I hadn't thought about it in those terms, but there is definitely value in those situations.

One more, you might find a great person that you want to...

Sorry, Matt is correct. I've typically created them with a process that is always running at startup, so they've always appeared to be there. That's a good thing to note...

I agree and think w3schools is really basic. But check it out and see what you think.

The 4 Guys site is good, but you'd really need to go back to...

And the db still grew?

You're correct. Once the db is restored, the size of it doesn't matter. It's the logs that have to be restored.

Did it ever catch up? I'm almost wondering if you...

Nice catch, George. Didn't notice that. Thanks for the note.

If you see "operating system error" in your log, it means that a Windows error is bubbling up. In this case, it's the same error you might get in Word...