I'd give the "SCHEMA_OBJECT_CHANGE_GROUP" a try in your audit, that might do what you need.  I'm not where I have access to a test instance I could verify this on,...

That makes it sound like the data isn't being "deleted" in the database, then.  While the files wouldn't shrink, the space IN the DB would be marked as "free" space...

I know this is a "why the heck didn't you have that stuff scripted out before, anyways" sort of situation, and you'd be right...

Just discovered today, working with a customer...

Having just gone through a "lift-and-shift" migration to Azure VMs with several SQL installs that use SSIS and an application that uses SSRS, I can conclusively say that, yes, if...

Glad to help!

Couple questions about this:

1. Is the VPN a "soft" VPN that uses a software client to make the connection, or a "site-to-site" VPN established through your router / firewall /...

So that rules out the easy stuff.

If you explicitly put the name of one of your audit files in, rather than the wild card *.sqlaudit, does it work?  If not,...

To clarify a few things on this:

1. The SQL instances, do they write the audit files directly to the locations you indicated, or is there a process that copies /...

There's a reason the wife and I have froze our credit reports.

I KNOW my info has been leaked, and several times from various breaches.  Aside from not using the same...

Ugh, I'm torn on this. On one hand, this might make things cheaper for some...

Fortunately, my employer has decided a majority of people can be Work From Home, with only some doing part WFH and part in-Office, and a rare, essential few doing...

Anyone know the old joke about it being "your turn in the barrel?"

Replace the barrel with the office, and that's where I'm at today.  We're starting to come off 100%...

Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.

If you think you have to meet...

Well, you...

I guess what you’re asking for is the amount of space actually used by data pages within the space allocated to db files of your databases.

To give...