SQL Server doesn't track this activity outside of the default trace.

If you have nightly file system backups, maybe you have a record from the older trace or...

Good question. No idea. I assume they go back to...

What are defunct filegroups? I'm not sure what you're doing or what the set up is currently.

Variables can't be used as columns. You can use dynamic SQL as noted to get a different column returned.

A wrapper is a good idea, especially if you can get a version somehow and have the procedure automatically change things.

My $0.02, Microsoft is not removing numbered procedures....

This is what Filestream was created to do. If the images are > 1 MB, you get better performance with them as files in the file system rather than in...

I would open a case with MS here. I haven't seen anyone getting corruption with TDE because of enabling it, but there might be some bug. I would be worried...

Explanation corrected. Apparently I was had an offset on my fingers last week.

We have six on a server and that works fine.

Keep in mind that LS is a thread for restore on a schedule. You control this and with multiple...

What's the update? You can potentially use a proc, a TVP, and update everything at once.

I built a few FoxPro and VFP apps. They were much better than VB at the time, and worked well. Of course, you'd want to use SQL Server as a...

Good class. Still interesting to see this analysis: https://fivethirtyeight.com/features/mariano-riveras-unanimous-induction-shows-an-evolving-cooperstown/

I am hoping the hall is evolving. No reason to not have some unanimous ballots before now. Those...

That is incorrect.