If this is confusing to you, it's probably confusing to your coworker, especially future coworker. If you cannot figure out how to avoid generating those fake backup rows, maybe it's...

It's managed by your 3rd party SQL backup software, so, the backup software knows where it is, how to restore it when needed. It's almost the same for all 3rd...

SQL Native backup is much better than Commvault SQL backup in my opinion.

Rackspace(a hosting company) uses Commvault SQL backup to back up client databases. Occasionally, backup took days and then...

I got the same on SQL 2019 with latest CU12.

DBCC CHECKDB ([msdb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY;

PRINT @@ERROR;

-- result: 0

DBCC CHECKDB ([msdb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS;

PRINT @@ERROR;

-- result: 2706

• This reply was modified 3 years, 2 months ago by  sterling3721.

Hi, iLearnSQL, The powershell script is for database properties, not for service accounts as illustrated in the screenshot. Could you update the script to match the screenshot? TIA

I feel sad about the loss of PASS.

Since it's mainly promoting Microsoft technologies, wonder why Microsoft didn't want to bail it out, a few million dollars is life or death...

If you have X licenses(X is the number of cores) for one node and software assurance(SA) for the other node, OR

X licenses for one node and another X licenses for...

As for ODAC 12.2 memory leak, Oracle said there was a fix, but it required a service account to download. Since this was not my major area, I just used...

Caution: stay away from the new driver(12.2). about one year ago, I used it first, SSIS consumed 30GB memory, which was almost all the memory on the box; I switched...

could be earlier than 2040??. It's not slow to everyone. Just like table variable, after it was available, I adopted and in the end, I switched back to temp table,...

thank you, Joe, for the COBOL info. I didn't know SQL was so impacted by COBOL. Yes, the display should be handled on the front end, instead of the database...

Why Microsoft released a less performant FORMAT function to make SQL server look bad? I am sure Microsoft released it from requests by SQL server community. Not everyone/every application is...

no matter whether you like it or not, 1)application developers write managed code more; 2)application developers implemented the functions, including FORMAT, CONVERT, CAST, LTRIM, RTRIM, TRIM, LEFT, RIGHT; 3)FORMAT is...

true, format() is slower, and I started using it since it was not available until SQL server 2012 and my employer migrated from SQL 2008 to SQL 2016. Just like...