Regardless of which method you plan on, if you intend to audit every data change even in "just" user databases, you should immediately at least double the disk space and...

I'd create a morning report for all jobs.  It's not difficult to do and will teach you a lot about the tables in MSDB.  I render the report in T-SQL...

Now, all those in the room that have actually used this function in production, please raise your hand! 😀

BEFORE YOU DELETE ANYTHING, MAKE SURE THAT YOUR BACKUPS ARE WORKING CORRECTLY AND THAT YOU CAN RESTORE TO A POINT IN TIME!!!!!

Ah.  Got it.

Whether running in a VM on Azure, AWS, or locally, a VM is just a VM. You're responsible for your database backups the same way across all of them....

I'd also get out of the habit of having discrete logins even if they're Active Directory logins.  Use Active Directory Groups instead.  Of course, the exception (there's almost...

Many thanks Jeff. This has become a repeated problem. App team says there is nothing wrong from the application. Blame games gets started for 1 day and eventually they...

So there won't be true consistent last login then? I will need to be able to identify haven't logged in for over 120 days however, our servers are rebooted...

Hi Experts,

Seeking for inputs on High cpu scenario.

App team has started running workload at that time and they back saying DB is slow. Seeing 100% CPU on one of...

First of all, that's an Oracle error.  Oracle and SQL Server haven a whole lot of differences.  PL/SQL <> T-SQL.  Let's hope that whoever...

PLEASE don't duplicate posts.  All does is split up the answers others make.

Please, no more answers on this thread folks.  Instead, post them on the following thread.

https://www.sqlservercentral.com/forums/topic/master-and-detail-table

Synchronization process?  Why wouldn't "replication" work for you?

I've also found the...

>> IDENTITY() is a piece of automation that solves a set of tricky problems for you. <<

Actually, IDENTITY creates problems rather than solve them. Essentially, you've decided to throw...

While I agree that there have been some pretty cool successful attempts at making things "better" which, as you say, means "go faster", in this case,  all is not without...