Nice article and I appreciate the Why and the Step by Step. Well written.

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 2 years, 4 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...