Thank you, that looks worth considering, although migrating the entire setup to Azure is much more work than I had hoped for just a (seemingly) simple authentication problem. And I...

Thank you, that looks promising. Unfortunately, I cannot do this myself - I have to rely on the IT department, and they are not exactly enamored of my database. They...

My usual method is as follows:

Exhaust every possible avenue of research.

Triple-check everything to ensure I am correct and won't look silly if I have to post a question somewhere.

Repeat...

I had a heck of a time getting FileTables to work. There are four different places that require setting up a special name or alias, and NONE of the documentation...

PowerShell arrays are 0-based. We have 10 elements, so the index goes from 0 to 9. The assignment was $numbers = @(1,2,3,4,5,6,7,8,9,10). So $numbers[0] = 1, $numbers[1] = 2,...

I don't get it. If you set element 4 to Null, why is it that number 5 vanishes from the array?

Really? It...

those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct...

• This reply was modified 1 year, 4 months ago by  pdanes.

And, I think it was mentioned earlier, but any chance you have "autoclose" or "autoshrink" turned on? I doubt that autoshrink would cause this issue, but I could see...

And your backup process is done outside of SQL? Is there a reason you don't use the SQL Agent to schedule the jobs? I mean, nothing against doing it...

• This reply was modified 1 year, 6 months ago by  pdanes.

That sounds like it may be a bug in SSMS then... but oof... using the edit GUI in SSMS? I find that to be clunky and painful to work...

As another random thought - Are you seeing any pattern to when it blanks out? Like is it good at 8:02 but by 8:15 it is blank? If so,...

• This reply was modified 1 year, 6 months ago by  pdanes.
• This reply was modified 1 year, 6 months ago by  pdanes.
• This reply was modified 1 year, 6 months ago by  pdanes.

OK, I finally found notes on the sys view I was trying to remember:

sys.dm_db_file_space_usage

This time, that should (actually) help you determine what you need to know (you would...

Even weirder. I just made some manual changes, in a table that I confirmed has a primary key. Initially, it showed a change in only one of the tables, from...

Just thought of a small scenario that MAY not impact you, but thought I'd toss this in here too - do you have any heaps? The reason I ask...

• This reply was modified 1 year, 6 months ago by  pdanes.
• This reply was modified 1 year, 6 months ago by  pdanes.