My first DBA job I was content.  Good company, good pay and benefits, great IT team.... I figured I'd work there until I retired.  However, job cuts got me and...

Both places I have worked some of the drives were formatted to 4k instead of 64k.  Personally I don't think it truly makes that big of a difference from what...

I see they just released CU23 but I don't see any mention of a fix for this issue.

We have the same issue after applying CU15 to one of our systems with several servers participating in a AG.

I would not touch tables in master at all personally.   MSDB can get quite large for job history and backup history.

I use this for msdb:

use msdb

go

ALTER INDEX ALL ON [dbo].[sysmail_mailitems]

REBUILD...

We have been experiencing this issue since February when we went to CU19 one to three dbs get messed up almost every month when we do Windows Updates/Server restarts.  We...

We are on SQL2019 and have NEVER had this issue but it started happening in Feb during our Windows Update/Server restarts.  Almost every month we have 1 to 3 databases...

If you have $$ you might look into some audit software like Idera's Compliance Manager.  It tracks changes and you can filter it and capture what you want or don't...

A couple years back I was interviewing for a DBA position with many companies.  I was shocked that almost all of them barely applied Windows patches or hadn't in over...

I wish they would have a create date and modified date (if applicable) for everything created within SQL Server.  Linked servers, Triggers, Alerts, Operators, etc.  When I went from DB2...

If your database gets hijacked and the data gets compromised on the primary node then it will replicate any data changes to your secondary node.

Yes, the windows servers have to...

That account is an Admin on the server.  Also, I am not sure where the C:\Users comes into play because I am not specifying that at all.

I would agree on the mdf and ldf file growth as stated above.  It should be to a reasonable MB growth not percentage.  The reason is if your files gets...

TRUNCATEONLY

Releases all free space at the file's end to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the...

I was reading an article about MFA security a few months ago.  It was quite interesting because you'd think that is a good idea.  However, there are now hackers that...