All your statements are true but then I'm sure you already know that SQL Server has temporal tables, when designed well removes the need for audit tables. I have made...

This stinks of AI.

This has nothing to do with a web page. This is just performance enhancements with SQL Server that have been around for a long while.

Also Analytics aren't really needed to...

I agree. This seems like an AI generated article. and unfortunately made it through.

Thank you. I enjoyed the article very much.

___

It would have been helpful to know what prerequisites are required for a command to run successfully. For example,

-- Run this on each server instance participating in...

• This reply was modified 1 years, 10 months ago by andre.quitta.

I very much enjoyed this article. One of the best ones I've seen in a while.

The nice part about this article is that it is generic and the principles could be applied to any database platform. Same with the execution, with Python just executing T-SQL...

Also Active Directory groups and reduced use of SQL logins helped us a lot. We also rename the SA account and disable it.

I've found that bigger teams require Leads to represent the group or else Stand Up takes a long time. You're right that management is very hard, especially in IT. I've...

Turns out they came from Visual Studio 2015 when defining an SSIS Data Source as a Project Data Source.

We created a pattern where setting up Always On was done with a remote login of a windows service account. It took care of a lot of problems.

for SSRS 2016 -- 

Agreed with the header and footer skewing the Excel column creation.

• Start out with just the table(s). Get rid of...

These are both really good. Will discuss with my Release Manager and my Architect which direction.
Thanks very much.
Andre